Given the CUSTOMERS table, you have to generate a report that shows, in each income level, 50% of each credit amount. 

Repeated credit amounts in each income level should not be shown in the report. 

Which from the following queries would produce the required result?

Analyze the following commands wich were used to create DEPARTMENT_DETAILS and COURSE_DETAILS: 

If you want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses, 

which from the following SQL statements must you use?

In the sample below analyze the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables. 

In the SALES table referencing the PRODUCTS table, the PROD_ID column is the foreign key, and the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively. 

Given that, analyze the following command: 

►CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE) AS SELECT prod_id, cust_id, time_id FROM sales; 

Which from the following statements is true?

Analyze this statement: 

Which from the following statements is true about the evaluation of rows returned by the subquery in the INSERT statement?

Which from the following statements are true in regards of the SQL GROUP BY clause? (Select two.)

You issue the following SQL statement: 

What would the outcome be?

Analyze these CREATE TABLE commands: 

►CREATE_TABLE orders (ord_no NUMBER (2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE, cust_id NUMBER (4) ); 

►CREATE TABLE ord_items (ord _no NUMBER (2), item_no NUMBER(3), qty NUMBER (3) CHECK (qty BETWEEEN 100 AND 200), expiry_date date CHECK (expiry_date> SYSDATE), CONSTRAINT it_pk PRIMARY KEY (ord_no, item_no), CONSTARAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord_no) ); 

What could be the reason for the above command failing when executed.?

Analyze the following SQL statements which were executed in the given order: 

Which from the following statements is true regarding the status of the foreign key EMP_MGR_FK?