CS312 Final Term MSQs

Q1. -------------Statement is used to view the data from database?

1. Select
2. Join
3. View
4. Create

Q2. Which is not related to SQL?

1. Data Translation Language
2. Data Manipulation Language
3. Data definition language
4. Data control Language

Q3. Which wildcard character is used in SQL?

1. $
2. #

C)! D) %

Q4. Which of the following command will be used if you want to permanently save the changes made in database?

Select the correct option

A. Save point B. Store C. Commit D. Rollback

Q5. Where closure restricts-----------returned as a result after execution of select command?

A Column B Attributes C Rows D Tables

Q6. Single Functions one or more argument (s) and return -------Value (s) for each row returned by the query?

A Two B four C Three E One

Q7. Which logical operator will be used in where clause of SQL statement if you want to display the list of all employee names who are earning more than 2500 but less than 5000?

1. XOR
2. AND
3. OR
4. NOT

Q8. The Rollback statement is the transactional command used to save changes invoked by a transaction to the database?

1. True
2. False

Q9. ---------- is used to extract unique values of column from the table?

1. Single
2. *
3. Unique
4. Distinct

Q10. -------- is used in the transaction which have not already been stored in the database?

1. Truncate
2. Rollback
3. Undo
4. Commit

Q11. Groups of functions manipulate groups of rows to give results per group of rows?

1. Four
2. One
3. Three
4. Two

Q12. Insert, Update and delete are the command?

1. DOL
2. DLL
3. DML
4. DCA

Q13. ------- is Multi Rows/Group function?

1. ROUND
2. CONCAT
3. COUNT
4. INSERT

Q14. Which of these is NOT an anomaly?

1. Insert anomaly
2. Delete anomaly
3. Search anomaly
4. Update anomaly

Answer: Answer: c) Search anomaly

Q15. Insert anomalies typically occur due to:

1. Poor table design
2. Missing data constraints
3. Complex relationships between attributes
4. Redundant relationships

Answer: Answer: a) Poor table design

Q16. Which anomaly results in inconsistent data after multiple updates?

1. Delete anomaly