AIt has commands for performing database administration operations.
BIt can be used in interactive but not batch mode for SQL commands.
CIt has to be installed separately after the Oracle Database 12c installation.
DOperating system commands can be executed from the SQL*Plus command prompt.
Which two statements about the Process Monitor (PMON) process are true?
APMON performs process recovery when a client process fails.
BDuring instance startup, PMON takes care of instance recovery.
CPMON performs listener registration.
DPMON restarts background and dispatcher processes when they fail.
EPMON resolves failures of distributed transactions.
Which statement is true about loading data by using the conventional path of SQL*Loader?
ARedo is not generated while performing conventional path loads.
BOnly PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,
CNo exclusive locks are acquired when the conventional path loads are performed.
DInstead of performing transactions, SQL*Loader directly writes data blocks to the data files.
EINSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.
Which two statements about ADDM are true?
AReal-Time ADDM uses AWR snapshots of the last 10 minutes.
BReal-Time ADDM uses ASH recent activity from SGA data.
CReal-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
DRegular ADDM uses AWR snapshots that are not yet purged.
Question 6
Oracle Database 12c Essentials
0
Question 7
Oracle Database 12c Essentials
Question 8
Oracle Database 12c Essentials
Question 9
Oracle Database 12c Essentials
Question 10
Oracle Database 12c Essentials
Question 11
Oracle Database 12c Essentials
Question 12
Oracle Database 12c Essentials
Question 13
Oracle Database 12c Essentials
Question 14
Oracle Database 12c Essentials
Question 15
Oracle Database 12c Essentials
Question 16
Oracle Database 12c Essentials
Question 17
Oracle Database 12c Essentials
Question 18
Oracle Database 12c Essentials
Question 19
Oracle Database 12c Essentials
Question 20
Oracle Database 12c Essentials
Question 21
Oracle Database 12c Essentials
Question 22
Oracle Database 12c Essentials
Question 23
Oracle Database 12c Essentials
Question 24
Oracle Database 12c Essentials
Question 25
Oracle Database 12c Essentials
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ad
Want a break from the ads?
Become a Supporter and enjoy a completely ad-free experience, plus unlock Learn Mode, Exam Mode, AstroTutor AI, and more.
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Which is the default port number for Database Express?
A7801
B5500
C2243
D1521
E22
Which two statements about Database Express are true?
AIt uses internal infrastructure components, such as XDB and SQL*Net.
BIt can perform actions outside the database.
CIt has background tasks and processes that periodically collect information via FTP.
DIt has two new features: Performance Hub and Composite Active Reports.
EIt is not supported on Standard Edition (SE) and Express Edition (XE).
Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?
AThe average active sessions were more than three times the number of CPU cores.
BActive sessions were more than 10% of total load and CPU utilization was more than 50%.
CMemory allocations were more than 95% of physical memory.
DHung sessions were more than 10% of total sessions.
EA deadlock was detected.
FThe session limit was close to 100%.
Which command do you use to check for block corruption by validating the database?
ARMAN> VALIDATE CHECK LOGICAL
BRMAN> VALIDATE BACKUP
CRMAN> VALIDATE CORRUPT BLOCKS
DRMAN> VALIDATE DATABASE
Which tool is recommended for moving a PDB to a non-CDB?
ARMAN
BCold Backup
CTraditional Export / Import
DData Pump
ESQL*Plus
Which two statements describe data dictionary views?
AThey are stored in the SYSTEM tablespace.
BThey are based on virtual tables.
CThey are owned by the SYS user.
DThey speed up query and data manipulation language (DML) operations.
EThe VSFIXED_TABLEview can be queried to list the names of these views.
When you start up a CDB, which operations are performed automatically and in what order? a - The instance is started. b - Control files are opened. c - The root container is opened (redo logs and root data files). d - Seed pluggable database is in READ ONLY mode. e - Other PDBs are still in MOUNTED mode. f - Triggers may fire if they exist to open other PDBs.
Aa, b, c, d, e, f
Bb, c, a, d, e, f
Cc, b, a, d, f, e
Da, b, c, d
Eb, c, a, d
Your customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd). Which two options would accomplish this?
AYou copy all the PDBSSEEDdata files from the production CDB into the development CDB and execute this on the development CDB;SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by password;
BYou alter the salesprd source database to open in read-only mode, and start cloning the source database:SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd;
CYou alter the salesprd source database to open in read-only mode:SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;In the development CDB, you create a databaselink "PRD" that connects to the root of the source CDB, and start cloning the source PDB:SQL> CREATE PLUGGABLE DATABASE salesdevFROM salesprd@prd;
DConnected as the salesprd local DBA, you create an XML using:SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml' ;Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into the development CDB using:SQL> CREATE PLUGGABLE
Your database is down. You log in as the SYS user and issue this command:
SQL> STARTUP -
What happens after the instance is started?
ANothing else happens.
BThe database is mounted but not opened.
CThe database is mounted and finally opened.
DThe database is opened and finally mounted.
You went to create a new CDB foe your customer. Which two statements are true about the seed pluggable database that will reside in the new CDB?
AYou have to copy the seed data files yourself,
BYou can use the new SEED FILE_NAME_CONVERTclause in the CREATE DATABASE statement.
CThe seed pluggable database is not required.
DThe seed pluggable database does not require data files.
EThe seed pluggable database is always kept in READ ONLY mode.
FThe seed pluggable database is not a container.
You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer (OUI) shows a message that says one of the product- specific prerequisite checks has failed:
Checking available swap space requirements...
Expected result: 1512MB -
Actual Result: 1018MB -
Check complete. The overall result of this check is: failed
Problem: The system does not have the required swap space.
What happens to the installation in this situation?
AIt can be continued.
BIt resizes the swap space automatically when you proceed further.
CIt can be continued, but the instance cannot be started without increasing swap space.
DIt shows a message saying one or more prerequisite checks have failed and the installation aborts.
Which three statements are true about a database instance that has mounted a database but has not opened it?
ASystem administrators and users with the CREATE SESSION system privilege may connect to the instance.
BData files are open in read-only mode.
CA control file is open.
DSystem Global Area (SGA) is allocated and background processes are started.
EAn alert log and trace files are open.
FInstance recovery is performed for the database.
An Oracle instance is a combination of______.
Adatabase files and parameter file (initialization parameter file or server parameter file)
BSystem Global Area (SGA) and background processes
Ca listener process, server processes, and background processes
DSystem Global Area (SGA), server processes, and background processes
Edatabase files, System Global Area (SGA), and background processes
Which statement about Oracle patches is false?
AInterim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets.
BSecurity 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.
CPatch 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.
DPatch 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.
ETerminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies.
Which three statements represent the difference between a container database (CDB)and a non-container database?
AA container database has exactly one seed PDB, and a non-container database has no seed PDB.
BIn 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.
CNew 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.
DYou are allowed to create only a single HR user in a non-CDB database. This restriction is identical for a CDB database.
EEvery 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?
AThe session is terminated after receiving the error and JIM can continue with his transaction.
BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
CThe session is rolled back after receiving the error and JIM can continue with his transaction.
DSCOTT has to re-execute the last command in the transaction after he commits the transaction.
Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.
AOracle Database alert.log file
Bobject-level statistics
CAutomatic SGA Memory Management
DOracle Database Trace files
Eall server-generated alerts
You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?
AYou can perform complete recovery by using the command:RESTORE DATABASEFROM TAG"consistent_whole_backup";RECOVER DATABASE;
BYou can perform incomplete recovery by using the command:RESTORE DATABASE;FROM TAG "consistent_whole_backup";RECOVER DATABASE NOREDO;
COnly consistent backups can be used for restoring a database in NOARCHIVELOG mode.
DMedia recovery is possible in most cases.
Which statement about a server parameter file (SPFILE) is false?
AAn SPFILE is a binary file that cannot be edited by using a text editor.
BYou can create an SPFILE from an existing text initialization parameter file or from memory.
CYou can use the SHOW PARAMETERS command to display the values of initialization parameters in an SPFILE.
DThe instance first searches for an SPFILE named spfileoRACLE_SID.ora and, if this is not found. It searches for spfile.ora.
Identify two types of solutions in which you would need to use Active Data Guard and Golden Gate together.
Aa solution that provides zero-data-loss protection at any distance without impacting database performance
Ba solution for disaster protection and database rolling upgrades for a mission-critical OLTP database, where you also want to extract data from a data guard primary database for ETL update o' an enterprise data warehouse
Ca solution requiring minimal planned downtime and risk, using standby first patching, database rolling upgrades, and select platform migrations
Da solution that helps with integrated automatic database and client failover between source and target, where you also need to establish advanced replication