Tag: databases

Questions Related to databases

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

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