Real of 1Z0-052 book materials and tutorials for Oracle certification for IT specialist, Real Success Guaranteed with Updated 1Z0-052 pdf dumps vce Materials. 100% PASS Oracle Database 11g: Administration I exam Today!

2021 Dec 1Z0-052 practice test

Q41. Note the following functionalities of various background processes:

1. Record the checkpoint information in data file headers.

2. Perform recovery at instance startup.

3. Cleanup unused temporary segments.

4. Free the resources used by a user process when it fails.

5. Dynamically register database services with listeners.

6. Monitor sessions for idle session timeout.

Which option has the correct functionalities listed for a background process?

A. Archiver Process (ARCn): 1, 2, 5

B. System Monitor Process (SMON): 1, 4, 5

C. Process Monitor Process (PMON): 4, 5, 6

D. Database Writer Process (DBWn): 1, 3, 4

Answer: C


Q42. In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)

A. if a table is not in a cluster

B. if a table has an active trigger

C. if a table has an encrypted column

D. if a table has a column of data type LONG defined on it

E. if a table has a referential integrity constraint defined on it

Answer: BCE


Q43. You have an ORDERS table with the following structure:

The table has data in the ODATE column for all rows. Many orders are placed in a single day. You need to ensure that the ODATE column must contain data for every order in future.

Which method would serve the purpose?

A. Modify the column using the ALTER TABLE ... MODIFY command.

B. Add a UNIQUE constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.

C. Add a NOT NULL constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.

D. Add a PRIMARY KEY constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.

Answer: A


Q44. Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

A. Failure when no standby database is configured

B. Failure because a data file is renamed accidentally

C. Failure that requires no archive logs to be applied for recovery

D. Failure due to loss of connectivity-for example, an unplugged disk cable

Answer: BD


Q45. The user HR receives the following error while inserting data into the TTK table:

ERROR at line 1:

ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD

Upon investigation, you find that SMD is a small file tablespace.

Which three action would allow the user to insert data? (Choose three.)

A. Add a data file to the SMD tablespace.

B. Add a data file to the temporary tablespace associated with the user HR.

C. Resize the data file associated with the SMD tablespace to make it larger.

D. Alter the data file associated with the SMD tablespace to grow automatically.

E. Change the segment space management for the SMD tablespace to automatic.

Answer: ACD


Improve 1Z0-052 practice test:

Q46. You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.

View the Exhibit to examine the commands used to create tables.

Which action would you take to delay the referential integrity checking until the end of the transaction?

Exhibit:

A. Set the constraint to deferred before starting the transaction

B. Alter the constraint to NOVALIDATE state before starting the transaction

C. Enable the resumable mode for the session before starting the transaction

D. Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction

Answer: A


Q47. Which two statements are true regarding Oracle Data Pump? (Choose two.)

A. EXPDP and IMPDP are the client components of Oracle Data Pump

B. DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clients

C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege

D. Oracle Data Pump imports can be done from the export files generated in the Original Export Release 9.x

E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands

Answer: AB


Q48. In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.

What is the impact of this setting?

A. Optimizer statistics are collected automatically.

B. Only timed operating system (OS) statistics and plan execution statistics are collected.

C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.

D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.

E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

Answer: C


Q49. 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


Q50. Which two operations can be performed on an external table? (Choose two.)

A. Create a view on the table

B. Create an index on the table

C. Create a synonym on the table

D. Add a virtual column to the table

E. Update the table using the UPDATE statement

F. Delete rows in the table using the DELETE command

Answer: AC