The SALES table should have the following column specifications 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 following SQL commands: 

>CREATE TABLE ord_items INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCYCLE; 

>CREATE TABLE ord_items (ord_no NUMBER (4) DEFAULT ord_seq.NEXTVAL NOT NULL, item_no NUMBER (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 ord_fk FOREIGN KEY (ord_no) REFERENCES orders(ord_no)); 

The command used to create the table fails. 

What statements explain the possible reasons for the failure of the SQL statement? (Select two.)

On the EMPLOYEES table below, examine the data in the ENAME and HIREDATE columns: 

It is needed to generate a list of user IDs as follows: In that order, the following query is issued: 

>SELECT CONCAT (SUBSTR (INITCAP (ename) , 1, 3, REPLACE (hiredate, ‘-‘)) “USERID” FROM employees; 

What would the outcome be?

Which from the following statements are true about subqueries? (Select two.)

Analyze the structure of the transactions table below: It is needed to display the date, time, and transaction amount of all transactions done before 12 noon. 

Those transactions where the transaction amount has not been entered, should display the value zero. 

Which of the following queries would give the required outcome?

A table with the following column specifications is needed: 

1. An Employee ID column, to store the ID of each employee (number data type). 

2. An Employee Name column, to store the name of each employee (characters data type).

 3. A Hire date column, to store the date each employee has joined the organization.

4. A Status column (character data type, which contains the default value 'active’ if no data is entered. 

5. A Resume column (character large object [CLOB] data type), which contains the resume each employee has submitted. 

What syntax would you use to create the table?

You have to create a table for a banking application, with the following requirements for one column: 

1: The duration of the credit period will be stored in the column. 

2: A format that can be easily added and substracted with DATE datatypes without using conversion functions, should be used to store the data in the column. 

3: 30 days is the maximum credit period provided in the application. 

4: Interest is calculated depending on the number of days for which the credit has been taken. 

From the following data types, wich one would you choose for the column?

Examine the CREATE TABLE statements for the STORES and SALES tables. 

> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12), store_address VARCHAR2(20), start_date DATE); > CREATE TABLE sales(sales_id NUMBER(4) CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER(4), quantity NUMBER(10), sales_date DATE, store_id NUMBER(4), CONSTRAINT store_id_fk FOREIGN KEY(store_id) REFERENCES stores(store_id)); You issued this statement: 

> DELETE from stores WHERE store_id=900; The execution fails due to the integrity constraint error: ORA-02292: integrity constraint (HR.STORE_ID_FK) violated. 

In order to ensure that the statement is successfully executed, which of the following options would you apply? (Select three.)