Tag: databases

Questions Related to databases

Concatenation operator is
technology databases

  1. +

  2. -

  3. ||

  4. *

Show answer
Correct Option: C

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

Limiting the rows in a select statement for a specific condition is done by the clause
technology databases

  1. Distinct

  2. Projection

  3. Where

  4. All 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

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

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

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

technology databases

  1. DTEXEC

  2. DTSEXEC

  3. SQLEXEC

  4. PSEXEC

Show answer
Correct Option: A