Oracle 1Z0-072 Online Practice Questions and Exam Preparation

Oracle 1Z0-072 Online Questions & Answers

• Question 71:

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

• Question 72:

  Examine the command:

  

  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.
  B. USER1 requires a quota to be able to store objects in the default permanent tablespace.
  D. A quota on the temporary tablespace must be specified to enable USER1 to perform queries and transactions.

• Question 73:

  Which two are true about incomplete recovery? (Choose two.)

  A. Incremental backups cannot be used to roll forward the database while performing it.
  B. Uncommitted transactions will be rolled back after it completes.
  C. It is possible only when the database is in MOUNT state.
  D. The database must have FLASHBACK enabled in order to perform it.
  E. Only RMAN backupsets can be used to restore a database as part of it.
  D. The database must have FLASHBACK enabled in order to perform it.
  E. Only RMAN backupsets can be used to restore a database as part of it.

• Question 74:

  Which two tasks can you perform by using DBCA for a new database?

  A. Register it with an available Enterprise Manager Management server.
  B. Configure a nonstandard block size.
  C. Configure incremental backups.
  D. Enable flashback.
  E. Create user tablespaces.
  A. Register it with an available Enterprise Manager Management server.
  E. Create user tablespaces.

• Question 75:

  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.
  B. It supports multilingual databases.
  C. It uses less space than other character sets, for all data types.

• Question 76:

  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.
  C. It allows a user to have unlimited space in any tablespace in the database.

• Question 77:

  In your database, you want to create a tablespace of non-standard block size by using this command:

  

  Which is a requirement for this command to succeed?

  A. All other DB_nK_CACHE_SIZE parameters should be set to zero.
  B. The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA.
  C. The value of the DB_CACHE_SIZE parameter should not be 16 KB.
  D. The DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE.
  E. The DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB.
  B. The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA.

• Question 78:

  Which two statements are true about the tablespace SEGMENT SPACE MANAGEMENT clause? (Choose two.)

  A. It applies only to tablespaces with uniform extent size.
  B. It overrides the DEFAULT STORAGE clause specified for a tablespace.
  C. It specifies whether used and free extents are tracked using free lists or bitmaps.
  D. It specifies whether users have direct control over space allocation for the objects in a tablespace.
  E. It applies only to permanent tablespaces.
  F. It applies only to smallfile tablespaces.
  C. It specifies whether used and free extents are tracked using free lists or bitmaps.
  D. It specifies whether users have direct control over space allocation for the objects in a tablespace.

• Question 79:

  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
  A. table partition
  E. table

• Question 80:

  You want to use table compression suitable for OLTP that will:

  1.

  Compress rows for all DML statements on that table

  2.

  Minimize the overheads associated with compression.

  Which compression option is best suited for this?

  A. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
  B. ROW STORE COMPRESS ADVANCED
  C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
  D. ROW STORE COMPRESS BASIC
  E. COLUMN STORE COMPRESS FOR QUERY LOW
  B. ROW STORE COMPRESS ADVANCED