Pass4sure offers free demo for 1Z0-053 exam. "Oracle Database 11g: Administration II", also known as 1Z0-053 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1Z0-053 exam, will help you answer those questions. The 1Z0-053 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1Z0-053 exams and revised by experts!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-053 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q251. 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
Q252. Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER,
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?
A. The LOB values are automatically compressed.
B. The LOB values are cached by default in the buffer cache.
C. The LOB values are automatically stored in encrypted mode.
D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
Q253. Which statement about the enabling of table compression in Oracle Database 11g is true?
A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.
B. Compression can be enabled only at the table 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 both direct loads and conventional DML.
Q254. Which two statements are true about a job chain? (Choose two.)
A. A job chain can contain a nested chain of jobs.
B. The jobs in a job chain cannot have more than one dependency.
C. A job of the CHAIN type can be run using event-based or time-based schedules.
D. The jobs in a job chain can be executed only by using the events generated by the Scheduler
Q255. For which two situations would you use functionality provided by the Resource Manager? (Choose two.)
A. setting idle timeout limits on resource plans
B. saving storage space by using compressed backup sets
C. creating jobs that will run automatically at a scheduled time
D. assigning priorities to jobs to manage access to system resources
E. creating alerts to perform notification when tablespaces are low on available space resources
Q256. You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?
a. Shut down the database.
b. Restore a control-file copy from backup media.
c. Use the create control file command to create a new control file.
d. Copy the backup control file into place.
e. Create a new copy of the control file from one of the surviving control files.
f. Recover the database using the recover database using backup controlfile command.
g. Start up the database.
A. a, b, f, g
B. c, f, g
C. a, d, f, g
D. a, f, g
E. a, e, g
Q257. In your production database, you:
- Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals
Set the control file autobackup to "on"
- Are maintaining image copies of the database files
You have lost the server parameter tile (SPFILE) and the control file. Which option must you consider before restoring the SPFILI: and the control file by using the control file autobackup?
A. setting DBID for the database
B. using the RMAN SWITCH command
C. using the RMAN SWITCH command
D. starting up the database Instance In the NOMOUNT state
Q258. Which of the following restrictions are not true with respect to tablespace point-in-time recovery? (Choose all that apply.)
A. The target database must be in NOARCHIVELOG mode.
B. No backup is required of the database before you perform a TSPITR.
C. You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
D. If you rename a tablespace, you can not perform a TSPITR to any point in time before that rename operation occurred.
E. If you have tables in tablespace_1 that have associated constraints in tablespace_2, then you must transport both tablespaces.
Q259. Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?
A. Workload capture is per instance.
B. You only need to restart one instance to begin workload capture.
C. Specifically in RAC, you shut down all instances, restart them individually, and begin workload capture with the last instance started.
D. RAC does not support workload capture, but it does support workload replay.
E. None of the above.
Q260. Evaluate the following block of code:
acl => 'mycompany-com-permissions.xml',
principal => 'ACCT_MGR',
is_grant => TRUE,
privilege => 'connect');
acl => 'mycompany-com-permissions.xml',
host => '*.mycompany.com');
What is the outcome of the above code?
A. It produces an error because a fully qualified host name needs to be specified.
B. It produces an error because the range of ports associated with the hosts has not been specified.
C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.