082-汇总_在线真题试卷与模拟练习_082-汇总

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Which two statements are true about Oracle Managed Files (OMF)?

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

Choose two. Which two statements are true about row chaining and row migration done by Oracle database block space management?

Choose two. You execute this command:

CREATE SMALLPILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf ' SIZE 5G SEGMENT SPACE MANAGEMENT AUTO;

Which two statements are true about the SALES tablespace?

Choose two. Which two statements are true concerning logical and physical database structures?

Choose three. Which three statements are true about Oracle Managed Files (OMF)?

Choose two. You must create a tablespace of non-standard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE '/u02/oracle/data/nstbs_f01. dbf ' SIZE 100G BLOCKSIZE 32K; The standard block size is 8k but other non-standard block sizes will also be used.

Which two are requirements for this command to succeed?

Choose two. Examine this command:

SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT

Which two statements are true?

Choose three.

Which three statements are true about Deferred Segment Creation in Oracle databases?

Choose three. Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quotas?

Choose three. Which three are types of segments in an Oracle Database?

Choose two. Which two are true about unused columns?

Which three statements are true about dropping and unused columns in an Oracle database?

(Choose three.)

choose two:

Examine the structure of the DEPARTMENTS table

（含图）

You execute the following command:

SQL> ALTER TABLE departments

SET UNUSED (country);

Which two statements are true?

In one of your databases, you create a user, scott, and then execute this command: GRANT CREATE SESSION TO scott WITH ADMIN OPTION;

Which three actions can scott perform? (Choose three.)

Choose two. You have been granted the CREATE ANY INDEX system privilege. You want to create an index, owned by you, on a table in another schema to which you have been granted only the SELECT privilege.

Which two are true?

Choose three.

Which three are true about privileges?

Choose three.

Which three statements about roles are true?

Choose three.

Which FOUR actions can you perform only with system privileges?

Choose two answer.

As the DBA, you execute this command:

GRANT CREATE VIEW TO A WITH ADMIN OPTION;

A then executes this command:

GRANT CREATE VIEW TO B WITH ADMIN OPTION;

B then executes this command:

GRANT CREATE VIEW TO C;

Which statement is true?

1 4 5 6 7 8 15