0

databases Online Quiz - 160

Description: databases Online Quiz - 160
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

____________ is used to join a table to itself.

  1. Selfjoin

  2. Outerjoin

  3. innerjoin

  4. equijoin


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. Duplicate

  2. Distinct

  3. Remove

  4. Delete


Correct Option: B

The two types of subqueries are:

  1. Single-row subquery, Double-row subquery

  2. Double-row subquery, Multiple-row subquery

  3. Multiple-row subquery

  4. Single-row subquery and Multiple subquery


Correct Option: D
  1. Only one row

  2. Two rows

  3. Zero rows

  4. There is no such subquery


Correct Option: A
  1. It gives the name and marks of all the students.

  2. It does not return anything.

  3. It shows an error saying” INVALID SYNTAX ERROR”

  4. It shows an error saying” Single-row subquery returns more than one row


Correct Option: D

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

  1. IN

  2. OF

  3. ALL

  4. ANY


Correct Option: C
  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


Correct Option: D
  1. Insert to table tablename (….);

  2. Insert into table tablename (….);

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

  4. Any one of the above


Correct Option: C

Which is the function that records the current date?

  1. Date

  2. Sysdate

  3. Current Date

  4. System Date


Correct Option: B

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

  1. Distinct

  2. Projection

  3. Where

  4. All of the above


Correct Option: C

Character values are case insensitive

  1. True

  2. False


Correct Option: B
  1. Projection

  2. Selection

  3. Join

  4. All of the above


Correct Option: D
  1. Select all columns from EMP;

  2. Select distinct columns from EMP;

  3. Select * from EMP;

  4. All of the above


Correct Option: C

Select ename from emp where ename =”Scott”; This select statement executes successfully.

  1. True

  2. False


Correct Option: B
- Hide questions