170+ câu trắc nghiệm Cơ sở dữ liệu Oracle có đáp án - Phần 6
25 câu hỏi
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
Chọn C
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
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
Chọn D
DB_KEEP_CACHE_SIZE
DB_CACHE_SIZE
DB_BLOCK_SIZE
DB_RECYCLE_CACHE_SIZE
Chọn C
Database buffer
Dictionary cache
Redo log buffer
Library cache
Chọn C
One
2
Four
Zero
Chọn B
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
Chọn B
KEEP
RECYCLE
LIBRARY
DEFAULT
Chọn C
Database buffer cache
Shared pool
Redo log buffers
None of the above
Chọn D
One
Two
Three
None
Chọn D
ORA_SID
INSTANCE_NAME
ORACLE_INSTANCE
ORACLE_SID
Chọn D
STARTUP NORMAL
STARTUP MOUNT
STARTUP NOMOUNT
STARTUP FORCE
Chọn A
One control file per database
One control file per disk
Hai control file trên hai ổ đĩa
Two control files on one disk
Chọn C
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
Chọn D
STARTUP INSTANCE
STARTUP NOMOUNT
STARTUP MOUNT
None of the above
Chọn B
DB_BLOCK_SIZE
DB_NAME
CONTROL_FILES
None; all the initialization parameters can be changed as and when required
Chọn A
SID
USERID
SERIAL#
SEQUENCE#
Chọn A và C
File destinations
Control files
Log file groups
Tất cả đáp án trên
Chọn D
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
Chọn A
catalog.sql
catproc.sql
sql.bsq
dictionary.sql
Chọn A
ALL_
DBA_
USR_
USER_
Chọn D
SHARED
EXCLUSIVE
NONE
OS
Chọn C
DBA_SOURCE
DBA_OBJECTS
DBA_PROCEDURES
DBA_STATUS
Chọn B
Re-create the procedure
ALTER PROCEDURE RECOMPILE
ALTER PROCEDURE COMPILE
VALIDATE PROCEDURE
Chọn C
V$CONTROLFILE
V$DATAFILE
V$PWFILE_USERS
V$LOGFILE
Chọn C
