1) What is the full form of SQL a) Structured Query Language b) Structured Query List c) Simple Query Language d) None of these 2) Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? a) Data Definition Language (DDL) b) Data Manipulation Language (DML) c) Both of above d) None 3) Which operator performs pattern matching? a) BETWEEN b) LIKE c) EXISTS d) None 4) What operator tests column for the absence of data? a) EXISTS b) NOT c) IS NULL d) None 5) In SQL, which command(s) is(are) used to change a table's storage characteristics? a) ALTER TABLE b) MODIFY TABLE c) CHANGE TABLE d) All of the above 6) In SQL, which command is used to SELECT only one copy of each set of duplicate rows a) SELECT DISTINCT b) SELECT UNIQUE c) SELECT DIFFERENT d) All of the above 7) A command that lets you change one or more fields in a record is a) Insert b) Modify c) Look-up d) All of the above 8) Which SQL keyword is used to retrieve only unique values? a) DISTINCTIVE b) UNIQUE c) DISTINCT d) DIFFERENT 9) Which SQL statement is used to delete data FROM a database? a) DROP b) REMOVE c) ALTER d) DELETE 10) Which SQL keyword is used to sort the result-set? a) SORT BY b) ORDER c) ORDER BY d) SORT

SQL 1

Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?