-
In SQL, what is the command used to delete data from a table? A. INSERTEGIN* B. DROPTABLE C. DELETE D. DROP
-
What command is used to restrict the number of records returned by a query? A. PICK B. JOIN C. LIMIT* D. SORT
-
What operator is used to combine the results of two queries into one result set? A. AND B. INTERSECT C. UNION* D. OR
-
Which keyword is used to specify a condition when retrieving records from a table? A. IF B. WHILE C. WHERE* D. DO
-
Which type of clause is used to modify the sequence of data returned by a query? A. SELECT B. ORDER BY* C. FROM D. WHERE
-
What is the full form of SQL? A. Standard Query Lines B. Structured Query Language* C. Structured Query Lines D. Standard Query Language
-
What keyword is used in SQL to give access to certain records in a table? A. GRANT* B. ALLOW C. PERMIT D. LET
-
How do you represent wildcards in a LIKE clause? A. # B. & C. * D. %*
-
What is the default ordering of returned records in a query? A. Random B. Ascending C. Descending D. Unsorted / No Default Ordering*
-
Which clause is used to remove records from a table in SQL? A. DROP* B. DELETE C. CLEAR D. REMOVE
Loading...