170+ câu trắc nghiệm Cơ sở dữ liệu Oracle

A. Khởi động lại sao lưu với tùy chọn NOT BACKED UP 

B. Use mirrored backups to send the backup to two different device types

C. Include the archive logs in the backup

D. There is no alternative to a failed backup other than to restart the backup

A.  MAXLOGMEMBERS 

B. MAXLOGGROUPS 

C. MAXDATAFILES

D. MAXLOGHISTORY

A. 1 CSDL, nhiều instance

B. One instance, multiple databases

C. Multiple databases on multiple servers

D. Shared server process takes care of multiple user processes

A. Database, tablespace, extent, segment, block

B. Database, tablespace, segment, extent, block

C. Database, segment, tablespace, extent, block

D.  Database, extent, tablespace, segment, block

A. INACTIVE

B. There will be no session information in V$SESSION view

C. TERMINATED

D. KILLED

A. INITIAL = 1MB; NEXT = 2MB

B. INITIAL = multiple of SORT_AREA_SIZE + 1; NEXT =  INITIAL 

C. INITIAL = multiple of SORT_AREA_SIZE + DB_BLOCK_SIZE; NEXT = INITIAL 

D. INITIAL = 2 ∴ SORT_AREA_SIZE; NEXT = SORT_AREA_SIZE 

A. NLS_CHARACTERSET

B. NLS_SORT 

C. NLS_NCHAR_CHARACTERSET 

D. NLS_TERRITORY

A. A checkpoint will occur every 500 seconds regardless of  database activity

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

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

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

A. DBA_SOURCE 

B. DBA_OBJECTS 

C. DBA_PROCEDURES 

D. DBA_STATUS 

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

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

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

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

A. DBA_PROFILES 

B. DBA_USERS 

C. DBA_PASSWORDS

D. V$SESSION

A. DBWn and database buffer cache

B.  LGWR and online redo log file

C. CKPT and control file

D. DBWn and archived redo log file

A. CPU_PER_SESSION

B. CONNECT_TIME 

C. PASSWORD_LOCK_TIME 

D. All the above 

A. The LogMiner activity will not impact other users‟ activity against the data dictionary

B. The LogMiner reports will be more accurate against a snapshot of the data dictionary rather than a constantly changing live data dictionary

C. 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

D. The database does not need to be open to use LogMiner, since all needed information is in the redo logs

A. STALE 

B. Blank 

C. ACTIVE 

D. INVALID 

A. DBA_ 

B. X$ 

C. V$ 

D. X#

A. System Global Area

B. Process monitor

C.  Control file

D. Shared pool

A. DEFAULT

B. LARGE 

C. KEEP 

D. RECYCLE 

A. PRIVATE_SGA 

B. CPU_PER_SESSION 

C. CONNECT_TIME 

D. LOGICAL_READS_PER_CALL

A. ALTER PROFILE

B. ALTER USER

C.  SET PROFILE

D. The profile should be specified when creating the user; it cannot be changed

A. 1

B. 10

C. 256

D. Limit specified by an operating system parameter

A. 16KB 

B. 24KB 

C. 12KB

D. 40KB 

A. DBWn 

B. SMON

C. LGWR

D. CKPT

A. One, with pop-up windows

B. Four, as in previous versions

C. Two, in a master/detail format

D. Two, with DBA tools in the right-hand pane

A. ALTER USER 

B. ALTER ROLE 

C. SET ROLE 

D. SET PRIVILEGE