1Z1-082試験無料問題集（145題）「Oracle Database Administration I 認定」

出題：1

Examine the description of the product_details table:

Which two statements are true?

A. EXPIRY_ DATE cannot be used in arithmetic expressions.

B. EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.

C. PRODUCT_NAKE cannot contain duplicate values.

D. PRODUCT _ic can be assigned the PRIMARY KEY constraint.

E. PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.

F. PRODUCT _price contains the value zero by default if no value is assigned to it.

正解：D,E 解答を投票する

出題：2

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

B. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

C. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

D. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

E. Add the AUTOEXTEND ON clause with NEXT set to 100M.

正解：C,D 解答を投票する

出題：3

Which three are types of segments in an Oracle Database? (Choose three.)

A. undo

B. clusters

C. stored procedures

D. tables

E. sequences

F. index

正解：A,B,D 解答を投票する

出題：4

What is true about non-equijoin statement performance? (Choose two.)

A. The BETWEEN condition always performs less well than using the >= and <= conditions

B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

C. The BETWEEN condition always performs better than using the >= and <= conditions

D. Table aliases can improve performance

E. The join syntax used makes no difference to performance

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

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

出題：5

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

A. The sales user must have been granted the CREATE TABLE privilege

B. The sales user must have a quota on the TEMP tablespace

C. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

D. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

E. The sales user must have been granted the CREATE SESSION privilege

F. The sales user must have their quota on the users tablespace removed

正解：A,D,F 解答を投票する

出題：6

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

A. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

B. Undo segments must be stored in a BIGFILE tablespace

C. Undo segments have a minimum of three extents

D. An undo segment may be used by multiple transactions simultaneously

E. Undo segments can extend when a transaction fills the last extent of the undo segment

F. Undo segments must be stored in a SMALLFILE tablespace

G. A single transaction may use multiple undo segments simultaneously

正解：D,E,F 解答を投票する

出題：7

Which two statements are true about the rules of precedence for operators? (Choose two.)

A. NULLS influence the precedence of operators in an expression

B. Multiple parentheses can be used to override the default precedence of operators in an expression

C. Arithmetic operators with equal precedence are evaluated from left to right within an expression

D. The + binary operator has the highest precedence in an expression in a SQL statement

E. The concatenation operator | | is always evaluated before addition and subtraction in an expression

正解：B,C 解答を投票する

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

出題：8

Which two statements are true about undo and undo tablespaces?

A. undo segments are owned by SYSTEM.

B. An instance will crash if the active undo tablespace is lost.

C. An undo tablespace may be owned by only one instance.

D. There can be only one undo tablespace created in a database.

E. undo segments are owned by SYSBACKUP.

正解：B,C 解答を投票する

出題：9

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

A. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".

B. It succeeds and the generated undo is stored in SYSTEM.

C. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

D. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

E. It succeeds and the generated undo is stored in SYSAUX.

正解：A 解答を投票する

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

出題：10

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

B. The number, but not names, of columns must be identical for all SELECT statements in the query.

C. The names and number of columns must be identical for all SELECT statements in the query.

D. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

E. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

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

1Z1-082試験無料問題集「Oracle Database Administration I 認定」