Oracle基础练习题及答案11_练习版.pdfVIP

*************************************************************************************** 试题说明 本套试题共包括1套试卷 答案和解析在每套试卷后 Oracle基础练习题及答案11(400题) *************************************************************************************** Oracle基础练习题及答案11 1.[单选题]当需要删除视图时，用户可以使用（ ）语句删除视图。 A)DROP VIEW B)DELETE VIEW C)MODIFY VIEW D)ATLER VIEW 2.[单选题]View the Exhibit and examine the structure of the PRODUCTS table. style=width: auto; class=fr-fic fr-fil fr-dib cursor-hoverYou must display the category with the maximum number of items. You issue this query: style=width: auto; class=fr-fic fr-fil fr-dib cursor-hoverWhat is the result? A)It generates an error because = is not valid and should be replaced by the IN operator. B)It executes successfully but does not give the Answer: output. C)It executes successfully and gives the Answer: output. D)It generate an error because the subquery does not have a GROUP BY clause. 3.[单选题]You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.Which service will you need to connect to? A)TP B)Low C)MEDIUM D)TPURGENT 4.[单选题]下面关于主事务处理和自主事务处理的说法错误的是( ) A)自主事务处理结果的变化不倚赖于主事务处理的状态 B)自主事务处理提交或回退时，不影响主事务处理的结果 C)自主事务处理提交，对主事务处理是不可见的 D)自主事务处理还可以启动其他自主事务处理 Create proc p1 Begin Insert ….. P2(); 5.[单选题]在Oracle中，执行下面的语句： SELECT ceil(-97.342), Floor(-97.342), -123.01 -124 Round(-97.342), Trunc(-97.342) FROM dual; 哪个函数的返回值不等于-97( )。 A)ceil() B)floor() C)round(0) D)trunc() 6.[单选题]在Oracle中，关于子程序的描述不正确的是（ ）。 A)子程序是已命名的PL/SQL 块，可带参数并可在需要时随时调用 B)子程序可以具有声明部分、可执行部分和异常处理部分 C)子程序参数的模式只有IN 和OUT 两种模式 D)子程序可分为过程和函数两种类型 7.[单选题]What is the main use case for REST APIs? A)Monitoring Development B)DevOps only C)Monitoring only D)Monitoring, DevOps, Development 8