Fast2test 為 Oracle Upgrade to Oracle Database 12c 考生準備了三種產品形式：可列印的 PDF、模擬真實考場的 Desktop Test Engine，以及跨裝置使用的 Online Test Engine。無論你偏好哪種讀書方式，1Z0-060 的 205 道題目都能陪你練到考前一天。

Oracle 1Z0-060 考試概覽:

Oracle 1Z0-060 考試大綱主題:

Oracle Upgrade to Oracle Database 12c 考生最常問的問題

最新的 Oracle Database 1Z0-060 免費考試真題：

問題 #1

Which two statements are true regarding the count function?

A. A select statement using the COUNT function with a DISTINCT keyword cannot have a where clause.
B. Count (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns.
C. The count function can be used only for CHAR, VARCHAR2, and NUMBER data types.
D. Count (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column.
E. Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column.

問題 #2

A new report process containing a complex query is written, with high impact on the database.
You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.
For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

A. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
B. Enable SQL trace for the query.
C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_ MONITOR function to view the report.
D. Execute the query and view Active Session History (ASH) for information about the query.

問題 #3

You are administering a database and you receive a requirement to apply the following restrictions:
1. A connection must be terminated after four unsuccessful login
attempts by user.
2. A user should not be able to create more than four simultaneous
sessions.
3. User session must be terminated after 15 minutes of inactivity.
4. Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?

A. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
B. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
C. by granting a secure application role to the users
D. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE
E. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4

問題 #4

Which two statements are true regarding single row functions?

A. SYSDATE: returns the database server current date and time
B. TRIM: can be used to remove all the occurrences of a character from a string
C. CONCAT: can be used to combine any number of values
D. MOD: returns the quotient of a division
E. INSTR: can be used to find only the first occurrence of a character in a string
F. TRUNC: can be used with number and date values

問題 #5

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

A. It will create a CDB with root opened and seed read only.
B. It will create a CDB with root opened and seed mounted.
C. It will create a CDB that must be plugged into an existing CDB.
D. It will create a multitenant container database (CDB) with only the root opened.
E. It will create a CDB with root and seed opened and one PDB mounted.

問題與答案：