You must create a SALES table with these column specifications and data types:
SALESID: Number
STOREID: Number
ITEMID: Number
QTY: Number, should be set to 1 when no value is specified
SLSDATE: Date, should be set to current date when no value is specified PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified Which statement would create the table? (Choose the best answer.)

• A.CREATE TABLE sales(salesid NUMBER(4),storeid NUMBER(4),itemid NUMBER(4),qty NUMBER DEFAULT 1,slsdate DATE DEFAULT 'SYSDATE',payment VARCHAR2(30) DEFAULT CASH);
• B.CREATE TABLE sales(salesid NUMBER(4),storeid NUMBER(4),itemid NUMBER(4),qty NUMBER DEFAULT 1,slsdate DATE DEFAULT SYSDATE,payment VARCHAR2(30) DEFAULT 'CASH');
• C.CREATE TABLE sales(salesid NUMBER(4),storeid NUMBER(4),itemid NUMBER(4),qty NUMBER DEFAULT = 1,slsdate DATE DEFAULT SYSDATE,payment VARCHAR2(30) DEFAULT = "CASH");
• D.CREATE TABLE sales(salesid NUMBER(4),storeid NUMBER(4),itemid NUMBER(4),qty NUMBER DEFAULT = 1,slsdate DATE DEFAULT SYSDATE,payment VARCHAR2(30) DEFAULT = "CASH");

Comment: *

Name: *

Email: *

Verification: *

You must write a query that prompts users for column names and conditions every time it is executed.
The user must be prompted only once for the table name.
Which statement achieves those objectives?

• A.SELECT &col1, &col2
  FROM "&table"
  WHERE &condition = &cond;
• B.SELECT &col1, '&col2'
  FROM &table
  WHERE &&condition = '&cond';
• C.SELECT &col1, &col2
  FROM &&table
  WHERE &condition = &&cond
• D.SELECT &col1, &col2
  FROM &&table
  WHERE &condition = &cond;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding subqueries? (Choose three.)

• A.Multiple columns or expressions can be compared between the main query and subquery.
• B.Subqueries can contain ORDER BY but not the GROUP BY clause.
• C.Main query and subquery can get data from different tables.
• D.Subqueries can contain GROUP BY and ORDER BY clauses.
• E.Main query and subquery must get data from the same tables.
• F.Only one column or expression can be compared between the main query and subquery.

Comment: *

Name: *

Email: *

Verification: *

Which statements are true? (Choose all that apply.)

• A.The data dictionary is created and maintained by the database administrator.
• B.The data dictionary views consists of joins of dictionary base tables and user-defined tables.
• C.The usernames of all the users including the database administrators are stored in the data dictionary.
• D.The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a constraint applies.
• E.Both USER_OBJECTS and CAT views provide the same information about all the objects that are owned by the user.
• F.Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base tables from the data dictionary.

Comment: *

Name: *

Email: *

Verification: *

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER
Statement 1:
SELECT MAX (unit price*quantity) "Maximum Order FROM order items;
Statement 2:
SELECT MAX (unit price*quantity "Maximum order" FROM order items GROUP BY order id;
Which two statements are true?

• A.Statement 1 returns only one row of output.
• B.Both the statement given the same output.
• C.Statement 2 may return multiple rows of output.
• D.Both statements will return NULL if either UNIT PRICE or QUANTITY contains NULL,
• E.Statement 2 returns only one row of output.

Comment: *

Name: *

Email: *

Verification: *