You want to create a table with the following specifications for columns and data types: 

SALESID: Number. STOREID: Number. 

ITEMID: Number. 

QTY: Number; when no value is specified, it should be set to 1. 

SLSDATE: Date; when no value is specified, it should be set to the current date. 

PAYMENT: Characters, up to 30 characters; when no value is specified, it should be set to CASH. 

Which from the following statements would create the table?

Analyze the structure design for a TRANSACTIONS table: 

Which of the following statements are true about the creation and data storage in the above table’s structure? (Select two.)

Analyze the following types and examples of relationships: 

1. One to one 

a) Professor to students. 

2. One to many 

b) Employees to Manager. 

3. Many to one 

c) Person to SSN. 

4. Many to many 

d) Customers to products. 

Which from the following options indicates a correct match between relationships?

Which from the following statements is true about the UNION operator?

Analyze the following SQL commands: 

► CREATE SEQUENCE ORD_SEQ INCREMENT BY 10 START WITCH 120 MAXVALUE 9999 NOCYCLE; 

►CREATE TABLE ORD_ITEMS (ORD_NO NUMBER(4) DEFAULT ORD_SEQ.NEXTVAL NOT NULL, ITEM_NO NUMER(3), QTY NUMBER(3) CHECK (QTY BETWEEN 100 AND 200), EXPIRY_DATE DATE CHECK (EXPIRY_DATE > SYSDATE), CONSTRAINT IT_PK PRIMARY KEY (ORD_NO, ITEM_NO), CONSTRAINT IORD_FK FOREIGN KEY (ORD_NO) REFERENCES ORDERS (ORD_NO)); 

The command used to create the table fails. Identify the possible reasons for the failure of the SQL statement. (Select two.)

In the Exhibit, evaluate the data in the PROMO_NAME and PROMO_END_DATE columns of the promotions table, as well as the required output format. 

Which of the following queries will produce the correct output? (Select two.)

View the Exhibit, and anlyze the structure of the CUSTOMERS, PRODUCTS and SALES tables. 

You have to generate a report that provides details of the customer’s last name, product name and quantity sold for customers in 'Tokyo'. 

Which of the following queries would give the required outcome? (Select two.)

In order to display the 5 percent of the highest paid employees from the EMPLOYEES table, which of the following queries will produce the required outcome?