170+ câu trắc nghiệm Cơ sở dữ liệu Oracle có đáp án - Phần 4

2MB

4MB

5MB

7MB

All changes to an SPFILE are implemented only after the instance is restarted

Thay đổi được thực hiện trong SPFILE với câu lệnh ALTER SYSTEM có thể thay đổi đồng thời với thay đổi của bộ nhớ bản sao các tham số

An SPFILE can exist on the client side

SPFILEs can be used in conjunction with a text-format PFILE

ALTER TABLESPACE ADD DATAFILE SIZE

ALTER DATABASE DATAFILE RESIZE

ALTER DATAFILE RESIZE

ALTER TABLESPACE DATAFILE RESIZE

16KB

24KB

12KB

40KB

Block is read from remote cache without Cache Fusion

Block is read from a local cache

Block is read from a remote cache with Cache Fusion 2

Block is read from a shared disk

DB_8K_CACHE_SIZE

DB_16K_CACHE_SIZE

DB_CACHE_SIZE

UNDO_MANAGEMENT

Native C code is generated for PL/SQL procedures

The compiled code resides in the SGA

Byte code is generated by the compiler and therefore can easily be reused by different transactions

The compiled code resides in the PGA

System Global Area

Process monitor

Control file

Shared pool

DBA_DATA_FILES

DBA_TABLESPACES

DBA_TEMP_FILES

DBA_LOCAL_FILES

DBWn and database buffer cache

LGWR and online redo log file

CKPT and control file

DBWn and archived redo log file

When the initialization parameter COALESCE_TABLESPACES is set to TRUE

When the PCTINCREASE default storage of the tablespace is set to 0

Khi giá trị trữ PCTINCREASE của tablespace được thiết lập là 50

Whenever the tablespace has more than one free extent

1

10

256

Limit specified by an operating system parameter

Delete data from table

Drop table

Create new table

None of the above

Rename all the objects in the tablespace and then drop the tablespace

Remove the data files belonging to the tablespace from the disk

Use ALTER DATABASE DROP CASCADE

Use DROP TABLESPACE INCLUDING CONTENTS

DBWn

LGWR

CKPT

ARCn

ALTER DATABASE

ALTER TABLESPACE.

ALTER DATA FILE.

You cannot change the auto-extensible feature once the data file created

6KB

20KB

32KB

50KB

1 CSDL, nhiều instance

One instance, multiple databases

Multiple databases on multiple servers

Shared server process takes care of multiple user processes

Can be made read-only

Can be offline

Data files can be renamed

Data files cannot be resized

INITIAL = 1MB; NEXT = 2MB

INITIAL = multiple of SORT_AREA_SIZE + 1; NEXT = INITIAL

INITIAL = multiple of SORT_AREA_SIZE + DB_BLOCK_SIZE; NEXT = INITIAL

INITIAL = 2 ∴ SORT_AREA_SIZE; NEXT = SORT_AREA_SIZE

INITIAL

NEXT

MAXEX

None

Query the DBA_SORT_SEGMENT view.

Query the V$SORT_SEGMENT view.

Query the V$SORT_USAGE view.

You can obtain only the total sort segment size; you cannot find information on individual session sort space usage

Database, tablespace, extent, segment, block

Database, tablespace, segment, extent, block

Database, segment, tablespace, extent, block

Database, extent, tablespace, segment, block

All data files belonging to the tablespace must be online

Không bảo data files là available

Need not do media recovery when bringing the tablespace online

Cần phải phục hồi đa phuơng tiện khi chuyển tablespace qua online

%s

%t

%a

%u