Tag: databases

Questions Related to databases

SET clause in CREATE statement allows duplicate rows whereas MULTISET will not

technology databases

  1. True

  2. False

Show answer
Correct Option: B

These joins always requires SPOOL Files

technology databases

  1. Product Join

  2. Exclusion Merge Join

  3. Merge Join

  4. All the Above

Show answer
Correct Option: D

What does SQL stand for?

technology databases

  1. Structured Question Language

  2. Structured Query Language

  3. Strong Question Language

  4. None

Show answer
Correct Option: B

Select the DDL Statement from below:
technology databases

  1. SELECT

  2. UPDATE

  3. DELETE

  4. ALTER

Show answer
Correct Option: D

SQL is case sensitive

technology databases

  1. True

  2. False

Show answer
Correct Option: B

The SQL statement used to delete a table:
technology databases

  1. DROP

  2. DELETE

  3. TRUNCATE

  4. All the Above

Show answer
Correct Option: A

The AND operator displays a record if both the first condition and the second condition is true. The OR operator displays a record if either the first condition or the second condition is true.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

The below Query is to select the persons with a first name that starts with any character, followed by "la" from the "Persons" table. SELECT * FROM Persons WHERE FirstName LIKE '%la%'

technology databases

  1. True

  2. False

Show answer
Correct Option: B

The Correct Statement to select a column named "LastName" from a table named "Employee".

technology databases

  1. SELECT LastName FROM Employee

  2. EXTRACT LastName FROM Employee

  3. SELECT Employee.LastName

  4. None

Show answer
Correct Option: A

The Correct Statement to select all the columns from a table named "Employee".

technology databases

  1. SELECT *.Employee

  2. SELECT [all] FROM Employee

  3. SELECT * FROM Employee

  4. SELECT Employee

Show answer
Correct Option: C