Download Upgrade Oracle DBA 11g or 12c to 12c R2.real-exams.1z0-074.2019-08-10.1e.47q.vcex


Download Exam

File Info

Exam Upgrade Oracle DBA 11g or 12c to 12c R2
Number 1z0-074
File Name Upgrade Oracle DBA 11g or 12c to 12c R2.real-exams.1z0-074.2019-08-10.1e.47q.vcex
Size 706 Kb
Posted August 10, 2019
Downloads 1



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%


 
 



Demo Questions

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.



Question 2
Which two statements are true about application containers? (Choose two.)

  • A: A regular PDB can be plugged in to an application container provided it is an Oracle Database 12c Release 2 (12.2) PDB.
  • B: An application root can be unplugged from a CDB and plugged in to another CDB.
  • C: An application PDB can belong to multiple application containers.
  • D: User-created common objects are accessible from the CDB root.
  • E: The application root stores user-created common objects and Oracle-supplied common objects.
  • F: Multiple application roots can be created in one container database.



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



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



Question 5
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



Question 6
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



Question 7
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.



Question 8
Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

  • A: ESTIMATE (SHORTP_POLICY = 192) estimates the space requirement based on the SHORTP_POLICY value of 192 minutes.
  • B: ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160) estimates the space requirement based on current ADR diagnostics file space usage.
  • C: ESTIMATE (SIZEP_POLICY = 209715200) estimates only the long retention policy.
  • D: ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760) provides estimates that users can use to set SIZEP_POLICY.
  • E: ESTIMATE (SIZEP_POLICY = 209715200) estimates the value of LONGP_POLICY.



Question 9
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



Question 10
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









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset