Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

• A.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
• B.SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100
  "DUES AMOUNT" FROM transactions;
• C.SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;
• D.SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
• E.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;

Comment: *

Name: *

Email: *

Verification: *

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
Be stored in a format supporting date arithmetic without using conversion functions Store a loan period of up to 10 years Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

• A.INTERVAL YEAR TO MONTH
• B.INTERVAL DAY TO SECOND
• C.TIMESTAMP
• D.TIMESTAMP WITH TIMEZONE
• E.TIMESTAMP WITH LOCAL TIMEZONE

Comment: *

Name: *

Email: *

Verification: *

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017/3/6 14:45:17
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

• A.Grant UNLIMITED TABLESPACE to U1
• B.Increase U1's quota sufficiently in DATA
• C.Drop other U1 objects in DATA
• D.Set AUTOEXTEND ON for data files in DATA
• E.Set DEFERRED_SEGMENT_CREATION to TRUE
• F.Add a data file to DATA

Comment: *

Name: *

Email: *

Verification: *

Which is true about roles?

• A.Roles containing object privileges can be created only by the object owner.
• B.All roles belong to the SYSTEM schema.
• C.A role can be password-protected only if it has been granted system privileges.
• D.A role can be granted to other roles.
• E.Roles can be created only by SYS or SYSTEM.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

• A.The names and number of columns must be identical for all SELECT statements in the query.
• B.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
• C.The number, but not names, of columns must be identical for all SELECT statements in the query.
• D.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
• E.The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

Comment: *

Name: *

Email: *

Verification: *