Free Oracle 1Z1-052 Exam Dumps Questions & Answers

Which two can be exported by a non-administrative account by using Data Pump? (Choose two.)

• A.  database
• B.  tables
• C.  schemas
• D.  tablespaces
• E.  directory objects

Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users to work with the database simultaneously. Some users of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. As a DBA, which configuration would you set to support more than 1,500 connections at a time?

• A.  You would configure the database in shared server mode to use the connection pooling feature.
• B.  You would configure more listeners for the database.
• C.  You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
• D.  You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

View the Exhibit and examine the setting for a table.

Which statement is true about the PCTFREE setting for the table?

• A.  It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
• B.  It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
• C.  It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.
• D.  It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.

View the Exhibit. What would happen if Oracle Home is not empty?

• A.  The installation terminates automatically after showing an error message.
• B.  The installation can be continued, but the existing files will be overwritten.
• C.  The installation will proceed without overwriting the existing files.
• D.  The installation will not be continued until the location is empty.

Where is backup metadata stored for use by Recovery Manager (RMAN)?

• A.  in the diagnostic destination files
• B.  in the SYSTEM tablespace
• C.  in the SYSAUX tablespace
• D.  in the control file
• E.  in the SPFILE