Download Oracle Database 12cR2 Administration.certkiller.1z0-072.2019-06-04.1e.33q.vcex


Download Exam

File Info

Exam Oracle Database 12cR2 Administration
Number 1z0-072
File Name Oracle Database 12cR2 Administration.certkiller.1z0-072.2019-06-04.1e.33q.vcex
Size 449 Kb
Posted June 04, 2019
Downloads 55



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
Which three failures require intervention for recovery? (Choose three.)

  • A: a user error such as dropping the wrong table
  • B: network interface card (NIC) failure
  • C: user process failure
  • D: statement failure
  • E: media failure



Question 2
In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2.  
The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1.  
USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME. 
TBS1 is exported from ORCL by using this command:
[[email protected] ~]$ expdp system/oracle tablespace=tbs1 directory=exp_dir dumpfile=tbs1.dmp 
The TESTDB database has a TBS1 tablespace but no TBS2. 
The SYSTEM user in TESTDB executes this command:
[[email protected] ~]$ impdp system/oracle directory=exp_dir dumpfile=u1.dmp tablespace=tbs1 
What is the result and why?

  • A: It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.
  • B: It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.
  • C: It fails because TESTDB has TBS1.
  • D: It imports only EMP.
  • E: It fails because TESTDB does not have TBS2 to create EMP_IDX.



Question 3
In your database, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION; 
Which three actions can HR perform? (Choose three.)

  • A: Grant the CREATE SESSION privilege without ADMIN OPTION to other users.
  • B: Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
  • C: Execute DML statements in the HR schema.
  • D: Log in to the database instance.
  • E: Revoke the CREATE SESSION privilege from other users.
  • F: Execute DDL statements in the HR schema.



Question 4
TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF). 
Examine this command:
DROP TABLESPACE tbs1; 
Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?

  • A: The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
  • B: TBS1 must be placed in READ ONLY state.
  • C: Objects in TBS1 must not be in use when the command is executed.
  • D: TBS1 must not contain any temp files.
  • E: DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group.



Question 5
Which three types of files are created by expdp operations? (Choose three.)

  • A: SQL files
  • B: dump files
  • C: reject files
  • D: log files
  • E: input data files
  • F: bad files
  • G: control files



Question 6
DATADIR1 and DATADIR2 are database directory objects. 
Examine this command:
[[email protected] ~] expdp system/oracle \ 
> FULL=y \ 
> DUMPFILE=datadir1:full%U.dmp, datadir2: full2%U.dmp \
> FILESIZE=2G \ 
> PARALLEL=4 \ 
> LOGFILE= datadir1:/expfull.log
> JOB_NAME= expfull 
Which two are true about the expdp operation? (Choose two.)

  • A: It creates a dump file for the entire database.
  • B: It fails if the total size of the dump file is more than 2 GB.
  • C: It creates a dump file only for objects in the SYSTEM schema.
  • D: It creates a master table to store details of the export operation.
  • E: It starts only when four worker processes are available.



Question 7
Which two are true about RETENTION GUARANTEE? (Choose two.)

  • A: It is a tablespace attribute.
  • B: It prevents FLASHBACK DATABASE operation failure.
  • C: It prevents out-of-space errors.
  • D: It prevents “Snapshot too old” errors.
  • E: It is a static parameter.



Question 8
Which two can you use to recover a dropped table? (Choose two.)

  • A: FLASHBACK QUERY
  • B: FLASHBACK DATABASE
  • C: FLASHBACK TRANSACTION
  • D: FLASHBACK TABLE TO SCN
  • E: FLASHBACK DROP



Question 9
orcl.dmp contains a full export of the ORCL database. 
This command is executed to load data from orcl.dmp into the TESTDB database:
[[email protected] ~] impdp system/oracle \ 
> SHEMAS=sh,oe \ 
> REMAP_SCHEMA=sh:hr \
> DUMPFILE=orcl.dmp \ 
> EXCLUDE=index \ 
> TABLE_EXISTS_ACTION=replace \ 
> LOGFILE=impdp.log 
Which two are true? (Choose two.)

  • A: It skips only tables that exist in both ORCL:SH and TESTDB:HR.
  • B: It drops and recreates tables that exist in both ORCL:SH and TESTDB:HR.
  • C: It skips all indexes of ORCL:SH and ORCL:OE.
  • D: It skips only indexes that exist in both ORCL:SH and TESTDB:HR.
  • E: It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.



Question 10
Which is true about roles?

  • A: A role can be granted to other roles.
  • B: Roles can be created only by SYS or SYSTEM.
  • C: Roles containing object privileges can be created only by the object owner.
  • D: All roles belong to the SYSTEM schema.
  • E: A role can be password-protected only if it has been granted system privileges.








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