0

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

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

Which of the following is not a multiple-row operator?

  1. IN

  2. OF

  3. ALL

  4. ANY


Correct Option: B

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

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

Arithmetic expressions containing a null value evaluate to null.

  1. True

  2. False


Correct Option: B
Explanation:

To solve this question, the user needs to know what a null value is and how arithmetic expressions are evaluated.

A null value is a value that represents an absence of a value or an unknown value. In arithmetic expressions, null values can occur when a value is missing or undefined.

Now, let's go through each option and explain why it is right or wrong:

A. True: This option is incorrect. Arithmetic expressions containing a null value do not necessarily evaluate to null. The actual result depends on the specific operation being performed and the other values in the expression.

B. False: This option is correct. Arithmetic expressions containing a null value do not necessarily evaluate to null. The actual result depends on the specific operation being performed and the other values in the expression.

The Answer is: B

SQL is

  1. Structured Query Language

  2. Standard Query Language

  3. System Query Language

  4. Simple Query Language


Correct Option: A

Which is the function that records the current date?

  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

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

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

  1. DTEXEC

  2. DTSEXEC

  3. SQLEXEC

  4. PSEXEC


Correct Option: A

Function of Multicast Transformation is:

  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