Which statement is true about an undo tablespace created using the Database Configuration Assistant (DBCA)? A. It contains undo only for uncommitted transactions. B. It is used for the FLASHBACK TABLE…TO BEFORE DROP operation. C. It can be recovered while…
Which two tasks can be performed in the NOMOUNT state? (Choose two.) A. re-creating control files B. full database recovery C. enabling online redo log archiving D. renaming data files E. creating a database
Which two are segment types? (Choose two.) A. table partition B. materialized views on a prebuilt container C. stored procedure D. sequence E. table F. view
Which two tasks can you perform by using DBCA for a new database? A. Register it with an available Enterprise Manager Management server. B. Configure a nonstandard block size. C. Configure incremental backups. D. Enable flashback. E. Create user tablespaces.
Examine these commands: What is the expected result? A. It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME. B. Only the first row in EMP.DAT is inserted into U1.EMP. C. Only the first and…
Which two are true about complete and incomplete recovery? (Choose two.) A. Uncommitted transactions will be rolled back after complete recovery completes. B. The database must have FLASHBACK enabled in order to perform incomplete recovery. C. Uncommitted transactions will be…
Which two are true about Oracle recovery and data protection solutions? (Choose two.) A. RMAN can be used to FLASHBACK a database. B. RMAN can be used to roll back committed transactions. C. Data Recovery Advisor can be used to…
Which two are true about conventional path SQL load? (Choose two.) A. It does not generate UNDO. B. It cannot load data into clustered tables. C. It locks objects being processed. D. It enforces referential integrity constraints. E. It always…
Which three are true about the Oracle Optimizer? (Choose three.) A. It determines the optimal table join order and method. B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found…
Which two are true about the roles? (Choose two.) A. All privileges and roles granted to a user are enabled by default when the user logs in. B. The SETROLE statement can be used once per session. C. The SETROLE…