发布时间:2015-03-19 23:45:08
3. You need to extract details of those products in the SALES table where the PROD_ID columncontains the string '_D123'. Which WHERE clause could be used in the SELECT statement to get.........【阅读全文】
发布时间:2015-03-19 23:40:54
2. 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 v3 AS SELECT * FROM SALES WHERE cust_id = 2034 WITH CHECK OPTION; B. CREATE VIEW v1 AS.........【阅读全文】
发布时间:2015-03-19 23:08:14
1. 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. Similarly, the CUST_ID and TIME.........【阅读全文】