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

Chặn các khối bị lỗi

Users connecting and disconnecting from the database

All user errors

The default values of the parameters used to start up the database

One.

Two.

More than one; only one will be used for the SYSTEM tablespace

Nhiều hơn 1, tất cả đều được dùng trong tablespace SYSTEM

SYS

SYSTEM

DBA

ORACLE

MANAGER

CHANGE_ON_INSTALL

SYS

There is no default password

DBA_VERSIONS

PRODUCT_COMPONENT_VERSION

PRODUCT_VERSIONS

ALL_VERSION

DBA_

X$

V$

X#

MAXLOGMEMBERS

MAXLOGGROUPS

MAXDATAFILES

MAXLOGHISTORY

AUD$

LINK$

sql.bsq

DICT

ALERT_DUMP_DEST

USER_DUMP_DEST

BACKGROUND_DUMP_DEST

CORE_DUMP_DEST

SHUTDOWN IMMEDIATE

SHUTDOWN TRANSACTIONAL

SHUTDOWN NORMAL

None of the above

SHUTDOWN IMMEDIATE

SHUTDOWN TRANSACTIONAL

SHUTDOWN NORMAL

SHUTDOWN ABORT

STARTUP READ ONLY

STARTUP MOUNT; ALTER DATABASE OPEN READ ONLY

STARTUP NOMOUNT; ALTER DATABASE READ ONLY

STARTUP; ALTER SYSTEM ENABLE READ ONLY

DATABASE_ADMINISTRATOR

SUPER_USER

DBA

No such role is created by default; you need to create administrator

FILE

PASSWORD

ENTRIES

All the parameters are optional; if you omit a parameter, Oracle substitutes the default

ALTER SYSTEM

RESTRICTED SESSION

CONNECT

RESTRICTED SYSTEM

Before the instance start-up

Instance started

Database mounted

Database opened

INACTIVE

There will be no session information in V$SESSION view

TERMINATED

KILLED

STARTUP FORCE

SHUTDOWN FORCE

SHUTDOWN START

There is no single command to “bounce” the database; you need to shut down the database and then restart it

The SPFILE can be mirrored across several drives, unlike PFILEs

Là những thay đổi đối với cấu hình CSDL sẽ đƣợc thực hiện xuyên suốt quá trình shutdown và startup

Because the SPFILE is binary, the DBA will be less likely to edit it

The ALTER SYSTEM command cannot modify the contents of an SPFILE

SHOW PARAMETER DB_BLOCK_SIZE

SHOW PARAMETERS DB_BLOCK_SIZE

SHOW ALL

DISPLAY PARAMETER DB_BLOCK_SIZE

The users with DBA privilege remain connected, and others are disconnected

The users with RESTRICTED SESSION remain connected, and others are disconnected

Ko gì xảy ra, vẫn tiếp tục làm việc bình thường

The users are allowed to complete their current transaction and are disconnected

V$PWFILE_USERS

DBA_PWFILE_USERS

DBA_SYS_GRANTS

None of the above

DB_CREATE_FILE_DEST

DB_CREATE_FILE_DEST_2

DB_CREATE_ONLINE_LOG_DEST_1

DB_CREATE_ONLINE_LOG_DEST_5

Sort area

Program Global Area

Library cache

Large pool

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‟