databases Online Quiz - 154

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

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

What is the result of the query below? SELECT Stud_name, Rollnum FROM STUDENT WHERE stud_marks=(SELECT MIN (stud_marks) FROM STUDENT GROUPBY Rollnum);

  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

A DML statement is executed when you

  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

Fastload does not use Transient Journal

  1. True

  2. False

Correct Option: A
  1. Acquisition

  2. Transaction

  3. Application

  4. Clean Up

Correct Option: A,C
  1. Define the target table

  2. Define the Work table

  3. Define the input file

  4. Define the Error table

Correct Option: C

It is possible to restart Fastload script when the target table is created in the script

  1. True

  2. False

Correct Option: B

The support tables are created in which phase of Multiload

  1. Acquisition

  2. Transaction

  3. Application

  4. Preliminary

Correct Option: D
- Hide questions