Basic SQL

What does the SELECT Statement do?

• Data is read from the SQL database by this statement and displayed to the database user.

• The stored data in the SQL database is changed or modified by this SQL statement.

• By deleting the stored data, this SQL statement deletes the database.

• A new table in SQL is created using this SQL statement.

What is the functionality of SQL COUNT?

• It returns the no of record of column

• It returns the no of record of database

• It returns the no of record of table

• It returns the no of record of row

In SQL SELECT COUNT, one needs to specify the –

• Row Name

• Column Name

• Table name

• None of the above

What does SQL stand for?

• Sample Query Language

• Sequential Query Language

• Sample Query Language

• Structured Query Language

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 * from Persons where FirstName <> "Peter"

• Select [all] from Persons where FirstName Like "Peter"

Which of the following statements would you use to add a new instructor to the Instructor table.

• SELECT Instructor(ins_id, lastname, firstname, city, country)

  FROM VALUES(4, 'Doe', 'John', 'Sydney', 'AU');

• INSERT INTO Instructor(ins_id, lastname, firstname, city, country)

  VALUES(4, 'Doe', 'John', 'Sydney', 'AU');

• INSERT

  VALUES(4, 'Doe', 'John', 'Sydney', 'AU') INTO Instructor(ins_id, lastname, firstname, city, country);

• UPDATE Instructor(ins_id, lastname, firstname, city, country)

  WITH VALUES(4, 'Doe', 'John', 'Sydney', 'AU');