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

FREELISTS

PCTFREE

INITRANS

MAXTRANS

DBA_TABLESPACES

DBA_FREE_SPACE

DBA_EXTENTS

DBA_SEGMENTS

DBA_FREE_SEGMENTS

DBA_FREE_SPACE

DBA_SEGMENTS

DBA_EXTENTS

Common and variable header

Row directory

Table directory

Row data

Khi free space đạt tới ngưỡng PCTFREE.

When row data reaches the PCTFREE threshold

When free space drops below the PCTUSED threshold

When row data drops below the PCTUSED threshold

The tablespace cannot contain nested tables.

The tablespace cannot be transportable.

The tablespace ko thể chứa đối tượng LOBs.

The bootstrap segment cannot reside in a tablespace that has automatic segment space management enabled

cross joins

inner joins

full outer joins

left outer joins

V$UNDOSTAT

V$ROLLSTAT

V$SESSION

V$ROLLNAME

One, with pop-up windows

Four, as in previous versions

Two, in a master/detail format

Two, with DBA tools in the right-hand pane

0

10

40

100

DBA_ROLLBACK_SEGS

V$ROLLSTAT

DBA_SEGMENTS

V$ROLLNAME

A single row spread across multiple blocks

Moving a table from one tablespace to another

Lưu trữ 1dòng vào khối khác khi không đủ chổ trong khối hiện hành để mở rộng

Deleting a row and adding it back to the same table

Explicitly accept all statistics

Explicitly reject all statistics

Let IMPORT decide if the statistics are safe; otherwise recalculate

Tất cả đều đúng

Rollback extents nhỏ hơn.

Higher MAXEXTENTS value

Larger rollback extents

Higher OPTIMAL value

100

255

DB_BLOCK_SIZE

The maximum is operating system dependent

Gọi 1 stored procedure

Using OS authentication

Using PWFILE authentication

Using an encrypted role password

CREATE TABLE

CREATE INDEX

UPDATE

CREATE TABLESPACE

The DBA can use the Active Session Pool feature to put Chad‟s session on hold until another user in the same consumer group finishes their session

The DBA can use the Automatic Consumer Group Switching feature to switch Chad‟s consumer group to the same group as the OLTP user

The DBA can use the Active Session Pool feature to suspend the session if there are too many active OLTP sessions

DBA có thể dùng tính năng Automatic Consumer Group Switching feature để chuyển nhóm khách hàng của Chad tới nhóm khác với độ ưu tiên thấp hơn

From the initialization parameters

From the tables involved in the sort operation

Sử dụng tham số lưu trữ mặc định cho tablespace

The database block size

Table

Segment

Block

The LogMiner activity will not impact other users‟ activity against the data dictionary

The LogMiner reports will be more accurate against a snapshot of the data dictionary rather than a constantly changing live data dictionary

Khối xấu(hư hỏng) trong 1 trong những redo log sẽ làm ngưng LogMiner Analysis với các TĐDL tĩnh

The database does not need to be open to use LogMiner, since all needed information is in the redo logs

ALTER TABLESPACE USERS READ ONLY

ALTER DATABASE MAKE TABLESPACE USERS READ ONLY

ALTER TABLESPACE USERS ONLINE

ALTER TABLESPACE USERS TEMPORARY

Khởi động lại sao lưu với tùy chọn NOT BACKED UP

Use mirrored backups to send the backup to two different device types

Include the archive logs in the backup

There is no alternative to a failed backup other than to restart the backup

When the sort operation completes

When the instance is shut down

When you issue ALTER TABLESPACE COALESCE

When SMON clears up inactive sort segments

PCTUSED

FREELISTS

FREELIST GROUPS

Tất cả đều đúng