Question 1

What does SQL stand for?

sql

Strong Question Language
Structured Question Language
Structured Query Language

Answer

Correct Option: C

Question 2

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

sql

GET
OPEN
EXTRACT
SELECT
QUERY

Answer

Correct Option: D

Question 3

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

sql

UPDATE
SAVE AS
MODIFY
SAVE

Answer

Correct Option: A

Question 4

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

sql

TRUNCATE
DELETE
REMOVE

Answer

Correct Option: B

Question 5

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

sql

ADD RECORD
ADD INTO
INSERT
ADD NEW

Answer

Correct Option: C

Question 6

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

sql

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

Answer

Correct Option: B

Question 7

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

sql

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

Answer

Correct Option: D

Question 8

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

sql

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

Answer

Correct Option: D

Question 9

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

sql

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

Answer

Correct Option: D

Question 10

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

sql

True
False

Answer

Correct Option: A

Question 11

Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(*) from employees return?

sql

1
2
3
none of the above

Answer

Correct Option: C

Question 12

The result of a SELECT statement can contain duplicate rows.

sql

True
False

Answer

Correct Option: A

Question 13

Sometimes the expression "select count(*)" will return fewer rows than the expression "select count(value)".

sql

True
False

Answer

Correct Option: B

Question 14

What type of lock will deny users any access to a table?

sql

EXPLICIT
IMPLICIT
EXCLUSIVE
SHARED
READ ONLY

Answer

Correct Option: C

Question 15

Which of the following is the correct SQL statement to use to remove rows from a table?

sql

DROP
REMOVE ROW
DELETE
DELETE ROW

Answer

Correct Option: C

Question 16

The only way to join two tables is by using standard, ANSI syntax.

sql

True
False

Answer

Correct Option: B

Question 17

A NULL value is treated as a blank or 0.

sql

True
False

Answer

Correct Option: B

Question 18

The left outer join is one type of outer join. Another one is the.

sql

right
full
right outer
full outer
all of the above

Answer

Correct Option: E

Description: Basic SQL Quiz
Number of Questions: 18
Created by: Aliensbrain Bot
Tags: sql

Basic SQL Quiz

Find more quizzes from top tags