Q 1 - Which of the following is not true about multiple-row subqueries?

A - Multiple row subqueries return multiple rows from the outer SELECT statement.

B - Multiple row subqueries return multiple rows from the inner SELECT statement.

C - Multiple row subqueries use multiple-row comparison operators.

D - All of the above.

Q 2 - Which of the following comparison operators could be used in a multiple row query?

A - IN operator

B - ANY operator

C - ALL operator

D - All of the above

Q 3 - In which of the following cases a DML statement is executed?

A - When new rows are added to a table.

B - When a table is created.

C - When a transaction is committed.

D - None of the above.

Q 4 - In which of the following cases a DML statement is not executed?

A - When existing rows are modified

B - When some rows are deleted

C - When a table is deleted

D - All of the above

Q 5 - Which of the following is not true about inserting news rows to a table?

A - The INSERT INTO statement is used for inserting new rows to a table

B - You cannot insert rows with NULL values to a table.

C - You may insert a new row containing values for each column.

D - All of the above.

Q 6 - Which of the following is true about inserting news rows to a table?

A - You must list values in the default order of the columns in the table.

B - You can also list the columns in the INSERT clause.

C - You can use the INSERT statement to add rows from one table to another.

D - All of the above.

Q 7 - Which of the following is not true about modifying rows in a table?

A - Existing rows in a table are modified using the UPDATE statement.

B - You can update more than one row at a time.

C - All the rows in a table are modified if you omit the WHERE clause.

D - None of the above.

Q 8 - Which of the following is true about modifying rows in a table?

A - You can update some rows in a table based on values from another table.

B - If you try to update a record related to an integrity constraint, it raises an error.

C - You can modify multiple columns.

D - All of the above.

Q 9 - Which of the following is true about removing rows from a table?

A - You remove existing rows from a table using the DELETE statement

B - No rows are deleted if you omit the WHERE clause.

C - You cannot delete rows based on values from another table.

D - All of the above.

Q 10 - Which of the following is not true about removing rows from a table?

A - You can use a subquery in a DELETE statement.

B - Specific rows are deleted based on the WHERE clause condition.

C - A statement like, DELETE , would cause deletion of the table from the database.

D - All of the above.

Q 11 - Which statement allows conditional update, or insertion of data into a table simultaneously?

A - INSERT statement

B - MERGE statement

C - UPDATE statement

D - None of the above

Q 12 - A transaction starts when

A - A COMMIT statement is issued

B - A ROLLBACK statement is issued

C - A CREATE statement is used

D - All of the above

Q 13 - Which of the following is true about the SQL transaction control statements?

A - They ensure data consistency.

B - They allow preview of data changes before making permanent changes in data.

C - They group logically related operations.

D - All are true.

Q 14 - Which of the following is NOT true about the SQL transaction control statements?

A - The COMMIT statement ends the current transaction and makes all data changes permanent.

B - The ROLLBACK statement ends the transaction and discards all the pending data changes.

C - Each DML statement is automatically committed.

D - All are true.

Q 15 - Which of the following is not true about the database objects?

A - Indexes improve performance of queries.

B - Views give alternative names to objects.

C - Sequences are numeric value generators.

D - Tables are the basic unit of storage.

Q 16 - Which of the following is true about the CREATE TABLE statement?

A - This is a DML statement.

B - This statement also record information in the data dictionary.

C - You don’t need any privilege to use this statement.

D - All of the above.

Q 17 - Which of the following is not true about the ALTER TABLE statement?

A - It can add a new row.

B - It can add a new column.

C - It can modify existing columns.

D - It can define a default value for the new column.

Q 18 - Consider the following schema −

LOCATIONS(subject_code, department_name, location_id, city);

Which code snippet will alter the table LOCATIONS and add a column named Address, with datatype VARCHAR2(100)?

A - ALTER TABLE locations ADD (address varchar2(100));

B - ALTER TABLE locations ADD COLUMN(address varchar2(100));

C - MODIFY TABLE locations ADD COLUMN (address varchar2(100));

D - None of the above.

Q 19 - Consider the following schema −

LOCATIONS(subject_code, department_name, location_id, city);

Which code snippet will alter the table LOCATIONS and change the datatype of the column CITY to varchar2(30)?

A - ALTER TABLE locations MODIFY COLUMN (city varchar2(30));

B - MODIFY TABLE locations ADD (city varchar2(30));

C - ALTER TABLE locations MODIFY (city varchar2(30));

D - None of the above.

Q 20 - Consider the following schema −

LOCATIONS(subject_code, department_name, location_id, city);

Which code snippet will alter the table LOCATIONS and delete the column named CITY?

A - MODIFY TABLE locations DROP (city varchar2(30));

B - ALTER TABLE locations DROP COLUMN city;

C - ALTER TABLE locations DROP (city);

D - None of the above.

Q 21 - Which of the following code will successfully delete the table LOCATIONS from the database?

A - DROP TABLE locations;

B - DELETE TABLE locations;

C - TRUNCATE TABLE locations;

D - None of the above.

Q 22 - Which of the following is true about deleting a table from the database?

A - All the data in the table are deleted

B - The table structure is removed

C - The indexes in the table are deleted

D - All of the above.

Q 23 - Which of the following code will remove all the rows from the table LOCATIONS?

A - DROP TABLE locations;

B - DELETE TABLE locations;

C - TRUNCATE TABLE locations;

D - None of the above.

Q 24 - Which of the following is not true about constraints?

A - A NOT NULL constraint specifies that the column cannot have a null value.

B - A UNIQUE constraint specifies that a column or a combination of column must have unique values for all rows.

C - A PRIMARY KEY is same as UNIQUE.

D - A FOREIGN KEY enforces a foreign key relationship between a column and a referenced table.

Q 25 - Which of the following is not true about creating constraints?

A - Constraints are defined using the CREATE CONSTRAINT statement.

B - They are created at the same time when the table is created.

C - They could be created after the table is created.

D - All the constraints are stored in data dictionary.