SQL basic query

How many row of the result of the following query contains

SELECT *;

FROM Customers, Orders;

WHERE age <> 31 AND amount <> 400;

• 20

• 16

• 12

• 0

How many row of the result of the following query contains

SELECT *;

FROM Customers, Orders;

WHERE age <> 31 OR amount <> 400;

• 25

• 22

• 23

• 24

With SQL, we want to select a column named "FirstName" from a table named "Persons". We also want the query result returns all string which the second character is ‘a’ and end with the character ‘h’.

Which one is the correct syntax?

• 
• 
• 
• 

Consider the following table. What is the output of the below query?

SELECT first_name AS fn, age AS a;

FROM Customers;

WHERE a = 31;

• 
• 
• 
• Syntax Error

What is the correct SQL Query Order of Execution?

• FROM > WHERE > SELECT > ORDER BY

• SELECT > FROM > WHERE > ORDER BY

• SELECT > WHERE > FROM > ORDER BY

• FROM > SELECT > WHERE > ORDER BY

How to specify the Referential Integrity Constraints in SQL?

• Using PRIMARY KEY clause

• Using UNIQUE clause

• Using FOREIGN KEY clause

• Using CHECK clause

In addition to key and referential integrity constraints, other table constraints can also be specified through additional CHECK clauses at the end of a CREATE TABLE statement. These can also be called __________ constraints as they affected on each tuple individually as being inserted or modified.

• row-based

• column-based

• key

• optional