Q 1 - Which of the following is not true about a FOREIGN KEY constraint?

A - It is a referential integrity constraint.

B - It establishes a relationship between a primary key or a unique key in the same table or a different table.

C - A foreign key value cannot be null.

D - A foreign key value must match an existing value in the parent table.

Q 2 - Which of the following is not true about use of a database view?

A - It restricts data access.

B - It makes queries easy.

C - It provides data independence.

D - It prevents different views of same data.

Q 3 - Which of the following is not true about simple views?

A - They derive data from one table.

B - They contain no functions or grouping.

C - You cannot perform DML operations through a simple view.

D - All of the above are true.

Q 4 - Which of the following is not true about complex views?

A - They derive data from more than one table.

B - They contain no functions or grouping.

C - You cannot perform DML operations through a complex view.

D - All of the above are true.

Q 5 - Consider the following schema −

STUDENTS(student_code, first_name, last_name, email, 
         phone_no, date_of_birth, honours_subject, percentage_of_marks);

Which of the following code will create a simple view named all_marks_english that contains the names and percentage of marks of the students in the honours_subject ‘Eng01’?

A - create view all_marks_english as select first_name, last_name, percentage_of_marks from students where honours_subject = ‘Eng01’;

B - create view all_marks_english as ( first_name, last_name, percentage_of_marks from students where honours_subject = ‘Eng01’);

C - select view all_marks_english as select first_name, last_name, percentage_of_marks from students where honours_subject = ‘Eng01’;

D - None of the above.

Q 6 - Which of the following code will retrieve data from the view all_marks_english, created in the previous question?

A - select view all_marks_english;

B - select from all_marks_english;

C - retrieve from all_marks_english;

D - select * from all_marks_english;

Q 7 - Which of the following code will delete a view named all_marks_english?

A - delete view all_marks_english;

B - drop view all_marks_english;

C - delete all_marks_english;

D - drop all_marks_english;

Q 8 - Which of the following is not true about a sequence?

A - They are used for generating sequential numbers.

B - Sequences are created by the CREATE SEQUENCE statement.

C - You cannot modify a sequence.

D - None of the above.

Q 9 - Which of the following minimal code would create a sequence named loc_seq as a primary key of the LOCATIONS table?

A - create sequence loc_seq;

B - create sequence loc_seq on locations;

C - create loc_seq;

D - None of the above.

Q 10 - Which of the following statement is used to modify a sequence?

A - ALTER SEQUENCE

B - SELECT SEQUENCE

C - DROP SEQUENCE

D - None of the above.

Q 11 - Which of the following is not true about the Pseudocolumns that return the sequence values?

A - NEXTVAL returns the next available sequence value.

B - CURRVAL gets the current sequence value.

C - PREVVAL gets the previous sequence value.

D - None of the above.

Q 12 - Which of the following code will delete a sequence named loc_seq?

A - delete sequence loc-seq;

B - drop sequence loc_seq;

C - delete primary key loc_sec;

D - drop primary key loc_sec;

Q 13 - Which of the following is true about database indexes?

A - You can create an index on one or more columns.

B - Indexes always slow down the speed of query process.

C - Indexes are always created automatically.

D - Indexes should ideally be created on small tables.

Q 14 - Which of the following code will create an index named stu_marks_ind on the columns student_code and percentage_of_marks of the STUDENTS table?

A - It’s not possible to create an index on two columns.

B - create index stu_marks_ind from students(student_code, percentage_of_marks);

C - create index stu_marks_ind on students(student_code, percentage_of_marks);

D - create index stu_marks_ind (student_code, percentage_of_marks) on students;

Q 15 - Which of the following code will create an index named

stu_marks_ind on the columns student_code and percentage_of_marks of the STUDENTS table.

Now which will delete the index stu_marks_ind.

Which of the following code will delete an index stu_marks_ind on the columns student_code and percentage_of_marks of the STUDENTS table?

A - drop index stu_marks_ind;

B - delete index stu_marks_ind;

C - drop stu_marks_ind;

D - drop index stu_marks_ind on students;

Q 16 - Which of the following is not true about database synonyms?

A - Synonyms are used for shortening lengthy object names.

B - A synonym is just an alternative name.

C - Synonyms can be created for tables, views, sequences, procedures and other database objects.

D - None of the above.

Q 17 - A database administrator can

A - Create users.

B - Create privileges.

C - Grant privileges.

D - All of the above.

Q 18 - Which of the following is a system privilege?

A - Creating new users

B - Removing users

C - Removing tables

D - All of the above.

Q 19 - Which of the following is not a developer’s privilege?

A - CREATE USER

B - CREATE TABLE

C - CREATE VIEW

D - CREATE SEQUENCE

Q 20 - Which statement is used for allocating system privileges to the users?

A - CREATE

B - GRANT

C - REVOKE

D - ROLE

Q 21 - Which of the following is true about a role?

A - A role is a named group of related privileges.

B - It can be it can be created and assigned to a user.

C - It can be revoked from a user.

D - All of the above.

Q 22 - Which of the following code would create a role named student_admin?

A - CREATE student_admin;

B - GRANT student_admin;

C - CREATE ROLE student_admin;

D - ROLE student_admin;

Q 23 - Which of the following code would allocate the privileges of creating tables and view to the role named student_admin?

A - grant create table, create view to student_admin;

B - grant to student_admin create table, create view;

C - grant role student_admin create table, create view;

D - None of the above.

Q 24 - Which of the following code would grant the role student_admin to a user named william?

A - grant student_admin to william;

B - grant to william student_admin;

C - grant william student_admin;

D - None of the above.

Q 25 - Which of the following statements allows William to change his database user account password to bill?

A - create user william identified by bill;

B - alter user william identified by bill

C - create user william password bill;

D - alter user william password bill;