1Z0-082問題集、Oracle実際の試験問題

質問 1

You must create a tablespace of non-standard block size in a new file system and plan to use this command:

The standard block size is 8k but other non-standard block sizes will also be used. Which two are requirements for this command to succeed?

A. The /u02 file system must have at least lOOg space for the datafile.

B. d3_32k_cache_size should be set to a value greater than db_cache_size.

C. The operating system must use a 32k block size.

D. db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.

E. db_32r_cache_si2e must be less than db_ca=he_size.

F. db_32k_cache_size must be set to a value that can be accommodated in the SGA.

正解: D,E

質問 2

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

A. A table that is truncated will always have its segment removed

B. Private Temporary Tables (PTTS) store metadata in memory only

C. An index that is altered to be UNUSABLE will retain its segment

D. An index created with the UNUSABLE attribute has no segment

E. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

正解: D,E

質問 3

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

A. Data block headers contain their own Data Block Address (DBA)

B. Index block free space is always contiguous in the middle of the block

C. A table row piece can be chained across several database blocks

D. Data block free space is always contiguous in the middle of the block

E. Multiple row pieces from the same row may be stored in the same block

F. Multiple row pieces from the same row may be stored in different database blocks

正解: C,D,F

質問 4

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?
(Choose three.)

A. analysis of all privileges used by all users but excluding administrative users in the database

B. analysis of privileges that a user has on their own schema objects that they did not use

C. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

D. analysis of privileges granted directly to a role that are then used by a user who has been granted that role

E. analysis of privileges that a user has on their own schema objects that they did use

F. analysis of all privileges used by all users including administrative users in the database

正解: B,C,F

解説: (PassTest メンバーにのみ表示されます)

質問 5

Examine the description of the members table:

Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?

A. WHERE city = =%AN%'

B. WHERE city IN (?AN%')

C. ORDER BY 1, 2

D. ORDER BY 1, LNAME DESC

E. WHERE city LIKE *%AN%*

F. ORDER BY last_narae DESC, city ASC

正解: D,E

質問 6

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

A. Set OS_AUTHENT_PREFIX to OPS$

B. Alter user KING to be IDENTIFIED EXTERNALLY

C. Grant DBA to KING

D. Have the OS administrator add KING to the OSDBA group

E. Unset REMOTE_LOGIN_PASSWORDFILE

正解: E

質問 7

Which three activities are recorded in the database alert log? (Choose three.)

A. Data Definition Language (DDL) statements

B. non-default database parameters

C. session logins and logouts

D. deadlock errors

E. block corruption errors

正解: B,D,E

解説: (PassTest メンバーにのみ表示されます)

質問 8

Which three object types support deferred segment creation? (Choose three.)

A. clustered tables

B. partitioned tables

C. temporary tables

D. heap organized tables

E. index organized tables

F. external tables

正解: B,D,E

Oracle Database Administration I - 1Z0-082 模擬練習