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

Buffer cache

Dictionary cache

Library cache

Parse cache

Use the ALTER DATABASE RENAME FILE command

Shut down the database, rename the control file by using an operating system command, and restart the database after changing the CONTROL_FILES parameter in the initialization parameter file

Put the database in RESTRICTED mode and issue the ALTER DATABASE RENAME FILE command

Shut down the database, change the CONTROL_FILES parameter, and start up the database

Instance name

Database name

Tablespace names

Log sequence number

BUFFER_POOL_ADVICE

DB_CACHE_ADVICE

DB_CACHE_SIZE

SHARED_POOL_SIZE

Mounted

Not mounted

Open

Restricted

V$DATABASE

V$INSTANCE

V$CONTROLFILESTATUS

None of the above

A checkpoint will occur every 500 seconds regardless of database activity

A checkpoint will occur after writing 500 blocks to the redo log file

Upon instance startup, the database will not be ready for connections for at least 500 seconds while instance recovery is performed by SMON

Phục hồi từ instance thất bại ko nên quá 500 giây

V$INSTANCE

V$LOG

V$DATABASE

V$THREAD

DBWn

SMON

LGWR

CKPT

Database performance

Đề phòng sự cố hư hỏng ổ đĩa

Faster archiving

Writes are concurrent, so having control files on different disks speeds up control file writes

Archive log file

Redo log file

Control file

Alert log file

Buffer cache

Library cache

Shared pool

Program Global Area

CSDL bị treo

The instance will shut down

ARCn starts writing to LOG_ARCHIVE_DUPLEX_DEST if it is specified

Oracle stops writing the archived log files

Five

Four

10

Operating system dependent

STALE

Blank

ACTIVE

INVALID

Eight

Two

One

4

Statement will fail, because the group number is missing

Statement will fail, because log file size is missing

Tạo nhóm redo log mới với 2 member

Adds two members to the current redo log group

LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST

LOG_ARCHIVE_DEST and LOG_ARCHIVE_DEST_1

LOG_ARCHIVE_DEST_1 and LOG_ARCHIVE_DEST_2

None of the above; you can specify all the archive destination parameters with valid destination names

DBWn

LGWR

SMON

PMON

Dropping log files with OMF automatically drops the related operating system file

OMF quản lí archived redo log files sử dụng tham số khởi tạo DB_CREATE_ARCHIVE_LOG_DEST_n

A new log file group can be added without specifying a filename in the ALTER DATABASE statement.

A log file group managed with OMF can be dropped by specifying only the log group number

V$ARCHIVE_LOG

V$DATABASE

V$PARAMETER

V$LOG

Data buffer that is being accessed

Data buffer đã được thay đổi nhưng không được ghi vào ổ đĩa

Data buffer that is free

Data buf that is changed and written to the disk

arch_%S

arch_%s

arch_000000%s

arch_%0%s

The entire table is copied to the database buffer cache

The extent is copied to the database buffer cache

Khối được copy tới CSDL buffer cache

The row is copied to the database buffer cache

ALTER SYSTEM SET CONTROL_FILES= ‘/u01/oradata/PRD/cntrl01.ctl’, ‘/u01/oradata/PRD/cntrl02.ctl’ SCOPE=SPFILE;

ALTER SYSTEM SET CONTROL_FILES= „/u01/oradata/PRD/cntrl01.ctl‟, „/u01/oradata/PRD/cntrl02.ctl‟ SCOPE=MEMORY;

ALTER SYSTEM SET CONTROL_FILES= „/u01/oradata/PRD/cntrl01.ctl‟, „/u01/oradata/PRD/cntrl02.ctl‟ SCOPE=BOTH;

The number of control files is fixed when the database is created