IT 321 2nd Live Quiz

What is a combination of a Cartesian product followed by a selection process.

• Join

• Select

• Update

• Delete

Natural join acts on those matching attributes where the values of attributes in both the relations

are same.

• TRUE

• FALSE

What statement is used to select data from a database?

• OPEN

• SELECT

• PICK

• ALTER

SELECT CustomerName, City FROM Customers;

• This show all data on the table

• This show all data except for CustomerName column

• This show only the data for CustomerName Column

What clause is used to filter records?

• WHERE

• ORDER BY

• DISTINCT

• COUNT

The WHERE clause is only used in SELECT statements, it is not used in UPDATE, DELETE, etc

• TRUE

• FALSE

What keyword sorts the records in ascending order by default?

• GROUP BY

• ORDER BY

• SELECT DISTINCT

• INNER JOIN

A NULL value is different from a zero value or a field that contains spaces

• TRUE

• FALSE

what function returns the average value of a numeric column?

• MAX()

• AVE()

• AVG()

• AVERAGE()

When Theta join uses only equality comparison operator, it is said to be natural join.

• TRUE

• FALSE