You must create a table EMPLOYEES in which the values in the columns EMPLOYEES_ID and LOGIN_ID must be unique and not null.
Which two SQL statements would create the required table? (Choose two.)

• A.CREATE TABLE employees
  ( employee_id NUMBER CONSTRAINT emp_id_nn NOT NULL,
  login_id NUMBER CONSTRAINT login_id_nn NOT NULL,
  employee_name VARCHAR2(100),
  hire_date DATE,
  CONSTRAINT emp_num_id_uk UNIQUE (employee_id, login_id));
• B.CREATE TABLE employees
  ( employee_id NUMBER,
  login_id NUMBER,
  employee_name VARCHAR2(100),
  hire_date DATE,
  CONSTRAINT emp_id_uk UNIQUE (employee_id, login_id));
• C.CREATE TABLE employees
  ( employee_id NUMBER,
  login_id NUMBER,
  employee_name VARCHAR2(100),
  hire_date DATE,
  CONSTRAINT emp_id_uk UNIQUE (employee_id, login_id);
  CONSTRAINT emp_id_nn NOT NULL (employee_id, login_id));
• D.CREATE TABLE employees
  ( employee_id NUMBER,
  login_id NUMBER,
  employee_name VARCHAR2(25),
  hire_date DATE,
  CONSTRAINT emp_id_pk PRIMARY KEY (employee_id, login_id));
• E.CREATE TABLE employees
  ( employee_id NUMBER CONSTRAINT emp_id_pk PRIMARY KEY,
  login_id NUMBER UNIQUE,
  employee_name VARCHAR2(25),
  hire_date DATE);

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the CUSTOMERS table.
Which two tasks would require subqueries or joins to be executed in a single statement?

• A.listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.
• B.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers
• C.listing of customers who do not have a credit limit and were born before 1980
• D.finding the number of customers, in each city, who's marital status is 'married'.
• E.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'

Comment: *

Name: *

Email: *

Verification: *

You want to display the date for the first Monday of the next month and issue the following command:

What is the outcome?

• A.In generates an error because fmand double quotation marks should not be used in the format string.
• B.In generates an error because TO_CHARshould be replaced with TO_DATE.
• C.In generates an error because rrrrshould be replaced by rrin the format string.
• D.It executes successfully and returns the correct result.
• E.It executes successfully but does not return the correct result.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PRODUCT table.

Which two tasks would require subqueries? (Choose two.)

• A.display the number of products whose list prices are more than the average list price
• B.display all products whose minimum list price is more than the average list price of products having the status 'orderable'
• C.display the minimum list price for each product status
• D.display all suppliers whose list price is more than 1000
• E.display the total number of products supplied by supplier 102 and have product status as 'OBSOLETE'

Comment: *

Name: *

Email: *

Verification: *

View the exhibit for the structure of the STUDENTand FACULTYtables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location.
Examine the following two SQL statements:
Statement 1
SQL>SELECT faculty_name, COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECT faculty_name, COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;
Which statement is true regarding the outcome?

• A.Only statement 2 executes successfully and gives the required result.
• B.Both statements 1 and 2 execute successfully and give the same required result.
• C.Both statements 1 and 2 execute successfully and give different results.
• D.Only statement 1 executes successfully and gives the required result.

Comment: *

Name: *

Email: *

Verification: *