0

databases Online Quiz - 161

Description: databases Online Quiz - 161
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Structured Query Language

  2. Standard Query Language

  3. System Query Language

  4. Simple Query Language


Correct Option: A
  1. It divides both the values and gives the quotient.

  2. It multiplies both the values and gives the product.

  3. It divides both the values and gives the remainder.

  4. There is no such function.


Correct Option: C
  1. It divides both the values and gives the quotient.

  2. It multiplies both the values and gives the product.

  3. It divides both the values and gives the remainder.

  4. There is no such function.


Correct Option: C

To perform wild card search “Like” is used .

  1. True

  2. False


Correct Option: B
  1. When a join condition is omitted.

  2. When a join condition is invalid.

  3. All rows in the first table are joined to all rows in the second table.

  4. All of the above.


Correct Option: D
  1. Single-row Functions and Double-row Functions

  2. One-row Functions and Two-row Functions

  3. Single-row Functions and Multiple-row Functions

  4. None of the above


Correct Option: C

Compare the output of the following: SELECT TRUNC(99.57,1) FROM DUAL; and SELECT ROUND(99.57,1) FROM DUAL;

  1. 99.57,99,6

  2. 99.5,99.6

  3. 99.6,99.6

  4. 99.57,99.57


Correct Option: B
  1. Table1.column1=Table2.column2

  2. Table1.column1=Table2.column1

  3. Table1.column2=Table2.column1

  4. None of the above


Correct Option: B
  1. Return records which have no direct match

  2. Return records which have direct match

  3. Return all the records

  4. None of the above


Correct Option: A
- Hide questions