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

質問 1

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

（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.

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

質問 2

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

（A）temporary tables

（B）index organized tables

（C）partitioned tables

（D）heap organized tables

（E）external tables

（F）clustered tables

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

質問 3

Which three statements are true about sequences in a single instance Oracle database?

（A）A sequence can only be dropped by a DBA.

（B）A sequence's unallocated cached values are lost if the instance shuts down.

（C）Sequences can always have gaps.

（D）A sequence number that was allocated can be rolled back if a transaction fails.

（E）A sequence can Issue duplicate values.

（F）Two or more tables cannot have keys generated from the same sequence.

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

質問 4

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

（A）in the SGA

（B）in the PGA

（C）in the temporary tablespace

（D）in the SYSAUX tablespace

（E）in the undo tablespace

正解：E 解答を投票する

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

質問 5

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

（A）SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;

（B）SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;

（C）SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

（D）SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

（E）SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;

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

質問 6

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

（A）Execute DML statements in the HR schema

（B）Revoke the CREATE SESSION privilege from user HR

（C）Revoke the CREATE SESSION privilege from other users

（D）Grant the CREATE SESSION privilege with ADMIN OPTION to other users

（E）Log in to the database instance

（F）Execute DDL statements in the HR schema

正解：C、D、F 解答を投票する

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

質問 7

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

（A）Private Temporary Tables (PTTS) store metadata in memory only

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

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

（D）A table that is truncated will always have its segment removed

（E）An index created with the UNUSABLE attribute has no segment

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

質問 8

Which two statements are true about UNDO and REDO? (Choose two.)

（A）The generation of UNDO generates REDO

（B）The generation of REDO generates UNDO

（C）DML modifies Oracle database objects and only generates REDO

（D）DML modifies Oracle database objects and only generates UNDO

（E）DML modifies Oracle database objects and generates UNDO and REDO

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

質問 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 read undo block of UNDOTBS1 is overwritten by the generated undo.

（D）It succeeds and the generated undo is stored in SYSAUX.

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

正解：E 解答を投票する

質問 10

Which three are true about the Oracle Optimizer? (Choose three.)

（A）It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

（B）It can re-optimize execution plans after previous executions detect suboptimal plans.

（C）It updates stale object statistics in the Data Dictionary.

（D）It can optimize only SELECT statements.

（E）It will only generate SQL Plan Directives specific to a given SQL statement.

（F）It determines the optimal table join order and method.

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

質問 11

The orders table has a column ORDER_DATE of data type date.
The default display format for a date Is DD-MON-RR.
Which two where conditions demonstrate the correct usage of conversion functions?

（A）WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

（B）WHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')

（C）WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018',
'Mon DD YYYY'))

（D）WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'

（E）WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')

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

質問 12

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 IN (?AN%')

（B）WHERE city LIKE *%AN%*

（C）ORDER BY last_narae DESC, city ASC

（D）ORDER BY 1, LNAME DESC

（E）WHERE city = =%AN%'

（F）ORDER BY 1, 2

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

質問 13

Examine this command:

Which two statements are true?

（A）It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.

（B）Tables with one or more extents in this data file may be queried during the execution of this command.

（C）The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

（D）DML may be performed on tables with one or more extents in this data file during the execution of this command.

（E）Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.

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

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

弊社を連絡する

関連リンク

トップ試験