网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?()
A

16 

B

100 

C

160 

D

200 

E

150


参考答案

参考解析
解析: 暂无解析
更多 “单选题Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?()A 16 B 100 C 160 D 200 E 150” 相关考题
考题 语句select ROUND(45.953,-1),TRUNC(45.936,2)from dual;的结果是()。 A.46 and 45B.46 and 45.93C.50 and 45.93D.50 and 45.9

考题 用SQL命令生成含有字段职工号、姓名的视图,下列语句正确的是______。A.CREATE VIEW ZG w AS SELECT职工号,姓名FROM职工B.CREATE QUERY ZG w AS SELECT职工号,姓名FROM职工C.CREATE VIEW ZG w AS SELECT职工号,姓名D.CREATE QUERY ZG w AS SELECT职工号,姓名

考题 Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?()A. User processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)

考题 The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? () A. GRANT select ON dept TO ALL_ USER;B. GRANT select ON dept TO ALL;C. GRANT QUERY ON dept TO ALL_USERSD. GRANT select ON dept TO PUBLIC;

考题 Evaluate the SQL statement:SELECT ROUND(45.953, -1), TRUNC(45.936, 2)FROM dual;Which values are displayed? () A. 46 and 45B. 46 and 45.93C. 50 and 45.93D. 50 and 45.9E. 45 and 45.93F. 45.95 and 45.93

考题 Evaluatethefollowingquery:SQL>SELECTTRUNC(ROUND(156.00,-1),-1)FROMDUAL;Whatwouldbetheoutcome?() A.16B.100C.160D.200E.150

考题 Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed?() A.B.C.D. The query fails because the subquery returns more than one row.E. The query fails because the outer query and the inner query are using different tables.

考题 SQL是 ______的缩写。A.Standard Query LanguageB.Structured Query LanguageC.Select Query LanguageD.以上都不是

考题 SQL是哪几个英文单词的缩写?A.Standard Query LanguageB.Structured Query LanguageC.Select QueryL anguageD.以上都不是

考题 Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?()A.AB.BC.CD.DE.E

考题 SQL是哪几个英语单词的缩写()A、Standard Query LanguageB、Structured Query LanguageC、Select Query LanguageD、其他三项都不是

考题 SQL是那几个英文单词的缩写()A、Standard Query LanguageB、Structured Query LanguageC、Select Query LanguageD、以上都不是

考题 SQL是()英文单词的缩写。A、Structured Query LanguageB、Standard Query LanguageC、Select Query LanguageD、以上都不是

考题 A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?()A、AliasB、ViewC、SchemaD、Trigger

考题 Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?()A、0B、1C、0.00D、An error statement

考题 Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?()A、16 B、100 C、160 D、200 E、150

考题 A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL connect smith/smith  Connected.  SQL SELECT * FROM v$session;  SELECT * FROM v$session *  ERROR at line 1:  ORA-00942: table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION()A、granting SELECT privilege to SMITH on V$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

考题 Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? ()A、46 and 45B、46 and 45.93C、50 and 45.93D、50 and 45.9E、45 and 45.93F、45.95 and 45.93

考题 语句select ROUND(45.953,-1),TRUNC(45.936,2)from dual;的结果是()。A、46 and 45B、46 and 45.93C、50 and 45.93D、50 and 45.9

考题 单选题语句select ROUND(45.953,-1),TRUNC(45.936,2)from dual;的结果是()。A 46 and 45B 46 and 45.93C 50 and 45.93D 50 and 45.9

考题 单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:   SQL SELECT * FROM sales;   Which process would retrieve the result from the database and return it to the client program?()A  User processB  Server processC  System Monitor (SMON)D  Process Monitor (PMON)E  Checkpoint process (CKPT)

考题 单选题Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?()A 46 and 45B 46 and 45.93C 50 and 45.93D 50 and 45.9E 45 and 45.93F 45.95 and 45.93

考题 单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()A User processB Server processC System Monitor (SMON)D Process Monitor (PMON)E Checkpoint process (CKPT)

考题 单选题Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?()A 0B 1C 0.00D An error statement

考题 单选题The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()A GRANT select ON dept TO ALL_ USER;B GRANT select ON dept TO ALL;C GRANT QUERY ON dept TO ALL_USERSD GRANT select ON dept TO PUBLIC;

考题 单选题A user named Arren is executing this query:   select table_name,operation,undo_sql  from  flashback_transaction_query t,  (select versions_xid as xid  from employees versions between scn minvalue and maxvalue  where employee_id = 123) e  where t.xid = e.xid;   When the query runs,he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table,you know that it is not the problem.  Which of the following SQL statements will correct this problem?()A  GRANT SELECT ANY TRANSACTION TO ARRENB  GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARRENC  GRANT SELECT_ANY_TRANSACTION TO ARREND  GRANT FLASHBACK TO ARRENE  GRANT SELECT ANY VIEW TO ARREN

考题 单选题EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?()A Exhibit AB Exhibit BC The query returns no rowsD The query fails because the outer query is retrieving more than one columnE The query fails because both the inner and outer queries are retrieving data from the same table.