MySQL Learn Simpli September 6, 2019 no Comments 1. What is it called as when a column that automatically generates numeric values? Identity column Candidate column Unique column Integer column None 2. Which are valid Transaction levels in SQL Server in the following answers? READ UNCOMMITTED REPEATABLE READ All of the above READ COMMITTED None 3. What does ACID stands for in SQL? Atomicity, Consistency, Isolation, Decoupled Atomicity, Consistency, Isolation, Durability Automatic, Concurrent, Isolation, Durability Atomic, Cryptic, Independent, Durable None 4. Which is the correct order of query operators in a SQL query? FROM -> OUTER -> GROUP BY -> WHERE FROM -> OUTER -> WHERE -> ON SELECT -> FROM -> OUTER -> WHERE SELECT -> FROM -> WHERE -> OUTER None 5. What is meant by indexes? Index speed up the data retrieval Index stores large number of integer values Index minimize the data redundancy None of the above. None 6. What does OLTP stands for? Online Timebound Processing Offline Transaction Processing Online Transactional Processing Ontime Transaction Program None 7. Which of the followings are the types of locks in SQL Server? Shared locks All of the above Exclusive locks None 8. Which are the authentication modes in SQL Server? All of the above Mixed mode none Windows mode None 9. What is meant by Primary Key in SQL? Primary keys are unique names of a table. Primary keys are unique identifiers for each row in a table. primary is no of rows in table Primary keys are integer ids in a table rows. None 10. What does RAID stands for? Redundant Automatic Individual Durable Reduce Array of Independent Disks Redundant Array of Independent Disks Redundancy Accelerator Independent Disks None Time's up
