MySQL Learn Simpli September 6, 2019 no Comments 1. Which are the authentication modes in SQL Server? Mixed mode Windows mode none All of the above None 2. Which keyword is used to raise an error in stored procedure in the following answers? THROW ERROR THROWERROR RAISERROR None 3. What does RAID stands for? Redundancy Accelerator Independent Disks Reduce Array of Independent Disks Redundant Automatic Individual Durable Redundant Array of Independent Disks None 4. Which are valid Transaction levels in SQL Server in the following answers? READ UNCOMMITTED REPEATABLE READ All of the above READ COMMITTED None 5. What does a trigger means in SQL? A trigger is a procedure which executes when an error occurred. A trigger is a SQL procedure that performs some tasks on accessing db tables. A trigger is an event that can be raised from Stored Procedures. A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. None 6. What is meant by Primary Key in SQL? Primary keys are integer ids in a table rows. Primary keys are unique names of a table. primary is no of rows in table Primary keys are unique identifiers for each row in a table. None 7. Which is not a valid data type in SQL server in the following answers? nvarchar money blob xml None 8. How many types of indexes are there in SQL server? Integer and string Clustered and Non clustered none Unique and non-unique None 9. What do you meant by normalization? None of the above It is a set of rules to normalize database transactions. It is a set of rules to improve database performance. It is a set of database design rules to minimize redundancy. None 10. What is meant by indexes? None of the above. Index stores large number of integer values Index minimize the data redundancy Index speed up the data retrieval None Time's up
