What Approved 1Z0-072 Test Questions Is

NEW QUESTION 1
Which two operations can be performed on external tables? (Choose two.)

• A. creating invisible indexes
• B. creating views
• C. creating partitions
• D. creating public synonyms
• E. executing UPDATE statements

Answer: BD

NEW QUESTION 2
DATADIR1 and DATADIR2 are database directory objects.
Examine this command:
[oracle@host01 ~] 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.

Answer: AE

NEW QUESTION 3
Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)

• A. Only users granted SYSDBA can query or update tables in all user schemas.
• B. Only users granted SYSDBA can take a complete backup of a database.
• C. Users granted either SYSDBA or SYSOPER connect to an instance as SYS.
• D. Users granted either SYSDBA or SYSOPER can mount or open a database.
• E. Only users granted SYSDBA can start up and shut down a database instance.
• F. Users granted either SYSDBA or SYSOPER can query data in all user schemas.

Answer: BC

NEW QUESTION 4
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.

Answer: ADG

NEW QUESTION 5
The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name. Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’;
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

• A. as SCOTT in BOSTON_DB
• B. as SYS in both the databases
• C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• D. as SCOTT in both the databases
• E. as SCOTT in DALLAS_DB

Answer: D

NEW QUESTION 6
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.

Answer: CDF

NEW QUESTION 7
Which is true about the UNLIMITED TABLESPACE SYSTEM privilege?

• A. It can be granted to any user and any role.
• B. It is overridden by any specified user space quota.
• C. It allows a user to have unlimited space in any tablespace in the database.
• D. It allows a user to have unlimited space only in his or her default permanent tablespace.
• E. It can be revoked from a user and replaced with a specific space quota only if no user schema objects exist.

Answer: C

NEW QUESTION 8
Which two are true about instance recovery for a database that is open in read write mode? (Choose two.)

• A. It is guaranteed to complete within fast_start_mttr_target number of seconds.
• B. No users can log on until instance recovery has completed.
• C. Only the CURRENT REDO log group is required to perform instance recovery.
• D. It is always performed when opening a database.
• E. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.
• F. The database opens after the roll forward phase of instance recovery has completed.

Answer: DE

NEW QUESTION 9
In a database, the default temporary tablespace is TEMP and USER1’s default tablespace is DATA. Examine these parameters:

Which tablespace stores UNDO generated by USER1’s DML on temporary tables?

• A. DATA
• B. SYSTEM
• C. SYSAUX
• D. TEMP
• E. UNDOTBS1

Answer: D

NEW QUESTION 10
What two are benefits of Data Pump? (Choose two.)

• A. It can execute in parallel.
• B. It can restart failed export jobs.
• C. It makes use of client system resources.
• D. It can export data into sequential media, such as tapes.
• E. It represents database metadata information as DDL statements in the dump file.

Answer: AB

NEW QUESTION 11
Examine this extract from the show parameters command:


How are SGA and PGA memory managed by an instance using these parameter settings?

• A. SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management.
• B. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management.
• C. SGA and PGA memory are managed by using Automatic Memory Management (AMM).
• D. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed.
• E. SGA and PGA memory are manually managed.

Answer: C

NEW QUESTION 12
Which two functions are performed by a listener?

• A. creating a user session in the System Global Area (SGA)
• B. verifying the service name in an incoming user request
• C. verifying a user’s authentication credentials
• D. maintaining the connection to a client’s user process until the user request is completed
• E. returning the results of processing from the server process to the user process
• F. connecting a user process to a server process

Answer: EF

NEW QUESTION 13
Which two statements are true about Oracle Data Pump? (Choose two.)

• A. expdp and impdp are its client components.
• B. impdp always uses conventional path inserts when importing data.
• C. The DBMS_DATAPUMP package can be used only with Data Pump clients
• D. It cannot be used to export data as of a previous SCN.
• E. impdp can change target data file names, schemas, and tablespaces during import.

Answer: AC

NEW QUESTION 14
EMP_IDX is an index on the EMP.ENO column. EMP and EMP_IDX reside in the TBS1 tablespace. During an INSERT into EMP, you get this error: ERROR at line 1:
ORA-01654: unable to extend index USERS.EMP_IDX BY 8 in tablespace TBS1
Which two actions would you take to correct the space problem in TBS1 without affecting uncommitted transactions on EMP? (Choose two.)

• A. Drop and re-create EMP_IDX.
• B. Coalesce EMP_IDX.
• C. Shrink EMP.
• D. Rebuild EMP_IDX online in a tablespace with sufficient space.
• E. Shrink TBS1.

Answer: AB

NEW QUESTION 15
Which two are true about undo tablespaces? (Choose two.)

• A. They can be recovered only when an instance is in MOUNT state.
• B. They are always owned by SYS.
• C. They must have only one data file.
• D. There can be multiple active undo tablespaces for a single instance database.
• E. SYSDBA users can create objects in them.

Answer: CD

NEW QUESTION 16
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.

Answer: BDE

NEW QUESTION 17
Examine the command: CREATE USER user1 IDENTIFIED BY user123
DEFAULT TEMPORARY TABLESPACE temp
QUOTA 5M ON system PROFILE hr_user PASSWORD EXPIRE;
Which two are true? (Choose two.)

• A. The PASSWORD EXPIRE clause is invalid because passwords are controlled by the HR_USER profile.
• B. USER1 requires a quota to be able to store objects in the default permanent tablespace.
• C. USER1 will be prompted for a new passport at first login.
• D. A quota on the temporary tablespace must be specified to enable USER1 to perform queries and transactions.
• E. USER1’s account is locked.

Answer: BD

NEW QUESTION 18
Which two are prerequisites for shrinking a table online?

• A. It must have a unique key constraint.
• B. It must not have any referential integrity constraints.
• C. It must not have any DML triggers.
• D. It must be in a tablespace that uses Automatic Segment Space Management (ASSM) .
• E. It must have row movement enabled.

Answer: AB

NEW QUESTION 19
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

Answer: AE

NEW QUESTION 20
Examine these commands:


What is the expected result?

• A. It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME.
• B. Only the first row in EMP.DAT is inserted into U1.EMP.
• C. Only the first and fourth rows in EMP.DAT are inserted into U1.EMP.
• D. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.
• E. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows.

Answer: D

NEW QUESTION 21
......