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

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 DATABASE ADD LOGFILE „/logs/redo22.log‟ TO GROUP 2

ALTER DATABASE ADD LOGFILE MEMBER ‘/logs/redo22.log’ TO GROUP 2

ALTER DATABASE ADD MEMBER „/logs/redo22.log‟ TO GROUP 2

ALTER DATABASE ADD LOGFILE „/logs/redo22.log‟

Signals the CKPT process to clean up the dirty buffers

Signals the SMON process to clean up the dirty buffers

Signals the CKPT process to initiate a checkpoint

Signals the DBWn process to write the dirty buffers to disk

DB_KEEP_CACHE_SIZE

DB_CACHE_SIZE

DB_BLOCK_SIZE

DB_RECYCLE_CACHE_SIZE

Database buffer

Dictionary cache

Redo log buffer

Library cache

One

2

Four

Zero

When a transaction begins

Khi transaction kết thúc 1 cách không bình thường

When a checkpoint occurs

When a COMMIT is issued

KEEP

RECYCLE

LIBRARY

DEFAULT

Database buffer cache

Shared pool

Redo log buffers

None of the above

One

Two

Three

None

ORA_SID

INSTANCE_NAME

ORACLE_INSTANCE

ORACLE_SID

STARTUP NORMAL

STARTUP MOUNT

STARTUP NOMOUNT

STARTUP FORCE

One control file per database

One control file per disk

Hai control file trên hai ổ đĩa

Two control files on one disk

Oracle adjusts the size of all the redo log files to 10MB

Oracle creates all the redo log files as 5MB

Oracle creates all the redo log files as 5MB except redo0101.log, which is created as 10MB

Câu lệnh không được thực hiện

STARTUP INSTANCE

STARTUP NOMOUNT

STARTUP MOUNT

None of the above

DB_BLOCK_SIZE

DB_NAME

CONTROL_FILES

None; all the initialization parameters can be changed as and when required

SID

USERID

SERIAL#

SEQUENCE#

File destinations

Control files

Log file groups

Tất cả đáp án trên

Từ file tham số khởi tạo

From the CREATE DATABASE command line

From the environment variable

Files created under $ORACLE_HOME and name derived from .ctl

catalog.sql

catproc.sql

sql.bsq

dictionary.sql

ALL_

DBA_

USR_

USER_

SHARED

EXCLUSIVE

NONE

OS

DBA_SOURCE

DBA_OBJECTS

DBA_PROCEDURES

DBA_STATUS

Re-create the procedure

ALTER PROCEDURE RECOMPILE

ALTER PROCEDURE COMPILE

VALIDATE PROCEDURE

V$CONTROLFILE

V$DATAFILE

V$PWFILE_USERS

V$LOGFILE