Database Interview Questions - SAP

1. What is the command to create an index?
a) CREATE index name on table (empno)
b) CREATE name index on table
c) CREATE table
d) None of the above

2. What is the command to delete an index?
a) DROP index empno.empid
b) DELETE index empno.empid
c) REMOVE index empno.empid
d) None of the above

3. What is the purpose of NOT NULL constraint?

a) allows NULL values in table
b) allow to pass NULL values in column
c) doesn’t allow NULL values in table
d) doesn’t allow NULL values in column

4. What are different types of primary key exists?
5. What are the constraints used in a database?
6. What is referential integrity constraint?
7. What are the key values it provides?
8. What are the different clauses used inside a foreign key?