Our pass rate is high to 98.9% and the similarity percentage between our oracle database 11g administration i 1z0 052 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Oracle 1z0 052 pdf exam in just one try? I am currently studying for the Oracle oracle database 11g administration i 1z0 052 exam. Latest Oracle 1z0 052 dumps Test exam practice questions and answers, Try Oracle 1z0 052 dumps Brain Dumps First.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-052 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q61. 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.
Q62. Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What affect would this command have on the database?
A. The extents in the undo tablespace retain data until the next full database backup
B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes
C. The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down
D. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten
Q63. The database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
OS_ROLES = FALSE
REMOTE_OS_AUTHENT = FALSE
REMOTE_OS_ROLES = FALSE
TIMED_OS_STATISTICS = 0
You have a local operating system user SKD. You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has the CREATE SESSION privilege.
What would you achieve by the above process?
A. The database user OPS$SKD will be able to administer the database.
B. The authentication detail for the database user OPS$SKD is recorded in the password file.
C. The local operating system user SKD will be able to access the database instance without specifying the username and password.
D. The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
Q64. Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)
A. It can be increased up to the value of the SGA_MAX_SIZE parameter.
B. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.
C. Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and manually sized components.
D. Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.
Q65. Which two statements are true about alerts? (Choose two.)
A. Clearing an alert sends the alert to the alert history
B. Response actions cannot be specified with server-generated alerts
C. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view
D. Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified
Q66. View the Exhibit and examine the privileges granted to the SL_REP user.
The EMP table is owned by the SCOTT user. The SL_REP user executes the following command:
SQL> GRANT SELECT ON scott.emp TO hr;
Which statement describes the outcome of the command?
A. The command executes successfully
B. The command produces an error because the EMP table is owned by SCOTT
C. The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION
D. The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table
Q67. In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
A. Apply fine-grained auditing.
B. Implement value-based auditing.
C. Impose standard database auditing to audit object privileges.
D. Impose standard database auditing to audit SQL statements.
Q68. View the Exhibit and examine the user information.
The user has been granted CONNECT and RESOURCE roles and no individual system privileges.
The SL_REP user executes this command to create a table:
SQL> CREATE TABLE orders (
) TABLESPACE purchase_space;
The PURCHASE_SPACE tablespace already exists in the database.
Which statement describes the effect of the command?
A. The command executes successfully and creates the table in the USERS tablespace.
B. The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
C. The command produces an error because the user does not have the privilege to createthe table.
D. The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.
Q69. You executed the following command to create a tablespace called SALES_DATA:
SQL> CREATE TABLESPACE sales_data
DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES_DATA tablespace? (Choose two)
A. The database automatically determines the extent-sizing policy for the tablespace.
B. The segments are automatically shrunk when the contents are removed from them.
C. The allocation of extents within the tablespace is managed through the dictionary tables.
D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E. The space utilization description of the data blocks in segments is managed through free lists.
Q70. You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape:
Which two statements are true about differential incremental backups? (Choose two.)
A. The backup performed on Sundays contains all the blocks that have ever been used in the database
B. The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup
C. The backup performed on each working day contains all the blocks that have changed since the last level 0 backup
D. The backup performed on Monday contains all the blocks that have changed since the level 0 backup and every other working day contains all the blocks that have changed since the level 1 backup