Free Oracle 1z1-072 Exam Dumps Questions & Answers

Which is true about unexpired undo?

• A.  It is required when a transaction rolls back.
• B.  It may be used to support flashback queries.
• C.  It is the first type of undo overwritten when trying to avoid out-of-space errors.
• D.  It consists of undo only for uncommitted transactions.
• E.  It is always retained for the time specified in UNDO__RETENTION.

Which action helps in applying the principle of least privilege?

• A.  setting the O7_DICTIONARY_ACCESSIBILITY parameter to true
• B.  setting the REMOTE_OS_AUTHENT parameter to true
• C.  restricting access to directory objects in the database
• D.  revoking all system privileges from the SYSTEM user
• E.  disabling audit for users with system privileges

Which two are true about the roles? (Choose two.)

• A.  A role must be disabled before it can be revoked from a user.
• B.  The SET ROLE statement enables as well as disables roles in a session.
• C.  All privileges and roles granted to a user are enabled by default when the user logs in.
• D.  The SET ROLE statement can be used once per session.
• E.  The ALTER USER statement must be used to set specific default roles for a user.

You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

• A.  It is offline by default.
• B.  DML operations performed on objects in this tablespace are not logged by default.
• C.  The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.
• D.  It is read-only by default.
• E.  It uses the default blocksize used at database creation.
• F.  It is a locally managed tablespace.

In your database, you want to create a tablespace of non-standard block size by using this command:
CREATE TABLESPACE ns_tbs
DATAFILE '/u01oracle/data/nstbs_f01.dbf' SIZE 100M
BLOCKSIZE 16K;
Which is a requirement for this command to succeed?

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