Which two are true about database ta

多选题

Which two are true about database table rows?

A、

They have a row header only when they are chained across multiple database blocks.

B、

They are chained across multiple blocks only when the table has more than 255 columns.

C、

They always have a row header.

D、

They can be stored in a single database block.

E、 They are always stored in a single database block.

查看答案

下载APP答题

由4l***rx提供分享举报纠错

相关试题

单选题
You must upgrade your Oracle 11g Database to Oracle 12c R2. Which method can you use?

A、Use Enterprise Manager Express.

B、Use SQL*Developer

C、Use the Database Creation Assistant(DBCA、to upgrade

D、Perform a direct upgrade by running the Database Upgrade Assistant (DBUA、. 通过运行数据库升级助手(DBUA、执行直接升级。

E、Perform a rolling upgrade.

查看答案

单选题
Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management(ASM). How would you achieve this?

A、 by using RMAN

B、 by using Data Pump 数据泵只能抽取逻辑内容无法改变物理结构

C、 by using the Database Upgrade Assistant (DBUA、错无法升级过去

D、 by using a transportable database 错不能使用可移动数据库无法转存系统表空间内容

查看答案

单选题
One of your databases has archive logging enabled and RMAN backups are taken at regular intervals.
The data file for the USERS tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace?

A、 SWITCH DATAFILE ALL;

B、 STARTUP FORCE

C、 ALTER TABLESPACE users OFFLINE TEMPORARY;

D、 ALTER TABLESPACE users OFELINE NORMAL;

E、 ALTER TABLESPACE users OFFLINE IMMEDIATE;

查看答案

单选题
Examine these commands and output:
SELECT open_mode from v4database;
------------------------------------
READ WRITE
ARCHIVE LOG LIST;
Database log mode No archive Mode
Automatic archive Dsiabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Now examine these steps
1)STARTUP NOMOUNT
2)STARTUP MOUNT
3)STARTUP FORCE
4)ALTER DATABASE ARCHIVELOG
5)ALTER DATABASE MOUNT;
6)ALTER DATABASE OPWEN RESETLOGS
7)SHUTDOWN IMMEDIATE
8)ALTER DATABASE OPEN;
Identify the required steps in the correct order to change the database to run in ARCHIBELOG mode.

A、7,1,4,5,6

B、7,2,4,8

C、3,4,8

D、7,2,4,6

E、3,4,6

查看答案

单选题
What is a requirement for creating a remote database scheduler job?

A、 The remote database job must run as a user that is valid on target remote database

B、 A private datbase link must be created from the originating database to the target remote database 不用私有只要能连接就行

C、 The target remote database on which the job is shceduled must be Oracle Database 11g Release 2 or later 11.1以上版本就支持了

D、 The target remote database must be on a different host from the originating scheduler database host 可以在同一台主机不同的实例下

查看答案

单选题
You must create a table, DAILY_ORDERS, for a DSS application.
Data should be compressed when using direct-path INSERT the table will also be used for occasional Dss queries.
Load performance is critical
Which compression option satisfies these requirements?

A、COLUMN STORE COMPRESS FOR QUERY HIGH

B、ROW STORE COMPRESS ADVANCED 行存储压缩

C、COLUNN STORE COMPRESS FOR QUERY LOW

D、COLUNN STORE COMPRESS FOR ARCHIVE HIGH

E、COLUNN STORE COMPRESS FOR ARCHIVE LOW

查看答案

单选题
Examine the parameters for a database instance：
NAME TYPE VALUE
Temp_undo_enabled boolean TRUE
Undo_management string AUTO
Undo_retention integer 900
Undo_tablespace string UNDOTBS1
Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transaction?

A、 Transactions write their undo in a temporary tablespace. 错不写入到临时表空间

B、 Transactions fail.

C、 Transactions write their undo in the SYSTEM undo segment. 错权限不够无法写入

D、 Transactions wait until space becomes available in UNDOTBS1. 错事务会选择直接撤销不能发生

查看答案

单选题
Examine the details of he uncompressed,non-partitioned heap table CITIES.
Name null type
CITYID NOT NULL NUMBER(4)
CITY_NAME VARCHAR2(50)
Examine the command:
SQL>ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?

A、Make sure that row movement is disabled

B、Disable any constraints on the table.

C、Make sure that row movement is enabled.

D、Make any invisible indexes on the table visible.

E、Make all indexes on the table invisible.

查看答案