DBMS_CIE-II_T4

Which SQL keyword eliminates duplicate rows?

• DISTINCT

• UNIQUE

• ALL

• ORDER BY

Which command changes an existing row?

• ALTER

• UPDATE

• MODIFY

• INSERT

Which string function returns the length of a string?

• LENGTH()

• SUBSTR()

• INSTR()

• CONCAT()

Which clause is evaluated first during query execution?

• SELECT

• WHERE

• GROUP BY

• ORDER BY

Which view stores actual data?

• Simple view

• Complex view

• Materialized view

• Inline view

Which SQL command is used to add a new column?

• ADD

• UPDATE

• ALTER

• CREATE

Which function rounds a number to the nearest integer?

• TRUNC()

• ROUND()

• MOD()

• ABS()

Which operator compares a value with each row of a subquery?

• ANY

• EXISTS

• IN

• ALL

Which SQL command undoes a transaction to a savepoint?

• COMMIT

• ROLLBACK

• SAVEPOINT

• DELETE

Which PL/SQL object is used to fetch rows one by one?

• Procedure

• Function

• Cursor

• Trigger