1Z0_062 questions • Exam prepare

Exam contains 381 questions

Page 28 of 64

Question 163 🔥

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.What must this name be made up of?

Which database solution meets these requirements?

A. It must be made up of a database name and a domain name.

B. It must be made up of the value in ORACLE_SID and HOSTNAME.

C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.

D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

Discussion of the question

Question 164 🔥

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

Which database solution meets these requirements?

A. DDL statements can be audited.

Highly voted

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

Highly voted

C. Operations by the users logged on as SYSDBA cannot 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 of the question

Question 165 🔥

You executed the following command to create a password file in the database server:$ orapwd file = orapworcl entries = 5 ignorecase=NWhich statement describes the purpose of the above password file?

Which database solution meets these requirements?

A. It records usernames and passwords of users when granted the DBA role

B. It contains usernames and passwords of users for whom auditing is enabled

C. It is used by Oracle to authenticate users for remote database administrator

Highly voted

D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

Discussion of the question

Question 166 🔥

Which three statements are true about space usage alerts? (Choose three.)

Which database solution meets these requirements?

A. Alerts are issued only when the critical threshold for space available in a tablespace is breached.

Highly voted

B. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.

C. Database alerts can provide warnings about low space availability at both tablespace and segment levels.

D. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.

Highly voted

E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.

Highly voted

Discussion of the question

Question 167 🔥

Which three statements are true about Oracle Data Pump? (Choose three.)

Which database solution meets these requirements?

A. IMPDP can be used to change target data file names, schemas, and tablespaces during import.

B. The DBMS_DATAPUMP PL/SQL package can be used independently of Data Pump clients to perform export and import operations.

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

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

E. IMPDP always use the conventional path insert method to import data.

Discussion of the question

Question 168 🔥

Examine the parameters for your database instance:You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario?

Which database solution meets these requirements?

A. Undo data is written to flashback logs after 1200 seconds.

B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.

C. You can perform a Flashback Database operation only within the duration of 1200 seconds.

D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_062

Exam contains 381 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us