During regular database&#8...

单项选择题X 纠错

During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）

A.DBW0
B.LGWR
C.ARCH
D.SMON
E.PMON

参考答案：

进入题库练习

查答案就用赞题库小程序还有拍照搜题语音搜题快来试试吧

无需下载立即使用

你可能喜欢

单项选择题

You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）

A.OPTIMAL
B.INITIAL
C.PCTINCREASE
D.NEXT

点击查看答案进入题库练习

单项选择题

ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）

A.Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
B.Make a copy of the control file with the database shut down
C.Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
D.Make a copy of the control file with the database still running

点击查看答案进入题库练习

单项选择题

You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）

A.V$DATABASE
B.DBA_TABLES
C.SYSAUD$
D.EMP

点击查看答案进入题库练习

单项选择题

You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

A.SYSTEM
B.OUTLN
C.INTERNAL
D.SYS

点击查看答案进入题库练习

单项选择题

You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

A.Clone
B.Copy
C.Template
D.Terminal

点击查看答案进入题库练习

单项选择题

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

点击查看答案进入题库练习

单项选择题

You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）

A.When the instance is started
B.When the database is mounted
C.When the database is opened
D.When the database is closed

点击查看答案进入题库练习

单项选择题

A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）

A.Acquire locks on table queried
B.Generate redo for statement
C.Fetch data from disk into memory
D.Write changes to disk

点击查看答案进入题库练习

单项选择题

You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）

A.ALTER DATABASE
B.SET TRANSACTION
C.ALTER ROLLBACK SEGMENT
D.ALTER TABLE

点击查看答案进入题库练习

单项选择题

Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）

A.One runs faster than the other
B.A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
C.A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
D.The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE

点击查看答案进入题库练习

赞题库

赞题库-搜题找答案

（已有500万+用户使用）

历年真题
章节练习
每日一练
高频考题
错题收藏
在线模考
提分密卷
模拟试题

无需下载立即使用

手机版电脑版