Instant Access Oracle.1Z1-082.v2022-01-20.q105 Actual Practice Test Engine for Free (Page 15)

Question 66

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

A.A DROP COLUMN command can be rolled back
B.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
C.Partition key columns cannot be dropped.
D.A column that is set to UNUSED still counts towards the limit of 1000 columns per table
E.An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
F.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.

Question 67

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

A.It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
B.It succeeds and the generated undo is stored in SYSTEM.
C.It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
D.It succeeds and the generated undo is stored in SYSAUX.
E.It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
'UNDOTBS1'".

Question 68

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A.The ADR base defaults to $ORACLE_HOME/rdbms/admin if
neither DIAGNOSTIC_DEST nor ORACLE_BASE is set
B.The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
C.It supports diagnostics for Automatic Storage Management (ASM)
D.It supports diagnostics for Oracle Clusterware
E.It is held inside an Oracle database schema

Question 69

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_AMOUNT
FROM customers
WHERE cust_income_level <> NULL
AND due_amount <> NULL;
B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_incoms_level IS NOT NULL
AND due_amount IS NOT NULL;
C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL;
D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND cust_credit_level !=NULL;
E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND due_amount !=NULL;

Question 70