databases Online Quiz - 151

Description: databases Online Quiz - 151
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Duplicate

  2. Distinct

  3. Remove

  4. Delete

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

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

The right syntax insert a row into a table is

  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

Concatenation operator is

  1. +

  2. -

  3. ||

  4. *

Correct Option: C

A Literal is enclosed in double quotes.

  1. True

  2. False

Correct Option: B
  1. Structured Query Language

  2. Standard Query Language

  3. System Query Language

  4. Simple Query Language

Correct Option: A
  1. Date

  2. Sysdate

  3. Current Date

  4. System Date

Correct Option: B

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

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

  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

Which is the command line tool to execute SQL Server Integration Services packages?





Correct Option: A
  1. distributes a row to single output and another to the other output

  2. distributes its input to one or more outputs

  3. join two inputs

  4. extract data from a connection

Correct Option: B

Which of the following is not a Control Flow Element?

  1. Containers

  2. Tasks

  3. Transformations

  4. Precedence Constraints

Correct Option: C
- Hide questions