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

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

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;

What is the implication of this command?

  1. The command produces an error because the retention time cannot be reduced.

  2. All historical data older than three years is purged from the flashback archive FLA1.

  3. All historical data is purged and the new flashback data archives are maintained for three years.

  4. All historical data is retained but the subsequent flashback data archives are maintained for only three years.

Answer: B

Question No: 2

What are the recommendations for Oracle Database 11 g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)

  1. ORACLE_BASE should be set explicitly.

  2. An Oracle base should have only one Oracle home created in it.

  3. Flash recovery area and data file location should be on separate disks.

  4. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

Answer: A,C,D

Question No: 3

Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?

  1. It returns space usage of only BasicFile LOB chunks.

  2. It returns space usage of only SecureFile LOB chunks.

  3. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

  4. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

Answer: B

Question No: 4

You are managing an Oracle Database 11 g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.)

  1. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.

  2. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.

  3. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.

  4. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

Answer: A,B,D Explanation:

http://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm#autoId 32

Question No: 5

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:

SQLgt; SELECT substr(component, 0,10) COMP, current_size CS, user_specified_size US

FROM v$memory_dynamic_components WHERE current_size!=0;

Dumps4Cert 2018 PDF and VCE

What do you infer from this?

  1. The database instance is running with manual PGA management.

  2. The database instance is running with manual shared memory management.

  3. The database instance has the MEMORY_TARGET value set to a nonzero value.

  4. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.

Answer: C

Question No: 6

View the Exhibit for some of the current parameter settings.

Dumps4Cert 2018 PDF and VCE

A user logs in to the HR schema and issues the following commands:

SQLgt; CREATE TABLE emp

(empno NUMBER(3), enameVARCHAR2(20), sal NUMBER(8,2));

SQLgt; INSERT INTO emp(empno,ename) VALUES(1 /JAMES#39;);

At this moment, a second user also logs in to the HR schema and issues the following command:

SQLgt; ALTER TABLE emp MODIFY sal NUMBER(10,2);

What happens in the above scenario?

  1. A deadlock is created.

  2. The second user#39;s command executes successfully.

  3. The second user#39;s session immediately produces the resource busy error.

  4. The second user#39;s session waits for a time period before producing the resource busy error.

Answer: D

Question No: 7

Your database initialization parameter file has the following entry: SEC_MAX_FAILED_LOGIN_ATTEMPTS=3

Which statement is true regarding this setting?

  1. It is enforced only if the password profile is enabled for the user.

  2. It locks the user account after the specified number of attempts.

  3. It drops the connection after the specified number of login attempts fail for any user.

  4. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.

Answer: C

Question No: 8

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recover catalog owned by RC011. You also want to deregister them from the catalog after import.

You executed the following commands to achieve this: RMANgt; CONNECT CATALOG rco1 1/password@catdb

RMANgt; IMPORT CATALOG rcat1 0/oracle@inst1 DBID=1423241,1423242;

What happens if the RC011 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?

  1. The scripts in the RC011 catalog are overwritten.

  2. RMAN renames the local stored scripts in the RC011 catalog.

  3. The RMAN session in which the command is executed aborts.

  4. RMAN renames the global scripts that are imported from the RCAT10 catalog.

Answer: D

Question No: 9

You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of l/Os. Which statement describes a solution to the above?

  1. Set a threshold for the default system-defined moving window baseline.

  2. Add directives to the Automatic Database Diagnostic Monitor (ADDM).

  3. Modify the profile for the targeted users for which control needs to be imposed.

  4. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

Answer: D

Question No: 10

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?

  1. Drop the table.

  2. Partition the table

  3. Truncate the table.

  4. Add a column to the table.

  5. Rename a column in the table.

Answer: D

100% Dumps4cert Free Download!
Download Free Demo:1z0-050 Demo PDF
100% Dumps4cert Free Guaranteed!
1z0-050 Dumps

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 *