Techdefeat – Mohammad Fareed Online Technical Blog

Latest stuff about software, apps and Windows. Checkout for free technical tutorials, gadget reviews, certifications exam dumps, and new technologies in techdefeat.com

Oracle Database Application Development

New Released Free Update of 1Z0-074 Exam Practice Materials

How to pass Jun 27,2022 Hotest 1Z0-074 exam questions exam easily with less time? We provides the most valid 1Z0-074 dumps to boost your success rate in Oracle Database Application Development Latest 1Z0-074 pdf Upgrade Oracle DBA 11g or 12c to 12c R2 exam. If you are one of the successful candidates with We 1Z0-074 vce, do not hesitate to share your reviews on our Oracle Database Application Development materials.

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.Although questions are from 1Z0-074 free dumps, the validity and accuracy of the 1Z0-074 dumps are absolutely guaranteed.

Question 1:

APP1 is an application container that has an application seed and two application PDBs, APP_PDB1 and APP_PDB2.

1.0 is the current version of the application. You execute this block in the application root:

What is the outcome?

A. An error is thrown because the version number should be sequential, either 1.1 or 2.0.

B. An error is thrown because the CONTAINER=ALL clause is missing.

C. An error is thrown because the c## prefix is missing in the role name.

D. A common role is created only in the application root.

E. A common role is created only in the application root and application seed.

F. A common role is created in the application root, application seed, APP_PDB1, and APP_PDB2.

Correct Answer: D


Question 2:

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 3:

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 4:

You want to restrict PGA usage to 200 MB for a set of database users\’ sessions as part of your organization\’s security requirements for combating denial of service (DOS) attacks. Which statement is true about limiting PGA usage for those users\’ sessions?

A. You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.

B. You cannot limit PGA for a set of database user sessions.

C. You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.

D. You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.

E. You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager

Correct Answer: C

Reference: https://oracle-base.com/articles/12c/pga_aggregate_limit_12cR1


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:

You set the maximum size of the diagnostic collection repository by issuing this command as root.tfact1 set reposizeMB=5120 You then notice that the current repository size is 5 GB and that old files are not being purged.

Which statement is true?

A. The tfact1 command fails because it can be set only by the Oracle software owner.

B. TFA collects new diagnostic data if the Max Size of TFA Log parameter value is greater than 5 GB.

C. TFA does not collect new diagnostic data when the maximum repository size is reached.

D. TFA collects new diagnostic data but logs a warning message.

E. TFA collects new diagnostic data while the repository directory\’s file system has free space.

Correct Answer: A

Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/atnms/provisioning-access-to-users.html#GUID-C3CF0056-0869-4AC2-99CC- 9D0ACF848A46


Question 7:

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 8:

In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to `/u01/app/oracle/oradata\’.

CDB1 has an application container called REGIONS_APP.

There are no seeds for REGIONS_APP and 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?

A. Set the current container to REGIONS_APP

B. Set the current container to CDB1

C. Add the FILE_NAME_CONVERT clause to the command

D. Add the CREATE_FILE_DEST clause to the command

E. Set the PDB_FILE_NAME_CONVERT parameter to `/u01/app/oracle/oradata\’

Correct Answer: E


Question 9:

You create a new application container, SALES_APP, with application PDBs, SALES1_PDB, and SALES2_PDB. You want to install the NEW_APP application in SALES1_PDB and SALES2_PDB by using:

Where should you execute these statements?

A. All the statements should be executed in the application root.

B. All the statements should be executed in the application seed.

C. All the statements should be executed in the SALES1_PDB and SALES2_PDB application containers.

D. BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB.

E. BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.

Correct Answer: AD


Question 10:

The TESTDB container database (CDB) running in ARCHIVELOG mode contains two pluggable databases (PDBs) PDB1 and PDB2. A connect descriptor for TESTDB is mapped to the TNS alias testdb in tnsnames.ora.

The default RMAN configuration is used.

Examine these commands:

Which files are backed up?

A. all root and PDB1 data files, and the CONTROLFILE, SPFILE, and FLASHBACKLOGS

B. all root and PDB1 data files, and the CONTROLFILE, SPFILE, and ARCHIVELOGS

C. all root and PDB1 data files, and the CONTROLFILE and SPFILE

D. all root and PDB1 data files, and the CONTROLFILE, SPFILE, ONLINE REDO LOG FILES, and ARCHIVELOGS

E. all root and PDB1 data files

Correct Answer: E

Reference: https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1


Question 11:

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 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:

Identify four prerequisites for issuing the RMAN RECOVER TABLE command starting from ORACLE Database 12c Release 2.

A. The COMPATIBLE parameter must be set to 12.0 or greater.

B. The database must be in ARCHIVELOG mode.

C. FLASHBACK DATABASE must be enabled.

D. RMAN must use a recovery catalog.

E. The database must be in the READ WRITE state.

F. RMAN can recover the table only from a backupset.

G. An export dump file of the table must be available.

H. There must be sufficient space to start the auxiliary instance.

Correct Answer: ABEF

Reference: https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV697


Question 14:

You notice a large number of latch: cache buffers lru chain and latch: cache buffers chains wait events.

Which four might be reasons for these? (Choose four.)

A. The same small number of blocks are repeatedly accessed by different sessions simultaneously.

B. The buffer cache is undersized.

C. Cursors are closed explicitly after each execution.

D. A large number of connected user sessions are idle.

E. DBWR is not writing the dirty buffers fast enough.

F. Blocks are ageing out of the buffer cache frequently.

G. Too many sort operations are being performed.

Correct Answer: AEFG


Question 15:

Examine these commands executed in the cdb1 container database:

Which statement is true about the c##USER1 account?

A. It is locked for two days after the password expires.

B. It is locked if the password is not changed within three weeks.

C. It is locked for 90 minutes after four failed login attempts.

D. It is locked after for consecutive failed login attempts.

E. It is not affected by the profile because the user has the SYSDBA privilege.

Correct Answer: D


LEAVE A RESPONSE

Your email address will not be published. Required fields are marked *