[Free] Download Latest (March 2016) Oracle 1Z0-062 Real Exam 71-80

Ensurepass

QUESTION 71

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:

 

SQL > CREATE UNDO TABLESPACE undotb01

DATAFILE `u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;

 

What is the result?

 

A.

It executes successfully and creates an UNDO tablespace in HR_PDB.

B.

It falls and reports an error because there can be only one undo tablespace in a CDB.

C.

It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

D.

It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

E.

It executes successfully but neither tablespace nor the data file is created.

 

Correct Answer: E

Explanation:

Interesting behavior in 12.1.0.1 DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace.

When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.

 

 

QUESTION 72

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

 

clip_image002

 

Which two statements are true?

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 used.

 

Correct Answer: CD

 

 

QUESTION 73

Which three statements are true concerning the multitenant architecture?

 

A.

Each pluggable database (PDB) has its own set of background processes.

B.

A PDB can have a private temp tablespace.

C.

PDBs can share the sysaux tablespace.

D.

Log switches occur only at the multitenant container database (CDB) level.

E.

Different PDBs can have different default block sizes.

F.

PDBs share a common system tablespace.

G.

Instance recovery is always performed at the CDB level.

 

Correct Answer: BDG

Explanation:B:

A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other

user created tablespaces in it.

There is one default temporary tablespace for the entire CDB. However, you can create additional temporary tablespaces in individual PDBs.

D:

There is a single redo log and a single control file for an entire CDB

A log switch is the point at which the database stops writing to one redo log file and begins writing to another. Normally, a log switch occurs when the current redo log file is completely filled and writing must continue to the next redo log file.

G: instance recovery

The automatic application of redo log records to uncommitted data blocks when an database instance is restarted after a failure.

Incorrect:

Not A:

There is one set of background processes shared by the root and all PDBs.

High consolidation density. The many pluggable databases in a single container database share its memory and background processes, letting you operate many more pluggable databases on a particular platform than you can single databases that use the old architecture.

Not C: There is a separate SYSAUX tablespace for the root and for each PDB.

Not F: There is a separate SYSTEM tablespace for the root and for each PDB.

 

 

QUESTION 74

Which three factors influence the optimizer’s choice of an execution plan?

 

A.

the optimizer_mode initialization parameter

B.

operating system (OS) statistics

C.

cardinality estimates

D.

object statistics in the data dictionary

E.

fixed baselines

 

Correct Answer: AB

Explanation:

http://docs.oracle.com/cd/B19306_01/server.102/b14211/optimops.htm

 

 

QUESTION 75

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

 

clip_image004

 

There is enough free space in the disk group for mirroring to be done.

 

What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

 

A.

Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

B.

Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.

C.

The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.

D.

ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.

E.

Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.

 

Correct Answer: B

Explanation:

CREATE DISKGROUP NORMAL REDUNDANCY

For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files).

 

 

QUESTION 76

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database.

 

Both local and global partitioned B-tree Indexes are defined on the table.

 

A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.

 

Minimal disrupt ion to availability is required.

 

Which
three statements are true about this requirement?

 

A.

The partitions can be moved online to new tablespaces.

B.

Global indexes must be rebuilt manually after moving the partitions.

C.

The partitions can be compressed in the same tablespaces.

D.

The partitions can be compressed in the new tablespaces.

E.

Local indexes must be rebuilt manually after moving the partitions.

 

Correct Answer: ACD

Explanation:

A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.

D: Moving (Rebuilding) Index-Organized Tables

Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE…MOVE statement to rebuild the index and reduce this fragmentation.

C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.

Incorrect:

Not B, not E: Local and Global indexes can be automatically rebuild with UPDATE

INDEXES when you move the table.

 

 

QUESTION 77

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.

 

Examine the following command and its output:

 

$ crsctl config has

CRS-4622: Oracle High Availability Services auto start is enabled.

 

What does this imply?

 

A.

When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

B.

When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

C.

When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.

D.

When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

 

Correct Answer: B

Explanation:

About Startup Dependencies

Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first.

Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances.

http://docs.oracle.com/cd/E16655_01/server.121/e17636/restart.htm#ADMIN12710

QUESTION 78

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.

 

Correct Answer: B

Explanation:

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

 

 

QUESTION 79

Examine the memory-related parameters set in the SPFILE of an Oracle database:

 

memory_max_target–6G

memory_target=5G

pga_aggregate_target=500M

sga_max_size=0

sga_target=0

 

Which statement is true?

 

A.

Only SGA components are sized automatically-

B.

Memory is dynamically re-allocated between the SGA and PGA as needed.

C.

The size of the PGA cannot grow automatically beyond 500 MB.

D.

The value of the MEMORY_TARGET parameter cannot be changed dynamically.

 

Correct Answer: C

 

 

QUESTION 80

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?

 

A.

SYSTEM

B.

SYSAUX

C.

EXAMPLE

D.

UNDO

E.

TEMP

F.

USERS

 

Correct Answer: ABE

Explanation:

A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user created tablespaces in it.

Oracle Database creates both the SYSTEM and SYSAUX tablespaces as part of every database.

tablespace_datafile_clauses

Use these clauses to specify attributes for all data files comprising the SYSTEM and SYSAUX tablespaces in the seed PDB.

Incorrect:

Not D: a PDB can not have an undo tablespace. Instead, it uses the undo tablespace belonging to the CDB.

Note:

Example:

CONN pdb_admin@pdb1

SELECT tablespace_name FROM dba_tablespaces;

TABLESPACE_NAME

—————————–

SYSTEM

SYSAUX

TEMP

USERS

SQL>

 

Free VCE & PDF File for Oracle 1Z0-062 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

This entry was posted in 1Z0-062 Real Exam (March 2016) and tagged , , , , , , , . Bookmark the permalink.