NEW QUESTION 1
Which two actions does an incremental checkpoint perform? (Choose two.)

• A. It signals CKPT to write the checkpoint position to the data file headers.
• B. It writes the checkpoint position to the data file headers.
• C. It advances the checkpoint position in the checkpoint queue.
• D. It writes the checkpoint position to the control file.

Answer: CD

Explanation: References:
http://www.dba-oracle.com/t_incremental_checkpoint.htm

NEW QUESTION 2
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)

• A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
• B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
• C. The command will, create a common user whose description is contained in the root and each PDB.
• D. The schema for the common user C # # A_ADMIN can be different in each container.
• E. The command will create a user in the root container only because the container clause is not use

Answer: CD

NEW QUESTION 3
Examine the parameter settings in your local ORCL database:

Examine the parameter settings for the remote SALES database:

As the SYS user, you issue the following command on ORCL:
CREATE PUBLICDATABASE LINK sales.us.example.com USING ‘sales1’; The sales1 tnsnames entry points to the sales database instance.
Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

• A. The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database.
• B. The SALES1 net service name should be known to both the local and remote databases.
• C. Local database users who use this database link should have accounts and the required privileges in the remote database.
• D. The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.
• E. Only the user creating the database link must have an account and the required privileges in the remote databas

Answer: AC

NEW QUESTION 4
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

• A. 1, 5, and 4
• B. 3, 1, 5, and 6
• C. 2, 3, 6, and 4
• D. 2, 1, 6, and 4
• E. 2, 3, 1, and 6

Answer: E

NEW QUESTION 5
You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c. Which three tasks should be performed before a manual upgrade? (Choose three.)

• A. running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file
• B. running utlu121s.sql from the new Oracle home to display information about the required initialization parameters
• C. copying the initialization parameter file to the new Oracle home
• D. copying the password file to the new Oracle home
• E. copying net configuration files to the new Oracle home

Answer: ACE

NEW QUESTION 6
Examine this command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true? (Choose two.)

• A. All data definition language (DDL) statements are written to the control file
• B. Some DDL statements are written to an XML file in the ADR home
• C. All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home
• D. Some data definition language (DDL) statements are written to the control file
• E. Some DDL statements are written to a text file in the ADR home
• F. The Alert Log still contains some DDL statements

Answer: DE

NEW QUESTION 7
Which four are true about creating and running a remote database scheduler jobs? (Choose four.)

• A. A database destination must exist or be created for the remote database
• B. It must run as a user that is defined on the remote database
• C. Remote database jobs always run as the same user who submits the job on the local database
• D. A credential is optional for a remote database job
• E. A credential must be created to define the remote user
• F. A database destination group must exist or be created for a job to run on multiple remote databases
• G. A destination is optional for a remote database job because DB links can be used instead

Answer: ABDF

NEW QUESTION 8
Identify three uses of the CROSSCHECK command (Choose three.)

• A. to validate the database backup
• B. to synchronize logical backup records with physical files in backup storage
• C. to check the obsolete backups that can be deleted from the file system
• D. to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file
• E. to update the recovery catalog or control file if archived log files are deleted with operating system commands

Answer: BDE

NEW QUESTION 9
A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?

• A. The keep pool is not configured.
• B. Automatic Workarea Management is not configured.
• C. Automatic Shared Memory Management is not enabled.
• D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
• E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

Answer: D

Explanation: The most of the rows in SUBSCRIBE_LOG table are accessed once a week.

NEW QUESTION 10
You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle Grid Infrastructure for a standalone server is already installed on the server.
You want to configure job role separation. You create the following operating system users and groups:
- The user oracle as the owner of the Oracle database installation
- The user grid as the owner of Oracle Grid Infrastructure
- The group oinstall as an Oracle Inventory group
- The group dba as the OSDBA group for Oracle database
- The group asmdba as the OSDBA group for Oracle ASM
- The group asmadmin as the administration privileges group for Oracle ASM
- The group asmoper as the group for Oracle ASM
Which two additional tasks should you perform with regard to the OS-level owners and groups? (Choose two.)

• A. creating a separate central inventory group for the Oracle Database 12c installation
• B. assigning oinstall as the primary group for the oracle user
• C. assigning asmadmin and asmoper as primary groups for the oracle user
• D. creating OS groups associated with the OSBACKUPDBA, OSDGDBA, and OSKMDBA system privileges
• E. assigning asmdba as the secondary group for the oracle user

Answer: BD

NEW QUESTION 11
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:
1snrctl > STOP
What happens to the sessions that are presently connected to the database Instance?

• A. They are able to perform only queries.
• B. They are not affected and continue to function normally.
• C. They are terminated and the active transactions are rolled back.
• D. They are not allowed to perform any operations until the listener LISTENER is started.

Answer: B

Explanation: The listener is used when the connection is established. The immediate impact of stopping the listener will be that no new session can be established from a remote host. Existing sessions are not compromised.

NEW QUESTION 12
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.
On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

• A. Decreasing PCTUSED
• B. Decreasing PCTFREE
• C. Increasing the number of DBWN process
• D. Using Automatic Segment Space Management (ASSM)
• E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

Answer: D

Explanation: * Automatic segment space management (ASSM) is a simpler and more efficient way of managing space within a segment. It completely eliminates any need to specify and tune the pctused,freelists, and freelist groups storage parameters for schema objects created in the tablespace. If any of these attributes are specified, they are ignored.
* Oracle introduced Automatic Segment Storage Management (ASSM) as a replacement for traditional freelists management which used one-way linked-lists to manage free blocks with tables and indexes. ASSM
is commonly called "bitmap freelists" because that is how Oracle implement the internal data structures for free block management.
Note:
* Buffer busy waits are most commonly associated with segment header contention onside the data buffer pool (db_cache_size, etc.).
* The most common remedies for high buffer busy waits include database writer (DBWR) contention tuning, adding freelists (or ASSM), and adding missing indexes.

NEW QUESTION 13
Backup requirements for a database:
* Level 0 backup on Sunday
* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
* Differential incremental level 1 backup on Tuesday, Thursday, and Friday Which three statements are true about the strategy? (Choose three.)

• A. Level 0 backup on Sunday contains all the blocks that have been formatted.
• B. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.
• C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.
• D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.
• E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.

Answer: ACD

NEW QUESTION 14
Which two statements correctly describe the relationship between data files and logical database structures? (Choose two.)

• A. A segment cannot span data files.
• B. A data file can belong to only one tablespace.
• C. An extent cannot span data files.
• D. The size of an Oracle data block in a data file should be the same as the size of an OS block.

Answer: BC

Explanation: A single extent can never span data files. https://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT1095

NEW QUESTION 15
You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

• A. Oracle Data Pump.
• B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
• C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
• D. Online Table Redefinition.
• E. Edition-Based Table Redefinition.

Answer: D

Explanation: * Oracle Database provides a mechanism to make table structure modifications without significantly affecting the availability of the table. The mechanism is called online table redefinition. Redefining tables online provides a substantial increase in availability compared to traditional methods of redefining tables.
* To redefine a table online:
Choose the redefinition method: by key or by rowid
* By key—Select a primary key or pseudo-primary key to use for the redefinition. Pseudo-primary keys are unique keys with all component columns having NOT NULL constraints. For this method, the versions of the tables before and after redefinition should have the same primary key columns. This is the preferred and default method of redefinition.
* By rowid—Use this method if no key is available. In this method, a hidden column named M_ROW$$ is added to the post-redefined version of the table. It is recommended that this column be dropped or marked as unused after the redefinition is complete. If COMPATIBLE is set to 10.2.0 or higher, the final phase of redefinition automatically sets this column unused. You can then use the ALTER TABLE ... DROP UNUSED COLUMNS statement to drop it.
You cannot use this method on index-organized tables. Note:
* When you rebuild an index, you use an existing index as the data source. Creating an index in this manner enables you to change storage characteristics or move to a new tablespace. Rebuilding an index based on an existing data source removes intra-block fragmentation. Compared to dropping the index and using the CREATE INDEX statement, re- creating an existing index offers better performance.
Incorrect:
Not E: Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.

NEW QUESTION 16
Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

• A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
• B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.
• C. Use the DBMS_PDB package to clone an existing PDB.
• D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.
• E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.

Answer: ACD

Explanation: Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). This statement enables you to perform the following tasks:
* (A) Create a PDB by using the seed as a template
Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB.
* (C) Create a PDB by cloning an existing PDB
Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB) and then plugging the copy into the CDB. The files associated with the source PDB are copied to a new location and the copied files are associated with the new PDB. This operation is called cloning a PDB.
The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is used to connect to the remote CDB and copy the files.
* Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB
Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.

NEW QUESTION 17
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.)

• A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
• C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
• D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• E. Re-create the password file in the Oracle Database 12c format.

Answer: BD

Explanation: * orapwd
/ You can create a database password file using the password file creation utility, ORAPWD. The syntax of the ORAPWD command is as follows:
orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}] [DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}] [SYSKM={y|n}] [DELETE={y|n}]
[INPUT_FILE=input-fname]
force - whether to overwrite existing file (optional), * v$PWFILE_users
/ 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.
/ 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file. ColumnDatatypeDescription
USERNAMEVARCHAR2(30)The name of the user that is contained in the password file
SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges Incorrect:
not E: The format of the v$PWFILE_users file is already in 12c format.

NEW QUESTION 18
As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command: SQL> STARTUP UPGRADE
Which three statements are true about the upgrade process? (Choose three.)

• A. All system triggers are disabled during the upgrade process.
• B. Only queries on fixed views execute without errors until you run the catctl.pl script.
• C. The COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command.
• D. All job queues remain active during the upgrade process.
• E. Only connections AS SYSDBA are allowed during the upgrade process.

Answer: ADE