View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.

The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, the following SQL statement was written:
SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;
The desired output is not obtained after executing the above SQL statement. What could be the reason for this?

• A.The table prefix is missing for the column names in the SELECT clause.
• B.The NATURAL JOIN clause is missing the USING clause.
• C.The DEPARTMENTS table is not used before the EMPLOYEES table in the FROM clause.
• D.The EMPLOYEES and DEPARTMENTS tables have more than one column with the same column name and data type.

Comment: *

Name: *

Email: *

Verification: *

Which task can be performed by using a single Data Manipulation Language (DML) statement?

• A.Removing all data only from a single column on which a primary key constraint is defined.
• B.Adding a column with a default value while inserting a row into a table.
• C.Adding a column constraint while inserting a row into a table.
• D.Removing all data from a single column on which a unique constraint is defined.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of CUSTOMERS table.
Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

• A.SELECT TO_CHAR (NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;
• B.SELECT NVL(cust_credit_limit), 'Not Available') "NEW CREDIT"FROM customers;
• C.SELECT NVL (TO CHAR(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;
• D.SELECT NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;

Comment: *

Name: *

Email: *

Verification: *

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

• A.CREATE TABLE employees
  (employee_id NUMBER,
  Login_id NUMBER,
  Employee_name VARCHAR2(100),
  Hire_date DATE,
  CONSTRAINT emp_id_ukUNIQUE (employee_id, login_id));
• B.CREATE TABLE employees
  (employee_id NUMBER CONSTRAINT emp_id_pk PRIMARY KEY,
  Login_id NUMBER UNIQUE,
  Employee_name VARCHAR2(25),
  Hire_date DATE);
• C.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_id_ukUNIQUE (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,
  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));

Comment: *

Name: *

Email: *

Verification: *

Which two queries execute successfully?

• A.SELECT SYSTIMESTAMP + INTERVAL '1' DAY FROM DUAL;
• B.select INTERVAL '1' DAY +INTERVAL '1' MONTH FROM DUAL;
• C.SELECT INTERVAL '1' DAY - SYSDATE FROM DUAL;
• D.SELECT INTERVAL '1' DAY - INTERVAL '1' MINUTE FROM DUAL;
• E.SELECT SYSDATE "INTERRVAL '1' DAY FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *