[PDF and VCE] Free CertBus Oracle 1Z0-052 VCE and PDF, Exam Materials Instant Download

This dump is 100% valid to pass Oracle 1Z0-052 exam. The only tips is please do not just memorize the questions and answers, you need to get through understanding of it because the question changed a little in the real exam. Follow the instructions in the CertBus 1Z0-052 Oracle Database 11g: Administrator I PDF and VCEs. All CertBus materials will help you pass your Oracle exam successfully.

We CertBus has our own expert team. They selected and published the latest 1Z0-052 preparation materials from Oracle Official Exam-Center: http://www.certgod.com/1Z0-052.html

QUESTION NO:73

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 about these parameters after the database instance is

restarted?

(Choose two.)

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

B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically

set to zero.

C. The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed

manually.

D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are

set to 90 MB and 270 MB, respectively.

Answer: A,D

Explanation:

QUESTION NO:78

Note the following points describing various utilities in Oracle Database 11g:

Which point describes the Oracle Data Pump utility?

1. It enables the transfer of data from one database to another

2. It provides a complete solution for the backup, restoration and recovery needs of the

entire database

3. It enables the loading of data from an external file into tables of an Oracle Database

4. It provides a tape backup management for the Oracle ecosystem

A. 1

B. 2

C. 3

D. 4

E. 1 and 3

F. 1, 2, 3 and 4

Answer: A

Explanation:

QUESTION NO:178

Identify three situations in which you would NOT be able to drop a tablespace. (Choose

three.)

A. when the tablespace is online

B. when the tablespace has segments with data in it

C. when the tablespace is a default permanent tablespace for the database

D. when the tablespace contains a table that is currently being used by transactions

E. when the tablespace contains undo data that is needed to rollback an uncommitted

transaction

Answer: C,D,E

Explanation:

QUESTION NO:80

Your database is configured in shared server mode. However, your senior DBA asks you to

modify the value of the PRIVATE_SGA limit in the profile of the users.

What could be the reason for this?

A. To limit the User Global Area (UGA) memory allocated to a session from the SGA

B. To limit the amount of memory to be used for the dispatcher queue of a session in SGA

C. To limit the amount of memory to be used for the request pool in System Global Area

(SGA)

D. To control the amount of memory allocated in SGA for the local variables for each

shared server process

Answer: A

Explanation:

QUESTION NO:15

Examine the command:

SQL>ALTER USR skd ACCOUNT LOCK;

Which two statements are true after the command is executed? (Choose two.)

A. The SKD user cannot log in to the database instance

B. The objects owned by the SKD user are not accessible to any user

C. The other users can access the objects owned by the SKD user, on which they have

access

D. The password for the SKD user expires and the user is forced to change the password

at the next log in

Answer: A,C

Explanation:

QUESTION NO:7

See the Exhibit:

Which statements are true regarding the USERS tablespace? (Choose all that apply.)

A. A bitmap is used to record free extents

B. Free extents information is managed within the tablespace

C. Free extents information is managed in the SYSAUX tablespace

D. The data dictionary tables are updated when extents are allocated or deallocated

Answer: A,B

Explanation:

QUESTION NO:173

You receive complaints from users regarding the high waiting time for their transactions.

On investigation, you find that some users are not committing their transactions though

they are not performing any activity for a long time. As a result, SQL statements need to

wait for rowlevel locks. Which two actions could you take to prevent this locking problem in

the future? (Choose two.)

A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.

B. Use Database Resource Manager to automatically log out sessions that block others

and are idle

C. Set the limit in the profile of blocking users to control the number of blocks to be

accessed in a session.

D. Decrease the maximum number of interested transaction list (ITL) slots for the segments

on which the blocking user performs the transaction.

Answer: A,B

Explanation:

QUESTION NO:151

You are working on a database that must be functioning 24 hours a day, 7 days a week.

The database is configured in ARCHIVELOG mode.

Which two options do you have for performing user-managed backups? (Choose two.)

A. You can perform consistent backups only.

B. You can perform a complete database backup without shutting down the database

instance.

C. You can back up data files only when all data files have the same SCN recorded in the

control file.

D. You can back up only those data files whose headers are frozen by using ALTER

TABLESPACE BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP commands.

Answer: B,D

Explanation:

QUESTION NO:153

User SCOTT executes the following command on the EMP table but has not issued

COMMIT, ROLLBACK, or any data definition language (DDL) command:

SQL> SELECT ename FROM emp

2 WHERE job=’CLERK’ FOR UPDATE OF empno;

SCOTT has opened another session to work with the database instance.

Which three operations would wait when issued in SCOTT’s second session? (Choose

three.)

A. LOCK TABLE emp IN SHARE MODE;

B. LOCK TABLE emp IN EXCLUSIVE MODE;

C. UPDATE emp SET sal=sal*1.2 WHERE job=’MANAGER’

D. INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);

E. SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

Answer: A,B,E

Explanation:

QUESTION NO:162

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the

user SCOTT has started a query on a large table in the peak transactional hour that

performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives

the following error:

ORA-01555: snapshot too old

What could be the reason for this error?

Exhibit:

A. The query is unable to get a read-consistent image.

B. There is not enough space in Flash Recovery Area.

C. There is not enough free space in the flashback archive.

D. The query is unable to place data blocks in undo tablespace.

Answer: A

Explanation:

The ORA-01555 is caused by Oracle read consistency mechanism. If you have a long

running SQL that starts at 10:30 AM, Oracle ensures that all rows are as they appeared at

10:30 AM, even if the query runs until noon! Oracles does this by reading the “before

image” of changed rows from the online undo segments. If you have lots of updates, long

running SQL and too small UNDO, the ORA-01555 error will appear.

CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 1Z0-052 exam successfully with our Oracle materials. CertBus Oracle Database 11g: Administrator I exam PDF and VCE are the latest and most accurate. We have the best Oracle in our team to make sure CertBus Oracle Database 11g: Administrator I exam questions and answers are the most valid. CertBus exam Oracle Database 11g: Administrator I exam dumps will help you to be the Oracle specialist, clear your 1Z0-052 exam and get the final success.

1Z0-052 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1maWlwamtrRlhpLTQ/view?usp=sharing

1Z0-052 Oracle exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/1Z0-052.html [100% Exam Pass Guaranteed]

Why select/choose CertBus?

Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.

Brand	Certbus	Testking	Pass4sure	Actualtests	Others
Price	$45.99	$124.99	$125.99	$189	$69.99-99.99
Up-to-Date Dumps
Free 365 Days Update
Real Questions
Printable PDF
Test Engine
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back
Secure Payment
Privacy Protection