ocp-1Z0-082_在线真题试卷与模拟练习_ocp-1Z0-082

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Which statement is true about the INTERSECT operator used in compound queries?

A database is configured to use automatic undo management with temporary undo enabled.

An UPDATE is executed on a temporary table. Where is the UNDO stored?

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

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.

The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

（含图）

Which statement is true?

You want to write a query that prompts for two column names and the WHERE condition each
Time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?

Examine the description of the CUSTOMERS table:

（含图）

You want to display details of all customers who reside in cities starting with the letter D followed

By at least two characters.

Which query can be used?

Evaluate the following ALTER TABLEstatement:
ALTER TABLE orders SET UNUSED (order_date);
Which statement is true?

Choose the best answer Evaluate the following SQL statement:
ALTER TABLE hr.emp
SET UNUSED (mgr_id);
Which statement is true regarding the effect of the above SQL statement?

Which statement is true about profiles? （choose one)

Which statement is true about the DEFAULT profile? （choose one）

A user establishes a connection to a database instance by using an Oracle Net connection.
You want to ensure the following:
1 The user account must be locked after five unsuccessful login attempts.
2 Data read per session must be limited for the user.
3 The user cannot have more than three simultaneous sessions.
4 The user must have a maximum of 10 minutes session idle time before being logged off
Automatically.
How would you accomplish this?

You execute this command: （含图）

Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace? (Choose two.)

Which three statements are true about advanced connection options supported by Oracle Net

For connection to Oracle Database instances? (Choose three.)

Which two statements are true about date/time functions in a session where
NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

Which three statements are true concerning logical and physical database structures? (Choose
Three.)

Which two statements are true regarding a SAVEPOINT? (Choose two.)

Which three functions are performed by dispatchers in a shared server configuration? (Choose
Three.)

Which two statements are true about the SET VERIFY ON command? (Choose two.)

Which three statements are true about a self-join? (Choose three.)

Examine this command:

（含图）

Which two statements are true? (Choose two.)

1 2

更多题库