19 November, 2020

Replace Upgrade Oracle DBA 11g/12c To 12cR2 1z0-074 Actual Exam

Master the 1z0-074 Upgrade Oracle DBA 11g/12c to 12cR2 content and be ready for exam day success quickly with this Ucertify 1z0-074 braindumps. We guarantee it!We make it a reality and give you real 1z0-074 questions in our Oracle 1z0-074 braindumps.Latest 100% VALID Oracle 1z0-074 Exam Questions Dumps at below page. You can use our Oracle 1z0-074 braindumps and pass your exam.

Free 1z0-074 Demo Online For Oracle Certifitcation:

Page: 1 / 6

Total 75 questions Full Exam Access

Question 1

You create a new application container,SALES_APP, with applicationPDBs,SALES1_PDB, andSALES2_PDB.
You want to install theNEW_APPapplication inSALES1_PDBandSALES2_PDBby using:
1Z0-074 dumps exhibit

Where should you execute these statements?

All the statements should be executed in the application root.

All the statements should be executed in the application seed.

All the statements should be executed in theSALES1_PDBandSALES2_PDBapplication containers.

BEGIN/END INSTALLstatements should be executed in the application root and the SYNC statement inSALES1_PDBandSALES2_PDB.

BEGIN/END INSTALLstatements should be executed in the CDB root and the SYNC statement in the application root.

Question 2

USER1is an OS user with the passwordoracleand is only a member of theoinstallgroup. In theORCLdatabase, theOS_AUTHEN_PREFIXvalue isops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally; SQL> GRANT create session TO ops$user1;
How canUSER1be given theSYSRACprivilege?

MakeUser1a member of the OSDBA group in Linux or theORA_%HOMENAME%_SYSDBAgroup in Windows only.

GrantSYSRACtouser1.

GrantSYSRACtoops$user1.

MakeUSER1a member of theOSRACDBAgroup in Linux or theORA_%HOMENAME%_SYSRACgroup in Windows.

GrantSYSDBAtoops$user1

Question 3

Which three types of database objects can have their columns stored in the In-Memory column store? (Choose three.)

heap tables with composite primary key constraints

heap tables with dependent materialized views

clustered tables with dependent materialized views

index-organized tables stored in system-defined tablespaces

sys-owned objects stored in sysaux-defined tablespaces

Question 4

From which two failure scenarios can a database be restored and recovered with theREPAIR DATABASE
command? (Choose two.)

loss ofARCHIVELOGS

loss of a redo log member

loss of a noncritical data file

loss of all copies of the control file

loss of a critical data file such asSYSTEM,SYSAUXorUNDO

loss ofSPFILE

Question 5

Which three statements are true about the deferred invalidation clause inDDLstatements? (Choose three.)

It defers invalidating dependent cursor when possible.

It cannot be used for bitmap index creation.

TheCURSOR_INVALIDATIONparameter always overrides the deferred invalidation clause.

It always overrides theCURSOR_INVALIDATIONsetting.

It cannot be used for creating a secondary index on index organized tables

Question 6

Which statement is true about the Automatic Diagnostic Repository (ADR)?

Space used by the ADR can be limited to a user-specified value.

Space used by the ADR is limited based only on the retention period.

The retention period for the ADR is set based on the space limit specified.

When the ADR reaches the space limit, it deletes incident dumps and metadata before deleting old core dumps.

Manual purging of all types of ADR files is allowed.

Question 7

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

It recommends the use of SQL Tuning Advisor for regressed SQL statements.

It recommends the creation of indexes for regressed SQL statements.

It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).

It always executes triggers that are fired recursively inFULLDMLmode.

It generates execution plans for each SQL statement in an STS.

Question 8

Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

ESTIMATE (SHORTP_POLICY = 192)estimates the space requirement based on theSHORTP_POLICYvalue of 192 minutes.

ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160)estimates the space requirement based on current ADR diagnostics file space usage.

ESTIMATE (SIZEP_POLICY = 209715200)estimates only the long retention policy.

ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760)provides estimates that users can use to setSIZEP_POLICY.

ESTIMATE (SIZEP_POLICY = 209715200)estimates the value ofLONGP_POLICY.

Question 9

In which four situations does theRMAN DUPLICATEcommand use the “pull” method? (Choose four.)

when theUSING BACKUPSETclause is used

when theSET ENCRYPTIONclause is added before theDUPLICATEcommand

when theSECTION SIZEclause is used

when the number of auxiliary channels allocated is less than the number of target channels allocated

when theUSING COMPRESSED BACKUPSETclause is used

when no auxiliary channels are allocated

whenIMAGE COPIESare used for theDUPLICATEoperation

Question 10

In your CDB1 container database, theDB_CREATE_FILE_DESTparameter is set to‘/u01/app/oracle/ oradata’.
CDB1has an application container calledREGIONS_APP.
There are no seeds forREGIONS_APPand there are no other application containers. You plan to execute this command.
CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123;
What must you do for the command to execute successfully?

Set the current container toREGIONS_APP

Set the current container toCDB1

Add theFILE_NAME_CONVERTclause to the command

Add theCREATE_FILE_DESTclause to the command

Set thePDB_FILE_NAME_CONVERTparameter to‘/u01/app/oracle/oradata’

Question 11

You create and enable a unified audit policy on a database that has the default auditing configuration.
1Z0-074 dumps exhibit

The OE user, who has the DBA role, executes these statements.
1Z0-074 dumps exhibit

What is true about the SELECT statement and why?

It is audited because unified auditing is disabled be default.

It is audited because, by default, the database is in mixed auditing mode with default policies enabled.

It is audited because, by default, all user activities in the database are audited.

It is not audited because the table belongs to another schemA.

It is not audited because audit records are stored only when unified auditing is enabled in the database.

Question 12

Which two statements are true about a PDB lockdown profile? (Choose two.)

It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.

It is created by a common user with the SYSDBA privilege inCDB$ROOT.

It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.

It is enabled by default on creation.

It is enabled by using thePDB_LOCKDOWNparameter in each PDBs where it needs to be applied.

It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.

Question 13

You create a refreshable copy PDB,PDB_COPY, from thePDB_ORGPDB by using theREFRESH MODE EVERY 5 MINUTESclause.
What happens every five minutes?

An automatic refresh is done providedPDB_COPYis closed; otherwise the refresh is differed and attempted again after five minutes.

PDB_COPYis automatically closed provided there is no ongoing transaction inPDB_ORGand then reopened as read-only after the refresh is complete.

PDB_COPY’Sstate is automatically changed to read-write and back to read-only after the refresh is complete.

PDB_COPY’Sstate is automatically changed to read-only and then reopened as read-write after the refresh is complete.

An automatic refresh is done providedPDB_COPYis in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.

Question 14

Your CDB is inARCHIVELOGmode and has an application container with a container PDB. A backup exists for the CDB.
When you connect to the container PDB and try to execute a query, you get an error that aSYSTEMdata file is missing in the container PDB.
You want to use the RMANRESTORE DATABASEandRECOVER DATABASEcommands to perform the recovery.
Examine these actions:
Connect toCDB$ROOTand executeSHUTDOWN ABORTandSTARTUP MOUNT.
Connect to the application container and executeSHUTDOWN ABORT.
Connect to the application container and executeALTER PLUGGABLE DATABASE CLOSE ABORT. Which option correctly lists the actions that you must execute before performing the recovery?

1 and 3

1 and 2

only 2

only 3

Question 15

ACDB,CDB1, has aLOCATIONSapplication container. NORTH_PDBandSOUTH_PDBare two application PDBs inLOCATIONS.
Both application PDBs are synchronized with the application installed in theLOCATIONS root… InCDB2, you create a remote clone,LOC_R, of theLOCATIONSapplication root.
You want to query data across theLOCATIONSapplication PDBs created inCDB1andCDB2. How can you do this?

by creating a proxy PDB inLOCATIONS_ROOTinCDB1, referencingLOC_R

by creating a proxy PDB inCDB1root, referencingLOC_R

by using private database links created inCDB1andCDB2

by using public database links created inCDB1andCDB2

by creating a proxy PDB inCDB2root, referencingLOC_R

Question 16

Which two statements are true about application containers? (Choose two.)

A regular PDB can be plugged in to an application container provided it is an Oracle Database 12c Release2 (12.2) PDB.

An application root can be unplugged from a CDB and plugged in to another CDB.

An application PDB can belong to multiple application containers.

User-created common objects are accessible from the CDB root.

The application root stores user-created common objects and Oracle-supplied common objects.

Multiple application roots can be created in one container database.

Question 17

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

number of parallel queries issued by a consumer group

maximum number of DML operations performed by a consumer group

sessions that are blocking other sessions

sessions that are not blocking other sessions

UNDO quota for a consumer group

Question 18

Examine these parameters in aPFILEused to start database instance.
1Z0-074 dumps exhibit

Which two statements are true after an instance restart is attempted and why? (Choose two.)

PGA_AGGREGATE_TARGETandSGA_TARGETremain1Gand2Grespectively.

PGA_AGGREGATE_TARGETandSGA_TARGETare set to zero for the instance.

TheMEMORY_MAX_TARGETparameter is set to zero for the instance.

MEMORY_MAX_TARGETis automatically set to 4G for the instance.

The instance does not start because AMM is enabled butPGA_AGGREGATE_TARGETandSGA_TARGETare set to nonzero values.

Question 19

Examine these statements:
1Z0-074 dumps exhibit

Which statement is true?

Statements 2 and 3 will validate the conversion

Only statement 3 will validate the conversion

Only statement 1 will validate the conversion

Statement 1 will return an error

All the statements will validate the conversion

Question 20

Which two are true about tables recovered by using theRMAN RECOVER TABLEcommand or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

They may be recovered to a schema in a different PDB

AnAUXILIARYinstance is started only if there is sufficient disk space

They can be recovered by RMAN without anAUXILIARYinstance

They must be un-partitioned tables

They may be recovered to a different schema in the same pluggable database (PDB)

Question 21

Examine this command:
1Z0-074 dumps exhibit

Which statement is true?

Up to four worker processes are allocated to export data and metadata

Four worker processes are allocated to export only data

Four worker processes are active to export only metadata

Four worker processes are allocated to export data and metadata

Four worker processes are allocated when there is sufficient CPU available

Question 22

You plan to execute this command:
1Z0-074 dumps exhibit

Which statement is true and why?

It creates partitionsP1andP2whereCOUNTRYis a single column partition key andCHANNELis a subpartition key.

It returns an error because only one set of multiple values can be specified for each partition.

It returns an error because only a single column key can be used for a list-partitioned table.

It returns an error because theAUTOMATICoption must be specified.

It creates partitionsP1andP2whereCOUNTRYandCHANNELare multi-column partition keys.

Question 23

TheORCLCDB has a PDB,ORCL_PDB.
Examine these parameters inORCL:
1Z0-074 dumps exhibit

Examine these parameters inORCL_PDB:
1Z0-074 dumps exhibit

You switch toORCL_PDBand plan to execute these commands:
1Z0-074 dumps exhibit

What will be the outcome?

SGA_TARGETis set to 600M.The other values remain unchanged in bothORCLandORCL_PDB.

SGA_TARGETis set to 600M andDB_CACHE_SIZEto 200M inORCL_PD

The other values remain unchanged in bothORCLandORCL_PDB.

SGA_TARGETandSGA_MAX_SIZEare set to 600M andDB_CACHE_SIZEto 200M inORCL_PD

SGA_TARGETandSGA_MAX_SIZEare set to (1360-600)M andDB_CACHE_SIZEto 200M inORCL.

Altering theDB_CACHE_SIZEresults in an error becauseSGA_TARGETshould be altered to 600M first.

Altering theDB_CACHE_SIZEresults in an error because it cannot be altered in a PD

SGA_TARGETsize is changed to 600 M.

Page: 1 / 6

Total 75 questions Full Exam Access