默认题库 - 1Z0-031

单选题

You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）

A. Writes buffers to disk
B. Writes current redo log number to datafile headers
C. Writes redo log information to disk
D. Reads information into memory for user

查看答案

单选题

You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

A. One tablespace has only one datafile
B. Many tablespaces can share one datafile
C. One tablespace can have many datafiles
D. One datafile can contain many tablespace

查看答案

单选题

You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）

A. DB_CREATE_FILE_DEST
B. DB_CREATE_ONLINE_LOG_1
C. DB_CREATE_ONLINE_LOG_2
D. The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

查看答案

单选题

In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）

A. Password file
B. Initialization file
C. Datafile
D. Control file
E. Nothing - SYSDBA privileges are not required for these actio

查看答案

单选题

In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）

A. DBA_USERS
B. DBA_OBJECTS
C. DBA_TS_QUOTAS
DBA_TAB_PRIVS&e

查看答案