SQL Quiz

Choose the correct option to convert phone_number attribute from varchar to integer data type

• phone_number:varchar(*)

• phone_number.int

• phone_number:varchar (3)

• phone_number to int

List all operations of relation algebra in the query: SELECT accountld FROM Account;

• Projection
• Projection, union

• Projection, selection

• Selection

A table that satisfies 2NF

• None of the given

• May violate 1NF

• Always satisfies 1NF

• Always satisfies 3NF

With SQL, how do you select all the columns from a table named "Persons"?

• SELECT Persons;

• SELECT * Persons;

• SELECT [all] FROM Persons;

• SELECT * FROM Persons;

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 LIKE 'a%;

• SELECT * FROM Persons WHERE FirstName='%a%;

The___ operator combines all tuples from two relations excluding duplicates.

• Difference

• Divide

• Union

• Intersect

Which SQL keyword is used to retrieve a maximum value?

• MOST

• UPPER

• TOP

• MAX

What does the SQL FROM clause do?

• None of the given

• Specifies the tables to retrieve rows from

• Specifies the columns we are retrieving

• Specifies a search condition

Which of the following is used to denote the selection operation in relational algebra?

• Pi (Greek)

• Lambda (Greek)

• Omega (Greek)

• Sigma (Greek)

Which of the following SQL statements can be used to create a relational table?

• INSERT INTO

• APPEND TABLE

• ADD TABLE

• CREATE TABLE