In which three situations does a new transaction always start?

• A.when issuing a TRUNCATEstatement after a SELECT statement was issued in the same session
• B.when issuing a CREATE INDEXstatement after a CREATE TABLEstatement completed successfully in the same session
• C.when issuing a CREATE TABLEstatement after a SELECTstatement was issued in the same session
• D.when issuing the first Data Manipulation Language (DML) statement after a COMMIT or ROLLBACK statement was issued in the same session
• E.when issuing a DML statement after a DML statement failed in the same session
• F.when issuing a SELECT FOR UPDATEstatement after a CREATE TABLE AS SELECTstatement was issued in the same session

Comment: *

Name: *

Email: *

Verification: *

Examine this statement:

What is returned upon execution?

• A.an error
• B.1 row
• C.2 rows
• D.0 rows

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the BOOKS_TRANSACTIONStable:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?
SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM

• A.FROM BOOKS_TRANSACTIONS;
• B.FROM BOOKS_TRANSACTIONS;
  SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE"
• C.BOOKS_TRANSACTIONS;
  SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM
• D.BOOKS_TRANSACTIONS;
  SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE"

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.
Which two SQL statements would create the required table? (Choose two.) CREATE TABLE employees

• A.(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));
  CREATE TABLE employees
• B.(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));
• C.(employee_id NUMBER CONSTRAINT emp_id_pk PRIMARY KEY,
  login_id NUMBER UNIQUE,
  employee_name VARCHAR2(25),
  hire_date DATE);
  CREATE TABLE employees
• D.(employee_id NUMBER,
  login_id NUMBER,
  employee_name VARCHAR2(100),
  hire_date DATE,
  CONSTRAINT emp_id_uk UNIQUE (employee_id, login_id));
  CREATE TABLE employees
• E.(employee_id NUMBER,
  login_id NUMBER,
  employee_name VARCHAR2(25),
  hire_date DATE,
  CONSTRAINT emp_id_pk PRIMARY KEY (employee_id, login_id));
  CREATE TABLE employees

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SQL statement:
SQL> select cust_id, cust_last_name "Last name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses either one of which can complete the query. (Choose three.)

• A.ORDER BY "Last name"
• B.ORDER BY 2, cust_id
• C.ORDER BY CUST_NO
• D.ORDER BY 2,1
• E.ORDER BY "CUST_NO"

Comment: *

Name: *

Email: *

Verification: *