网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
热门标签
最新试卷