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

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

Which two tasks can you perform using DBCA for databases? (Choose two.)

You plan to create a database by using the Database Configuration Assistant

(DBCA）, with t he following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA）?

You execute this query:

SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE）, ‘MON’), ‘dd “Monday for” fmMonthrrrr’)

What is the result?

Examine this command:
CREATE UNDO TABLESPACE undotbs01 DATAFILE ‘undotbs_01.dbf’ SIZE 100M AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

Which three statements are true about views in an Oracle database? (Choose three.)

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.

Examine this command:

SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);

Which segment or segments, if any, are created as a result of executing the command?

Choose the best answer . Which statement is true about database links?

Choose three. Which three statements are true about views in an Oracle
Database?