SQL QUIZ
1 .
What is returned by INSTR(‘FREETIMELEARN’, ‘M’)?

Correct Answer : Option (A)

7
  Show Answer
2 .
Which of the following is not true about Natural Joins?

Correct Answer : Option (B)

It selects rows from the two tables having different values in the matched columns.
  Show Answer
3 .
With SQL, how do you select a column named "FirstName" from a table named "Persons"?

Correct Answer : Option (C)

SELECT FirstName FROM Persons
  Show Answer
4 .
With SQL, how do you select all the columns from a table named "Persons"?

Correct Answer : Option (D)

SELECT * FROM Persons
  Show Answer
5 .
With SQL, how can you insert a new record into the "Persons" table?

Correct Answer : Option (B)

INSERT INTO Persons VALUES ('Ram', 'Raj')
  Show Answer
6 .
With SQL, how can you insert "Ramana" as the "LastName" in the "Persons" table?

Correct Answer : Option (B)

INSERT INTO Persons (LastName) VALUES ('Ramana')
  Show Answer
7 .
Which of the following is true about a group function?

Correct Answer : Option (C)

Group functions ignore null values.
  Show Answer
8 .
Which of the following query will result in an error?

Correct Answer : Option (D)

select dept_id, count(name) from employees;
  Show Answer
9 .
Which of the following is not true about removing rows from a table?

Correct Answer : Option (C)

A statement like, DELETE , would cause deletion of the table from the database.
  Show Answer
10 .
How can you change "Ramana" into "Suresh" in the "LastName" column in the Persons table?

Correct Answer : Option (B)

UPDATE Persons SET LastName='Suresh' WHERE LastName='Ramana'
  Show Answer