搜索博文结果_ChinaUnix博客

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

热搜：服务器存储 .net Java C语言 Python 项目管理移动开发

博客首页〉搜索结果

按类别查询搜索结果

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

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

【Oracle】【第59题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-07-18 10:54:40 | 阅读(1250) | 评论(0)

Which three statements are true about naming methods?B) The local naming method does not support connect-time failover and load-balancing options.D) Local naming supports multiple protocols, but for any one connection, the client and server must use the same protocol.Answer：AD...【阅读全文】

【Oracle】【第58题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-07-17 10:01:16 | 阅读(610) | 评论(0)

Which two statements are true about Oracle network connections?B) A server process checks a user's authentication credentials and creates a session if the credentials are valid.D) The listener always spawns a new server process to deal with each new connection.Answer：BC【阅读全文】

【Oracle】【第57题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-07-17 09:27:08 | 阅读(660) | 评论(0)

Which statement is true about a database in ARCHIVELOG mode?B) A Fast Recovery Area (FRA) must be configured for the database.D) All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.(解析：归档模式下可以进行热备，归档之前的备份是不能用来做完...【阅读全文】

【Oracle】 select count(*)和count(列名)的区别说明

dbwatcher | 2019-07-15 16:37:43 | 阅读(6900) | 评论(1)

博客文章除注明转载外，均为原创。转载请注明出处。count(*)对行的所有数目进行计算，包含NULL值的行。count(column)对特定的列的值具有的行数进行计算，不包含NULL值的行。count(1)的结果和count(*)的结果是一样的。小例子：sys@orcl-192.168.0.21> select count(*) from v$session; COUNT(*)----------&...【阅读全文】

【Oracle】【第56题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-07-04 09:55:51 | 阅读(680) | 评论(0)

In your database, USERS is the default permanent tablespace.SQL> CREATE USER user02 identified by us123 QUOTA 10M ON users;SQL> GRANT create session, sysdba TO user02;You plan to execute the commands:SQL> CREATE TABLE mytab (id number, lname varchar2(20));A) The MYTAB table is ...【阅读全文】

【Oracle】【第55题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-07-04 09:22:20 | 阅读(730) | 评论(0)

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo.A) Increase the size of the redo log buffer.C)...【阅读全文】

【Oracle】【第54题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-06-27 14:02:41 | 阅读(1270) | 评论(0)

Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class?B) A scheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler windowD) A scheduler window can control resourc...【阅读全文】

【Oracle】【第53题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-06-27 13:15:39 | 阅读(1000) | 评论(0)

The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:FROM employeesHR then opens a second session.A) SELECT job FROM employees WHERE job='CLERK' FOR UPDATE OF empno;C) SELECT em...【阅读全文】

【Oracle】【第52题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-06-26 15:54:37 | 阅读(1350) | 评论(0)

When is the UNDO_RETENTION parameter value ignored by a transaction?B) when the undo tablespace is of a fixed size and retention guarantee is not enabledD) when the data file of the undo tablespace is autoextensible(解析：启用闪回数据库时，对undo_retention这个参数是没有任何关系，其它的...【阅读全文】

【Oracle】【第51题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-06-26 14:33:27 | 阅读(990) | 评论(0)

The HR. DEPARTMENTS table is the parent of the HR. EMPLOYEES table. The EMPLOYEES .Which statement is true?B) The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS ...【阅读全文】

【Oracle】【第50题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-06-26 14:06:56 | 阅读(990) | 评论(0)

Which two statements are true about the Database Configuration Assistant (DBCA)?B) It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.D) It can be used to create a database template from an existing database.Answer：DE...【阅读全文】

【Oracle】【第49题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-06-04 15:22:30 | 阅读(950) | 评论(0)

Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM).A) by using a transportable databaseC) by using the Database Upgrade Assistant (DBUA)Answer：D【阅读全文】

【Oracle】【第48题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-06-04 14:35:29 | 阅读(950) | 评论(0)

Which two statements are true about using SQL*Loader?B) It can generate unique sequential key values in specified columns.D) It can load data from external files by using direct path only.Answer：BC/ Load data into multiple tables during the same load session.different system f...【阅读全文】

【Oracle】【第47题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-06-04 14:00:10 | 阅读(990) | 评论(0)

Your database instance is started with a PFILE.NAME TYPE VALUEmemory_target big inte...【阅读全文】

【Oracle】玩一把redis源码(一):为redis添加自己的列表类型

法典化健 | 2019-06-03 14:13:43 | 阅读(600) | 评论(0)

同时也再次感受到良好的基础是深入学习的前提。特别强调本文档仅用于学习，并非是要修改redis源码。建议读者阅读本文档时实际动手敲一下代码，然后翻阅下redis源码，debug下redis本文档分为三大部分：实现命令redis原生命令命令含义...【阅读全文】

【Oracle】 Oracle RAC集群测试-生产环境最佳方法（Oracle 11g/12c/18c/19 RAC）

于秋1217 | 2019-05-30 17:37:31 | 阅读(11340) | 评论(0)

生产环境Oracle RAC集群测试最佳方法（支持Oracle 11g/12c/18c/19c RAC安装后期测试过程）【阅读全文】

【Oracle】【第46题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-05-30 16:59:56 | 阅读(1370) | 评论(0)

Examine this command:Which two statements are true?B) The Alert Log still contains some DDL statements.D) All data definition language (DDL) statements are written to the control file.F) Some DDL statements are written to an XML file in the ADR home.(解析：打开 DDL 跟踪后，要...【阅读全文】

【Oracle】【第45题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-05-30 13:29:19 | 阅读(1450) | 评论(0)

Which three statements are true about the purpose of checkpoints?B) They ensure that dirty buffers in the buffer cache are written to disk regularly.D) They ensure that all the dirty buffers are written to disk during a normal shutdown.Answer：BCD【阅读全文】

【Oracle】【第44题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-05-30 10:31:52 | 阅读(1390) | 评论(0)

Which three statements are true about a job chain?B) It cannot invoke the same program or nested chain in multiple steps in the chain.D) It can be executed using event-based schedules.F) It cannot have more than one dependency.(解析：job chain可以基于时间、事件或者基于依赖行的工作...【阅读全文】

【Oracle】【第43题】【062题库】2019年OCP认证062考试新题

unix_5359 | 2019-05-28 13:05:34 | 阅读(1540) | 评论(0)

Which two services may you see on the My Service Dashboard page?B) Network Cloud ServiceD) Compute Cloud Service(解析：这道题考的是Oracle云服务相关的问题，超出了数据库知识点的范畴，有点宣传产品的目的。如果您注册了一个支持通用信用的付费Oracle云帐户(通过Oracle销售或您自己)，或者如果您是...【阅读全文】

首页
<<
1
2
3
4
5
6
7
8
9
10
>>
末页

网络110 报警服务