0

databases Online Quiz - 159

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

A Literal is enclosed in double quotes.

  1. True

  2. False


Correct Option: B

SQL is

  1. Structured Query Language

  2. Standard Query Language

  3. System Query Language

  4. Simple Query Language


Correct Option: A

Character values are case insensitive

  1. True

  2. False


Correct Option: B

What are SQL “SELECT” statement capabilities.

  1. Projection

  2. Selection

  3. Join

  4. All of the above


Correct Option: D

To select all the columns from a table EMP, which one of the following is TRUE?

  1. Select all columns from EMP;

  2. Select distinct columns from EMP;

  3. Select * from EMP;

  4. All of the above


Correct Option: C

SQL is

  1. Structured Query Language

  2. Standard Query Language

  3. System Query Language

  4. Simple Query Language


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

Single-row subquery returns:

  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 of the following is not a multiple-row operator?

  1. IN

  2. OF

  3. ALL

  4. ANY


Correct Option: B
  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
  1. Date

  2. Sysdate

  3. Current Date

  4. System Date


Correct Option: B
- Hide questions