Which clause can be used with SET operators to sort the final result set?

• A.GROUP BY
• B.HAVING
• C.WHERE
• D.ORDER BY

Comment: *

Name: *

Email: *

Verification: *

Which of the following SQL commands retrieves data from a relational database?

• A.DELETE
• B.UPDATE
• C.SELECT
• D.INSERT

Comment: *

Name: *

Email: *

Verification: *

What will the following query return?
SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY') AS formatted_date FROM dual;

• A.The time part of the current date
• B.The current date in the default system format
• C.The current date in the format 'DD-MM-YYYY'
• D.An error

Comment: *

Name: *

Email: *

Verification: *

What does the following SQL statement do?
CREATE TABLE employees (
employee_id NUMBER PRIMARY KEY,
first_name VARCHAR2(50),
hire_date DATE NOT NULL
);

• A.Creates a temporary table
• B.Creates a table with only VARCHAR2 and DATE columns
• C.Creates a table with a primary key and a NOT NULL constraint
• D.Creates a table with no constraints

Comment: *

Name: *

Email: *

Verification: *

What happens when the maximum value of a sequence is reached?

• A.The sequence starts decrementing values.
• B.An error is raised, and the sequence must be recreated.
• C.The sequence stops generating values.
• D.The sequence resets to the starting value if the CYCLE option is specified.

Comment: *

Name: *

Email: *

Verification: *