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

Question #85

Which two are true about the Fast Recovery Area (FRA)? (Choose two.)

A. It should be larger than the database

B. Only consistent backups can be stored in the FRA

C. It must reside on the same file system as the database data files

D. A database must be in ARCHIVELOG mode to use the FRA

E. Space management in the FRA is controlled by the database backup retention policy

Discussion 0

Correct Answer: A,E Vote an answer

Question #86

You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

A. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

B. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

C. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

D. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

Discussion 0

Correct Answer: B Vote an answer

Question #87

Which two statements are true regarding B-tree index? (Choose two.)

A. The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.

B. The leaf blocks in the index are doubly linked.

C. The leaf node stores a bitmap for each key value.

D. The rows with NULL value in key columns also have entries in the index.

Discussion 0

Correct Answer: A,B Vote an answer

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

Question #88

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

A. Create a view on the table

B. Delete rows in the table using the DELETE command

C. Update the table using the UPDATE statement

D. Add a virtual column to the table

E. Create a synonym on the table

F. Create an index on the table

Discussion 0

Correct Answer: A,E Vote an answer

Question #89

Examine this LISTENER.ORA file:

How should you configure and start an additional listener LISTENER2 that listens for the same SID?

A. Add relevant details in DESCRIPTION under the existing LISTENER with a different port number in LISTENER.ORA

B. Add relevant details in SID_LIST_LISTENER under the existing LISTENER in LISTENER.ORA

C. Add LISTENER2 and its SID_LIST details separately under the name LISTENER2 in LISTENER.ORA

D. Create another configuration file called LISTENER2.ORA with only LISTENER2 details in it

Discussion 0

Correct Answer: C Vote an answer

Question #90

Which two statements are true about standard database auditing? (Choose two.)

A. Statements that refer to standalone procedure can be audited.

B. Operations by the users logged on as SYSDBA cannot be audited.

C. DDL statements can be audited.

D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

Discussion 0

Correct Answer: A,C Vote an answer

Question #91

View the Exhibit and examine the initialization parameter settings.

Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose three.)

A. LOG_BUFFER

B. DB_KEEP_CACHE_SIZE

C. SORT_AREA_SIZE

D. DB_16K_CACHE_SIZE

E. STREAMS_POOL_SIZE

F. JAVA_POOL_SIZE

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #92

Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?

A. An update in a leaf row takes place.

B. The leaf block containing the row to be updated is marked as invalid.

C. A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.

D. The index becomes invalid after the update.

Discussion 0

Correct Answer: C Vote an answer

Question #93

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components WHERE current_size!=0; What do you infer from this?
Exhibit:

A. The database instance has the MEMORY_TARGET value set to a nonzero value.

B. The database instance is running with manual shared memory management.

C. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.

D. The database instance is running with manual PGA management.

Discussion 0

Correct Answer: A Vote an answer

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

Question #94

SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)

A. The tablespace can be dropped with the current setting with segments present in it.

B. Segment space is managed by free lists in the tablespace.

C. No more data files can be added to the tablespace.

D. A user created without being assigned a default tablespace uses this tablespace.

Discussion 0

Correct Answer: C,D Vote an answer

Question #95

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.
After 30 minutes, you executed the following command:

What could be the reason for the elimination of the other rows in the output?
Exhibit:

A. The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

B. An Automatic Workload Repository snapshot has been taken recently.

C. The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.

D. The threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.

Discussion 0

Correct Answer: D Vote an answer

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

Question #96

You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.
View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file?

A. ORACLE_BASE/diag/rdbms/orcl/alert

B. ORACLE_HOME/dbs

C. /u01/app/oracle/flash_recovery_area

D. ORACEL_HOME/rdbms

E. /u01/app/oracle/admin/orcl/adump

F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace

Discussion 0

Correct Answer: F Vote an answer

Question #97

View the Exhibit1, which shows the options that are selected to create the user SL_REP.
View the Exhibit2 and examine the contents of DATABASE_PROPERTIES.
Which two statements are true regarding this user? (Choose two.)
Exhibit1 (exhibit):

Exhibit2 (exhibit):

A. The user does not require quota on the TEMP tablespace to perform sort operations.

B. The user is forced to change the password at the first login to the database instance.

C. The user is authenticated by the operating system.

D. The objects created by the user in future are unlocked to be accessed by all the users in the database by default.

E. The objects created by the user are placed in the USERS tablespace.

Discussion 0

Correct Answer: A,E Vote an answer

Question #98

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 local operating system user SKD will be able to access the database instance without specifying the username and password.

B. The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

C. The authentication detail for the database user OPS$SKD is recorded in the password file.

D. The database user OPS$SKD will be able to administer the database.

Discussion 0

Correct Answer: A Vote an answer

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

Download Free Oracle 1Z1-052 Demo