MS SQL Server - 12 - SQL Basic MCQ

12 – SQL Basic MCQ

Best of luck!

1 / 25

1. What are literal values in SQL?

Special characters used as delimiters

Comments used for documentation

Fixed values used in SQL queries

Identifiers representing tables

2 / 25

2. Which of the following is an example of a string literal in SQL?

'John Smith'

FROM

123

SELECT

3 / 25

3. In SQL, what is the purpose of identifiers?

To specify reserved keywords

To define literal values

To add comments to SQL queries

To uniquely identify database objects

4 / 25

4. Which of the following is an example of an identifier in SQL?

12345

SELECT

employee_id

'John Smith'

5 / 25

5. What is the role of delimiters in SQL?

To specify data types

To separate keywords

To indicate reserved keywords

To enclose string literals

6 / 25

6. In SQL, how are string literals typically enclosed?

With single quotation marks (' ')

With double quotation marks (" ")

With angle brackets (< >)

With square brackets ([ ])

7 / 25

7. Which of the following is a valid SQL delimiter?

@

;

#

!

8 / 25

8. What is the purpose of comments in SQL?

To add explanatory text to SQL code

To specify reserved keywords

To separate identifiers

To enclose string literals

9 / 25

9. Which SQL operator is used to add comments to a single line of code?

//

—

/*

''

10 / 25

10. What is the purpose of reserved keywords in SQL?

To specify data types

To enclose string literals

To define the structure of SQL statements

To add comments to SQL queries

11 / 25

11. Which of the following is a reserved keyword in SQL?

SELECT

12345

employee_id

'John Smith'

12 / 25

12. In SQL, what is the role of square brackets ([ ])?

To specify reserved keywords

To add comments to SQL queries

To delimit identifiers containing spaces or special characters

To enclose string literals

13 / 25

13. Which of the following is NOT a valid SQL comment syntax?

/* This is a comment */

— This is a comment

/* This is a multiline comment */

// This is a comment

14 / 25

14. What is the primary purpose of adding comments to SQL code?

To delimit identifiers

To specify reserved keywords

To enclose string literals

To provide documentation and clarity

15 / 25

15. In SQL, what is the role of double quotation marks (” “)?

To add comments to SQL queries

To specify reserved keywords

To enclose string literals

To delimit identifiers containing spaces or special characters

16 / 25

16. Which of the following is a valid SQL comment syntax for multiline comments?

/* This is a comment */

— This is a comment

// This is a comment

'' This is a comment ''

17 / 25

17. What is the purpose of adding square brackets ([ ]) around an identifier in SQL?

To enclose string literals

To delimit identifiers containing spaces or special characters

To provide multiline comments

To specify reserved keywords

18 / 25

18. Which of the following is a valid SQL delimiter for terminating statements?

:

%

$

;

19 / 25

19. In SQL, how are multiline comments typically enclosed?

With double quotation marks (" ")

With single quotation marks (' ')

With square brackets ([ ])

With /* and */

20 / 25

20. Which SQL operator is used to add multiline comments to code?

/*

—

''

//

21 / 25

21. What is the primary role of reserved keywords in SQL?

To enclose string literals

To add comments to SQL queries

To define the structure and behavior of SQL statements

To specify data types

22 / 25

22. In SQL, how are comments typically indicated?

With — or /* and */

With single quotation marks (' ')

With double quotation marks (" ")

With square brackets ([ ])

23 / 25

23. Which of the following is a valid SQL delimiter for terminating statements?

:

;

%

$

24 / 25

24. In SQL, what is the role of double slashes (//)?

To add single-line comments

To specify reserved keywords

To delimit identifiers containing spaces or special characters

To enclose string literals

25 / 25

25. What is the primary advantage of using delimiters in SQL statements?

They delimit string literals.

They separate keywords and statements.

They allow for multiline comments.

They provide a way to add comments.

Your score is

0%

MS SQL Server – 12 – SQL Basic MCQ