Free Oracle 1Z1-050 Exam Dumps Questions & Answers

Which statement about the enabling of table compression in Oracle Database 11g is true?

• A.  Compression can be enabled only at the table level for both direct loads and conventional DML.
• B.  Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.
• C.  Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
• D.  Compression can be enabled at the table, tablespace, or partition level for direct loads only.

You are managing an Oracle Database 11 g database. You want to take the of size 100 TB on tape drive, but you have tape drives of only 10 GB each, quickly and efficiently?

• A.  parallel image copy backup
• B.  parallel backup with MAXPIECESIZE configured for the channel
• C.  intrafile parallel backup
• D.  backup with MAXPIECESIZE configured for the channel

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

• A.  It can be used to allow the access privilege settings for users but not roles.
• B.  It can be used to allow the access privilege settings for users as well as roles.
• C.  It can be used to selectively restrict a user's access to different applications in a specific host computer.
• D.  It can be used to selectively restrict the access for each user in a database to different host computers.
• E.  It can be used to control the time interval for which the access privilege is available to a user.

To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the EC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:
SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop.10;
What is the significance of this setting?

• A.  It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.
• B.  It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.
• C.  It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.
• D.  It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11 g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:
SQL>@utlrp.sql
What is the significance of executing this script?

• A.  It performs parallel recompilation of only the stored PL/SQL code.
• B.  It performs sequential recompilation of only the stored PL/SQL code.
• C.  It performs sequential recompilation of any stored PL/SQL as well as Java code.
• D.  It performs parallel recompilation of any stored PL/SQL as well as Java code.