1z1-072 試験問題を無料オンラインアクセス

When is a SID_LIST_<listener name> section required in a LISTENER.ORA file?

• A.when the listener uses multiple port numbers for different database instances
• B.when the list of existing database services must be defined
• C.when a dynamic listener is used
• D.when multiple dynamic listeners are used
• E.when a static listener is used

Which three failures require intervention for recovery? (Choose three.)

• A.statement failure
• B.a user error such as dropping the wrong table
• C.network interface card (NIC) failure
• D.user process failure
• E.media failure

Examine this extract from the show parameters command:

How are SGA and PGA memory managed by an instance using these parameter settings?

• A.SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management.
• B.SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management.
• C.SGA and PGA memory are manually managed.
• D.SGA and PGA memory are managed by using Automatic Memory Management (AMM).
• E.SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed.

Which two are true about roles? (Choose two.)

• A.The SET ROLE statement can be used once per session.
• B.The SET ROLE statement enables as well as disables roles in a session.
• C.All privileges and roles granted to a user are enabled by default when the user logs in.
• D.A role must be disabled before it can be revoked from a user.
• E.The ALTER USER statement must be used to set specific default roles for a user.

In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE.
Examine this command:
SQL> CREATE TABLE t1(c1 INT PRIMARY KEY, c2 CLOB);
Which table segments are created?

• A.T1 only
• B.T1, an index segment for the primary key, a LOB segment, and lobindex segment
• C.T1 and an index segment created for the primary key only
• D.T1, an index segment for the primary key, and a LOB segment only