Oracle 1Z0-060 問題集

質問 1：
Which two statements are true regarding single row functions?
A. MOD: returns the quotient of a division
B. TRUNC: can be used with number and date values
C. SYSDATE: returns the database server current date and time
D. INSTR: can be used to find only the first occurrence of a character in a string
E. CONCAT: can be used to combine any number of values
F. TRIM: can be used to remove all the occurrences of a character from a string
正解：B,C

質問 2：
Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX?
A. Thread creation must be routed through a dispatcher process.
B. The local listener may pass the request to an existing process which in turn will create a thread.
C. Each multithreaded Oracle process has an SCMN thread.
D. Each Oracle process runs an SCMN thread.
正解：A,B

質問 3：
Which two statements are true about the Oracle Direct Network File system (DNFS)?
A. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
B. A traditional NFS mount is not required when using Direct NFS.
C. Direct NFS can load-balance I/O traffic across multiple network adapters.
D. It utilizes the OS file system cache.
E. Direct NFS is available only in UNIX platforms.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges:

Which statement is true about the common user created by the command?
A. The user can connect only to the root database.
B. The user cannot connect to any database because the CREATE ANY SESSION privilege must be granted.
C. The user can connect to the root and all PDBs.
D. The user cannot connect any database because the CONTAINER clause is missing.
正解：C

質問 5：
You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script?
A. The seed will be opened read-only.
B. The seed will be opened read/write.
C. The seed will be in mount state.
D. The other PDBs will be in mount state.
E. The PDBs will be opened read/write.
F. The other PDBs will be opened read-only.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You notice a performance change in your production Oracle 12c database and you want to know what change caused this performance difference. You generate the compare period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?
A. It detects the top wait events causing performance degradation.
B. It gives information about statistics collection in both time periods.
C. It detects any configuration change that caused a performance difference in both time periods.
D. It shows the resource usage for CPU, memory, and I/O in both time periods.
E. It identifies any workload change that caused a performance difference in both time periods
正解：C,D,E

質問 7：
Which two are true concerning a multitenant container database with three pluggable database?
A. Pluggable databases are only used for database consolidation.
B. The pluggable databases increase patching time.
C. The pluggable databases are patched together.
D. The pluggable databases reduce administration effort.
E. All administration tasks must be done to a specific pluggable database.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= `/dev/flash_device_1 `,' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?
A. Set DB_FLASH_CACHE_ZISE = 64G.
B. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.
C. Set DB_FLASH_CACHE_ZISE = 64G, 64G
D. Set DB_FLASH_CACHE_ZISE = 128G.
正解：C
解説: (Topexam メンバーにのみ表示されます)