Improve Oracle Database 12c: Installation And Administration 1Z0-062 Testing Material

NEW QUESTION 1
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 2
The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table. Which statement is true?

• A. The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.
• B. The transaction acquires a table lock on the DEPARTMENTS tabl
• C. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS table is complete.
• D. The transaction acquires a table lock on the EMPLOYEES tabl
• E. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.
• F. Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transactions on the DEPARTMENTS table is complete.

Answer: C

NEW QUESTION 3
As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT’s password is TIGER. The service mane “HQ” is used to connect to the remote HQ database.
Which command would you execute to create the database link?

• A. CREATE DATABASE LINK HQ USING 'HQ';
• B. CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING ‘HQ’;
• C. CREATE PUBLICDATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
• D. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

Answer: C

NEW QUESTION 4
Identify three situations in which messages are written to the alert log file. (Choose three.)

• A. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50)"
• B. Creating a table returns "ORA-00955: name is already in used by an existing object"
• C. Inserting a value into a table returns "ORA-01722: invalid number"
• D. Updating a record in a table returns "ORA-00060: deadlock detected while waiting for resource"
• E. Inserting a value into a table returns "ORA-00001: unique constraint (SYS.PK_XXXX) violated"
• F. Running a query on a table returns "ORA-01578: ORACLE data block corrupted (file # 4, block # 131)"

Answer: ADF

NEW QUESTION 5
Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

• A. recommending creation of indexes based on SQL workload
• B. recommending restructuring of SQL statements that have suboptimal plans
• C. checking schema objects for missing and state statistics
• D. recommending optimization of materialized views
• E. generating SQL profiles

Answer: BCE

NEW QUESTION 6
Which set of statements is true about data dictionary views?
1. They are stored in the SYSTEM tablespace.
2. They are based on virtual tables.
3. They are owned by the SYS user.
4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.
5. The V$FIXED_TABLE view can be queried to list the names of these views.
6. They are owned by the SYSTEM user.

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

Answer: C

Explanation:
References: https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCPT002

NEW QUESTION 7
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.

Which two statements are true? (Choose two.)

• A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
• B. An attempt to start a new session by a user belonging to OTHER_GROUPS fails with an error.
• C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
• D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
• E. A user belonging to the DSS QUERIES resource consumer group can create a new session but the session will be queued.

Answer: CE

NEW QUESTION 8
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.

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

Answer: B

Explanation:
Reference:
http://dba-oracle.com/bk_disable_archive_log_mode.htm

NEW QUESTION 9
Which three activities are supported by the Data Recovery Advisor? (Choose three.)

• A. Advising on block checksum failures
• B. Advising on inaccessible control files
• C. Advising on inaccessible block change tracking files
• D. Advising on empty password files
• E. Advising on invalid block header field values

Answer: ABE

Explanation:
* Data Recovery Advisor can diagnose failures such as the following:
/ (B) Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on
/ (A, E) Physical corruptions such as block checksum failures and invalid block header field values
/ Inconsistencies such as a datafile that is older than other database files
/ I/O failures such as hardware errors, operating system driver failures, and exceeding operating system resource limits (for example, the number of open files)
* The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user's request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).

NEW QUESTION 10
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A. By default, EM express is available for a database after database creation.
• B. You can use EM express to manage multiple databases running on the same server.
• C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D. You cannot start up or shut down a database Instance by using EM express.
• E. You can create and configure pluggable databases by using EM express.

Answer: D

Explanation:
References: http://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html

NEW QUESTION 11
Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity.
Which action generates recommendations to overcome the performance issues?

• A. running the Memory Advisor for the buffer cache
• B. running the Memory Advisor for the library cache
• C. running the Memory Advisor for the SGA
• D. running the Memory Advisor for the PGA

Answer: B

NEW QUESTION 12
Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

• A. It generates a script to recompile invalid objects post-upgrade.
• B. The preupgrade_fixups.sql script is created to list and describe issues in the source database.
• C. A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.
• D. It checks for required tablespaces and if they are not available, creates them automatically.
• E. The preupgrade_fixups.sql script is executed automatically to fix issues in the source database.
• F. The postupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.

Answer: ACE

Explanation:
References https://docs.oracle.com/database/122/UPGRD/using-preupgrade-information-tool-for-oracle- database.htm#UPG

NEW QUESTION 13
Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle Database 12c?

• A. It automatically restarts a Data Pump Export or Import job after a failure is connected and the job continues from the point of failure.
• B. It can be used to migrate a database only if the source and target databases are hosted on the same endian format.
• C. It can be used to migrate a database only if the source database does not have any tablespace in read-only mode.
• D. It allows migration of a database directly over network link

Answer: D

NEW QUESTION 14
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

• A. Tracking the most recent read time for a table segment in a user tablespace
• B. Tracking the most recent write time for a table segment in a user tablespace
• C. Tracking insert time by row for table rows
• D. Tracking the most recent write time for a table block
• E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
• F. Tracking the most recent write time for a table segment in the SYSAUX tablespace

Answer: ABD

Explanation:
Incorrect:
Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database.
References:

NEW QUESTION 15
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 16
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 17
Which three statements are true about server-generated alerts? (Choose three.)

• A. Server-generated alerts notify administrators of problems that cannot be resolved automatically.
• B. Alerts are not issued for locally managed read-only tablespaces.
• C. Response actions cannot be specified for server-generated alerts.
• D. Stateful alerts can be queried only from the DBA_ALERT_HISTORY view.
• E. When an alert is cleared, it is moved to the DBA_ALERT_HISTORY view.

Answer: ABE

Explanation:
References https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120

NEW QUESTION 18
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 19
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

• A. Place the root container in ARHCHIVELOG mode.
• B. Take the user data tablespace offline.
• C. Place the root container in the nomount stage.
• D. Ensure that HR_PDB is ope

Answer: A

NEW QUESTION 20
In your database, the RESOURCE_LIMIT parameter is set to TRUE. You create the profile:

Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)

• A. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL
• B. These users can never reuse a password
• C. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.
• D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.

Answer: CD

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

• A. ALTER TABLESPACE users OFFLINE
• B. STARTUP FORCE NOMOUNT
• C. STARTUP FORCE
• D. SWITCH DATAFILE ALL

Answer: A

NEW QUESTION 22
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.

• A. Change in the Oracle Database version
• B. Change in your network infrastructure
• C. Change in the hardware configuration of the database server
• D. Migration of database storage from non-ASM to ASM storage
• E. Database and operating system upgrade

Answer: ACE

Explanation:
Oracle 11g/12c makes further use of SQL tuning sets with the SQL Performance Analyzer, which compares the performance of the statements in a tuning set before and after a database change. The database change can be as major or minor as you like, such as:
* (E) Database, operating system, or hardware upgrades.
* (A, C) Database, operating system, or hardware configuration changes.
* Database initialization parameter changes.
* Schema changes, such as adding indexes or materialized views.
* Refreshing optimizer statistics.
* Creating or changing SQL profiles.

NEW QUESTION 23
Your database instance has started using an SPFILE. Examine the RMAN configuration settings:

You execute the command:
RMAN> BACKUP AS COPY TABLESPACE TEST;
Which three types of files are backed up by using this command? (Choose three.)

• A. online redo log files
• B. control file
• C. SPFILE
• D. archived redo log files
• E. data file(s)
• F. PFILE

Answer: BCE

Explanation:
References:
http://www.juliandyke.com/Research/RMAN/BackupCommand.php

NEW QUESTION 24
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? (Choose two.)

• A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• B. Setting the target tablespace to read-only
• C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• D. Setting the target tablespace offline
• E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Answer: BC

Explanation:
The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.

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

• A. All data definition language (DDL) commands are logged in to the alert log file.
• B. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.
• C. A subset of executed DDL statements is written into an XML file in ADR home.
• D. A subset of executed DDL statements is written to the DDL log in ADR home.
• E. All DDL commands are logged in to a trace file in ADR hom

Answer: CD

NEW QUESTION 26
Examine the structure of the SALES table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled.

You want to perform online segment shrink to reclaim fragmented free space below the high water mark. What should you ensure before the start of the operation?

• A. Row movement is enabled.
• B. Referential integrity constraints for the table are disabled.
• C. No queries are running on this table.
• D. Extra disk space equivalent to the size of the segment is available in the tablespace.
• E. No pending transaction exists on the tabl

Answer: A

NEW QUESTION 27
......