Which three statements are true about UNDO and REDO? (Choose three.)
ABoth REDO and UNDO can be multiplexed.
BUNDO is used for read consistency.
CREDO is used for ROLLBACK.
DREDO is used for instance recovery.
EREDO is used for read consistency.
FUNDO is used for some flashback operations.
Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB) and affect the entire container database (CDB)?
AALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION
BALTER SYSTEM FLUSH BUFFER_CACHE
CALTER SYSTEM CHECKPOINT
DALTER SYSTEM SWITCH LOGFILE
Which two listed schema object advisors are part of Automatic Maintenance Tasks?
(Choose two.)
AAutomatic Object Failure Analyzer, which collects detail logs on any object that generates database errors.
BAutomatic Index Advisor, which is used to create and maintain table indexes based on the DML load and operations.
CAutomatic Segment Advisor, which identifies segments that have space available for reclamation, and makes recommendations on how to defragment those segments.
DAutomatic Storage Advisor, which identifies objects that require additional space that are not configured as Auto Extend.
EOptimizer Statistics Advisor, which analyzes how statistics are being gathered on schema objects and suggests changes that can be made to fine-tune the statistics collected.
You execute the SHUTDOWN ABORT command.
Which two statements are true? (Choose two.)
ASubsequent instance startup performs media recovery.
BUncommitted transactions are not rolled back by the shutdown.
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
You have connected to the CDB root as a common user with the CREATE PLUGGABLE
DATABASE system privilege and issued the following command:
Which three are results of the CREATE command? (Choose three.)
AIt creates a new local user ADMIN with sysdba privileges.
BAfter the PDB is created, it is automatically opened Read/Write.
CThe PDB must be opened Read Only to complete the integration of the PDB into the CDB.
DIt creates a new local user ADMIN with restricted privileges.
EIt creates new default schemas for the PDB.
FIt creates tablespaces to store metadata.
Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quotas? (Choose two.)
AIt allows a role to have unlimited space in any tablespace in the database.
BIt allows a user to have unlimited space only in their default permanent tablespace.
CIt allows a user to have unlimited space in any tablespace in the database.
DIt is overridden by a space quota specified for the user.
EBy default, users have no quota on their default permanent tablespace.
Which statement is applicable after the Oracle Database server has been shut down using the SHUTDOWN TRANSACTIONAL command?
AInstance recovery occurs automatically during the shutdown.
BUncommitted transactions are allowed to continue to the next COMMIT or ROLLBACK.
CInstance recovery occurs at the next restart.
Which two methods can be used to generate Value-Based audits? (Choose two.)
ABy enabling CAPTURE_SQL_VALUES in a Unified Audit Policy
BBy capturing the SYS_CONTEXT session variables using Unified Audit Policy
CBy using a database trigger and a PL/SQL construct to capture changed roles when a SET ROLE command is used
DBy using FGA policies with an event-driven PL/SQL construct to capture changed values in an object
EBy using a database trigger and event-driven PL/SQL constructs to capture changed values in an object
Which two tasks can you perform using DBCA for databases? (Choose two.)
AConfigure a nonstandard block size for a new database.
BRegister a new database with an available Enterprise Manager Management server.
CEnable flashback database for an existing database.
DConfigure incremental backups for a new database.
EChange the standard block size of an existing database.
Which statement best defines Fine Grain Audit (FGA)?
AFGA can be used to monitor data access based on content using SELECT, INSERT, DELETE, and MERGE SQL statements.
BFGA is used to capture any structural changes performed on an audited table or view.
CFGA is used to capture name changes of an audited table column using Unified Audits.
How important is Database Auditing from a security perspective?
AMonitors proper usage of the system and data by privileged users
BAlerts DBA about system issue
CProtects against data corruption
Examine this command:
Which statement is correct?
AIt overwrites any existing file with the name SALES02.DBF in/u02 by default.
BCompressed objects in SALES01. DBF will be uncompressed in SALES02.DBF after the move.
CTables with one or more extents in this data file may be queried during the execution of this command.
You execute this command:
Which statement is correct about the SALES tablespace?
AAny data files added to the tablespace must have a size of 5 gigabytes.
BIt must be smaller than the smallest BIGFILE tablespace.
CIt uses the database default blocksize.
Which statement is true about the status of a PDB that has been unplugged from a CDB?
AThe STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.
BThe STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.
CThe STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.
The standard block size is 8k but other nonstandard block sizes will also be used.
You must create a tablespace of nonstandard block size in a new file system and plan to use this command:
Which is a requirement for this command to succeed?
ADB_32k_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.
BDB_32k_CACHE_SIZE must be less than DB_CACHE_SIZE.
CDB_32k_CACHE_SIZE must be set to a value that can be accommodated in the SGA.
Which statement regarding Pluggable Database (PDBs) is correct?
AWhen the relocation of a PDB is finished, the source PDB must be dropped.
BYou can drop a source PDB of a refreshable PDB.
CYou can drop an application root along with the associated PDBs.
Which statement best describes Oracle Database Tuning Methodology?
ATune inside out, start with database server, then the network configuration, and then the application server.
BTune bottom up, start the database instance, then the sessions, and then the application.
CTune from the top down, start with the application design, then the application code, and then the database instance.
In one of your pluggable databases, the user HR has the password HRMGR.
You want to connect to a pluggable database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@Orclpdbl -
No name server is used.
Which statement is true about ORCLPDB1?
APDB orclpdb1 must be the name of the database instance HR wishes to connect.
BPDB orclpdb1 must be the name of the server running the database instance HR wishes to connect.
CPDB orclpdb1 must resolve to a valid descriptor in the client’s tnsnames.ora file.
Which statement is correct about the UNLIMITED TABLESPACE system privilege and space quotas?
AIt is overridden by a space quota specified for the user.
BBy default, users have no quota on their default permanent tablespace.
CIt allows a user to have unlimited space only in their default permanent tablespace.
Which two statements are true about the DUAL table? (Choose two.)
AIt consists of a single row and single column of VARCHAR2 data type.
BIt can display multiple rows and columns.
CIt can be accessed by any user who has SELECT privilege in any schema.
DIt can be used to display only constants or pseudo columns.
EIt can be accessed only by the SYS user.
Which statement is true about an SPFILE?
AIt is automatically created by the DBCA.
BIt can easily be updated manually with any available editor.
CIt must exist for a database instance to start.
Which statement is a benefit of using temp UNDO when performing DML on global temporary tables?
AIt reduces I/Os to the SYSTEM tablespace.
BIt reduces the amount of UNDO stored in the UNDO tablespace.
CIt reduces I/Os to the SYSAUX tablespace.
Which statement is true about table data storage in Oracle Database?
AData block free space is always contiguous in the middle of the block.
BMultiple row pieces from the same row may be stored in different database blocks.
CMultiple row pieces from the same row must be stored in different database blocks.
Which statement is true about Common Users?
ACommon Users can be created at the root and local level.
BAll system and user-defined Common Users must start with the common user prefix.
CCommon Users are replicated in all existing and future containers.
