CREATE DATABASE students
CREATE DATABASE students;
IF NOT EXISTS CREATE DATABASE `STUDENTS`;
Correct Answer : Option (D) : IF NOT EXISTS CREATE DATABASE `STUDENTS`;
SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;
SELECT `customer name` FROM customers ORDER BY zone WHERE cat_id = 12;
SELECT FROM `customers` 'customer name';
SELECT customer name FROM customers;
Correct Answer : Option (A) : SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;
Correct Answer : Option (B) : limits the row data are returned.
Correct Answer : Option (D) : All of the above.
Correct Answer : Option (B) : An exact match is not possible in a SELECT statement.
Correct Answer : Option (C) : Outer join
Correct Answer : Option (C) : They include procedural and SQL statements.
Correct Answer : Option (A) : A way to establish an IF-THEN-ELSE in SQL.
Correct Answer : Option (A) : Both consist of procedural code.