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

質問 1

Which two tasks can you perform using DBCA for databases? (Choose two.)

（A）Configure a nonstandard block size for a new database

（B）Change the standard block size of an existing database

（C）Register a new database with an available Enterprise Manager Management server

（D）Configure incremental backups for a new database

（E）Enable flashback database for an existing database

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

質問 2

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

（A）The alert log records the execution details

（B）The initialization parameter file is read

（C）The Oracle background processes are started

（D）The control file is read

（E）The online data files are opened

（F）The online redo logs are opened

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

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

質問 3

Which two are true about shrinking a segment online? (Choose two.)

（A）To shrink a table it must have a PRIMARY KEY constraint

（B）To shrink a table it must have a UNIQUE KEY constraint

（C）It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

（D）It always eliminates all migrated rows if any exist in the table

（E）It is not possible to shrink either indexes or Index Organized Tables (IOTs)

（F）To shrink a table it must have row movement enabled

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

質問 4

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

（A）It overwrites data in EMP with data in EMP.DAT

（B）It uses the database buffer cache to load data

（C）It generates a sql script that it uses to load data from EMP.DAT to EMP

（D）It appends data from EMP.DAT to EMP

（E）It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

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

質問 5

You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

（A）Free space is managed using freelists

（B）It uses the database default blocksize

（C）It is a locally managed tablespace

（D）It must be smaller than the smallest BIGFILE tablespace

（E）Any data files added to the tablespace must have a size of 5 gigabytes

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

質問 6

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

（A）The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

（B）The Oracle join syntax supports natural joins

（C）The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

（D）The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

（E）The SQL:1999 compliant ANSI join syntax supports natural joins

（F）The Oracle join syntax supports creation of a Cartesian product of two tables

（G）The Oracle join syntax only supports right outer joins

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

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

質問 7

Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE 'undotbs_01.dbf'
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

（A）Make certain that the database operates in automatic undo management mode

（B）Add the ONLINE clause

（C）Add the SEGMENT SPACE MANAGEMENT AUTO clause

（D）Add the NOLOGGING clause

（E）Set UNDO_TABLESPACE to UNDOTBS01

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

質問 8

Which statement is true about database links?

（A）A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

（B）A public database link can be created only by sys.

（C）Private database link creation requires the same user to exist in both the local and the remote databases.

（D）A database link can be created only between two Oracle databases.

（E）A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.

正解：A 解答を投票する

質問 9

Which three statements are true about views in an Oracle database? (Choose three.)

（A）Data Manipulation Language (DML) can always be used on views

（B）The WITH CHECK clause prevents certain rows from being displayed when querying the view

（C）Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

（D）Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

（E）Tables in the defining query of a view must always exist in order to create the view

（F）Views can be updated without the need to re-grant privileges on the view

（G）The WITH CHECK clause prevents certain rows from being updated or inserted

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

質問 10

Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.
Which two queries will execute successfully?

（A）SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';

（B）SELECT prod_id I I q' ('s not available) * 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK

（C）SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK

（D）SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';

（E）SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

（F）SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;

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

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

弊社を連絡する

関連リンク

トップ試験