Loading demo links...
Showing 1–12 of 12 questions
What does NVL return when its first argument is null?
Select an option, then click Submit answer.
Which clause filters rows before grouping in a SELECT statement?
Select an option, then click Submit answer.
Which statement removes a table and its structure permanently?
Select an option, then click Submit answer.
What does an inner join return?
Select an option, then click Submit answer.
In a relational database, what does each row in a table represent?
Select an option, then click Submit answer.
Which two functions handle null values directly? (Choose two.)
Select all that apply, then click Submit answer.
Where can a scalar subquery appear in a statement?
Select an option, then click Submit answer.
Which two clauses can restrict rows returned by SELECT? (Choose two.)
Select all that apply, then click Submit answer.
Which two are valid table-level constraints? (Choose two.)
Select all that apply, then click Submit answer.
CORRECT TEXT
The ______ function returns the current date and time from the database server.
Answer is in the explanation below.
DRAG DROP
Match each clause to its purpose in a SELECT statement.
Items to match: WHERE clause, GROUP BY clause, HAVING clause, ORDER BY clause.
Answer is in the explanation below.
DRAG DROP
Match each DDL statement to its action.
Items to match: CREATE statement, ALTER statement, DROP statement, RENAME statement.
Answer is in the explanation below.
