OCP-082(2)_在线真题试卷与模拟练习_OCP-082(2)

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

What is true about non-equijoin statement performance?

NLS_DATE FORMAT is set to DD-MON-YY. Which query requires explicit data type conversion?（含图）

Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

Examine the description of the PRODUCTS table:

Which query is valid?

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?

Examine the description of the SALES1 table: SALES2 is a table with the same description as

SALES1. Some sales data is duplicated in both tables. You want to display the rows from the

SALES1 table which are not present in the SALES2 table. Which set operator generates the required

output?

Your database instance is started with a PFILE. Examine these parameters: You want to increase

the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You

execute the command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M; What is the

outcome?

Your database instance is started by using a server parameter file (SPFILE). You execute the

following command to change the value of the LOG_BUFFER initialization parameter: ALTER

SYSTEM SET LOG_BUFFER=32M; What is the outcome of this command?

Choose the best answer. Examine this scenario: connect / as sysdba Connected. SHUTDOWN

TRANSACTIONAL Database closed. Database dismounted. ORACLE instance shut down.

STARTUP Now examine these steps: 1. Oracle instance is started. 2. The control file is read. 3.

Instance recovery is started. 4. Datafiles and redo log files are opened. 5. The spfile or pfile is read. 6.

The database is available for use. 7. The database is mounted. 8. Instance recovery is completed.

Identify the correct steps and the order they will be executed in following this command:

Choose the best answer. All of your database instances use SPFILES. You executed this command

in one of them: ALTER SYSTEM SET MEMORY_ MAX_ TARGET=1024M; Which statement is true?

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. Each database has a tnsnames.ora file defining DALLAS_DB as a service name. Examine this command: CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

Which statement is true regarding the INTERSECT operator?

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?

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?

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: CUUG,What will be the result?

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

Examine this command and some partial output: Why does the DB01.abc.com service show

unknown status?

Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which

statement is true?

choose one Examine the parameters for a database instance: NAME TYPE VALUE

temp_undo_enabled boolean TRUE undo_ management string AUTO undo _retention Integer 900

undo _tablespace string UNDOTBS1 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？

1 2 3 4 5 6