一、 原题View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.Simila
转载
精选
2015-08-03 19:05:01
409阅读
一、原题 Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three)A. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;B. SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL;C. SELECT T
转载
精选
2015-08-03 19:10:46
696阅读
一、原题View the Exhibit; examine the structure of the PROMOTIONS table.Each promotion has a duration of at least seven days.Your manager has asked you to generate a report, which provides the weekly cost
转载
精选
2015-08-03 19:16:45
435阅读
一、原题Examine the structure of the SHIPMENTS table:Name Null &nbs
转载
精选
2015-08-03 19:19:51
363阅读
一、原题View the Exhibit to examine the description for the SALES table.Which views can have all DML operations performed on it? (Choose all that apply.) A. CREATE VIEW v3AS SELECT * FROM SALESWHERE
转载
精选
2015-08-03 19:06:08
379阅读
一、原题Which two statements are true regarding single row functions? (Choose two.)A. They accept only a single argument.B. They can be nested only to two levels.C. Arguments can only be column values or
转载
精选
2015-08-03 19:09:37
269阅读
一、原题 View the Exhibit and examine the structure of the CUSTOMERS table.Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two) A. listing of cust
转载
精选
2015-08-03 19:14:54
403阅读
一、原题Which statement is true regarding the INTERSECT operator?A. It ignores NULL values.B. Reversing the order of the intersected tables alters the result.C. The names of columns in all SELECT statemen
转载
精选
2015-08-03 19:15:40
542阅读
查看Oracle用户可以使用那些表数据字典表(管理用户所有表)descuser_tables;(查看可以操作的表)selecttables_namefromuser_tables;(SCOTT用户可以使用四个表)字符类型都是左对齐，数字类型的都是右对齐空值是不可用的、未分配的、未知的或不使用的值空值不同于零或空格设置显示行间距setlinesize200;宽度为200setpagesize50;每
原创
2019-09-03 17:23:24
710阅读
一、原题You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'.Which WHERE clause could be used in the SELECT statement to get the required o
转载
精选
2015-08-03 19:07:09
457阅读
一、原题Examine the structure of the SHIPMENTS table:Name Null &nbs
转载
精选
2015-08-03 19:13:08
260阅读
一、原题Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)A. Both USING and ON clauses can be used for equijoins and nonequijoins.B. A maximum of one pair of co
转载
精选
2015-08-03 19:13:48
624阅读
1. View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMEStables. The PROD...
转载
2013-09-30 09:28:00
166阅读
2评论
11. View the Exhibit and examine the structure of the PRODUCTS table.All products have a list price. You i...
转载
2013-09-02 14:22:00
268阅读
2评论
14. Using the CUSTOMERS table, you need to generate a report that shows 50% of each creditamount in eac...
转载
2013-09-02 14:45:00
326阅读
2评论
118. View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL sta...
转载
2013-09-11 09:43:00
214阅读
2评论
120. View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERStables. You issu...
转载
2013-09-11 10:01:00
101阅读
2评论
33. You want to create an ORD_DETAIL table to store details for an order placed having the followingbusine...
转载
2013-09-18 10:22:00
91阅读
2评论
99. View the Exhibit and examine the structure of the PROMOTIONS table.Using the PROMOTIONS table, you ne...
转载
2013-09-23 09:44:00
307阅读
2评论
26. Which is the valid CREATE TABLE statement?A. CREATE TABLE emp9$# (emp_no NUMBER (4));B. CREATE TABLE...
转载
2013-09-22 16:23:00
97阅读
2评论
