Tag: technology

Questions Related to technology

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
technology databases

  1. SELECT * FROM Persons SORT BY 'FirstName' DESC

  2. SELECT * FROM Persons SORT 'FirstName' DESC

  3. SELECT * FROM Persons ORDER BY FirstName DESC

  4. SELECT * FROM Persons ORDER FirstName DESC

Show answer
Correct Option: C

Which SQL statement is used to extract data from a database?

technology databases

  1. OPEN

  2. EXTRACT

  3. SELECT

  4. GET

Show answer
Correct Option: C

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

  1. UPDATE

  2. MODIFY

  3. SAVE

  4. SAVE AS

Show answer
Correct Option: A

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

  1. ADD NEW

  2. INSERT INTO

  3. ADD RECORD

  4. INSERT NEW

Show answer
Correct Option: B

What does SQL stand for?
technology databases

  1. Strong Question Language

  2. Structured Query Language

  3. Structured Question Language

  4. Strong Query Language

Show answer
Correct Option: B

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

  1. SELECT * FROM Persons

  2. SELECT [all] FROM Persons

  3. SELECT Persons

  4. SELECT FROM Persons

Show answer
Correct Option: A

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

  1. SELECT DIFFERENT

  2. SELECT UNIQUE

  3. SELECT DISTINCT

  4. SELECT EXACT

Show answer
Correct Option: C

With SQL, how can you insert a new record into the "Persons" table?
technology databases

  1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

  2. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

  3. INSERT ('Jimmy', 'Jackson') INTO Persons

  4. INSERT VALUES ('Jimmy', 'Jackson')

Show answer
Correct Option: A

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

technology databases

  1. INSERT INTO Persons (LastName) VALUES ('Olsen')

  2. INSERT ('Olsen') INTO Persons (LastName)

  3. INSERT INTO Persons ('Olsen') INTO LastName

  4. INSERT INTO Persons ('Olsen')

Show answer
Correct Option: A

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
technology databases

  1. DELETE ROW FirstName='Peter' FROM Persons

  2. DELETE FROM Persons WHERE FirstName = 'Peter'

  3. DELETE FirstName='Peter' FROM Persons

  4. REMOVE FROM Persons WHERE FirstName = 'Peter'

Show answer
Correct Option: B