Latest Oracle 1Z1-052 Actual Free Exam Questions & Community Discussion, Page 2

Question #15

The tnsnames.ora file has an entry for the service alias ORCL as follows:
ORCL
( DESCRIPTION
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))
(CONNECT_DATA
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oracle.com)
)
)
The TNSPING command executes successfully when tested with ORCL, but you are not able to connect to the database instance with the following command:
SQL> CONNECT scott/tiger@orcl
What could be the reason for this?

A. The orcl.oracle.com database service is not registered with the listener.

B. The TNS_ADMIN environmental variable is set to a wrong value.

C. The listener is not running on the database node.

D. The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.

Discussion 0

Correct Answer: A Vote an answer

Question #16

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?

A. The DBA has to perform the recovery on the database to recover the uncommitted transaction

B. The uncommitted transaction will be committed at the next startup of the database instance

C. The online redo log files and archived redo log files are required to accomplish the recovery

D. The uncommitted transaction is rolled back automatically at the next opening of the database

Discussion 0

Correct Answer: D Vote an answer

Question #17

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?

A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT

B. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

C. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully

D. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

E. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

Discussion 0

Correct Answer: B Vote an answer

Question #18

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 data in the undo tablespace are not overwritten until the instance is shut down

C. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten

D. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes

Discussion 0

Correct Answer: D Vote an answer

Question #19

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 space utilization description of the data blocks in segments is managed through free lists.

C. The allocation of extents within the tablespace is managed through the dictionary tables.

D. The segments are automatically shrunk when the contents are removed from them.

E. The space utilization description of the data blocks in segments is recorded in bitmap blocks.

Discussion 0

Correct Answer: A,E Vote an answer

Question #20

Which two are true about server-generated alerts? (Choose two.)

A. By default, a server-generated alert is raised for each tablespace that has 85 % or more of its space used.

B. Stateful alerts are preserved across instance restarts.

C. Stateless alerts can be found in DBA_OUTSTANDING_ALERTS.

D. They are automatically written to alert.log.

E. By default, an email is sent by the database instance for each server-generated alert.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #21

Which statement is true regarding undo tablespace?

A. Undo tablespace can consist of only one data file that is reused in a cyclic fashion.

B. Only one undo tablespace can exist in a database.

C. Undo tablespace is a temporary tablespace.

D. Multiple undo tablespace can exist in a database but only one can be active at a time.

Discussion 0

Correct Answer: D Vote an answer

Question #22

You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)

A. Archived redo log files that have multiple copies in a different archive location and not backed up

B. User managed backups of the data files and control files

C. Flashback log files

D. Backups that have become obsolete

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #23

The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:
1 . Shut down the instance, if not already done.
2 . Copy one of the remaining control files to a new location.
3 . Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4. Start up the database instance to the NOMOUNT stage.
5. Recover the database to the point of failure of the control file.
6. Open the database.
Identify the correct sequence of steps?
Exhibit:

A. 5, 2, 3, 4; 1 and 6 not required

B. 4, 5, 6, 2, 3; 1 not required

C. 2, 4, 3, 5, 6; 1 not required

D. 1, 2, 4, 3, 5, 6

Discussion 0

Correct Answer: D Vote an answer

Question #24

Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to
'/u01/oracle/db01'.
The parameters, DB_CREATE_ONLINE_LOG_DEST_n and
DB_RECOVERY_FILE_DEST, are not specified.
Which four are stored in the location specified by DB-CREATE_FILE_DEST? (Choose four.)

A. control files

B. data files

C. audit files

D. temp files

E. RMAN backups

F. redo logs

G. audit logs

H. archived redo logs

Discussion 0

Correct Answer: A,B,F,G Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #25

Note the following points describing various utilities in Oracle Database 11g:
Which point describes the Oracle Data Pump utility?
1. It enables the transfer of data from one database to another
2. It provides a complete solution for the backup, restoration and recovery needs of the entire database
3 . It enables the loading of data from an external file into tables of an Oracle Database
4 . It provides a tape backup management for the Oracle ecosystem

A. 2

B. 4

C. 1, 2, 3 and 4

D. 1 and 3

E. 3

F. 1

Discussion 0

Correct Answer: F Vote an answer

Question #26

Which two statements are true about alerts? (Choose two.)

A. Response actions cannot be specified with server-generated alerts

B. Clearing an alert sends the alert to the alert history

C. Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified

D. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view

Discussion 0

Correct Answer: B,C Vote an answer

Question #27

Identify the two situations in which the alert log file is updated with details. (Choose two.)

A. Creating a table returns "ORA-00955: name is already used by an existing object'

B. Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578:
ORACLE data block corrupted (file # 14, block @ 50)."

C. Inserting a value in a table returns "ORA-01722: Invalid Number"

D. Running a query on a table returns "ORA-600: Internal Error"

E. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."

F. Rebuilding an index using ALTER INDEX .... REBUILD fails with an error "ORA-01578:
ORACLE data block corrupted (file #14, block #50)."

Discussion 0

Correct Answer: B,D Vote an answer

Question #28

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. Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.

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

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

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

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1Z1-052 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z1-052 Demo