Which two statements are true about single-row functions?

Which two will execute successfully?

Which two are true?

Name                                          NULL?                       TYPE

----------------------------------------------------------------------

TRANSACTION TD                      NOT NULL                VARCHAR2(6)

TRANSACTION TYPE                                                    VARCHAR2(3)

BORROWED DATE                                                        DATE

BOOK ID                                                                        VARCHAR2(6)

MEMBER ID                                                                   VARCHAR2(6)

Examine this partial SOL statement:

SELECT * FROM books_transactions

Which two WHERE conditions give the same result?

NAME                                                NULL                                TYPE

----------------------------------------------------------------------------

PRODUCT_ID                                NOT NULL                           NUMBER(2)

PRODUCT_NAME                         NOT NULL                         VARCHAR2(25)  

PRODUCT_PRICE                                                                      NUMBER(8.2)  

EXPIRY_DATE                                                                              DATE

Which two statements are true?

CREATE TABLE product (pcode NUMBER(2). pname VARCHAR2(20))

INSERT INTO product VALUES (1,‘pen');

INSERT INTO product VALUES(2，'pencil');

INSERTINTO product VALUES (3，'fountain pen');

SAVEPOINT a

UPDATE product SET pcode = 10 WHERE pcode = 1;

COMMIT

DELETE FROM Product WHERE pcode=2;

SAVEPOINT b:

UPDATE product SET pcode = 30 WHERE pcode = 3:

SAYEPOINT c;

DELETE FROM Product WHERE Pcode=10:

ROLLBACK TO SAVEPOINT b;

COMMT;

Which three statements are true?

Name                                      NULL？                             Type

-------------------------------------------------------------------------

MEMBER ID                           NOT NULL                      VARCHAR2(6)

FIRSTNAME                                                                    VARCHAR2(50)

LAST NAME                          NOT NULL                        VARCHAR2(50)

ADDRESS                                                                     VARCHAR2(50)

CITY                                                                             VARCHAR2(25)

Examine the partial query

SELECT city, last name LNAME FROM members

You want to display all cities that contain the string AN. The cities must be retured in ascending orderwith the last names further sorted in descending order.

Which two clauses must you add to the query?

Name

-----

CUSTID

CUST LASTNAME

CITY

CUST_CREDIT LIMIT

NuLL?--_--NOT NULL

Type

---

VARCHAR2(2)VARCHAR2(30)VARCHAR2(10)NUMBER(6，2)

You need to display last names and credit limits of all customers whose last name starts with A or B inlower or upper case, and whose credit limit is below 1000.

Examine this partial query

SELECT cust last_name,cust_credit limit FROM customers Which two WHERE conditions give the required result?

Examine the description of the PRODUCTS table: 

Name Null? Type

--------------------------------------------------------------------------------------------------------------------------------

PRODUCT_ID NOT NULL NUMBER (2) 

PRODUCT_NAME VARCHAR2 (10) 

UNIT_PRICE NUMBER(3) 

SURCHARGE VARCHAR2 (2) 

EXPIRY_DATE DATE 

DELIVERY_DATE DATE

Which three queries use valid expressions?

Examine the description of the EMPLOYEES table: 

Name Null? Type

- EMP_ID       NOT NULL NUMBER

EMP_NAME                    VARCHAR2 (40)

DEPT_ID                              NUMBER (2)

SALARY                              NUMBER(8,2) HIRE_DATE    

DATE NLS_DATE_FORMAT is DD-MON-RR.

Which two queries will execute successfully?

Which two WHERE conditions demonstrate the correct usage of conversion functions?

Examine the description of thePRODUCT STATUS table

Name                                      NULL？                             Type

-------------------------------------------------------------------------

PROD_ID                             NOT NULL                           NUMBER(2)

STATUS                               NOT NULL                        VARCHAER2(15)

The STATUS column contains the values 'IN STOCK' or 'OUT OF STOCK' for each row. Which two queries will execute successfully?

Name

PROMO IDPROMO NAME

PROMO CATEGORY

PROMO COST

Null?

NOT NULL

NOT NULL

NOT NULL

NOT NULL

Type

NUMBER(6)

VARCHAR2(30)VARCHAR2(30)

NUMBER(10，2)

You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.)