• databases Online Quiz - 154
Back
0

databases Online Quiz - 154

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

What are SQL “SELECT” statement capabilities.

technology databases

  1. Projection

  2. Selection

  3. Join

  4. All of the above

Show answer
Correct Option: D

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

technology databases

  1. Select all columns from EMP;

  2. Select distinct columns from EMP;

  3. Select * from EMP;

  4. All of the above

Show answer
Correct Option: C

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

A Literal is enclosed in double quotes.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

SQL is

technology databases

  1. Structured Query Language

  2. Standard Query Language

  3. System Query Language

  4. Simple Query Language

Show answer
Correct Option: A

Duplicate values are eliminated by which keyword

technology databases

  1. Duplicate

  2. Distinct

  3. Remove

  4. Delete

Show answer
Correct Option: B

The two types of subqueries are:

technology databases

  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

Show answer
Correct Option: D

Single-row subquery returns:

technology databases

  1. Only one row

  2. Two rows

  3. Zero rows

  4. There is no such subquery

Show answer
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);

technology databases

  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

Show answer
Correct Option: D

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

technology databases

  1. IN

  2. OF

  3. ALL

  4. ANY

Show answer
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?

technology databases

  1. IN

  2. OF

  3. ALL

  4. ANY

Show answer
Correct Option: C

A DML statement is executed when you

technology databases

  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

Show answer
Correct Option: D

The right syntax insert a row into a table is

technology databases

  1. Insert to table tablename (….);

  2. Insert into table tablename (….);

  3. Insert into table tablename values (…..);

  4. Any one of the above

Show answer
Correct Option: C

Which is the function that records the current date?

technology databases

  1. Date

  2. Sysdate

  3. Current Date

  4. System Date

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Please select the two phases of Fastload

technology databases

  1. Acquisition

  2. Transaction

  3. Application

  4. Clean Up

Show answer
Correct Option: A,C

DEFINE command in Fastload stands for

technology databases

  1. Define the target table

  2. Define the Work table

  3. Define the input file

  4. Define the Error table

Show answer
Correct Option: C

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

All Fastload commands should start with period(.) character

technology databases

  1. True

  2. False

Show answer
Correct Option: B

The support tables are created in which phase of Multiload

technology databases

  1. Acquisition

  2. Transaction

  3. Application

  4. Preliminary

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions