1Z0-082無料問題集「Oracle Database Administration I」

質問 1

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

（A）It must be bigger than the largest SMALLFILE tablespace

（B）It will be a dictionary-managed tablespace by default

（C）Additional data files may not be added

（D）It will always have a 32K blocksize

（E）AUTOEXTEND is possible for the datafile

正解：C、E 解答を投票する

質問 2

Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

（A）UNDO_RETENTION specifies how long all types of UNDO are retained.

（B）Unexpired UNDO is always retained.

（C）Active UNDO is always retained.

（D）UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

（E）UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

正解：B、D 解答を投票する

質問 3

Which two statements are true about Enterprise Manager (EM) Express?

（A）By default, EM express is available for a database after database creation using DBCA.

（B）You can use a single instance of EM Express to manage multiple database running on the same server.

（C）You can shut down a database instance using EM Express.

（D）EM Express uses a separate repository database to store target database metadata.

（E）You cannot start up a database instance using EM Express.

正解：A、C 解答を投票する

質問 4

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

（A）Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

（B）Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

（C）Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

（D）If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

（E）Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

正解：A、E 解答を投票する

質問 5

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

（A）It supports diagnostics for Oracle Clusterware

（B）The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

（C）It is held inside an Oracle database schema

（D）The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set

（E）It supports diagnostics for Automatic Storage Management (ASM)

正解：A、E 解答を投票する

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

質問 6

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

（A）It gives an error because the GROUP BY clause is not valid

（B）It gives an error because the ALL keyword is not valid

（C）It executes successfully but does not give the required result

（D）It executes successfully and gives the required result

正解：D 解答を投票する

質問 7

Which two statements are true about segment types in an Oracle Database?

（A）Temporary segments are only stored in a temporary tablespace.

（B）Undo segments are only stored in an undo tablespace.

（C）Index segments always have two or more extents.

（D）Table segments always have two or more extents.

（E）Cluster segments may contain data from multiple tables.

正解：A 解答を投票する

質問 8

Which statement is true about the INTERSECT operator used in compound queries?

（A）It ignores NULLs

（B）INTERSECT is of lower precedence than UNION or UNION ALL

（C）Multiple INTERSECT operators are not possible in the same SQL statement

（D）It processes NULLs in the selected columns

正解：D 解答を投票する

質問 9

Examine the description of the customers table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000.
Examine this partial query:
SELECT cust_last_name, cust_credit_limit FROM customers
Which two where conditions give the required result?
A)

C)

D)

E)

（A）Option E

（B）Option D

（C）Option B

（D）Option C

（E）Option A

正解：A、D 解答を投票する

質問 10

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

（A）the maximum amount of CPU time allowed for a user's sessions before their account is locked

（B）the maximum number of sessions permitted for a user before the account is locked

（C）the number of days for which an account may be inactive before it is locked

（D）the number of hours for which an account is locked after the configured number of login attempts has been reached

（E）the ability to prevent a password from ever being reused

（F）the number of password changes required within a period of time before a password can be reused

（G）the number of days for which an account is locked after the configured number of login attempts has been reached

正解：B、E、F、G 解答を投票する

1Z0-082 無料問題集「Oracle Database Administration I」

弊社を連絡する

関連リンク

トップ試験