搜索博文结果_ChinaUnix博客

博客首页博客专家往日推荐博客文集

热搜： cISCO Python Oracle AIX 云计算虚拟化高性能负载均衡

博客首页〉搜索结果

按类别查询搜索结果

操作系统程序设计数据库热点技术综合架构与运维移动开发与应用 Web前端

关于关键词的检测结果，共 11229 条

【Oracle】 oracle18c rman备份使用11g的catalog遇到的问题

nocode | 2019-04-29 17:52:37 | 阅读(0) | 评论(0)

11g以前，当高版本数据库使用低版本catalog进行备份时，只需要rman之后连接catalog并执行升级命令即可，而在18c版本，由于变化的东西很多，于是遇到了一些问题，以下是问题及解决过程记录：catalog上创建用户及权限方法不变，首先连接本地和catalog是正常的：$ rman target / catalog rman18c/rman18c@catalogRecover...【阅读全文】

【Oracle】 OCP新题，2019题库出现大量新题，062-第22题

unix_5359 | 2019-04-29 13:30:57 | 阅读(1890) | 评论(0)

Your database is running in ARCHIVELOG mode.Which two statements are true in this scenario?B) The database must be in MOUNT state to take consistent RMAN backups.D) The database instance must be shut down to take a user-managed consistent backup.Answer：BD【阅读全文】

【Oracle】 OCP 12c题库出现大量新题，062新题-第21题

unix_5359 | 2019-04-29 10:14:11 | 阅读(1700) | 评论(0)

Which three statements are true about Oracle checkpoint processing?B) Frequent thread checkpoints can degrade database performance.D) It reduces the recovery time from instance failures.Answer：BCD【阅读全文】

【Oracle】 OCP 12c考试题，062题库出现大量新题-第20道

unix_5359 | 2019-04-29 09:27:26 | 阅读(1670) | 评论(0)

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken.In which three scenarios do you need media recovery?B) abnormal termination of the database instanceD) loss of a data file that belongs to the active undo tablespaceF) loss of all the copies ...【阅读全文】

【Oracle】 OCP考试062题库出现大量新题-19

unix_5359 | 2019-04-28 14:52:09 | 阅读(1640) | 评论(0)

Which three statements are true about Oracle Data Pump?B) IMPDP can be used to change target data file names, schemas, and tablespaces during import.D) EXPDP and IMPDP are the client components of Oracle Data Pump.Answer：BCD【阅读全文】

【Oracle】 OCP考试062题库出现大量新题-18

unix_5359 | 2019-04-28 13:56:34 | 阅读(1480) | 评论(0)

Examine this command executed on a client that is remote from the database server.Which two are required for this command to connect the SQLPLUS client to a database instance?B) An orcl TNS entry must be defined in the client-side tnsnames.ora file.D) The service name orcl must be defi...【阅读全文】

【Oracle】 OCP 062考试题库2019年新出现的考题-17

unix_5359 | 2019-04-28 13:17:47 | 阅读(1130) | 评论(0)

What is a pre-requisite to alter a role?B) You should be granted the DBA role.D) You should have the ALTER ANY ROLE system privilege.(解析：要修改role只要分配D答案的权限即可。来自3组：1015267481)【阅读全文】

【Oracle】【062有新题】OCP 12c 062出现大量之前没有的新考题-16

unix_5359 | 2019-04-26 15:46:07 | 阅读(990) | 评论(0)

Which users are created and can be used for database and host management of your DBaaS database servers?B) root, oracle and cloud usersD) opc and oracle usersAnswer：B用户对云计算的交付能力已经不再满足于单纯的基础设施(IaaS)交付，他们希望数据中心中的更多传统 IT 服务能以云服务模式进...【阅读全文】

【Oracle】【062新题】OCP 12c 062出现大量新题-15

unix_5359 | 2019-04-26 14:52:25 | 阅读(970) | 评论(0)

In your Oracle 12c database, you plan to execute the command:The u02 file system has 1 GB of free space available.A) It raises an error because extent management is not specified.C) It creates a dictionary-managed tablespace with manual segment space management enabled.Answer：B...【阅读全文】

【Oracle】【有新题】OCP 12c 062出现大量新考题-14

unix_5359 | 2019-04-26 14:17:02 | 阅读(960) | 评论(0)

choose twoYou plan to upgrade your Oracle Database 9i to Oracle Database 12c.Which two methods can you use?A) Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.B) Upgrade your current database to Oracle Database release ...【阅读全文】

【Oracle】【2019年OCP新题】OCP题库更新出现大量新题-11

unix_5359 | 2019-04-25 14:44:05 | 阅读(1090) | 评论(0)

You want to disable archiving for the database. Examine these steps:2. Execute shutdown immediate.4. Set the db_recovery_file_dest parameter to $ORACLE_HOME/dbs/.6. Open the database.Identify the required steps in the correct sequence.B) 1, 2, 3, 4, 6D) 2, 3, 1, 6...【阅读全文】

【Oracle】【2019年OCP新题】OCP题库更新出现大量新题-10

unix_5359 | 2019-04-25 13:04:23 | 阅读(1050) | 评论(0)

10.Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database?A) It can load data in parallel.B) No data file needs to be specified.C) It loads data faster than conventional SQL*Loader.D) lt loads data more efficiently than conventional SQL*Loader.E) It requires Enter...【阅读全文】

【Oracle】【OCP 062新题】OCP题库更新出现大量新题-9

unix_5359 | 2019-04-25 11:44:08 | 阅读(950) | 评论(0)

9.You ran this command on a source database:$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=empl.dmp VIEWS_AS_TABLES=emp_deptOn the target database, you run this command:impdp hr/hr DIRECTORY=dumpdir DUMPFILE=empl.dmp VIEWS_AS_TABLES=emp_deptWhich two statements are true?A) The expdp operation export...【阅读全文】

【Oracle】【ocp新题】OCP 12c 062认证考试出现大量新题-8

unix_5359 | 2019-04-25 11:04:04 | 阅读(930) | 评论(0)

8. Which are two ways for a database service to be recognized by a listener in Oracle Database 12c?A) Static registration in the listener.ora file using the service_name parameterB) Dynamic Registration by the smon processC) Static registration in the listener.ora file using the global_dbname par...【阅读全文】

【Oracle】【新题】OCP 062题库出现很多新题-6

unix_5359 | 2019-04-24 11:54:44 | 阅读(870) | 评论(0)

6.Which four statements are true about database instance behavior?A) Redo log files can be renamed in mount state.B) Datafiles can be renamed in mount state.C) All dynamic performance views (v$ views) return data when queried from a session connected to an Instance in nomount state.D) An spfile ...【阅读全文】

【Oracle】 OCP 12c 062题库大更新，出现大量新题-5

unix_5359 | 2019-04-24 11:07:30 | 阅读(1040) | 评论(0)

5.One of your databases supports an OLTP workload.The default undo tablespace is fixed size with:1. RETENTION NOGUARANTEE2. undo_retention is 12 minutesUser scott get this error after a query on the sales table has run for more than 15 minutes:ORA-01555: snapshot too oldWhich three factors tak...【阅读全文】

【Oracle】（2019）OCP 12c 062考试题库出现大量新题-4

unix_5359 | 2019-04-24 10:33:11 | 阅读(850) | 评论(0)

4.Which four are true about creating and running a remote database scheduler jobs?A) A credential is optional for a remote database job.B) A database destination group must exist or be created for a job to run on multiple remote databases.C) A destination is optional for a remote database job bec...【阅读全文】

【Oracle】 2019年新出现的ocp 062考试原题-2

unix_5359 | 2019-04-23 11:09:00 | 阅读(870) | 评论(0)

　　2.Which three statements are true about pfiles, spfiles or both?　　A) All spfile parameters can be modified successfully with the scope=both clause.　　B) A spfile can be created by an idle instance.　　C) spfiles and pfiles may both be edited with an O/S editing utility.　　D) Some spfile ...【阅读全文】

【Oracle】 12c ocp 062新考题（之前没出现过）-1

unix_5359 | 2019-04-23 10:44:13 | 阅读(1070) | 评论(0)

　　1.One of your databases has archive logging enabled and RMAN backups are taken at regular intervals.　　The data file for the users tablespace is corrupt.　　Which command must you execute before starting the recovery of this tablespace ?　　A) SWITCH DATAFILE ALL;　　B) ALTE...【阅读全文】

【Oracle】查询占据高水位的对象并Shrink释放空间

evan_china | 2019-03-14 15:17:29 | 阅读(6790) | 评论(0)

1. 查询占据高水位的对象select owner,table_name,object_type, count(1) num_objfrom (select e.owner, nvl(nvl(t.table_name,l.table_name),i.table_name) table_name, case when t.table_name is not null then 'TABLE'&nb...【阅读全文】

首页
<<
8
9
10
11
12
13
14
15
16
17
>>
末页

网络110 报警服务