170+ câu trắc nghiệm Cơ sở dữ liệu Oracle có đáp án - Phần 7
25 câu hỏi
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
Chọn A
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
Chọn D
SYS
SYSTEM
DBA
ORACLE
Chọn A
MANAGER
CHANGE_ON_INSTALL
SYS
There is no default password
Chọn B
DBA_VERSIONS
PRODUCT_COMPONENT_VERSION
PRODUCT_VERSIONS
ALL_VERSION
Chọn B
DBA_
X$
V$
X#
Chọn C
MAXLOGMEMBERS
MAXLOGGROUPS
MAXDATAFILES
MAXLOGHISTORY
Chọn B
AUD$
LINK$
sql.bsq
DICT
Chọn A
ALERT_DUMP_DEST
USER_DUMP_DEST
BACKGROUND_DUMP_DEST
CORE_DUMP_DEST
Chọn B
SHUTDOWN IMMEDIATE
SHUTDOWN TRANSACTIONAL
SHUTDOWN NORMAL
None of the above
Chọn D
SHUTDOWN IMMEDIATE
SHUTDOWN TRANSACTIONAL
SHUTDOWN NORMAL
SHUTDOWN ABORT
Chọn B
STARTUP READ ONLY
STARTUP MOUNT; ALTER DATABASE OPEN READ ONLY
STARTUP NOMOUNT; ALTER DATABASE READ ONLY
STARTUP; ALTER SYSTEM ENABLE READ ONLY
Chọn B
DATABASE_ADMINISTRATOR
SUPER_USER
DBA
No such role is created by default; you need to create administrator
Chọn C
FILE
PASSWORD
ENTRIES
All the parameters are optional; if you omit a parameter, Oracle substitutes the default
Chọn C
ALTER SYSTEM
RESTRICTED SESSION
CONNECT
RESTRICTED SYSTEM
Chọn B
Before the instance start-up
Instance started
Database mounted
Database opened
Chọn C
INACTIVE
There will be no session information in V$SESSION view
TERMINATED
KILLED
Chọn D
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
Chọn A
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
Chọn B
SHOW PARAMETER DB_BLOCK_SIZE
SHOW PARAMETERS DB_BLOCK_SIZE
SHOW ALL
DISPLAY PARAMETER DB_BLOCK_SIZE
Chọn A và B
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
Chọn C
V$PWFILE_USERS
DBA_PWFILE_USERS
DBA_SYS_GRANTS
None of the above
Chọn A
DB_CREATE_FILE_DEST
DB_CREATE_FILE_DEST_2
DB_CREATE_ONLINE_LOG_DEST_1
DB_CREATE_ONLINE_LOG_DEST_5
Chọn B
Sort area
Program Global Area
Library cache
Large pool
Chọn C và D
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‟
Chọn B
