Download Upgrade Oracle DBA 11g or 12c to 12c R2.1z0-074.Prep4Sure.2019-01-31.43q.vcex

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

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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?
  1. Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.
  2. A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.
  3. Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.
  4. A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.
  5. A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.
Correct answer: A
Question 2
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 3
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: C
Question 4
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 5
Examine these statements executed in the PROD1 database:
   
Which statements are audited?
  1. only the CREATE USER statement
  2. only the ALTER SYSTEM statements
  3. only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES
  4. only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement
  5. all the statements
Correct answer: D
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?
  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 7
Which two statements are true about a PDB lockdown profile? (Choose two.)
  1. It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.
  2. It is created by a common user with the SYSDBA privilege in CDB$ROOT.
  3. It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.
  4. It is enabled by default on creation.
  5. It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied.
  6. It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.
Correct answer: BC
Explanation:
Reference: https://blogs.oracle.com/multitenant/a-simple-guide-to-lockdown-profiles
Reference: https://blogs.oracle.com/multitenant/a-simple-guide-to-lockdown-profiles
Question 8
Which two statements are true about a band join? (Choose two.)
  1. The optimizer always uses the smaller of the two row sources to build a hash table on the join key.
  2. It returns rows for SQL statements that contain an equijoin.
  3. 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.
  4. For each row in the first row source, Oracle probes the second row source for matching rows and joins them.
  5. The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.
Correct answer: CE
Explanation:
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgsql/joins.html#GUID-24F34188-110F-4245-9DE7-43954092AFE0
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgsql/joins.html#GUID-24F34188-110F-4245-9DE7-43954092AFE0
Question 9
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.)
  1. PGA_AGGREGATE_TARGET and SGA_TARGET remain 1G and 2G respectively.
  2. PGA_AGGREGATE_TARGET and SGA_TARGET are set to zero for the instance.
  3. The MEMORY_MAX_TARGET parameter is set to zero for the instance.
  4. MEMORY_MAX_TARGET is automatically set to 4G for the instance.
  5. 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 10
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
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

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

Get Now!