Download Upgrade Oracle DBA 11g or 12c to 12c R2.1z0-074.ActualTests.2019-07-02.38q.tqb

Vendor: Oracle
Exam Code: 1z0-074
Exam Name: Upgrade Oracle DBA 11g or 12c to 12c R2
Date: Jul 02, 2019
File Size: 896 KB
Download Exam

How to open TQB files?

Files with TQB (Taurus Question Bank) extension can be opened by Taurus Exam Studio.

Download
Taurus Exam Studio

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

Taurus Exam Simulator Taurus Exam Simulator Taurus Exam Simulator Taurus Exam Simulator Taurus Exam Simulator

Demo Questions

Question 1
Which two statements are true about application containers? (Choose two.)
  1. A regular PDB can be plugged in to an application container provided it is an Oracle Database 12c Release 2 (12.2) PDB.
  2. An application root can be unplugged from a CDB and plugged in to another CDB.
  3. An application PDB can belong to multiple application containers.
  4. User-created common objects are accessible from the CDB root.
  5. The application root stores user-created common objects and Oracle-supplied common objects.
  6. Multiple application roots can be created in one container database.
Correct answer: DE
Explanation:
Reference: https://blogs.oracle.com/oraclemagazine/multitenant-database-management
Reference: https://blogs.oracle.com/oraclemagazine/multitenant-database-management
Question 2
Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)
  1. expdp scripts to export database objects belonging to the SYS schema
  2. a log file containing a list of pre-upgrade patches to be applied
  3. RMAN database backup scripts
  4. a log file with tool recommendations and requirements
  5. pre- and post-upgrade fixup scripts
Correct answer: DE
Explanation:
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/using-preupgrade-information-tool-for-oracle-database.html#GUID-C0219AF1-AD43-4097-B358-E53E48958647
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/using-preupgrade-information-tool-for-oracle-database.html#GUID-C0219AF1-AD43-4097-B358-E53E48958647
Question 3
Which statement is true about transportable tablespaces?
  1. 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.
  2. The cannot be dictionary-managed tablespaces
  3. The source tablespace can be encrypted
  4. They can be administrative tablespaces such as SYSTEM or SYSAUX
Correct answer: A
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?
  1. You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.
  2. You cannot limit PGA for a set of database user sessions.
  3. You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.
  4. You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.
  5. You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager
Correct answer: C
Explanation:
Reference: https://oracle-base.com/articles/12c/pga_aggregate_limit_12cR1
Reference: https://oracle-base.com/articles/12c/pga_aggregate_limit_12cR1
Question 5
Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)
  1. ESTIMATE (SHORTP_POLICY = 192) estimates the space requirement based on the SHORTP_POLICY value of 192 minutes.
  2. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160) estimates the space requirement based on current ADR diagnostics file space usage.
  3. ESTIMATE (SIZEP_POLICY = 209715200) estimates only the long retention policy.
  4. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760) provides estimates that users can use to set SIZEP_POLICY.
  5. ESTIMATE (SIZEP_POLICY = 209715200) estimates the value of LONGP_POLICY.
Correct answer: DE
Question 6
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?
  1. An error is returned because the user is connected to a pluggable database.
  2. The current date is displayed.
  3. An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax: SQL”<command>”.
  4. An error is returned because the user is not SYS.
  5. An error is returned because the user is not a common user.
Correct answer: B
Question 7
To which two components does the term “shape” refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)
  1. number of network interface cards (NICs)
  2. number of database instances
  3. number of CPUs
  4. amount of RAM
  5. number of storage LUNs
Correct answer: CD
Explanation:
Reference: https://cloud.oracle.com/database/faq
Reference: https://cloud.oracle.com/database/faq
Question 8
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?
  1. The tfact1 command fails because it can be set only by the Oracle software owner.
  2. TFA collects new diagnostic data if the Max Size of TFA Log parameter value is greater than 5 GB.
  3. TFA does not collect new diagnostic data when the maximum repository size is reached.
  4. TFA collects new diagnostic data but logs a warning message.
  5. TFA collects new diagnostic data while the repository directory’s file system has free space.
Correct answer: A
Explanation:
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/atnms/provisioning-access-to-users.html#GUID-C3CF0056-0869-4AC2-99CC-9D0ACF848A46
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 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?
  1. SGA_TARGET is set to 600M. 
    The other values remain unchanged in both ORCL and ORCL_PDB.
  2. 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.
  3. 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.
  4. Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.
  5. 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
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?
  1. Set the current container to REGIONS_APP
  2. Set the current container to CDB1
  3. Add the FILE_NAME_CONVERT clause to the command
  4. Add the CREATE_FILE_DEST clause to the command
  5. Set the PDB_FILE_NAME_CONVERT parameter to ‘/u01/app/oracle/oradata’
Correct answer: E
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!