QUESTION 85 Examine this command : SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true?

QUESTION 87 You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which Three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three. )

QUESTION 88 Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

QUESTION 90 One of your databases supports an OLTP workload. The default undo tablespace is fixed size with: 1. RETENTION NOGUARANTEE 2. undo_retention is 12 minutes User scott get this error after a query on the sales table has run for more than 15 minutes: ORA-01555 : snapshot too old Which three Factors taken separately or in some combination might be the cause?

QUESTION 91 Which two statements are true about Enterprise Manager Database Express? (Choose two .)

QUESTION 92 Table EMPLOYEES contains columns including EMPLOYEE_ID , JOB_ID and SALARY. Only the EMPLOYEE_ ID column is indexed. Rows exist for employees 100 and 200 . Examine this statement: Which two statements are true? (Choose two .)

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

QUESTION 94 Which three statements are true about time zones , date data types, and timestamp data types in an Oracle database? (Choose three.)

QUESTION 95 Choose three Which three statements are true about time zones,date data types,and timestamp data types in an oracle database?

QUESTION 96 Choose three . Which three statements are true about CURRENT_TIMESTAMP?

QUESTION 97 Which three statements are true about inner and outer joins? (Choose three.)

QUESTION 98 Examine this description of the TRANSACTIONS table: Which two SQL statements execute successfully? (Choose two .)

QUESTION 99 The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two .)

QUESTION 102 Which two statements are true regarding the WHERE and HAVING clauses in a SELECT statement? ( Choose two. )

QUESTION 103 Your database instance was shut down normally and then started in NOMOUNT state . You then execute this command : ALTER DATABASE MOUNT; Which two actions are performed? (Choose two.)