【2026年最新】OPC -082 （OPC082）甲骨文Oracle数据库管理I 19c OPC 1Z0-082 认证题库

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Examine the description of the EMPLOYEES table:
（含图）

Which query is valid?&nbsp;

Choose the best answer.

Why would you use the TNSPING hr command?

Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance.

What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

Examine the description of the SALES1 table:&nbsp;

（含图）

SALES2 is a table with the same description as SALES1.
Some sales data is contained erroneously in both tables.
You must display rows from SALES1 and SALES2 and wish to see the duplicates too.
Which set operator generates the required output?

Choose the best answer. Examine these statements:&nbsp;

CREATE TABLE alter_test ( c1 VARCHAR2 ( 10), c2 NUMBER( 10)) ; INSERT INTO alter_test VALUES ('123', 123) ;&nbsp;

COMMIT ;&nbsp;

Which is true about modifying the columns in ALTER_TEST?

choose one.Which statement is true about the DEFAULT profile?

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 on the wee. Which query can be used?

Choose the best answer. Which compression method is recommended for Direct-Path Insert operations?

In your database,you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

Choose the best answer. Examine this statement which returns the name of each
Employee and their manager:
SELECT elast_name AS emp, m.1ast_name AS mgr FROM employees e JOIN managers m
ON

Which statement is true about database links?

You are administering a database and you receive a requirement to apply t he following restrictions:

1. A connection must be terminated after four unsuccessful login attempts by user.

2. A user should not be able to create more than four simultaneous sessions.

3. User session must be terminated after 15 minutes of inactivity.

4. Users must be prompted to change their passwords every 15 days.

How would you accomplish these requirements?

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?

Choose the best answer.

Examine the description of the PRODUCTS table:&nbsp;

Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Null &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Type

PROD_ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NOT NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NUMBER&nbsp;

PROD_NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VARCHAR2 (40)&nbsp;

COST &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NUMBER(8,2)

RELEASE_DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DATE

Which query is valid?

Choose the best answer.

Examine this statement:

SELECT 1 AS id, 'John' AS first_name, NULL AS commission

FROM DUAL

INTERSECT

SELECT 1, 'John' ,NULL

FROM DUAL

ORDER BY 3;

What is returned upon execution?

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

Choose the best answer. Examine these statements which execute successfully:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS' ;
ALTER SESSION SET TIME_ZONE = '-5:00' ;
SELECT DBTIMEZONE, SYSDATE FROM DUAL;
Examine the result:
DBTIMEZONE SYSDATE
------------- ------------------------------------------
+00.00 11- JUL-2019 11:00:00
�
If LOCALTIMESTAMP was selected at the same time, what would it return?

You plan to create a database by using the Database Configuration Assistant (DBCA), with the 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 the execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the Database?

An Oracle Database session has an uncommitted transaction in progress which
Updated 5000 rows in a table.
In which three situations does the transaction complete thereby committing the
Updates?

更多题库