Oracle - Variables constants comments literals MCQ

Oracle – Variables constants comments literals

1 / 25

1. What is a variable in Oracle SQL?

A database table

A constant value that cannot be modified

A named storage location whose value can be changed during program execution

A reserved keyword

2 / 25

2. Which type of literal represents a text value in SQL?

Date literal

String literal

Integer literal

Boolean literal

3 / 25

3. What does the term “integer literal” refer to in SQL?

A date value expressed as a string

A text value enclosed in single quotes

A whole number without a decimal point

A binary value

4 / 25

4. In SQL, what is the purpose of using comments within your SQL statements?

To execute the SQL statement

To remove SQL statements

To explain the purpose of the SQL statement

To create a new table

5 / 25

5. Which of the following represents a valid integer literal in SQL?

'123'

0x1A

42

3.14

6 / 25

6. What is a constant in Oracle SQL?

A named storage location whose value can be changed during program execution

A reserved keyword

A database table

A constant value that cannot be modified

7 / 25

7. Which type of literal represents a number value in SQL?

Numeric literal

Date literal

String literal

Integer literal

8 / 25

8. What is the purpose of using single quotes around text literals in SQL?

To specify a variable

To define a text value

To create a table

To indicate a comment

9 / 25

9. In SQL, what does the term “numeric literal” refer to?

A binary value

A date value expressed as a string

A text value enclosed in single quotes

A whole number without a decimal point

10 / 25

10. Which of the following represents a valid text literal in SQL?

'Hello, World!'

123

TRUE

3.14

11 / 25

11. What is the purpose of using comments in SQL statements?

To create a new table

To hide the SQL statement

To explain the purpose of the SQL statement

To execute the SQL statement

12 / 25

12. Which of the following is a valid date literal in SQL?

3.14

'Hello, World!'

123

'2023-10-15'

13 / 25

13. What is the primary role of variables in SQL?

To store data that cannot be changed

To create comments

To store data that can be modified during program execution

To store data in database tables

14 / 25

14. Which type of literal represents a date value in SQL?

String literal

Date literal

Boolean literal

Integer literal

15 / 25

15. In SQL, what does the term “boolean literal” refer to?

A true or false value

A text value enclosed in single quotes

A whole number without a decimal point

A date value expressed as a string

16 / 25

16. Which of the following is a valid boolean literal in SQL?

'TRUE'

123

FALSE

'Hello, World!'

17 / 25

17. What is the purpose of using double quotes around identifiers in SQL?

To create a new table

To enclose case-sensitive identifiers

To specify a variable

To indicate a comment

18 / 25

18. In SQL, what does the term “identifier” refer to?

A reserved keyword

A text value

A user-defined name for a database object

A numeric value

19 / 25

19. Which of the following is a valid identifier in SQL?

'Column1'

123

Employee_Name

SELECT

20 / 25

20. What is the primary role of constants in SQL?

To store data that cannot be changed

To store data in database tables

To store data that can be modified during program execution

To create comments

21 / 25

21. Which type of literal represents a binary value in SQL?

String literal

Binary literal

Integer literal

Date literal

22 / 25

22. In SQL, what does the term “binary literal” refer to?

A whole number without a decimal point

A text value enclosed in single quotes

A binary value

A date value expressed as a string

23 / 25

23. Which of the following is a valid binary literal in SQL?

X'ABCD'

'Hello, World!'

'1101'

123

24 / 25

24. What is the purpose of using /* / for comments in SQL statements?

To execute the SQL statement

To enclose multi-line comments

To create a new table

To indicate a single-line comment

25 / 25

Oracle – Variables constants comments literals MCQ