Want to know Testking 1Z0-053 Exam practice test features? Want to lear more about Oracle Oracle Database 11g: Administration II certification experience? Study Real Oracle 1Z0-053 answers to Improved 1Z0-053 questions at Testking. Gat a success with an absolute guarantee to pass Oracle 1Z0-053 (Oracle Database 11g: Administration II) test on your first attempt.
2021 Jun 1z0-053 free dumps:
Q31. Examine the following command that is used to duplicate a database on the same host:
ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; }
Which two statements describe the effect after the database is duplicated successfully? (Choose two)
A. The data files of the read-only tablespaces in the target database are not duplicated
B. The read-only tablespaces in the target database are still defined in new the database
C. The read-only tablespaces in the target database are changed to online after duplication
D. The data files of the read-only tablespaces in the target database get duplicated
E. The read-only tablespaces in the target database are not defined in the new database
Q32. While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database.
The options that can be considered while moving the recovery catalog are as follows:
1. Using one of the Oracle expdp utilities to export the catalog data
2. Creating a recovery catalog user and granting the necessary privileges in the other database
3. Creating the recovery catalog using the CREATE CATALOG command
4. Using the corresponding impdp utility to import the catalog data into the other database
5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.
A. 2, 3, 5
B. 1, 2, 4
C. 1, 2, 4, 5
D. 1, 2, 3, 4, 5
Q33. You opened the encryption wallet and then issued the following command:
SQL>CREATE TABLESPACE securespace
ENCRYPTION USING '3DES168'
Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome?
A. It creates the table and encrypts the data in it.
B. It generates an error because the wallet is closed.
C. It creates the table but does not encrypt the data in it.
D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
Q34. Which command creates an image copy?
A. backup as copy
B. backup copy
C. copy as backup
D. copy back
Q35. Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?
A. The database must be running in ARCHIVELOG mode.
B. No special setup is required, and the feature is enabled by default.
C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
D. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
Renewal 1z0-053 exam questions:
Q36. 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.)
A. Its entries are specific to a single database.
B. It contains file systems that have been mounted by Direct NFS.
C. It is globally available to all Oracle 11g databases on the machine.
D. It contains file systems that have been mounted by the kernel NFS system.
Q37. Which method could be utilized to identify both DML operations and the SQL statements needed to undo those operations for a specific schema owner? (Choose all that apply.)
A. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.
Limit rows by START_SCN and TABLE_OWNER.
B. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_SCN and TABLE_OWNER.
C. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_TIMESTAMP and TABLE_OWNER.
D. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.
Limit rows by START_SCN and TABLE_OWNER.
Q38. Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN (choose all that apply)
A. Limiting the input/output (I/O) bandwidth consumption
B. Specifying the size of backup sets and backup pieces
C. Specifying vendor-specific information for a media manager
D. Specifying the parallelism for backup and restore operations
Q39. Which background process coordinates the rebalance activity for disk groups?
Q40. The user SYS creates a job by using the following command:
Which two statements are true about the job that was created by the preceding command? (Choose two.)
A. The job is enabled by default after creation
B. The job is automatically dropped after the end date
C. The job executes with the privileges of the user SYS
D. The globalization environment that exists at the time of the job creation prevails at the job runs
see more 1Z0-053 dumps