[Free] 2018(Jan) Dumps4cert Pass4sure Oracle 1z0-050 Dumps with VCE and PDF 101-110

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan Oracle Official New Released 1z0-050
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/1z0-050.html

Oracle Database 11g: New Features for Administrators

Question No: 101

What are the advantages of variable extent size support for large ASM files? (Choose two.)

  1. It improves performance in the extended cluster configuration by reading from a local copy of an extent.

  2. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.

  3. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

  4. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.

Answer: C,D

Question No: 102

Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

  1. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

  2. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.

  3. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

  4. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

Answer: B,D

Question No: 103

View the Exhibit for some of the parameter settings.

Dumps4Cert 2018 PDF and VCE

You start a session and issue the following command:

SQLgt;CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;

What is the outcome of the above command?

  1. The index is not used by the optimizer but is maintained during DML operations.

  2. The index is not used by the optimizer and is not maintained during DML operations.

  3. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.

  4. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.

Answer: A

Question No: 104

Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

  1. Supplemental log must be enabled.

  2. Supplemental log must be enabled for the primary key

  3. Undo retention guarantee for the database must be configured.

  4. Execute permission on the DBMS_FLASHBACK package must be granted to the user.

Answer: A,B,D

Question No: 105

View the Exhibits exhibit1 and exhibit2.

Dumps4Cert 2018 PDF and VCE

Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than the process in exhibit2.

What is the reason for this?

  1. It creates less metadata for the jobs.

  2. It creates jobs temporarily in memory only.

  3. It writes the job metadata to disk in compressed format.

  4. It updates several tables in the SYSTEM tablespace instead of creating new tables.

Answer: A

Question No: 106

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)

  1. Its entries are specific to a single database.

  2. It contains file systems that have been mounted by Direct NFS.

  3. It is globally available to all Oracle 11 g databases on the machine.

  4. It contains file systems that have been mounted by the kernel NFS system.

Answer: C,D

Question No: 107

View the Exhibit to observe the error.

Dumps4Cert 2018 PDF and VCE

You receive this error regularly and have to shut down the database instance to overcome

the error. What can the solution be to reduce the chance of this error in future, when implemented?

  1. locking the SGA in memory

  2. automatic memory management

  3. increasing the value of SGA_MAX_SIZE

  4. setting the PRE_PAGE_SGA parameter to TRUE

Answer: B

Question No: 108

You set the following parameters in the parameter file and restarted the database:

MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M

Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)

  1. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

  2. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.

  3. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

  4. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

Answer: A,D

Question No: 109

Examine the following command:

ALTER DISKGROUP data MOUNT FORCE;

In which scenario can you use the above command to mount the disk group?

  1. when ASM disk goes offline

  2. when one or more ASM files are dropped

  3. when some disks in a disk group are offline

  4. when some disks in a failure group for a disk group are rebalancing

Answer: C

Question No: 110

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.

Which statement is true regarding the ACL created?

  1. It is a list of remote database links stored in the XML file that are available to the users of the database.

  2. It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.

  3. It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.

  4. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

Answer: B

100% Dumps4cert Free Download!
Download Free Demo:1z0-050 Demo PDF
100% Dumps4cert Free Guaranteed!
Download 2018 Dumps4cert 1z0-050 Full Exam PDF and VCE

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *