ITPub博客

7. 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 columns can be joined between two tables using the ON clause. C. The ON clause can be used to join...

6. Examine the structure of the SHIPMENTS table: name                          Null                  Type PO_ID        &nbs...

5. 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 TO_CHAR(1890.55,'$99,999D99') FROM DUAL; D. SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL; E. SEL...

4. 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 constants. D. They always return a single result row for every row of a queried table. E. The...

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 the required output?A. WHERE prod_id LIKE '%_D123%' ESCAPE '_'B. WHERE prod_id LIKE '%\_D123%' ESCAPE '\'C. WHE...

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 SELECT * FROM SALES WHERE time_id <= S...

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 ref...