Which of the following statements are true in regards of constraints?(Select two.)

Choose the CREATE TABLE statement that is valid:

For products with the lowest amount sold in the SALES table, you want to display 5 percent of the rows; the sample should include the rows with identical amount sold, even if this exceed 5 percent of the rows in the output. 

Which of the following queries will produce the required outcome?

View the structure of the following customers table: You must write a query that completes the following tasks: 

1. Display customers first name and their tax amount. Taxes are set at 5% of their credit limit. 

2. Only should be considered those customers whose income level has a value. 

3. Those customers whose tax amount is null should be ignored. 

Which SQL statement would accomplish all requirements?

Which of the following statements are true regarding sequences that have been created in a single instance database? (Select two.)

Examine the data of the products table in the Exhibit below. 

From the table, you need to display product names of those belonging to the 'software/other' category with minimum prices as either S2000 or S4000 and having no unit of measure defined. In that order, you issued the following query: 

> SELECT prod_name, prod_category, prod_min_price FROM products WHERE prod category LIKE ‘%Other%’ AND (prod_min_price = 2000 OR prod_min_price = 4000) AND prod_unit_of_measure <> ’ ’; 

What would be the outcome of the above query?

In order to display the columns associated with the constraints on a table owned by a user, which view should the user query?

Analyze the following SQL statements: 

► 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 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 execution of the above command fails. 

Which statement explains the failure?