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

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

Which statement is true regarding the INTERSECT operator?

Which two statements are true about single row functions? (Choose two.)

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

In one of your databases, the user HR has the password HRMGR.

You want to connect to a database instance whose listener listens on port 1531 by using this statement:

CONNECT HR/HRMGR@orcl No name server is used.

Which statement is true about ORCL?

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

Examine the description of the PROMOTIONS table: You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

Examine the description of the PROMOTIONS table: Management requires a report of unique promotion costs in each promotion category.

Which query would satisfy this requirement?

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:

1). A size of 100 MB

2). AUTOEXTEND is off

3). UNDO_RETENTION is set to 15 minutes

4). It has RETENTION GUARANTEE UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.

What will happen when the next update is attempted by any transaction?

Which two statements are true about the rules of precedence for operators? (Choose two.)

In one of your databases, user KING is: 1. Not a DBA user 2. An operating system

(OS) user Examine this command and its output: What must you do so that KING is authenticated by the OS when connecting to the database instance?

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.

You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval. Examine this SQL statement: What will be the result?

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

Which two statements are true about the DUAL table? (Choose two.)

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

Examine the description of the EMPLOYEES table: Which query is valid?

What is true about non-equijoin statement performance? (Choose two.)

In your data center, Oracle Managed Files (OMF) is used for all databases.

All tablespaces are smallfile tablespaces.

SALES_1 is a permanent user-defined tablespace in the SALES database.

Examine this command which is about to be issued by a DBA logged in to the SALES

Database: ALTER TABLESPACE sales_1 ADD DATAFILE;

Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

1 2 3 4 5 6 15