DDL interview questions part 1
DDL interview questions part 1
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Correct Answer is : Data Definition Language(DDL)
2. Which of the following is/are the DDL statements?
Correct Answer is : All of the Mentioned
3. In SQL, which command(s) is(are) used to change a table’s storage characteristics?
Correct Answer is : ALTER TABLE
4. In SQL, which of the following is not a data definition language commands?
Correct Answer is : RENAME
5. ________clause is an additional filter that is applied to the result.
Correct Answer is : Having
6. ___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
Correct Answer is : Constraint
7. SQL has how many main commands for DDL:
Correct Answer is : 3
8. Which command defines its columns, integrity constraint in create table:
Correct Answer is : Create command
9. Which command is used for removing a table and all its data from the database:
Correct Answer is : Drop table command
10. Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:
Correct Answer is : TRUNCATE command
11. _____________ is special type of trigger based on CLR environment.
Correct Answer is : CLR
12. Point out the correct statement :
Correct Answer is : Logon triggers are special type of trigger that fire when LOGON event of Sql Server is raised
13. DDL triggers can be applied to __________ statement.
Correct Answer is : CREATE
14. INSTEAD of clause cannot be used for ____________ trigger.
Correct Answer is : DDL
15. Point out the wrong statement :
Correct Answer is : DML trigger can be used to observe and control actions performed on the server, and to audit these operations
16. Purpose of DDL Trigger is to :
Correct Answer is : All of the mentioned
17. DDL triggers can only fire after the ______ statement has occurred.
Correct Answer is : DDL
18. How many types of DDL Trigger is present in SQL Server ?
Correct Answer is : 2
19. ____________ triggers do not create the special inserted and deleted tables.
Correct Answer is : DDL
20. Scope of DDL triggers in SQL Server can be :
Correct Answer is : Server
