Advanced Guide: oracle database 11g dba 1 1z0-053

It is impossible to pass Oracle 1Z0-053 exam without any help in the short term. Come to {brand} soon and find the most advanced, correct and guaranteed Oracle 1Z0-053 practice questions. You will get a surprising result by our Renewal Oracle Database 11g: Administration II practice guides.

2016 Sep 1Z0-053 Study Guide Questions:

Q51. Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

A. ALTER DISKGROUP misc MOUNT;

B. ALTER DISKGROUP misc DROP DISK misc2;

C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;

D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;

E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

Answer: AC

Q52. Which three elements can a job chain process involve? (Choose three)

A. an event

B. a schedule

C. a program

D. another chain

E. a lightweight job

Answer: BDE

Q53. In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.

Which method must you use to recover the lost data?

A. Complete Recovery with online redo log

B. Complete Recovery with archived redo log

C. Tablespace Point-in-Time Recovery (TSPITR)

D. Incomplete Recovery with system change number (SCN)

Answer: C

1Z0-053  exam engine

Replace 1z0-053 pdf free download:

Q54. Note the output of the following query;

SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve;

FLASHBACK_ARCHIEVE_NAME STATUS

—————————————- ———–

FLA1

You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:

ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;

What is the outcome of this command?

A. The table uses the default Flashback Data Archive.

B. The Flashback Data Archive Is created In the SYSAUX tablespace.

C. The Flashback Data Archive is created in the same tablespace where the tables are stored.

D. The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

Answer: A

Q55. What two are the prerequisites for enabling Flashback Database? (Choose two)

A. The database must be in ARCHIVELOG mode

B. The database must be in MOUNT EXCLUSIVE mode

C. The database must be opened in RESTRICTED mode

D. The database instance must be started in the NOMOUNT state

E. The database instance must have the keep buffer pool defined

Answer: AB

Q56. Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)

A. Generate reports on data failure such as data file failures.

B. You can track the Service Request (SR) and implement repairs.

C. You can package and upload diagnostic data to Oracle Support.

D. You can manually run health checks to gather diagnostic data for a problem.

Answer: BCD

certleader.com

Pinpoint 1z0-053 itpub:

Q57. Which of the following datatypes store time-zone information in the database? 

A. TIMESTAMP

B. DATE

C. TIMESTAMP WITH TIME ZONE

D. TIMESTAMP WITH LOCAL TIME ZONE

E. DATETIME

Answer: C

Q58. Your archive-log destination directory runs out of space. What is the impact of this on the database?

A. None. The database will switch over to the stand-by archive-log destination directory.

B. A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.

C. The database will shut down, and will not restart until you correct the out-of-space situation.

D. The database will continue to try to write to the archive-log destination directory for one hour.

After one hour, the database will shut down normally.

E. Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.

Answer: E

Q59. Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they don't want you to shut down the database to perform the backup. What options are available to you?

A. Put the database in hot backup mode and perform an online backup, including backing up the archived redo logs.

B. Just back up the database datafiles without shutting down the database.

C. You will have to wait until you can shut down the database to perform the backup.

D. Mark each datafile as backup in progress, back them up individually, and then mark them as backup not in progress. No archived redo logs will need to be backed up.

E. Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing, you can shut down the database and back up the datafiles the user changed during the course of the remaining backup

Answer: C

Q60. Which of the following statements are true about the BACKUP command? (Choose all that apply.)

A. The BACKUP command can not be used to make image copies of a datafile.

B. The BACKUP command can improve performance by multiplexing backup files.

C. The BACKUP can take advantage of the block-change tracking capability.

D. The BACKUP command cannot store data in incremental backups.

E. The BACKUP command can store data in cumulative incremental backups only.

Answer: BC

About 1Z0-053 Information: 1Z0-053 Dumps

Certleader Dumps
Certleader is a company specialized on providing high quality IT exam materials and fully committed to assist our respected clients crack any IT certification tests on their 1st efforts.