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.TIMESTAMP WITH TIMEZONE
• B.INTERVAL YEAR TO MONTH
• C.TIMESTAMP
• D.TIMESTAMP WITH LOCAL TIMEZONE
• E.INTERVAL DAY TO SECOND

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding indexes? (Choose three.)

• A.A UNIQUE index can be altered to be non-unique
• B.A SELECT statement can access one or more indices without accessing any tables
• C.A table belonging to one user can have an index that belongs to a different user
• D.An update to a table can result in updates to any or all of the table's indexes
• E.When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
• F.An update to a table can result in no updates to any of the table's indexes

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

• A.It generates a sql script that it uses to load data from EMP.DAT to EMP
• B.It appends data from EMP.DAT to EMP
• C.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• D.It uses the database buffer cache to load data
• E.It overwrites data in EMP with data in EMP.DAT

Comment: *

Name: *

Email: *

Verification: *

You want to use table compression suitable for OLTP that will:
* Compress rows for all DML statements on that table
* Minimize the overheads associated with compression
Which compression option is best suited for this?

• A.ROW STORE COMPRESS BASIC
• B.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• C.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• D.ROW STORE COMPRESS ADVANCED
• E.COLUMN STORE COMPRESS FOR QUERY LOW

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

• A.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount !=NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;
• E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;

Comment: *

Name: *

Email: *

Verification: *