SQL Aptitude Questions#1

Some SQL Aptitude questions for Aptitude Preparations

Q Which is the subset of SQL commands used to manipulate Oracle Database
structures, including tables?
Data Definition Language (DDL)
Q What operator performs pattern matching?
LIKE operator
Q What operator tests column for the absence of data?
IS NULL operator
Q Which command executes the contents of a specified file?
START or @
Q What is the parameter substitution symbol used with INSERT INTO command?
&
Q Which command displays the SQL command in the SQL buffer, and then executes
it?.
RUN

Q. What are the wildcards used for pattern matching?
_ for single character substitution
and % for multi-character substitution
Q State true or false. EXISTS, SOME, ANY are operators in SQL.
True
Q State true or false. !=, <>, ^= all denote the same operation.
True
Q. What are the privileges that can be granted on a table by a user to others?
Insert, update, delete, select, references, index, execute, alter, all

Read More Papers-Click Here