一、原题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 ...
一、原题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 SALESWH...
一、 原题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.Si...
一、原题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...
一、原题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 o...
一、原题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 requir...
一、原题 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. SELE...
一、原题 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 ...
一、原题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 stat...
10. View the Exhibit; e xamine the structure of the PROMOTIONS table.
Each promotion has a duration of at least seven days .
Your manager has asked you...
70. View the E xhibit and examine the structure of the PRODUCTS table.
You want to display only those product names with their list prices where the list...
67. Which two statements are true regarding the ORDER BY clause? (Choose two.)
A. It is executed first in the query execution.
B. It must be the last cla...
22. You need to create a table for a banking application. One of the columns in the table has the following
requirements:
1) You want a column in the ta...
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 equijoi...
71. Which arithmetic operations can be performed on a column by using a SQL function that is built into
Oracle database ? (Choose three .)
A. addition...
121. Which two statements are true regarding the USING clause in table joins? (Choose two .)
A. It can be used to join a maximum of three tables.
B. I...
