Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

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

ADD NEW
ADD RECORD
INSERT NEW
INSERT INTO

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

SELECT Persons.FirstName
EXTRACT FirstName FROM Persons
SELECT FirstName FROM Persons
SELECT FROM FirstName IN Persons

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

SELECT *.Persons
SELECT Persons
SELECT * FROM Persons
SELECT [all] FROM Persons

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

SELECT * FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
SELECT * FROM Persons WHERE FirstName<>'Peter'

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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"?

SELECT * FROM Persons WHERE FirstName='%a%'
SELECT * FROM Persons WHERE FirstName='a_'
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
SELECT * FROM Persons WHERE FirstName LIKE '%a'

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

SELECT FirstName='Peter', LastName='Jackson' FROM Persons
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
SELECT WHERE FirstName='Peter' AND LastName='Jackson' FROM Persons

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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"?

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
SELECT * FROM Persons WHERE LastName IN 'Hansen' AND 'Pettersen'

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which SQL statement is used to return only different values?

SELECT UNIQUE
SELECT DISTINCT
SELECT DIFFERENT
SELECT SAME

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

SORT
SORT BY
ORDER
ORDER BY

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
456
457
458
459
460
461
462
463
464
…
486
487
Next →