ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-12-16 15:04:35
Which two statements are true about single row functions?B) MOD : returns the quotient of a division operationD) FLOOR : returns the smallest integer greater than or equal to a specified numberAnswer：：CEceil 函数向上取整数。SQL> select ceil(-500.1) from dual;------------.........【阅读全文】
发布时间：2019-12-16 13:26:53
Exanine the desatption of the BOOKS_TRANSACTIONS table----------------------------------------------------------------------------------------------TRANSACTION_TYPE VARCHAR2(3)BOOK_ID .........【阅读全文】
发布时间：2019-11-27 09:44:09
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.........【阅读全文】
发布时间：2019-11-25 10:17:30
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.(解析：虚拟可以一下子产生一组的数字缓存在.........【阅读全文】
发布时间：2019-11-25 09:40:24
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.........【阅读全文】
