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

A. Buffer cache

B. Dictionary cache

C. Library cache

D. Parse cache

A. Use the ALTER DATABASE RENAME FILE command

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

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

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

A. Instance name 

B. Database name 

C. Tablespace names 

D. Log sequence number 

A. BUFFER_POOL_ADVICE

B. DB_CACHE_ADVICE 

C. DB_CACHE_SIZE

D. SHARED_POOL_SIZE

A. Mounted 

B. Not mounted 

C. Open 

D. Restricted 

A. V$DATABASE 

B. V$INSTANCE 

C. V$CONTROLFILESTATUS 

D. None of the above

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. V$INSTANCE

B. V$LOG 

C. V$DATABASE 

D. V$THREAD

A. DBWn 

B. SMON

C. LGWR

D. CKPT

A. Database performance

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

C. Faster archiving

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

A. Archive log file 

B. Redo log file 

C. Control file 

D. Alert log file

A. Buffer cache

B. Library cache

C. Shared pool

D. Program Global Area

A. CSDL bị treo

B. The instance will shut down

C. ARCn starts writing to LOG_ARCHIVE_DUPLEX_DEST if it is specified

D. Oracle stops writing the archived log files

A. Five 

B. Four 

C. 10

D. Operating system dependent 

A. STALE 

B. Blank 

C. ACTIVE 

D. INVALID 

A.  Eight 

B. Two 

C. One 

D.  4

A. Statement will fail, because the group number is missing

B. Statement will fail, because log file size is missing 

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

D. Adds two members to the current redo log group

A. LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST 

B. LOG_ARCHIVE_DEST and LOG_ARCHIVE_DEST_1 

C. LOG_ARCHIVE_DEST_1 and LOG_ARCHIVE_DEST_2 

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

A. DBWn

B.  LGWR

C. SMON

D. PMON

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. V$ARCHIVE_LOG 

B. V$DATABASE 

C. V$PARAMETER 

D. V$LOG

A. Data buffer that is being accessed

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

C.  Data buffer that is free 

D. Data buffer that is changed and written to the disk

A. arch_%S 

B. arch_%s 

C. arch_000000%s 

D. arch_%0%s

A. The entire table is copied to the database buffer cache

B. The extent is copied to the database buffer cache

C.  Khối đƣợc copy tới CSDL buffer cache

D. The row is copied to the database buffer cache

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

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

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

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