SQL Objective type Question and Answers

SQLObjective type Question and Answers Set 1

1.       What does SQL stand for?

a.         Structured Query Language

b.         Structured Question Language

c.         Strong Question Language

Ans: a. Structured Query Language

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

a.         GET

b.         OPEN

c.         EXTRACT

d.         SELECT

Ans: c. EXTRACT

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

a.         SAVE AS

b.         UPDATE

c.         SAVE

d.         MODIFY

Ans: b. UPDATE

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

a.         COLLAPSE

b.         DELETE

c.         REMOVE

Ans: b. DELETE

5.       Key to represent relationship between tables is called

a.         Primary key

b.         Secondary Key

c.         Foreign Key

d.         None of these

Ans: C Foreign Key

6.       With SQL, how do you select a column named “FirstName” from a table named “Persons”?

a.         SELECT FirstName FROM Persons

b.         SELECT Persons.FirstName

c.         EXTRACT FirstName FROM Persons

Ans: a. SELECT FirstName FROM Persons

7.       Which of the following is a valid SQL type?

a.         CHARACTER

b.         NUMERIC

c.         FLOAT

d.         All of the above

Ans: D  All of the above

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

a.         SELECT * FROM Persons WHERE FirstName=’Peter’

b.         SELECT [all] FROM Persons WHERE FirstName=’Peter’

c.         SELECT [all] FROM Persons WHERE FirstName LIKE ‘Peter’

d.         SELECT * FROM Persons WHERE FirstName<>‘Peter’

Ans: a. SELECT * FROM Persons WHERE FirstName=’Peter’

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

a.         SELECT * FROM Persons WHERE FirstName=’%a%’

b.         SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

c.         SELECT * FROM Persons WHERE FirstName=’a’

d.         SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

Ans: d. SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

10.       DML is provided for

a.       Description of logical structure of database.

b.      Addition of new structures in the database system.

c.       Manipulation & processing of database.

d.      Definition of physical structure of database system.

Ans: c  DML is provided for manipulation & processing of database.