Tag: databases

Questions Related to databases

Which SQL statement is used to insert new data in a database?
technology databases

  1. ADD NEW

  2. ADD RECORD

  3. INSERT NEW

  4. INSERT INTO

Show answer
Correct Option: D

With SQL, how do you select a column named "FirstName" from a table named "Persons"?
technology databases

  1. SELECT Persons.FirstName

  2. EXTRACT FirstName FROM Persons

  3. SELECT FirstName FROM Persons

  4. SELECT FROM FirstName IN Persons

Show answer
Correct Option: C

With SQL, how do you select all the columns from a table named "Persons"?
technology databases

  1. SELECT *.Persons

  2. SELECT Persons

  3. SELECT * FROM Persons

  4. SELECT [all] FROM Persons

Show answer
Correct Option: C

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

technology databases

  1. SELECT * FROM Persons WHERE FirstName='Peter'

  2. SELECT [all] FROM Persons WHERE FirstName='Peter'

  3. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

  4. SELECT * FROM Persons WHERE FirstName<>'Peter'

Show answer
Correct Option: A

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
technology databases

  1. SELECT * FROM Persons WHERE FirstName='%a%'

  2. SELECT * FROM Persons WHERE FirstName='a_'

  3. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

  4. SELECT * FROM Persons WHERE FirstName LIKE '%a'

Show answer
Correct Option: C

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
technology databases

  1. True

  2. False

Show answer
Correct Option: A

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
technology databases

  1. SELECT FirstName='Peter', LastName='Jackson' FROM Persons

  2. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

  3. SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

  4. SELECT WHERE FirstName='Peter' AND LastName='Jackson' FROM Persons

Show answer
Correct Option: B

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
technology databases

  1. SELECT LastName>'Hansen' AND LastName

  2. SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

  3. SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

  4. SELECT * FROM Persons WHERE LastName IN 'Hansen' AND 'Pettersen'

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to know how to use SQL to select specific records from a table based on certain criteria. Specifically, they need to know how to use the WHERE clause to filter records based on a specified range of values.

Now, let's go through each option and explain why it is right or wrong:

A. SELECT LastName>'Hansen' AND LastName'Hansen' AND LastName

Which SQL statement is used to return only different values?
technology databases

  1. SELECT UNIQUE

  2. SELECT DISTINCT

  3. SELECT DIFFERENT

  4. SELECT SAME

Show answer
Correct Option: B

Which SQL keyword is used to sort the result-set?
technology databases

  1. SORT

  2. SORT BY

  3. ORDER

  4. ORDER BY

Show answer
Correct Option: D