OCP试题1

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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?

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 want write a query that prompts users for column names and conditions every time it is executed.
The user must be prompted only once for the table name.
Which statement achieves those objectives?

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

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:
LISTENER_1 =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 172.32.230.134)
(PORT = 1521)
)
Which statement is true?

Which statement is true about database links?

Examine this query:
SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL;
What is the result?

Examine the description of the EMPLOYEES table:
Name Null? Type
------------------ -------------- -------------
EMP_ID NOT NULL NUMBER
EMP_NAME VARCHAR2(10)
DEP_ID NUMBER(2)
SALARY NUMBER(8,2)
JOIN_DATE DATE
NLS_DATA_FORMAT is set to DD-MON-YY.
Which query requires explicit data type conversion?

Why would you use the TNSPING hr command?

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

as the DBA, you execute this command:

Grant craete view to usr1 with admin option;

Usr1 then execute this command:

Grant create view to usr2 with admin option;

Usr2 then execute this command:

Grant create view to usr3;

Which statement is true?

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

You database instance is started with an SPFILE.

A PFILE is also available.

You execute this command:

Alter system set db_cache_size=100k;

Where is the value changed?

Which two Oracle database space management features require the use of locally managed tablespaces?

You execute this command:
CREATE BIGFILE TABLESPACE BIG_TBS ‘/u01/oracle/data/big_f1.dbf’ DATAFILE SIZE 20G;
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace?

Which three functions are performed by dispatchers in a shared server configuration?

Which three statements are true about dynamic performance views?

Which three statements are true about inner and outer joins?

In which three situations does a new transaction always start?

Which three statements are true regarding indexes?