Dumpsbuddy logo
In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.
Which statement is true about undo retention?
What action must you take to ensure complete database recovery till the point of failure?
Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)
Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?
Which two statements correctly describe the relationship between data files and logical database structures? (Choose two.)
Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged.
Which command must you execute before starting the recovery of this tablespace?
Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:
And then grant OPS$GUEST_USER the CREATE SESSION privilege.
Which two statements are true? (Choose two.)
You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
A user establishes a connection to a database instance by using an Oracle Net.
You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this? (Choose two.)
Which three statements are true about user account administration? (Choose three.)
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)
Which two statements are true about a server parameter file (SPFILE)? (Choose two.)
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)
You find this query being used in your Oracle 12c database:
Which method a used by the optimizer to limit the rows being returned?
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?
You set the following parameters in the parameter file and restart the database instance:
Which two statements are true? (Choose two.)
You have successfully taken a database backup by using the command:
RMAN> BACKUP AS BACKUPSET DATABASE;
Now you execute this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;
What is the outcome?
You want to create a role that:
- is protected from unauthorized usage
- does not use a password embedded in the application source code or stored in a table
- is enabled for a user based on security policies defined in a PL/SQL package
How would you create this role?
On your Oracle 12c database, you Issue the following commands to create indexes
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);
Which two statements are correct? (Choose two.)
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)
The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:
HR then opens a second session.
Which two operations wait when executed in HR’s second session? (Choose two.)
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?
You Execute the Following command to create a password file in the database server:
$ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’
Which two statements are true about the password file? (Choose two.)
Examine the parameters for your database instance:
Which three statements are true about the process of automatic optimization by using cardinality feedback? (Choose three.)
Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’);
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1 service.
3. An aggregated trace file is created for all the sessions that are running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database? (Choose two.)
Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);
Which two statements are true? (Choose two.)
You perform RMAN backups for your database and use a recovery catalog for managing the backups. To free space, you execute this command:
RMAN> DELETE OBSOLETE;
Which three statements are true is this scenario? (Choose three.)
Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32 M;
What is the outcome of this command?
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?
Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?
To enable faster incremental backups, you enabled block change tracking for the database.
Which two statements are true about the block change tracking file? (Choose two.)
Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).
In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic
Workload Repository (AWR) snapshot is taken every 30 minutes.
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?
You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time? (Choose two.)
Your database is in ARCHIVELOG mode.
You want to disable archiving for the database.
Examine these steps:
1. Execute the ALTER DATABASE NOARCHIVELOG command
2. Execute SHUTDOWN IMMEDIATE
3. Execute STARTUP MOUNT
4. Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/
5. Execute STARTUP NOMOUNT
6. Open the database
7. Execute SHUTDOWN TRANSACTIONAL
Identify the required steps in the correct sequence.
Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager
Database Express (EM Express)? (Choose two.)
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?
You execute the following piece of code with appropriate privileges:
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? (Choose two.)
You ran this command on a source database:
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept
On the target database, you run this command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept
Which two statements are true? (Choose two.)
The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes.
Which connection method guarantees that this requirement is met?
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?
TESTED 23 Apr 2024
