MySQL Learn Simpli September 6, 2019 no Comments 1. Which keyword is used to raise an error in stored procedure in the following answers? RAISERROR ERROR THROW THROWERROR None 2. Difference between Primary key and Unique key? Primary key doesn’t allow null value whereas unique key allows one null value. Primary key allows one null value whereas unique key allows multiple null values. Primary key allows one null value whereas unique key doesn’t allow null value. Primary key doesn’t allow null value whereas unique key allows multiple null values None 3. Which are the different types of trigger in SQL? DDL and DCL DML and DDL DDL and DUL DML and DTL None 4. What does RAID stands for? Reduce Array of Independent Disks Redundant Array of Independent Disks Redundancy Accelerator Independent Disks Redundant Automatic Individual Durable None 5. What does a trigger means in SQL? A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. A trigger is a SQL procedure that performs some tasks on accessing db tables. A trigger is a procedure which executes when an error occurred. A trigger is an event that can be raised from Stored Procedures. None 6. What do you meant by normalization? It is a set of rules to improve database performance. It is a set of rules to normalize database transactions. It is a set of database design rules to minimize redundancy. None of the above None 7. Which of the followings are the types of locks in SQL Server? Exclusive locks All of the above Shared locks None 8. How many types of indexes are there in SQL server? Unique and non-unique Clustered and Non clustered none Integer and string None 9. Which is the correct order of query operators in a SQL query? SELECT -> FROM -> OUTER -> WHERE FROM -> OUTER -> WHERE -> ON FROM -> OUTER -> GROUP BY -> WHERE SELECT -> FROM -> WHERE -> OUTER None 10. What is meant by indexes? Index speed up the data retrieval Index minimize the data redundancy None of the above. Index stores large number of integer values None Time's up
