SQL — Quiz

A Structured Query List B Structure Query Language C Sample Query Language D None of these.

A FLOAT B NUMERIC C DECIMAL D CHARACTER

A TRUNCATE B ALTER C CREATE D UPDATE

A COMMIT and ROLLBACK B UPDATE and TRUNCATE C SELECT and INSERT D GRANT and REVOKE

A DELETE B REMOVE C DROP D TRUNCATE

A Simple tables B Virtual tables C Complex tables D Actual Tables

A Only 1 B Only 2 C Depends on no of Columns D Depends on DBA

A CHAR B RAW C NUMERIC D VARCHAR

A Primary Key B Not Null C Check D Union

A COUNT B COMPUTE C SUM D MAX

A SELECT B PROJECT C JOIN D PRODUCT

A ANY B BETWEEN C ALL D IN

A NOT Operator B Exists Operator C IS NULL Operator D None of the above

A When existing rows are modified. B When a table is deleted. C When some rows are deleted. D All of the above

A DESC B ASC C There is no default value D None of the mentioned

A INSERT B MODIFY C LOOK-UP D All of the above

A SELF JOIN B EQUI JOIN C NON-EQUI JOIN D None of the above

A Similar to the WHERE clause but is used for columns rather than groups. B Similar to WHERE clause but is used for rows rather than columns. C Similar to WHERE clause but is used for groups rather than rows. D Acts exactly like a WHERE clause.

A WITH B FROM C WHERE D SELECT

A is illegal B garbage C 726 D 70

A The AS clause in SQL is used to change the column name in the output or assign a name to a derived column. B The SQL AS clause can only be used with the JOIN clause. C The AS clause in SQL is used to defines a search condition. D All of the mentioned

A ROLLBACK B COMMIT C TRUNCATE D DELETE

A CREATE B UPDATE C ALTER D SELECT

A Natural JOIN B Outer JOIN C EQUI JOIN D All of the above

A A way to establish a loop in SQL. B A way to establish an IF-THEN-ELSE in SQL C A way to establish a data definition in SQL D All of the above.

A Both run automatically. B Both are stored in the database. C Both consist of procedural code. D Both have to be called to operate.

A They include procedural and SQL statements. B They work similarly to the functions. C It does not need unique names. D It cannot be created with SQL statements.

A Union JOIN B Natural JOIN C Subqueries D All of the above

A Index improves the speed of data retrieval operations on a table. B Indexes are special lookup tables that will be used by the database search engine. C Indexes are synonyms of a column in a table. D All of the above

A View B Network C Unit D Transaction

A Read operations B Write operations C A & B both D None of the above

A Numeric value B Alphanumeric value C A & B both D None of the above

A 39 digits B 38 digits C 40 digits D 37 digits

A SELECT, GROUP BY, WHERE, HAVING B SELECT, WHERE, GROUP BY, HAVING C SELECT, HAVING, WHERE, GROUP BY D SELECT, WHERE, HAVING, GROUP BY

A Primary key can store null value, whereas a unique key cannot store null value. B We can have only one primary key in a table while we can have multiple unique keys C Primary key cannot be a date variable whereas unique key can be D None of these

A Equal B IN C IS D None of Above

A When an exact match is required in a SELECT statement. B When an exact match is not possible in a SELECT statement. C When an exact match is required in a CREATE statement. D When an exact match is not possible in a CREATE statement.

A FOREIGN KEY B PRIMARY KEY C UNIQUE D ALTERNATE KEY

A Stored Procedure B Trigger C Stored Function D None of the above

A It is fast to update the records. B It does not need extra work for SQL queries. C It minimizes the page transfer and maximizes the cache hits. D None of the above is correct.

A TIMESTAMP B INTERVAL MONTH TO DAY C INTERVAL YEAR TO MONTH D TIMESTAMP WITH DATABASE TIMEZONE

A USER_TAB_PRIVS_MADE B USER_COL_PRIVS_MADE C USER_TAB_PRIVS D USER_COL_PRIVS

A The specified table must contain data. B We must have a SELECT privilege on the view. C We should have a SELECT privilege only on the specified table. D The specified table must be in the same database or schema.

A = B BETWEEN C NOT IN D <>