Latest 1Z0-074 Exam 1Z0-074 Dumps 100% Free Download

Attention please! Here is the shortcut to pass your Jun 06,2022 Latest 1Z0-074 QAs exam! Get yourself well prepared for the Oracle Database Application Development Latest 1Z0-074 exam questions Upgrade Oracle DBA 11g or 12c to 12c R2 exam is really a hard job. But don’t worry! We We, provides the most update 1Z0-074 practice tests. With We latest 1Z0-074 exam questions, you’ll pass the Oracle Database Application Development Newest 1Z0-074 vce Upgrade Oracle DBA 11g or 12c to 12c R2 exam in an easy way

We Geekcert has our own expert team. They selected and published the latest 1Z0-074 preparation materials from Official Exam-Center.

The following are the 1Z0-074 free dumps. Go through and check the validity and accuracy of our 1Z0-074 dumps.Questions and answers from 1Z0-074 free dumps are 100% free and guaranteed. See our full 1Z0-074 dumps if you want to get a further understanding of the materials.

Question 1:

Your CDB has a PDB, EMP_PDB.

You successfully execute these commands as the SYSTEM USER in CDB$ROOT:

Which two statements are true about C##USR1? (Choose two.)

A. It can connect to EMP_PDB and view the data only in tables created by common users.

B. It can connect to EMP_PDB but cannot view the data in any table in it.

C. It can connect only to the root.

D. It is a common user.

E. It is a local user.

Correct Answer: AE


Question 2:

While performing a cross-platform PDB transport in an Oracle Database 12c Release 2 database, by using XTTS from a Linux (x86-64) server to a Solaris (x86-64) server, this command is executed to back up the files in a compatible format:

What will be the outcome?

A. It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.

B. The backup fails because the UNPLUG operation for cross-endian platforms is not supported.

C. It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.

D. It successfully completes.

E. It creates a backupset of the source database in the /home/oracle/backup directory

Correct Answer: E


Question 3:

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema. BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker\’s right.

BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.

When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to update?

A. CUST_RECORDS table in Bixby\’s schema

B. CUST_RECORDS table in Murdok\’s schema

C. CUST_RECORDS table in Rlayton\’s schema

D. CUST_RECORDS table in the schema of Bixby and Rlayton

E. CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok

Correct Answer: C


Question 4:

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

A. They require a clone instance to be created when used in a PDB flashback operation

B. They can be created for a PDB when connected to either the PDB or to the root

C. They require backups to be restored when used in a PDB flashback operation

D. They are created as guaranteed restore points

E. They can be created only if shared undo is enabled

F. They can be created only for a PDB in the mount state

Correct Answer: EF

Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/using-flasback-database-restore-points.html


Question 5:

To which two components does the term “shape” refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

A. number of network interface cards (NICs)

B. number of database instances

C. number of CPUs

D. amount of RAM

E. number of storage LUNs

Correct Answer: CD

Reference: https://cloud.oracle.com/database/faq


Question 6:

Examine these statements executed in the PROD1 database:

Which statements are audited?

A. only the CREATE USER statement

B. only the ALTER SYSTEM statements

C. only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES

D. only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement

E. all the statements

Correct Answer: D


Question 7:

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

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

B. It is created by a common user with the SYSDBA privilege in CDB$ROOT.

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

D. It is enabled by default on creation.

E. It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied.

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

Correct Answer: BC

Reference: https://blogs.oracle.com/multitenant/a-simple-guide-to-lockdown-profiles


Question 8:

Examine these parameters in a PFILE used to start database instance.

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

A. PGA_AGGREGATE_TARGET and SGA_TARGET remain 1G and 2G respectively.

B. PGA_AGGREGATE_TARGET and SGA_TARGET are set to zero for the instance.

C. The MEMORY_MAX_TARGET parameter is set to zero for the instance.

D. MEMORY_MAX_TARGET is automatically set to 4G for the instance.

E. The instance does not start because AMM is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET are set to nonzero values.

Correct Answer: CD


Question 9:

The ORCL CDB has a PDB, ORCL_PDB. Examine these parameters in ORCL:

Examine these parameters in ORCL_PDB:

You switch to ORCL_PDB and plan to execute these commands:

What will be the outcome?

A. SGA_TARGET is set to 600M. The other values remain unchanged in both ORCL and ORCL_PDB.

B. SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB. The other values remain unchanged in both ORCL and ORCL_PDB.

C. SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB. SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to 200M in ORCL.

D. Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.

E. Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB. SGA_TARGET size is changed to 600 M.

Correct Answer: D


Question 10:

Which statement is true about Trace File Analyzer (TFA) Collector?

A. TFA collects diagnostic data only for Oracle 12c Release 2 databases or later versions.

B. If TFA is installed on any cluster node, it automatically collects diagnostic data on all other cluster nodes.

C. It can be used to collect diagnostic data for predefined events, and can be configured to automatically collect data for other events.

D. In Oracle 12c Release 2, TFA installation can be done only while executing root.sh.

E. It is used to collect diagnostic data only for ORA-600, ORA-7445, and ORA-4031 events.

Correct Answer: D


Question 11:

Examine this command:

Which statement is true?

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

B. Four worker processes are allocated to export only data

C. Four worker processes are active to export only metadata

D. Four worker processes are allocated to export data and metadata

E. Four worker processes are allocated when there is sufficient CPU available

Correct Answer: D

Reference: https://oracle-base.com/articles/10g/oracle-data-pump-10g


Question 12:

In which two situations does the INHERIT ANY PRIVILIGES privilege regulate the privileges used?

A. when a user creates a new user

B. when a user performs a GRANT or REVOKE operation

C. when a user queries a BEQUEATH CURRENT_USER view that references an invoker\’s right procedure

D. when a user runs a procedure created with invoker\’s right

E. when a user runs a procedure created with definer\’s right

Correct Answer: CD

Reference: https://docs.oracle.com/database/121/DBSEG/dr_ir.htm#DBSEG661


Question 13:

In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U.

You recreate the password file:

$ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5

Examine the command and result:

$ sqlplus u1/[email protected] as sysdba

ERROR:

ORA-01017: invalid username/password; logon denied

What can you do to fix this error?

A. Recreate the password file with the password set to Oracle_4U.

B. Change the password of U1 to Oracle_123.

C. Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE.

D. Regrant SYSDBA to U1.

E. Restart the database instance.

Correct Answer: A

Reference: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:670117794561


Question 14:

You receive complaints about poor performance in an Oracle 12c database while long running queries execute. You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for

each step of each execution plan to help diagnose the problem during query execution.

How would you achieve this?

A. by viewing Active Reports for that time period

B. by enabling SQL trace for each query

C. by running the Automatic Workload Repository (AWR) report for that time period

D. by running the Active Session History (ASH) report for that time period

E. by enabling tracing for sessions that run these queries

Correct Answer: E

Reference: https://docs.oracle.com/database/121/TDPPT/tdppt_realtime.htm#TDPPT034


Question 15:

In which situation can the optimizer choose a hash join?

A. when a non-equijoin is used and the join column in at least one of the tables is a primary key

B. when a non-equijoin is used and the join column for both tables is a primary key

C. when a non-equijoin is used between a table and a sorted hash cluster

D. when an equality operator is used

E. when any self-join is done

Correct Answer: D


Leave a Reply

Your email address will not be published.