MySQL Learn Simpli September 6, 2019 no Comments 1. What does OLTP stands for? Online Timebound Processing Ontime Transaction Program Online Transactional Processing Offline Transaction Processing None 2. How many types of indexes are there in SQL server? Clustered and Non clustered none Integer and string Unique and non-unique None 3. Which are valid Transaction levels in SQL Server in the following answers? All of the above REPEATABLE READ READ COMMITTED READ UNCOMMITTED None 4. What is meant by indexes? None of the above. Index minimize the data redundancy Index speed up the data retrieval Index stores large number of integer values None 5. Which is the correct order of query operators in a SQL query? FROM -> OUTER -> GROUP BY -> WHERE SELECT -> FROM -> WHERE -> OUTER FROM -> OUTER -> WHERE -> ON SELECT -> FROM -> OUTER -> WHERE None 6. Which keyword is used to raise an error in stored procedure in the following answers? ERROR THROW THROWERROR RAISERROR None 7. What is meant by Primary Key in SQL? 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. Primary keys are unique names of a table. None 8. What is it called as when a column that automatically generates numeric values? Candidate column Integer column Unique column Identity column None 9. What do you meant by normalization? It is a set of rules to improve database performance. It is a set of database design rules to minimize redundancy. It is a set of rules to normalize database transactions. None of the above None 10. Which are the different types of trigger in SQL? DML and DDL DDL and DCL DML and DTL DDL and DUL None Time's up
