Oracle 1Z0-082 問題集

質問 1：
Which statement is true about database links?
A. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
B. A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.
C. Private database link creation requires the same user to exist in both the local and the remote databases.
D. A database link can be created only between two Oracle databases.
E. A public database link can be created only by sys.
正解：A

質問 2：
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
A. It can be used to switch a database into ARCHIVELOGMODE
B. It is available only when the database is open
C. It can be used to perform database recovery
D. The same port number can be used for Database Express configurations for databases on different hosts
E. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
正解：B,D

質問 3：
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)
A. the number of days for which an account may be inactive before it is locked
B. the ability to prevent a password from ever being reused
C. the number of password changes required within a period of time before a password can be reused
D. the maximum number of sessions permitted for a user before the account is locked
E. the maximum amount of CPU time allowed for a user's sessions before their account is locked
F. the number of hours for which an account is locked after the configured number of login attempts has been reached
G. the number of days for which an account is locked after the configured number of login attempts has been reached
正解：B,C,D,G

質問 4：
Which three statements are true regarding single row subqueries?
A. They can be used in the where clause.
B. They can be used in the having clause.
C. A SQL statement may have multiple single row subquery blocks.
D. They must be placed on the right side of the comparison operator or condition.
E. They must be placed on the left side of the comparison operator or condition.
F. They must return a row to prevent errors in the SQL statement.
正解：A,B,C

質問 5：
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
A. The output is sorted by the UNION ALL operator
B. The names of columns selected in each SELECT statement must be identical
C. Duplicates are eliminated automatically by the UNION ALL operator
D. NULLS are not ignored during duplicate checking
E. The number of columns selected in each SELECT statement must be identical
正解：D,E

質問 6：
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
A. writing inbound request to the common request queue from all shared server connections
B. broadcasting shared server session responses back to requesters on all connections
C. sending shared server session responses back to requesters on the appropriate connection
D. sending each connection input request to the appropriate shared server input queue
E. checking for outbound shared server responses on the common outbound response queue
F. receiving inbound requests from processes using shared server connections
正解：A,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which three statements are true about the Oracle Data Dictionary? (Choose three.)
A. The data dictionary is created and maintained by the database administrator
B. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
C. It is owned by the SYSTEM user
D. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
E. Base tables can be queried directly
F. Usernames of all users including database administrators are stored in the data dictionary
正解：B,E,F