Tag: databases

Questions Related to databases

Which of the following is not a multiple-row operator?
technology databases

  1. IN

  2. OF

  3. ALL

  4. ANY

Show answer
Correct Option: B

Which operator compares a value to every value returned by a subquery?
technology databases

  1. IN

  2. OF

  3. ALL

  4. ANY

Show answer
Correct Option: C

A DML statement is executed when you

technology databases

  1. Add new rows to a table

  2. Modify existing rows of a table

  3. Remove existing rows from a table

  4. All of the above

Show answer
Correct Option: D

The right syntax insert a row into a table is
technology databases

  1. Insert to table tablename (….);

  2. Insert into table tablename (….);

  3. Insert into table tablename values (…..);

  4. Any one of the above

Show answer
Correct Option: C

Which is the function that records the current date?

technology databases

  1. Date

  2. Sysdate

  3. Current Date

  4. System Date

Show answer
Correct Option: B

Limiting the rows in a select statement for a specific condition is done by the clause

technology databases

  1. Distinct

  2. Projection

  3. Where

  4. All of the above

Show answer
Correct Option: C

Character values are case insensitive
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Arithmetic expressions containing a null value evaluate to null.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Concatenation operator is

technology databases

  1. +

  2. -

  3. ||

  4. *

Show answer
Correct Option: C

What are SQL “SELECT” statement capabilities.
technology databases

  1. Projection

  2. Selection

  3. Join

  4. All of the above

Show answer
Correct Option: D