You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?
A. You can perform complete recovery by using the command: RESTORE DATABASE FROM TAG"consistent_whole_backup"; RECOVER DATABASE;
B. You can perform incomplete recovery by using the command: RESTORE DATABASE; FROM TAG "consistent_whole_backup"; RECOVER DATABASE NOREDO;
C. Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.
D. Media recovery is possible in most cases.
Identify the correct order of consolidation density.
A. multitenant< schema consolidation< dedicated database< VMs
B. schema consolidation< VMs< dedicated databases< multitenant
C. dedicated databases< VMs< schema consolidation< multitenant
D. VMs< dedicated databases< schema consolidation< multitenant
Examine the commands:
SQL> CONNECT sys@CDBl AS SYSDBA
$QL>STARTUP MOUNT
SQL> ALTER DATABASE cdbl MOUNT;
Which four options represent what happens when these commands are executed?
A. The instance is started.
B. The CDB control files are opened for the instance.
C. The root is mounted.
D. The root is opened.
E. The PDBs are mounted.
F. The PDBs are mounted, and the seed is opened in READ ONLY mode.
G. The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.
Which three options correctly match environment variables with their specific functionality?
A. ORACLE_SID specifies the instance name.
B. ORACLE_SID specifies the global database name.
C. ORACLE_BASE specifies the root of the Oracle Database directory tree in all platforms.
D. ORACLE_BASE specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms.
E. ORACLE_HOME specifies the directory containing the Oracle software executables and network files.
F. ORACLE_HOME specifies the directory containing only the Oracle software executables, but not the network files.
Which three statements represent the difference between a container database (CDB)and a non-container database?
A. A container database has exactly one seed PDB, and a non-container database has no seed PDB.
B. In a newly created non-CDB that does not yet contain user data, the data dictionary contains only system metadata. When application users create their own objects, this metadata is mixed with the system metadata. In a CDB, the data dictionary metadata is split between the root and the PDBs. The data dictionary in the PDB contains pointers to the data dictionary in the root.
C. New views are introduced. Next to DBA_views, AIL_-views, and USER_-views, there are CDB_-views. Both CDB and non-CDB databases can access this information.
D. You are allowed to create only a single HR user in a non-CDB database. This restriction is identical for a CDB database.
E. Every PDB in a CDB has its own control file. A non-CDB, which has no containers, needs only one control file.
The session of user SCOTT receives the following error after executing an UPDATE command on the
EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two
statements are true about SCOTT's session in this scenario?
A. The session is terminated after receiving the error and JIM can continue with his transaction.
B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C. The session is rolled back after receiving the error and JIM can continue with his transaction.
D. SCOTT has to re-execute the last command in the transaction after he commits the transaction.
Examine the command:
SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt
NUMBER (10, 2)) TABLESPACE users ;
Which two statements are true about the execution of the command?
A. A CHECK constraint is created on the OID column.
B. A NOT NULL constraint is created on the OID column.
C. The ORDERS table is the only object created in the USERS tablespace.
D. The ORDERS table and a unique index are created in the USERS tablespace.
E. The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.
Which two statements about Automatic Data Optimization (ADO) are true?
A. ADO policies can automatically compress data when it qualifies.
B. ADO policies can automatically move segments when necessary.
C. ADO is not dependent on Heat Map, and works even if Heat Map is disabled.
D. You cannot compress at block level, but you can compress at segment level.
E. You can compress at row level only for QUERY LOW.
Which statement about Oracle patches is false?
A. Interim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets.
B. Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products. SPUs are cumulative with respect to prior SPUs and generally contain only security fixes.
C. Patch Set Update (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set). PSUs are cumulative and include all the security fixes from CPU patches, plus additional fixes.
D. Patch Set is the main way in which Oracle provides bug fixes in between releases. Oracle bundles a number of fixes, tests them thoroughly together, and packages, then together for easy download and installation.
E. Terminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies.
You execute the following command:
SQL> ALTER USER skd ACCOUNT LOCK;
Which two statements are correct?
A. The SKD user cannot log in to the database instance.
B. The objects owned by the SKD user are not accessible to any user.
C. Other users can access objects owned by the SKD user, to which they have access.
D. The SKD user's password expires and the user is forced to change the password at the next login.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-497 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.