Oracle Oracle Certifications 1Z0-072 Questions & Answers

• Question 51:

  Which two tasks can be performed in the NOMOUNT state? (Choose two.)

  A. re-creating control files

  B. full database recovery

  C. enabling online redo log archiving

  D. renaming data files

  E. creating a database

  Correct Answer: AE

  Reference: https://books.google.com.pk/books?id=82Vbdt-nZAgCandpg=PA111andlpg=PA111anddq=oracle +tasks+can+be+performed+in+the+NOMOUNT +stateandsource=blandots=24tpIWNn0vandsig=ACfU3U39HP0usj4np24T_bi0d1J8AK8yQwandhl=enandsa=Xandredir_ esc=y#v=onepageandq=oracle%20tasks%20can%20be%20performed%20in%20the%20NOMOUNT% 20stateandf=false

• Question 52:

  Which two are true about the AL32UTF8 character set? (Choose two.)

  A. It is used to encode data for columns of any data type.

  B. It supports multilingual databases.

  C. It uses less space than other character sets, for all data types.

  D. It is used to store PL/SQL source code.

  E. It improves the I/O performance of a database compared to other character sets.

  Correct Answer: BC

  Reference: https://docs.oracle.com/database/121/NLSPG/ch6unicode.htm#NLSPG316

• Question 53:

  Which three types of files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

  A. control files

  B. bad files

  C. input files

  D. password files

  E. server parameter files (SPFILE)

  F. dump files

  Correct Answer: BCD

• Question 54:

  Which three are true about Oracle Database backup taken with RMAN?

  A. A whole backup contains all data blocks of all data files.

  B. RMAN cannot backup REDO logs.

  C. A full backup contains all data blocks from one or more data files.

  D. An RMAN image copy can be written only to disk.

  E. Only offline backup are consistent.

  F. RMAN always includes the control file in a backup.

  Correct Answer: CDF

• Question 55:

  In the ORCL database, UNDOTBS1 is the active undo tablespace with a fixed size of 70 MB and RETENTION GUARANTEE.

  UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on.

  Which statement is true about a transaction if UNDOTBS1 fills with uncommitted undo within 10 minutes of the transaction's first update?

  A. It succeeds and the generated undo is stored in SYSAUX.

  B. It succeeds and the generated undo is stored in TEMP.

  C. It fails and returns the error message "Snapshot too old".

  D. It succeeds and the generated undo is stored in SYSTEM.

  E. It fails and returns the error message "ORA=30036": unable to extend segment by 8 in undo tablespace `UNDOTBS1'".

  F. It succeeds and the least recently used undo block UNDOTBS1 is overwritten by the generated undo.

  Correct Answer: F

• Question 56:

  Which two are segment types? (Choose two.)

  A. table partition

  B. materialized views on a prebuilt container

  C. stored procedure

  D. sequence

  E. table

  F. view

  Correct Answer: AE

  Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html

• Question 57:

  Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?

  A. VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.

  B. VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.

  C. VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.

  D. VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.

  E. VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.

  Correct Answer: DE

• Question 58:

  Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value.

  Which three actions could help in handling a large number of concurrent users?

  A. using Automatic SGA Memory Management (ASMM)

  B. setting the LARGE_POOL_SIZE parameter to a non-zero value

  C. increasing the size of the PGA

  D. setting the SHARED_POOL_SIZE parameter to a non-zero value

  E. increasing the number of dispatchers

  Correct Answer: BCD

• Question 59:

  Which three statements are true about an spfile? (Choose three)

  A. It contains only static initialization parameters.

  B. It is the first file processed at instance startup.

  C. It can be edited by SYS when the database instance is shut down.

  D. It must exist for a database instance to start.

  E. It can be used to create a pfile.

  F. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.

  Correct Answer: DEF

  Reference: https://oracle-base.com/articles/9i/persistent-initialization-parameters

• Question 60:

  Which three actions are required to manually upgrade a database to Oracle Database 12c Release 2? (Choose three.)

  A. Run the Pre-Upgrade information tool on the source database.

  B. Take all user tablespaces offline before starting the upgrade.

  C. Copy the network configuration files from the existing database home to the new Oracle home location.

  D. Run the Parallel Upgrade utility from the new Oracle home.

  E. Run Oracle Net Configuration Assistant (NETCA) to configure the listening protocol address and service information for the new release of Oracle Database.

  F. Make all user tablespaces "read only" before starting the upgrade.

  G. Start the existing database in upgrade mode.

  Correct Answer: ADG

  Reference: https://oracle-base.com/articles/12c/upgrading-to-12c#manual-upgrades