Free Oracle 1Z0-072 Exam Dumps Questions & Answers

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

Which is always true about privileges?

• A.  Connections as SYSTEM can use only the SYSOPER privilege.
• B.  The owner of a schema is granted all object privileges within the schema by default.
• C.  System privileges can be granted only to users.
• D.  The SYSDBA privilege can be granted to a user or role.
• E.  Connections as SYS must be made using the SYSDBA privilege

Yom database is in ARCHIEVELOG mode. The USER)! tablespace is online in read write and no error conditions exists for any of its data files.
You want to take USER01 offline so that all existing transactions involving objects in it can complete. What must yon do?

• A.  Change its state to read only, and then take it offline with the immediate option.
• B.  Change its state to read only, and then take it offline with the temporary option.
• C.  Change its state to read only, and then take it offline with the normal option.
• D.  Take it offline with the immediate option.
• E.  Take it offline with the temporary option.
• F.  Take it offline with the normal option.

As the DBA, you execute this command:
GRANT SELECT ON hr.emp TO brown WITH GRANT OPTION;
BROWN then executes this command:
GRANT SELECT ON hr.emp TO scott WITH GRANT OPTION;
Which is true?

• A.  You can revoke only WITH GRANT OPTION from BROWN.
• B.  When you revoke the SELECT privilege from BROWN, it is automatically revoked from SCOTT.
• C.  When you revoke the SELECT privilege from BROWN, only the WITH GRANT OPTION is revoked from SCOTT.
• D.  When you revoke the SELECT privilege from BROWN, nothing is revoked from SCOTT.
• E.  BROWN can revoke only WITH GRANT OPTION from SCOTT.

Which two are true about Oracle Database Cloud Service (DBCS)? (Choose two.)

• A.  Third-party tools can be used with database instances in the cloud.
• B.  Database instances in the cloud can be accessed only by using Oracle*Net.
• C.  DBCS only creates compute nodes; the Oracle Database software must be installed and the database created.
• D.  Oracle-supplied tools can be used with database instances in the cloud.
• E.  Database instances in the cloud can be accessed only by using SSH.