SQL-DQL -quiz1

What does SQL stand for?

• Strong Question Language

• Structured Question Language

• Structured Query Language

• None of these

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

• Open

• Extract

• Get

• Select

With MySQL, how do you select all the records from a table named "Persons"

• Select all records from Persons

• Select all from Persons

• Select * from Persons

• Select From Persons all

Answer explanation

select * from Persons

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

• Select Persons.FirstName

• Select FirstName.Persons

• Select FirstName from Persons

• None of these

With MySQL, how do you select the record whose "FirstName" is "Peter" from a table named "Persons" ?

• Select * from Persons where FirstName='Peter'

• Select * from Persons where FirstName=Peter

• Select FirstName='Peter'

  from Persons

• None of these

Answer explanation

Select * from Persons where FirstName='Peter' and LastName='Jackson'

With MySQL, how do you select FirstName and LastName of all the records from a table named "Persons" ?

• select First Name Last Name from Persons

• select FirstName LastName from Persons

• select FirstName, LastName from Persons

• select FirstName LastName * from Persons

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

• Select all from Persons where FirstName not equal to 'Peter'

• Select all from Persons where FirstName <>'Peter'

• Select * from Persons where FirstName <>'Peter'

• None of these

With SQL, how do you find all person's Name who are from city "Bhubaneswar" from a table named "Persons" ?

• SELECT name FROM PERSONS city='Bhubaneswar'

• SELECT name FROM PERSONS WHERE city='Bhubaneswar'

• SELECT name FROM PERSONS WHERE city='bhubaneswar'

• None of these

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

• Select * from Persons where not country='India'

• Select * from Persons where country not 'India'

• Select * from Persons where not country as 'India'

• None of these

What does the following query returns? SELECT COUNT(DISTINCT States) FROM India

• All state names of India

• Returns all state column data from India Table

• It counts and returns the number of states in India table

• It counts distinct states in India table and returns the number