OCP-082

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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?

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
(1) Be stored in a format supporting date arithmetic without using conversion functions
(2) Store a loan period of up to 10 years
(3) Be used for calculating interest for the number of days the loan remains unpaid
Which data type should you use?

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.
The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson.
Which query produces output for CUST_LAST_NAME containing Oder for the first row and Aus for the second?

Which statement is true about aggregate functions?

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE .You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week.
Which query can be used?

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.

Table COSTS

（含图）

What will be the result?

Which statement is true about database links?

Which two statements are true about the PMON background process?

Which two statements are true about the PMON background process?

Which three statements are true concerning logical and physical database structures?

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

Which three instance situations are possible with Oracle Database server without multi-tenant?

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

Segment creation is not deferred.

You execute this command:

（含图）

Which three statements must be true so that the sales user can create tables in SALES_Q1?

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which two are types of analyses that can be done using the DBMS_PRIVILEGE_CAPTURE package?

Which four account management capabilities can be configured using Oracle profiles?

Which are two of the account management capabilities that can be configured using Oracle profiles?

Which two statements are true about User Authentication in an Oracle Database?

Which three statements are true about roles?

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPION;
Which three actions can HR perform?