0

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

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

  1. True

  2. False


Correct Option: B

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

Duplicate values are eliminated by which keyword

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

  1. IN

  2. OF

  3. ALL

  4. ANY


Correct Option: B

AI Explanation

To answer this question, we need to understand the concept of multiple-row operators.

Multiple-row operators are operators that can be used to compare a single value with multiple values in a subquery result set. These operators include "IN", "ALL", and "ANY".

Let's go through each option to understand why it is correct or incorrect:

Option A) IN - This option is a multiple-row operator. It allows you to check if a value matches any value in a list or a subquery result set.

Option B) OF - This option is not a multiple-row operator. It is not used for comparing a single value with multiple values in a subquery result set. Therefore, this option is correct.

Option C) ALL - This option is a multiple-row operator. It allows you to check if a value matches all the values in a list or a subquery result set.

Option D) ANY - This option is a multiple-row operator. It allows you to check if a value matches any one of the values in a list or a subquery result set.

The correct answer is B) OF. This option is not a multiple-row operator.

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

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

Which is the function that records the current date?

  1. Date

  2. Sysdate

  3. Current Date

  4. System Date


Correct Option: B

AI Explanation

To answer this question, you need to understand the functions that can record the current date in programming or database languages.

Option A) Date - This option is incorrect. The "Date" function is not commonly used to record the current date. It is used to create a new date object or to manipulate existing date objects in some programming languages.

Option B) Sysdate - This option is correct. The "Sysdate" function is commonly used in database languages like SQL to record the current date and time. It returns the current system date and time of the database server.

Option C) Current Date - This option is incorrect. The "Current Date" is not a standard function that records the current date in programming or database languages.

Option D) System Date - This option is incorrect. The "System Date" is not a standard function that records the current date in programming or database languages.

The correct answer is B) Sysdate. This option is correct because the "Sysdate" function is commonly used to record the current date in database languages like SQL.

Fastload does not use Transient Journal

  1. True

  2. False


Correct Option: A

Please select the two phases of Fastload

  1. Acquisition

  2. Transaction

  3. Application

  4. Clean Up


Correct Option: A,C

DEFINE command in Fastload stands for

  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

All Fastload commands should start with period(.) character

  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