購入前に中身を確かめたい方は、GoShikenの無料サンプルをご活用ください。1z1-062（Oracle Database 12c: Installation and Administration）の問題集は、実際の問題形式や解答の質をご確認いただいてからご購入いただけます。

Oracle 1z1-062 試験概要:

Oracle 1z1-062 試験シラバストピック:

Oracle Database 12c: Installation and Administrationのよくある疑問を解決します

Oracle Database 12c: Installation and Administration 認定 1z1-062 試験問題：

問題 #1

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.

A. Change in the hardware configuration of the database server
B. Change in the Oracle Database version
C. Change in your network infrastructure
D. Migration of database storage from non-ASM to ASM storage
E. Database and operating system upgrade

問題 #2

You Execute the Following command to create a password file in the database server:
$ orapwd file = '+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12' Which two statements are true about the password file? (Choose two.)

A. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
B. It records the usernames and passwords of users when granted the DBA role.
C. It contains the usernames and passwords of users for whom auditing is enabled.
D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
E. Is used by Oracle to authenticate users for remote database administration.

問題 #3

A user establishes a connection to a database instance by using an Oracle Net.
You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this? (Choose two.)

A. by implementing Database Resource Manager and assign it a role for the user
B. by using appropriate PASSWORD parameters set in the profile assigned to the user
C. by using appropriate KERNEL parameters set in the profile assigned to the user
D. by alerting the appropriate user attributes with an ALTER USER command
E. by implementing Database Resource Manager and assign it a profile for the user

問題 #4

On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statements are correct? (Choose two.)

A. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
C. Only the ORD_CUSTOMER_IX2 index is created.
D. Both the indexes are created; however, only the ORD_COSTOMER index is visible.
E. Only the ORD_CUSTOMER_IX1 index is created.

問題 #5

Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)

A. It frees unused temporary segments.
B. It frees resources held by abnormally terminated processes.
C. It registers database services with all local and remote listeners known to the database instance.
D. It records checkpoint information in the control file.
E. It kills sessions that exceed idle time.

解説：