MIDTERM EXAM PROGRAMMING

Which of the following is not a component of CRUD?

• Create

• Read

• Update

• Drop

Which of the following is used to delete data from a MySQL database?

• UPDATE

• DELETE

• INSERT INTO

• SELECT

Which of the following is used to insert new data into a MySQL database?

• 
  UPDATE

• 
  DELETE

• 
  INSERT INTO

• 
  SELECT

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

• 
  SELECT

• INSERT

• UPDATE

• DELETE

It is a collection of bytes in Database

• 
  Field

• Bit

• Record

• File

What is the total number of rows in MS Excel 2016 or 2019

• 
  1,048,576

• 
  16,384

• 255

• 31

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

• SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

• SELECT * FROM Persons WHERE FirstName='Peter'

• SELECT [all] FROM Persons WHERE FirstName='Peter'

• SELECT * FROM Persons WHERE FirstName<>'Peter'

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

• 
  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'

Which SQL keyword is used to sort the result-set?

• 
  ORDER

• SORT BY

• ORDER BY

• SORT

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

• SELECT * FROM Persons ORDER BY FirstName DESC

• 
  SELECT * FROM Persons SORT BY 'FirstName' DESC

• 
  SELECT * FROM Persons SORT 'FirstName' DESC

• 
  SELECT * FROM Persons ORDER FirstName DESC