搜索博文结果_ChinaUnix博客

由于近期受疫情的影响，Pearson VUE暂时关闭了中国大陆的考试中心，并暂停至 2020 年 3 月底。如您所持有的Oracle考券尚在有效期内，我们将自动为您的考劵延长3个月有效期。针对2020年2月29日到期的考劵，有效期将自动被延长至2020年5月31日。如果想要了解更多关于oracle认证内容，请联系北京CUUG...【阅读全文】

【Oracle】【2019年8月版】OCP 071认证考试原题-第37题

unix_5359 | 2019-11-27 09:44:09 | 阅读(1170) | 评论(0)

Examine the description of the PRODUCT_INFORMATION table:------------------------------------------------------------------------PROD_NANE VARCRAR2 (10)Which query retrieves the number of products with a null list price?B) SELECT Count(nvl( l...【阅读全文】

【Oracle】【2019年8月版】OCP 071认证考试原题-第36题

unix_5359 | 2019-11-25 10:17:30 | 阅读(1210) | 评论(0)

Which three statements are true about sequences in a single instance Orade database?B) Two or more tables cannot have keys generated from the same sequence.D) A sequence can issue duplicate values.F) A sequence can only be dropped by a DBA.(解析：虚拟可以一下子产生一组的数字缓存在...【阅读全文】

【Oracle】【2019年8月版】OCP 071认证考试原题-第35题

unix_5359 | 2019-11-25 09:40:24 | 阅读(1160) | 评论(0)

Which two statenents are tue about the COUNT function?B) COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing dupicates and NULLs in the INV_AMT columnD) A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.Answer：：BC...【阅读全文】

【Oracle】【2019年8月】OCP 071认证考试最新版本的考试原题-第27题

unix_5359 | 2019-11-14 13:26:48 | 阅读(1310) | 评论(0)

Which two statements are true about the DUAL table?B) It can be accessed only by the SYS user.D) It can display multiple rows but only a single column.F) It can be used to display only constants or pseudo columns.(解析：dual 这个虚拟的表可以显示多行多列;任何用户都可以访问它。这道题...【阅读全文】

【Oracle】【2019年8月】OCP 071认证考试最新版本的考试原题-第24题

unix_5359 | 2019-11-06 10:08:36 | 阅读(750) | 评论(0)

Which three statements are true about GLOBAL TEMPORARY TABLES?B) A GLOBAL TEMPORARY TABLE can have multiple indexesD) Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.F) A tigger can be created on a GLOBAL TEMPORARY TABLE(解析：全局临时表跟普通表一样，...【阅读全文】

【Oracle】【2019年8月】OCP 071认证考试最新版本的考试原题-第22题

unix_5359 | 2019-11-04 10:49:06 | 阅读(680) | 评论(0)

Which two statements are true about transactions in the Oracle Database serve?B) Data Manipulation Language (DML) statements always start a new transaction.D) A Data Detiniton Language (DDL) statement does a commit automatially only for the data dictionary updates caused by the DDLF) I...【阅读全文】

【Oracle】【2019年8月】OCP 071认证考试最新版本的考试原题-第21题

unix_5359 | 2019-11-04 10:18:09 | 阅读(860) | 评论(0)

In the PROMOTIONS table, the PROMO_BEGTN_DATE columm is of datatype DATE and the default date format is DD-MON-RR.A) TO_NUMBER(PROMO_ BEGIN_DATE) - 5 will return numberC) PROMO_BEGIN_DATE - SYSDATE will return a number.E) PROMO_BEGIN_DATE - SYSDATE will return an error.(解析：这道...【阅读全文】

【Oracle】【2019年8月】OCP 071认证考试最新版本的考试原题-第16题

unix_5359 | 2019-10-25 14:59:53 | 阅读(900) | 评论(0)

Examine this partial command:cust_id NUMBER(2),)Which two clauses are required for this command to execute successfully?B) the REJECT LIMIT clauseD) the ACCESS PARAMETERS clauseAnswer：AD【阅读全文】

【Oracle】【2019年8月】OCP 071认证考试最新版本的考试原题-第15题

unix_5359 | 2019-10-25 14:13:42 | 阅读(770) | 评论(0)

Examine the description of the PRODUCTS table:-----------------------------------------------------------------PRODUCT_NANE VARCHAR2(10)PURCHARGE &nb...【阅读全文】

【Oracle】【2019年8月版本】OCP 071认证考试最新版本的考试原题-第12题

unix_5359 | 2019-10-21 11:39:52 | 阅读(850) | 评论(0)

Which three statements are true about dropping and unused columns in an Oracle database?B) A DROP COLUMN command can be rolled backD) An UNUSED column's space is redaimed automatially when the row containing that column is next queried.F) A column that is set to NNUSED still counts tow...【阅读全文】

【Oracle】【2019年8月版本】OCP 071认证考试最新版本的考试原题-第11题

unix_5359 | 2019-10-21 10:25:04 | 阅读(650) | 评论(0)

Which two statements are true about a self join?B) It can be a left outer join.D) It can be an inner join.Answer：BD不过在进行内连接时为了区别表的名字，需要加别名from emp2 won w.mgr=m.empno;)【阅读全文】

【Oracle】【2019年8月版本】OCP 071认证考试最新版本的考试原题-第10题

unix_5359 | 2019-10-18 14:51:08 | 阅读(1030) | 评论(0)

Which two statements are true about Oracle synonyms?B) All private synonym names must be unique in the database.D) A synonym can be created on an object in a package.(解析：同义词也是 Oracle 的一个对象;【阅读全文】

【Oracle】【2019年8月版本】OCP 071认证考试最新版本的考试原题-第9题

unix_5359 | 2019-10-18 09:36:29 | 阅读(660) | 评论(0)

Which three statements are true about views in an Orade batabase?B) Rows inserted into a table using a view are retained in the table if the view is doppedD) Views have no segment.F) A view can be created that refers to a non-existent table in its defining query.(解析：...【阅读全文】

【Oracle】【2019年8月版本】OCP 071认证考试最新版本的考试原题-第8题

unix_5359 | 2019-10-17 11:49:07 | 阅读(620) | 评论(0)

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATEThe NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day ofthe weekA) SELECT emp_id,NEXT_DAY(ADD_MONTHS(hite_date,6), 'MONDAY') FROM employees;C) S...【阅读全文】

【Oracle】【2019年8月版本】OCP 071认证考试最新版本的考试原题-第7题

unix_5359 | 2019-10-17 09:52:27 | 阅读(610) | 评论(0)

Which three are true about granting object privileges on tables, views, and sequences?B) DELETE can be granted on tables, views, and sequences.D) INSERT can be granted on tables, vews, and sequences.F) ALTER can be granted only on tables and sequences.(解析：update 和 delete 只能在...【阅读全文】

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

网络110 报警服务