I am having trouble finding these answers, it is using Oracle 12 in database. Your help would be truly appreciated.Question 1 See the following tableCREATE TABLE product ( product_id NUMBER(3) PRIMARY KEY, product_name VARCHAR(30) NOT NULL, price NUMBER (3,2) CHECK (price 0), quantity NUMBER(3) );How many rows may the following statement return? (Hint: think about Primary Key's function)SELECT *FROM productWHERE product_id = 1023;Question 1 options: 1 or many 0 or 1 0 or many The statement returns an error.Question 2 Which of the following section in SELECT is mandatory ?Question 2 options: WHERE GROUP BY FROM ALLQuestion 3 See the following tableCREATE TABLE product ( product_id NUMBER(3), product_name VARCHAR(30) NOT NULL, price NUMBER (3,2) CHECK (price 0), quantity NUMBER(3) );How many rows does the following statement return?SELECT *FROM productWHERE product_id = 1023;Question 3 options: 1 0 or 1 0 or many The statement returns an error.Question 4 See the following tableCREATE TABLE product ( product_id NUMBER(3) PRIMARY KEY, product_name VARCHAR(30) NOT NULL, price NUMBER (3,2) CHECK (price 0), quantity NUMBER(3) CHECK (quantity BETWEEN 0 AND 1000), color_code NUMBER(2) UNIQUE);What is the possible maximum number of rows that the following statement can return?SELECT *FROM productWHERE color_code = 5 AND color_code 0), quantity NUMBER(3) CHECK (quantity BETWEEN 0 AND 1000), color_code NUMBER(2) CHECK (color_code = 0 and color_code 3 AND color_code 5000 GROUP BY SALARY 5000 WITH SALARY 5000 WHERE SALARY 5000Question 10 What SQL keyword would you use to remove duplications within the result set.Question 10 options: DISTINCTION DISTINCT REMOVE DUPLICTAE NO DUPLICATEQuestion 11 Which clause would you add in the following SELECT statement to limit the rows to those customers whose credit is in the range 400 to 600 (We want to include 400 and 600 in the result)?SELECT customer_id, customer_nameFROM customers;Question 11 options: WHERE credit_limit = 600 and credit_limit = 600 or credit_limit

Question

I am having trouble finding these answers, it is using Oracle 12 in database. Your help would be truly appreciated.

Question 1

See the following table

CREATE TABLE product (

product_id NUMBER(3) PRIMARY KEY,

product_name VARCHAR(30) NOT NULL,

price NUMBER (3,2) CHECK (price > 0),

quantity NUMBER(3)

);

How many rows may the following statement return? (Hint: think about Primary Key's function)

SELECT *

FROM product

WHERE product_id = 1023;

Question 1 options:

	1 or many
	0 or 1
	0 or many
	The statement returns an error.

Question 2

Which of the following section in SELECT is mandatory ?

Question 2 options:

	WHERE
	GROUP BY
	FROM
	ALL

Question 3

See the following table

CREATE TABLE product (

product_id NUMBER(3),

product_name VARCHAR(30) NOT NULL,

price NUMBER (3,2) CHECK (price > 0),

quantity NUMBER(3)

);

How many rows does the following statement return?

SELECT *
FROM product
WHERE product_id = 1023;

Question 3 options:

	1
	0 or 1
	0 or many
	The statement returns an error.

Question 4

See the following table

CREATE TABLE product (

product_id NUMBER(3) PRIMARY KEY,

product_name VARCHAR(30) NOT NULL,

price NUMBER (3,2) CHECK (price > 0),

quantity NUMBER(3) CHECK (quantity BETWEEN 0 AND 1000),

color_code NUMBER(2) UNIQUE

);

What is the possible maximum number of rows that the following statement can return?

SELECT *

FROM product

WHERE color_code >= 5 AND color_code < 10;

Question 4 options:

	6
	0
	5
	4

Question 5

IF a column alias contains a space or it is made of upper case and lower case letters, The alias must enclosed with (choose the best answer)

Question 5 options:

	Ampersand symbol
	Single quotes
	Parenthesis
	Double Quotes

Question 6

See the following table

CREATE TABLE product (

product_id NUMBER(3) PRIMARY KEY,

product_name VARCHAR(30) NOT NULL,

price NUMBER (3,2) CHECK (price > 0),

quantity NUMBER(3) CHECK (quantity BETWEEN 0 AND 1000),

color_code NUMBER(2) CHECK (color_code >= 0 and color_code < 3)

);

What is the possible maximum number of rows that the following statement can return?

SELECT *

FROM product

WHERE color_code > 3 AND color_code <= 7;

Question 6 options:

	The statement returns an error.
	0
	3
	4

Question 7

IN SELECT statement you always add SELECT , FROM and WHERE keywords because without WHERE condition you wouldn't know which data you search

Question 7 options:

	True
	False

Question 8

What will the following statement return after execution?

SELECT employeenumber, lastname, email

FROM products

ORDER BY employeenumber DESC and email;

Question 8 options:

	The results are sorted first numerically and then alphabetically.
	The results are sorted first numerically from high to low and then alphabetically.
	The results are sorted first alphabetically and then numerically.
	The query returns an error.

Question 9

Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000?

Question 9 options:

	ORDER BY SALARY > 5000
	GROUP BY SALARY > 5000
	WITH SALARY > 5000
	WHERE SALARY > 5000

Question 10

What SQL keyword would you use to remove duplications within the result set.

Question 10 options:

	DISTINCTION
	DISTINCT
	REMOVE DUPLICTAE
	NO DUPLICATE

Question 11

Which clause would you add in the following SELECT statement to limit the rows to those customers whose credit is in the range 400 to 600 (We want to include 400 and 600 in the result)?

SELECT customer_id, customer_name

FROM customers;

Question 11 options:

	WHERE credit_limit >= 600 and credit_limit <= 400
	WHERE credit_limit <= 600 and credit_limit >= 400
	WHERE credit_limit >= 600 or credit_limit <= 400
	WHERE credit_limit <= 600 or credit_limit >= 400

Question 12

Which one is NOT TRUE about views

Question 12 options:

	Views can be used for security purposes
	Views are same as tables hence they keep same records physically in the database and clone the underlined table data.
	Views are similar to table's two dimentional ros and columns look but they do not keep the data physically
	Views are named SQL objects meaning they are saved objects in the database based on given name to your query

Question 13

Which of the following SQL statements is not valid?

Question 13 options:

	SELECT orderdate when the order was submit FROM orders;
	SELECT orderdate as "when the order was submit" FROM orders;
	SELECT orderdate as whentheorderwassubmit FROM orders;
	all of the above

Question 14

What value does the following SELECT statement returns?

SELECT 100*2 +50/5 FROM table;

Question 14 options:

	50
	25
	210
	1200

Accepted Answer

Note: As per our guidelines we are suppose to answer only first three question. Kindly repost other…