Database Interview Questions - 3i Infotech

1. RDBMS file system can be defined as

a) Interrelated
b) Independent
c) Unrelated
d) None of the above

2. What is a super key?

a) Primary key and attribute
b) Foreign key
c) Composite key
d) Unique key

3. You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

a) CREATE INdEX emp_empno_idx ON employee, empno;
b) CREATE INdEX emp_empno_idx FOR employee, empno;
c) CREATE INdEX emp_empno_idx ON employee(empno);
d) CREATE emp_empno_idx INdEX ON employee(empno);

4. Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

a) ALTER TABLE employee DROP PRIMARY KEY CASCAdE;
b) ALTER TABLE employee DELETE PRIMARY KEY CASCAdE;
c) ALTER TABLE employee DROP PRIMARY KEY employee_id_pk CASCAdE;
d) MODIFY TABLE employee DELETE PRIMARY KEY employee_id_pk CASCAdE;

5. Which three commands cause a transaction to end?

a) ALTER b) GRANT c) DELETE d) INSERT e) UPdATE
f) ROLLBACK

6. Under which circumstance should you create an index on a table?

a) The table is small.
b) The table is updated frequently.
c) A columns values are static and contain a narrow range of values
d) Two columns are consistently used in the WHERE clause join condition of SELECT statements.