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

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

• A.The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.
• B.The high-water mark (HWM) of ORDERS is adjusted.
• C.Only queries are allowed on ORDERS while SHRINK is executing.
• D.The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.
• E.Dependent indexes become UNUSABLE.
• F.Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

Which two statements are true about User Authentication in an Oracle Database?

• A.REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.
• B.Password File authentication is supported for any type of database user.
• C.Password File authentication must be used for system-privileged administrative users.
• D.Password authentication must be used for system-privileged administrative users.
• E.Operating System authentication may be used for system-privileged administrative users.

Which four statements are true about the Oracle Server architecture?

• A.A person or program can have more than one session with an instance by logging in with different users.
• B.A session represents the state of a user's login to an instance.
• C.A person or program can have more than one session with an instance by logging in with the same user.
• D.The buffer cache and the redo log buffer are held in the large pool.
• E.A connection represents the state of a user's login to an instance.
• F.Each server process or background process has their own Program Global Area (PGA).

Which three statements are true about resumable space allocation in Oracle databases?

• A.Resumable space allocation may be enabled for some sessions and not others.
• B.Resumable space allocation is only possible with locally managed tablespaces.
• C.A user's session may be suspended and resumed multiple times.
• D.The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
• E.A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.
• F.All sessions must have the same timeout value when waiting for resumable space allocations.

Which advisor is used to detect missing or stale object statistics?

• A.SQL Tuning Advisor
• B.SQL Statistics Advisor
• C.SQL Performance Analyzer
• D.SQL Access Advisor