Latest Oracle 1Z1-182 Actual Free Exam Questions & Community Discussion, Page 3

Question #21

Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?

A. The role has the privileges to perform DDL operations on all local schema objects.

B. The role has the privileges to administer the PDB.

C. The role has the privileges to create and manage users within the PDB.

D. No privileges are provided with the PDB_DBA role.

Discussion 0

Correct Answer: B Vote an answer

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

Question #22

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

A. It supports diagnostics for Oracle Clusterware.

B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set.

C. It is held inside an Oracle database schema.

D. It supports diagnostics for Automatic Storage Management (ASM).

E. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #23

You must create a tablespace of nonstandard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE '/u02/oracle/data/nstbs_f01.dbf' SIZE 100G BLOCKSIZE 32K; The standard block size is 8K, but other nonstandard block sizes will also be used. Which two are requirements for this command to succeed?

A. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.

B. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

C. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.

D. The /u02 file system must have at least 100G space for the datafile.

E. The operating system must use a 32K block size.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #24

Which three actions are ways to apply the principle of least privilege?

A. Enabling Unified Auditing.

B. Revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the roles/users (assuming typo for duplicate option).

C. Setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE.

D. Setting the REMOTE_OS_AUTHENT parameter to TRUE.

E. Using Access Control Lists (ACLs).

Discussion 0

Correct Answer: A,B,E Vote an answer

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

Question #25

Which two statements are true about User Authentication in an Oracle Database?

A. Password File authentication must be used for system-privileged administrative users.

B. Password File authentication is supported for any type of database user.

C. REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.

D. Operating System authentication may be used for system-privileged administrative users.

E. Password authentication must be used for system-privileged administrative users.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #26

Which three statements are true about the tools used to configure Oracle Net Services?

A. Oracle Net Manager can be used to locally configure naming methods on a database server.

B. Oracle Net Manager can be used to centrally configure listeners on any database server target.

C. The Oracle Net Configuration Assistant is only used when running the Oracle installer.

D. The lsnrctl utility requires a listener.ora file to exist before it is started.

E. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

F. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.

Discussion 0

Correct Answer: A,E,F Vote an answer

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

Question #27

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

A. Dependent indexes become UNUSABLE.

B. The high-water mark (HWM) of ORDERS is adjusted.

C. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

D. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.

E. Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

F. Only queries are allowed on ORDERS while SHRINK is executing.

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #28

What are Oracle Database Metrics?

A. Oracle Database Metrics monitor performance using thresholds to generate alerts.

B. Oracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts.

C. Oracle Database Metrics are part of the Oracle Database Notification system to email information about major database events.

D. Oracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.

E. Oracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #29

In which two ways would you disable timing information collected for wait events and much of the performance monitoring capability of the database?

A. By setting the TIMED_STATISTICS system parameter to FALSE.

B. By setting the TIMED_STATISTICS_LEVEL system parameter to FALSE.

C. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.DISABLE(TRUE).

D. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.LEVEL(BASIC).

E. By setting the STATISTICS_LEVEL parameter to BASIC.

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #30

What are the three components of Oracle Database Automatic Maintenance Tasks?

A. A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.

B. The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.

C. A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.

D. Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.

E. A packaging system that allows you to combine all error and failure logs to share with Oracle Support.

F. A database alert log that stores details about major database operations and errors, which is used to manage cluster performance.

Discussion 0

Correct Answer: B,C,D Vote an answer

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

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

Download Free Oracle 1Z1-182 Demo