1Z0-074 Dumps 2023 Updated Oracle 1Z0-074 Exam Training Material
The updated Oracle 1Z0-074 exam training materials are valuable for preparing you for the Upgrade Oracle DBA 11g or 12c to 12c R2 exam. Passitdump’s updated 1Z0-074 exam dumps will provide you with real 1Z0-074 exam training materials, up-to-date.
The new Passitdump 1Z0-074 exam dumps will help you a lot in passing the Oracle 1Z0-074 exam.
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:
From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)
A. loss of ARCHIVELOGS
B. loss of a redo log member
C. loss of a noncritical data file
D. loss of all copies of the control file
E. loss of a critical data file such as SYSTEM, SYSAUX or UNDO
F. loss of SPFILE
Correct Answer: DE
Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta033.htm#RCMRF199
Question 4:
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 5:
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 6:
Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)
A. expdp scripts to export database objects belonging to the SYS schema
B. a log file containing a list of pre-upgrade patches to be applied
C. RMAN database backup scripts
D. a log file with tool recommendations and requirements
E. pre- and post-upgrade fixup scripts
Correct Answer: DE
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/using-preupgradeinformation-tool-for-oracle-database.html#GUID-C0219AF1- AD43-4097-B358-E53E48958647
Question 7:
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-flasbackdatabase-restore-points.html
Question 8:
Which statement is true about transportable tablespaces?
A. The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database\’s data file or files.
B. The cannot be dictionary-managed tablespaces
C. The source tablespace can be encrypted D. They can be administrative tablespaces such as SYSTEM or SYSAUX
Correct Answer: A
Question 9:
In your database, DEFERRED_SEGMENT_CREATION is set to TRUE. You successfully execute this command:
Which statement is true about the space allocated to the SALES_2016 table?
A. Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.
B. A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.
C. Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.
D. A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.
E. A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.
Correct Answer: A
Question 10:
The TESTDB container database (CDB) contains two pluggable databases (PDBs), PDB1 and PDB2.
USER1 is a local user in PDB1 and has the SYSBACKUP privilege.
Connect descriptors for PDB1 and PDB2 are mapped to TNS aliases pdb1 and PDB2 in tnsnames.ora.
Examine these commands executed by USER1 when all PDBs are open:
What is the outcome and why?
A. An error is returned because the user is connected to a pluggable database.
B. The current date is displayed.
C. An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax: SQL””.
D. An error is returned because the user is not SYS.
E. An error is returned because the user is not a common user.
Correct Answer: C
Question 11:
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 12:
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 13:
Which two statements are true about a band join? (Choose two.)
A. The optimizer always uses the smaller of the two row sources to build a hash table on the join key.
B. It returns rows for SQL statements that contain an equijoin.
C. It is a non-equijoin in which the key values in one data set must fall within the specified range of the second data set.
D. For each row in the first row source, Oracle probes the second row source for matching rows and joins them.
E. The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.
Correct Answer: CE
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgsql/joins.html#GUID24F34188-110F-4245-9DE7-43954092AFE0
Question 14:
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 15:
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