Exambible senior Oracle professors as well as specialists can say yes to in which Exambible Oracle 1Z0-052 test questions are usually almost correct. The move price associated with Oracle Database 11g: Administration I was almost 95 %. Previously mentioned al, we could demonstrate the 1Z0-052 examine materials created valuable research regarding Oracle candidates. The 1Z0-052 pdf file worth the examinees sparing without trying to study. It is possible to bet the shoe youll have a positive result from the Exambible Oracle Database 11g: Administration I apply assessments.

2016 Jun 1Z0-052 exam question

Q41. User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the following error after the INSERT statement is issued and few rows are inserted:

INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)

*

ERROR at line 1:

ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS

Identify two actions either of which will help you resolve this problem. (Choose two.)

A. Grant the RESOURCE role to SCOTT.

B. Add data files to the USERS tablespace.

C. Grant the CREATE ANY TABLE privilege to SCOTT.

D. Increase the space for SCOTT on the USERS tablespace.

E. Increase the size of the data file associated with the USERS tablespace.

Answer: BE


Q42. Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.

What would you do to recover the data file?

A. Take the USERS tablespace offline and re-create the lost data file

B. Shutdown the instance, restore the data file from the last consistent backup and restart the database instance

C. Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance

D. Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup and make the tablespace online

Answer: C


Q43. You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database.

Which is the most effective method to access this data in your database?

A. Use the database link.

B. Use the SQL*Loader utility.

C. Use the Oracle Data Pump utility.

D. Create an external table and leave the data in the flat file.

Answer: D


Q44. What can you achieve by implementing reverse key index?

A. Reverse the bytes of each column indexed including the row ID

B. Store a bitmap for each key value instead of a list of row IDs in the leaf node

C. Prevent contention on the highest leaf block when using sequences to generate keys

D. Remove repeated key values from the index to fit more index entries in a given amount of disk space

Answer: C


Q45. You executed the following command to perform a backup of the USERS tablespace:

SQL> ALTER TABLESPACE users BEGIN BACKUP;

ALTER TABLESPACE users BEGIN BACKUP

*

ERROR at line 1:

ORA-01123: cannot start online backup; media recovery not enabled

What could be the reason for this error?

A. The MTTR Advisor is disabled.

B. The database is in NOARCHIVELOG mode.

C. The tablespace is already in backup mode.

D. The Flash Recovery Area is not configured.

Answer: B


certifyforall.com

Up to date 1z0-052 practice test:

Q46. The instance abnormally terminates because of a power outage.

Which statement is true about redo log files during instance recovery?

A. Inactive and current redo log files are required to accomplish recovery

B. Online and archived redo files are required to accomplish instance recovery

C. All redo log entries after the last checkpoint are applied from redo log files to data files

D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

Answer: C


Q47. In a new installation of Oracle Database 11g, you perform these activities:

1. Organize software and data on different subdirectories to avoid poor performance.

2. Use consistent naming conventions for database files.

3. Separate administrative information pertaining to the database in different directories.

Which option corresponds to the type of activities you performed?

A. Oracle Managed Files

B. Oracle Grid Architecture

C. Optimal Flexible Architecture

D. Oracle database architecture

E. Automatic Storage Management

Answer: C


Q48. You executed this command to create a temporary table:

SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (

startdate DATE,

enddate DATE,

class CHAR(20)

) ON COMMIT PRESERVE ROWS;

Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?

A. The rows stay in the table only until session termination

B. The rows stay in the table only until the next transaction starts on the table

C. The rows are visible to all current sessions after the transaction in committed

D. The rows stay available for subsequent sessions after the transaction is committed

Answer: A


Q49. In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:

1. The user account must be locked after four unsuccessful login attempts.

2. The user must be prompted to change the password at regular intervals.

3. The user may not have more than three simultaneous sessions.

4. The user session must automatically be logged off if more than 10 minutes elapsed time used.

How would you accomplish the above?

A. By assigning profiles for the users

B. By implementing Fine-Grained Auditing (FGA)

C. By granting a secure application role to the users

D. By implementing the Database Resource Manager plan

Answer: A


Q50. Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the performance of the database in the future.

What action would you take to achieve this task?

A. Insert finding directives for ADDM tasks in the future.

B. Create a baseline on a pair of snapshots spanning the peak-load period.

C. Decrease the snapshot interval in the AWR to collect more snapshots during the peakload period.

D. Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.

Answer: B