Database Competency Self-Assessment

1. Which SQL clause is used to remove duplicates from the result set? (Easy)

A) DISTINCT B) UNIQUE C) DIFFERENT D) NO_DUPLICATES

2. What is the purpose of a database index? (Easy)

A) To speed up query retrieval B) To enforce data integrity C) To store data D) To back up data

3. What type of join returns all records from the left table and matched records from the right table? (Medium)

A) INNER JOIN B) LEFT JOIN C) RIGHT JOIN D) FULL OUTER JOIN

4. How can you create a view in SQL? (Medium)

A) CREATE VIEW view_name AS SELECT columns FROM table B) CREATE VIEW view_name SELECT columns FROM table C) ALTER VIEW view_name AS SELECT columns FROM table D) UPDATE VIEW view_name AS SELECT columns FROM table

5. What is a trigger in a database? (Medium)

A) A stored procedure that is automatically executed in response to certain events B) A manual query that updates data C) A type of index D) A way to back up data

6. What SQL statement is used to back up a database? (Expert)

A) BACKUP DATABASE B) BACKUP TABLE C) SAVE DATABASE D) EXPORT DATABASE

7. How can you handle a deadlock in SQL? (Expert)

A) By using proper transaction isolation levels and locking mechanisms B) By restarting the database server C) By manually killing processes D) By disabling triggers

8. What is the purpose of a cursor in SQL? (Expert)

A) To iterate over a result set row by row B) To store data temporarily C) To back up a database D) To create indexes

9. How do you define a stored procedure in SQL? (Expert)

A) CREATE PROCEDURE procedure_name AS BEGIN ... END B) CREATE FUNCTION function_name AS BEGIN ... END C) CREATE VIEW view_name AS SELECT ... D) CREATE TRIGGER trigger_name AS BEGIN ... END

10. What is the difference between a procedure and a function in SQL? (Expert)

A) A procedure does not return a value, while a function returns a value B) A function does not accept parameters, while a procedure does C) A procedure is used for data retrieval, while a function is used for data manipulation D) A procedure and a function are the same

11:00 - 17:00

Contact Us