BAZA

The _____ combines all tuples from two relations excluding duplicates.

• DIFFERENCE
• Divide

• UNION
• INTERSECT

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

• phone_number::varchar (3)

• phone_number: int

• phone_number::varchar(*)

• phone_number to int

With SQL, how can you return the number of records in the "Persons" table?

• SELECT MAX(*) FROM Persons
• SELECT AVG(*) FROM Persons
• SELECT SUM(*) FROM Persons
• SELECT COUNT(*) FROM Persons

Which of the following is the correct order of keywords for SQL SELECT statements?

• FROM, SELECT, WHERE
• SELECT, FROM, WHERE
• SELECT, WHERE, FROM
• WHERE, SELECT, FROM

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 LIKE 'a%'
• SELECT * FROM Persons WHERE FirstName = 'a'
• SELECT * FROM Persons WHERE FirstName LIKE 'a%;
• SELECT * FROM Persons WHERE FirstName LIKE 'a_'

Find all the tuples having temperature greater than 'Paris'.

• SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city 'Paris')

• SELECT * FROM weather WHERE temperature > 'Paris' temperature

• SELECT FROM weather WHERE temperature > (SELECT FROM weather WHERE city = 'Paris')

• SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')

Values of one type can be converted to another type using which of the following?

• CAST

• CONVERT

• DROP TYPE
  

• ALTER TYPE

What operator tests column for the absence of data?

• NOT

• EXIST

• IS NULL
• NONE OF THE GIVEN

Which of the following is a DML statement?

• UPDATE
• CREATE
• SELECT
• DELETE

Which SQL keyword is used to retrieve a maximum value?

• UPPER

• POST

• TOP

• MAX