NEW QUESTION 1
Which are two ways for a database service to be recognized by a listener in Oracle Database 12c? (Choose two.)

• A. Dynamic Registration by the LREG process
• B. Dynamic Registration by the SMON process
• C. Static registration in the listener.ora file using the GLOBAL_DBNAME parameter
• D. Dynamic Registration by the PMON process
• E. Static registration in the listener.ora file using the SERVICE_NAME parameter

Answer: AE

Explanation: Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG298

NEW QUESTION 2
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?

• A. It fails because an incremental level 1 backup always searches for an image copy as level 0 backup.
• B. It fails because an incremental level 0 backup does not exist.
• C. It takes a backup of blocks that have been formatted since the last full database backup.
• D. It takes an incremental level 0 backup of the database.
• E. It first takes an incremental level 0 backup and then an incremental level 1 backup.

Answer: E

Explanation: References: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm (4.4.1.2)

NEW QUESTION 3
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions
The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result? (Choose three.)

• A. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
• B. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
• C. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
• D. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.
• E. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
• F. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

Answer: ACE

Explanation: Note:
* Oracle 12c now provides the ability to index a subset of partitions and to exclude the others.
Local and global indexes can now be created on a subset of the partitions of a table. Partial Global indexes provide more flexibility in index creation for partitioned tables. For example, index segments can be omitted for the most recent partitions to ensure maximum data ingest rates without impacting the overall data model and access for the partitioned object.
Partial Global Indexes save space and improve performance during loads and queries. This feature supports global indexes that include or index a certain subset of table partitions or subpartitions, and exclude the others. This operation is supported using a default table indexing property. When a table is created or altered, a default indexing property can be specified for the table or its partitions.

NEW QUESTION 4
Which three statements are true about automated maintenance tasks? (Choose three.)

• A. They run at predefined time intervals that are intended to occur during a period of low system load.
• B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.
• C. A maintenance window is automatically extended until all the maintenance tasks defined are completed.
• D. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
• E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.

Answer: ABE

Explanation: References: https://docs.oracle.com/cd/E11882_01/server.112/e25494/tasks.htm#ADMIN12331

NEW QUESTION 5
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data? (Choose three.)

• A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
• B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
• C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
• D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
• E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
• F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

Answer: ACF

Explanation: AC (not E):
The md_restore command allows you to restore a disk group from the metadata created by the md_backup command. md_restore can’t restore data, only metadata.

NEW QUESTION 6
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)

• A. backup pieces
• B. copies of all parameter files
• C. trace file generated using BACKUP CONTROLFILE TO TRACE
• D. control file autobackups

Answer: AD

NEW QUESTION 7
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?

• A. The ORACLE_BASE base parameter is not set.
• B. The installation is being performed by the root user.
• C. The operating system group that is specified should have the root user as its member.
• D. The operating system group that is specified must have permission to write to the inventory directory.

Answer: D

Explanation: Note:
Providing a UNIX Group Name
If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.
You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.
Only users who belong to this group are able to install or deinstall software on this machine.

NEW QUESTION 8
Examine the parameters for a database instance:

Which two statements are true? (Choose two.)

• A. Undo records for temporary tables are stored in a temporary tablespace.
• B. Undo records for temporary tables are stored in the undo tablespace and logged in the redo.
• C. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.
• D. No redo is generated for the undo records belonging to temporary tables.
• E. No redo and undo records are generated for temporary table

Answer: AD

NEW QUESTION 9
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?

• A. as a secure application role
• B. with definer’s rights
• C. with global authentication
• D. with external authentication

Answer: A

Explanation: References: https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG97973

NEW QUESTION 10
To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?

• A. It results in an error because these parameter settings are invalid.
• B. One 64G flash cache file will be used.
• C. Two 64G flash cache files will be used.
• D. Two 32G flash cache files will be use

Answer: A

NEW QUESTION 11
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?

• A. RBAL
• B. CKPT
• C. SMON
• D. PMON
• E. MMON
• F. CTWR
• G. DBWR

Answer: F

NEW QUESTION 12
Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? (Choose three.)

• A. System privileges apply only to the PDB in which they are used.
• B. Local users cannot use local system privileges on the schema of a common user.
• C. The granter of system privileges must possess the set container privilege.
• D. Common users connected to a PDB can exercise privileges across other PDBs.
• E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

Answer: ACE

Explanation: A, Not D: In a CDB, PUBLIC is a common role. In a PDB, privileges granted locally to PUBLIC enable all
local and common users to exercise these privileges in this PDB only.
C: A user can only perform common operations on a common role, for example, granting privileges commonly to the role, when the following criteria are met:
The user is a common user whose current container is root.
The user has the SET CONTAINER privilege granted commonly, which means that the privilege applies in all containers.
The user has privilege controlling the ability to perform the specified operation, and this privilege has been granted commonly
Incorrect: Note:
* Every privilege and role granted to Oracle-supplied users and roles is granted commonly except for system privileges granted to PUBLIC, which are granted locally.

NEW QUESTION 13
You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.)

• A. Archived redo log files that have multiple copies in a different archive location
• B. user-managed backups of data files and control files
• C. RMAN backups that are obsolete
• D. flashback logs

Answer: CD

NEW QUESTION 14
You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade. What must you do first in this situation to attempt to fix this problem?

• A. Run catuppst.sql to perform revalidation actions
• B. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.
• C. Run preupgrd.sql and then execute the generated “fix-up” scripts to resolve status issues.
• D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY vie

Answer: D

NEW QUESTION 15
Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.)

• A. online redo log files
• B. parameter file
• C. multiplexed copies of the current control file
• D. archived log files
• E. Flashback Data Archive files
• F. Flashback logs

Answer: ADF

NEW QUESTION 16
Which statement is true regarding the startup of a database instance?

• A. The instance does not start up normally and requires manual media recovery after a shutdown using the ABORT option.
• B. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.
• C. There is no difference in the underlying mechanics of the startup whether the database is shut down by using the IMMEDIATE option or the ABORT option.
• D. Media recovery is required when the database is shut down by using either the IMMEDIATE option or the ABORT option.
• E. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.

Answer: E

Explanation: References:
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/start.htm

NEW QUESTION 17
Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)

• A. It utilizes the OS file system cache.
• B. A traditional NFS mount is not required when using Direct NFS.
• C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
• D. Direct NFS is available only in UNIX platforms.
• E. Direct NFS can load-balance I/O traffic across multiple network adapters.

Answer: CE

Explanation: E: Performance is improved by load balancing across multiple network interfaces (if available). Note:
* To enable Direct NFS Client, you must replace the standard Oracle Disk Manager (ODM) library with one that supports Direct NFS Client.
Incorrect:
Not A: Direct NFS Client is capable of performing concurrent direct I/O, which bypasses any operating system level caches and eliminates any operating system write-ordering locks
Not B:
* To use Direct NFS Client, the NFS file systems must first be mounted and available over regular NFS mounts.
* Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP).
Not D: Direct NFS is provided as part of the database kernel, and is thus available on all supported database platforms - even those that don't support NFS natively, like Windows.
Note:
* Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP). Direct NFS is built directly into the database kernel - just like ASM which is mainly used when using DAS or SAN storage.
* Oracle Direct NFS (dNFS) is an internal I/O layer that provides faster access to large NFS files than traditional NFS clients.

NEW QUESTION 18
A database is open READ WRITE and the instance has multiple sessions some of which have active transactions.
You execute this command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
Which three are true about the active transactions? (Choose three.)

• A. They may issue COMMIT OR ROLLBACK statements
• B. They are suspended and unable to issue any statements
• C. They may continue to issue DML statements
• D. They are rolled back automatically
• E. They may continue to issue queries
• F. They are terminated immediately

Answer: BDF