1. 云栖社区>
  2. 全部标签>
  3. #052#
052

#052#

已有0人关注此标签

内容分类:
博客 | 问答 | 视频 | 资料 |

OCP-052考试题库汇总(42)-CUUG内部解答版

You successfully executed these commands: connect scott/tiger@prod1; CREATE DATABASE LINK db_prod2 CONNECT TO scott IDENTIFIED BY tiger USING 'PROD2'...

Oracle BY Create database OCP cuug 052

OCP-052考试题库汇总(41)-CUUG内部解答版

Examine this session output: SQL> connect scott/tiger Connected. SQL>select name,value 2 from v$parameter 3 where name='audit_trail'; NAME VALUE ----...

Oracle SQL 数据库 操作系统 DB BY xml DML session update OCP cuug 052

OCP-052考试题库汇总(39)-CUUG内部解答版

Which three are true about auditing? A)Auditing is active only when the database is OPEN. B)Audit records are always stored in the database.

Oracle 数据库 操作系统 database OCP cuug 052

OCP-052考试题库汇总(37)-CUUG内部解答版

Examine these facts about objects in the SYSTEM schema: 1.EMP is a table. 2.EMP_PK is a primary key constraint on EMP.

Oracle 索引 序列 存储过程 OCP cuug 052

OCP-052考试题库汇总(35)-CUUG内部解答版

Which two are true about Oracle Data Pump in Oracle Database 11g Release 2? A)If the directory used in the export operation has existing dump files, it overwrites them.

加密 Oracle database IT OCP cuug 052

OCP-052考试题库汇总(34)-CUUG内部解答版

Where is an expdp operation tracked? A)dump files B)control file C)log files D)Automatic Diagnostic Repository(ADR) E)master table (MT) Answer: E 赵: 题译:哪里有一个 Exdp 操作跟踪? Master table 是一个临时 table,专门为 import pump 和 export pump 创建的,一旦完成就会自动被 drop。

Oracle LOG file dump OCP cuug 052

OCP-052考试题库汇总(33)-CUUG内部解答版

Which two can be exported by a non-administrative account by using Data Pump? A)directory objects B)tables C)tablespaces D)schemas E)database Answer: BD 赵: EXP 和 IMP 是客户端工具程序,它们既可以在客户端使用,也可以在服务端使用。

Oracle 数据库 database account OCP cuug 052

OCP-052考试题库汇总(32)-CUUG内部解答版

Which state must a database be to enable ARCHIVELOG ? A)NOMOUNT B)OPEN IN READ WRITE mode C)OPEN IN READ ONLY mode D)OPEN IN RESTRICTED mode E)MOUNT ...

Oracle 日志 数据库 open database read OCP cuug 052

OCP-052考试题库汇总(31)-CUUG内部解答版

which four are true about the tools used to administer Oracle database? A)the Data Pump utility can be used to load data from text files.

rman Oracle SQL 数据库 RAC Create database OCP cuug 052

OCP-052考试题库汇总(30)-CUUG内部解答版

Which two are true about the Inventory directory? A)It is shared by all Oracle software installations on a single server.

服务器 Oracle Server database Group IT single OCP cuug 052

OCP-052考试题库汇总(29)-CUUG内部解答版

When does an incremental checkpoint occur ? A)when an online redo log switch occurs. B)when DBWn writes dirty buffers as part of its normal processing.

Oracle LOG Processing file OCP cuug 052

OCP-052考试题库汇总(28)-CUUG内部解答版

Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’. The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, and not specified.

rman 服务器 Oracle LOG 数据库 database OCP cuug 052

OCP-052考试题库汇总(27)-CUUG内部解答版

Which two of these must be available READ/WRITE to keep a database open? A)all copies of the control file.

Oracle LOG open database file read Group OCP cuug 052

OCP-052考试题库汇总(26)-CUUG内部解答版

Which three of these must be accessible to keep a database open? A)Control file. B)All members of a redo log group. C)SYSTEM tablespace. D)SYSAUX tablespace. E)spfile Answer: ABC 赵: 1 nomount:实例已经启动,进程和内存已经分配。

Oracle LOG 数据库 open database file OCP cuug 052

OCP-052考试题库汇总(25)-CUUG内部解答版

Which four database objects never have any segments? A)A partitioned index B)A view selecting from a populated table C)An empty index D)An Oracle Loader type external table E)An empty table F)A view selecting from an empty table G)An Oracle Data Pump type external table Answer: BDFG 赵:视图和外部表不存在段。

Oracle 数据库 index database type view OCP cuug 052

OCP-052考试题库汇总(24)-CUUG内部解答版

Which structure can span multiple data files? A)a bigfile tablespace B)a permanent tablespace C)a segment D)a temporary tablespace E)an extent Answer...

Oracle OCP cuug 052

OCP-052考试题库汇总(23)-CUUG内部解答版

11g版本的OCP考试持续了好几年,一直比较稳定,直到2018年4月份左右,052考试不断的出现新的考题,虽然我们收集整理了不少,但新题还是难避免,这样出现一部分新题,我们收集一部分,持续了不短的时间。

Oracle 表空间 存储 OCP cuug 052

4
GO