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

質問 1

Which two statements are true about the Oracle Data Dictionary?

（A）Data dictionary views are always created with queries that join two or more base tables.

（B）It is owned by the system user.

（C）All data dictionary view joins base tables to dynamic performance views.

（D）Data dictionary base tables can be queried directly.

（E）It is owned by the sys user.

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

質問 2

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.

正解：A 解答を投票する

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

質問 3

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?

（A）Statement 1 returns only one row of output.

（B）Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

（C）Both the statements give the same output.

（D）Statement 2 returns only one row of output.

（E）Statement 2 may return multiple rows of output.

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

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

質問 4

Examine this description of the books table containing 100 rows:

Now examine this sequence of statements Issued In a new session;

Examine this description of the books table containing 100 rows:
Which three statements are true?

（A）The second rollback command restores the 100 rows that were in the table originally.

（B）The first rollback command leaves the inserted row locked.

（C）The first RollBack command restores the row that was inserted.

（D）The first rollback command restores the 100 rows that were in the table originally.

（E）The second rollback command rolls back the rollback to savepoint a command.

（F）The first rollback command leaves the table's 100 original rows locked.

（G）The second rollback command restores the row that was inserted.

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

質問 5

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

（A）The ADR base is specified In the diagnostic_dest database parameter.

（B）It can be used for problem diagnosis of a database when that database's instance is down.

（C）It is only used for Oracle Database diagnostic information.

（D）It Is held Inside an Oracle database schema.

（E）It is a file-based repository held outside any database.

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

質問 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、E 解答を投票する

質問 7

You currently have an active transaction in your session and have been granted select access to vstransaction.

In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

（A）after successfully executing a commit or rollback followed by a DML statement

（B）after successfully executing a create table statement followed by a create index statement

（C）after successfully executing a truncate statement followed by a DML statement

（D）after successfully executing a create table as select statement followed by a select for update statement

（E）after successfully executing a DML statement following a failed DML statement

（F）after successfully executing a commit or rollback followed by a select statement

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

質問 8

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

（A）writing inbound request to the common request queue from all shared server connections

（B）receiving inbound requests from processes using shared server connections

（C）broadcasting shared server session responses back to requesters on all connections

（D）checking for outbound shared server responses on the common outbound response queue

（E）sending each connection input request to the appropriate shared server input queue

（F）sending shared server session responses back to requesters on the appropriate connection

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

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

質問 9

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）Data block free space is always contiguous in the middle of the block

（D）Multiple row pieces from the same row may be stored in the same block

（E）Multiple row pieces from the same row may be stored in different database blocks

（F）A table row piece can be chained across several database blocks

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

質問 10

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

（A）They cannot be partitioned

（B）They support UPDATEs but not INSERTs and DELETEs

（C）The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

（D）The ORACLE_LOADER access driver can be used to unload data from a database into an external table

（E）The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

（F）External table files can be used for other external tables in a different database

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

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

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

弊社を連絡する

関連リンク

トップ試験