25 flashcards questions

1.location  audit= ,dbms_audit_mgmt_.set_audit_trail_location
2. Heat_map =determine io operation time
3. Hot backup at once two command = Answer:
ALTER DATABASE BEGIN BACKUP; and ALTER DATABASE END BACKUP;
4. What value of the ORA_ARCHIVE_STATE column indicates that a row is in a non-active state?
Answer:1
5. If you consolidate multiple non-CDB databases into a single multitenant container database, do you require a temporary tablespace common to all containers?
Answer:Yes
6. Which tablespace is common to all active tablespaces in the CDB?
Answer:the UNDO tablespace
7. What is the term for the time frame over which a record or condition is "in force" or effective, versus the date the record or condition was entered into the database?
Answer:temporal validity
8. When you grant a common role to the local user, what is the scope of the granted privileges?
Answer:Only in the local user's PDB
9. When you grant a common role to the local user, what is the scope of the granted privileges?
Answer:
Only in the local user's PDB
10. uestion:
What privilege is required to create a redaction policy?
Answer:
the EXECUTE privilege on the DBMS_REDACT PL/SQL package
11. Question:
Which SGA components are manually sized when Automatic Shared Memory Management (ASMM) is enabled?
Answer:    Nonstandard block size buffer caches
    The keep buffer cache
    The recycle buffer cache
    The log buffer
12. What is the maximum number of PDBs that can exist in a CDB?
Answer:253, including the se

13. Question:
What new functionality for reference-partitioned tables is provided with the EXCHANGE operation in Oracle Database 12c?
Answer:
cascading functionality
14. Which option in Enterprise Manager Express allows you to open a database?
Answer:None. You cannot start up or shut down a database instance using EM Express.
15. Which function would you execute first when creating a PDB from an existing Oracle 12c non-CDB database?
Answer:DBMS_PDB.DESCRIBE
16. Which clause of the GRANT statement will create a common role or privilege?
Answer:CONTAINER = ALL
17. Which types of index cannot be partitioned?
Answer:You cannot partition a cluster index, an index defined on a clustered table, or a bitmap index on a nonpartitioned table.
18. Question:Which option in Enterprise Manager Express allows you to manage multiple databases running on the same host?
Answer:
None. You cannot perform this operation.
19. Question:
Who is the schema owner of the unified audit trail?
Answer:AUDSYS
20. Question:
When using password file authentication, for what purpose is the password file used?
Answer:To store the user name and passwords of users having the SYSDBA and SYSOPER privileges
21. Question:
Which user(s) is automatically exempt from data redaction?
Answer:SYS and SYSTEM
22. Question:
From which container(s) can you issue the ALTER PLUGGABLE DATABASE ALL OPEN command?
Answer:root
23. Question:Which clause of the ALTER TABLE TRUNCATE PARTITION statement will cause the global index to be

23.Question:Which clause of the ALTER TABLE TRUNCATE PARTITION statement will cause the global index to be truncated when the partition is truncated?
Answer:UPDATE INDEXES
24. Which three tablespaces are created by default when you create a PDB from a seed?
Answer:
TEMP, SYSAUX, and SYSTEM
25. What parameter in the init.ora file generates an audit trail as an XML file?
Answer:AUDIT_TRAIL=XML
26. Question:
What is considered the opposite of OLTP processing?
Answer:
data warehousing

----

Your database is in ARCHIVELOG mode. You have configured the control file autobackup and take regular RMAN backups of your database, but you do not use a recovery catalog.

All copies of the current control file are lost. No data files are damaged or lost.

Examine the RMAN commands:

1. STARTUP NOMOUNT;
2. STARTUP MOUNT;
3. RESTORE CONTROLFILE FROM AUTOBACKUP;
4. ALTER DATABASE MOUNT;
5. RESTORE DATABASE;
6. RECOVER DATABASE;
7. ALTER DATABASE OPEN;
8. ALTER DATABASE OPEN RESETLOGS;

What is the correct sequence of required commands to recover the control file?
1,3,4,7
2,5,6,8
1,3,4,6,8
2,3,4,5,6,7


Explanation:
The correct sequence is:

RMAN> STARTUP NOMOUNT;
RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;
RMAN> ALTER DATABASE MOUNT;
RMAN> RECOVER DATABASE
RMAN> ALTER DATABASE OPEN RESETLOGS;

The STARTUP NOMOUNT; command will simply start the instance.

The RESTORE CONTROLFILE FROM AUTOBACKUP; command will restore the control file(s) from the autobackup that RMAN had been taking.

The ALTER DATABASE MOUNT; command will raise the instance from unmounted to mounted. This operation will be successful because the control files have been recreated and restored by the previous command.

Finally, the ALTER DATABASE OPEN RESETLOGS; command will reset the log files such that from this point forward, the system change number (SCN) in the header blocks of all the data files will be reset to match the corresponding SCNs in the control files. When the online redo log files are reset, a