SQL Quiz

Which of the following keyword is used to raise an error in stored procedure?

• ERROR

• RAISERROR

• THROWERROR

• DISPLAY

What is the purpose of the SQL keyword "GROUP BY"?

• To filter rows in a table

• To join multiple tables

• To sort data in ascending order

• To group rows with the same values

Which SQL is used in SQL Server?

• PL/SQL

• SQL

• T-SQL

• Not all of them

Which virtual table is created when the trigger statement is executed?

• updated and deleted

• deleted and inserted

• inserted and updated

• selected and inserted

Which the isolation level below is the default of transaction?

• Serializable

• Repeatable read

• Read Committed

• Read Uncommitted

Fill right answer: ALTER TABLE users ____CONSTRAINT PK_Users_ID PRIMARY KEY (id);

• INSERT

• ADD

• REFERENCE

• ON

Which statement is used to remove rows from a table?

• DELETE

• DROP

• REMOVE

• ERASE

Which join type is most rarely used?

• LEFT JOIN

• INNER JOIN

• RIGHT JOIN

• CROSS JOIN

Write a SELECT query to list the employee whose salary within 500 and 1.000

• ...IN 100 AND 1000

• ...WITHIN 500 AND 1000

• ...BETWEEN 500 AND 1000

• ...<500 and >1000

CHECK in database is a ____ statement

• DDL

• DML

• DCL

• TCL