Tag: databases

Questions Related to databases

We cannot add SQL functions, WHERE, and JOIN statements to a view
technology databases

  1. True

  2. False

Show answer
Correct Option: B

DATE() returns the current date

technology databases

  1. True

  2. False

Show answer
Correct Option: B

the data type "tinyint" allows whole numbers from 0 to 198
technology databases

  1. True

  2. False

Show answer
Correct Option: B

The WHERE keyword cannot be used with aggregate functions.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

SQL wildcards must not be used with the SQL LIKE operator.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

The IN operator allows you to specify multiple values in a WHERE clause.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

How many categories are available for SQL Commands
technology databases

  1. 1

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: C

Commit is required after truncate command is issued.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following is the correct usage of Order by

technology databases

  1. select col1,col2 from table_a order by col2,col1 desc

  2. select col1,col2 from table_a order by 2,col1 desc

  3. select col1,col2 from table_a order by 2,1

  4. select col1,col2 from table_a order by 1,col2

Show answer
Correct Option: A,C

What are the notations used for writing SQL language
technology databases

  1. OMEGA

  2. RHO

  3. DELTA

  4. PIE

Show answer
Correct Option: B,D