The CUSTOMERStable has a CUST_CREDIT_LIMITcolumn of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
• B.SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
• C.Available') FROM customers;
  SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;
• D.SLECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• E.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index- organized table. (Choose two.)

Evaluate this SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements are true?

• A.The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is added to the SQL statement.
• B.The FIRST_NAME column would be dropped provided it does not contain any data.
• C.The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.
• D.The FIRST_NAME column would be dropped provided at least one column remains in the table.

Comment: *

Name: *

Email: *

Verification: *

BOOK_SEQ is an existing sequence in your schema.
Which two CREATE TABLE commands are valid?

• A.CREATE TABLE bookings ( bk_id NUMBER(4),
  start_date DATE DEFAULT SYSDATE,
  end_date DATE DEFAULT (end_date >= start_date));
• B.CREATE TABLE bookings (
  bk_id NUMBER(4) NOT NULL DEFAULT book_seq.CURRVAL,
  start_date DATE NOT NULL,
  end_date DATE DEFAULT SYSDATE);
• C.CREATE TABLE bookings (
  bk_id NUMBER(4) DEFAULT book_seq.CURRVAL,
  start_date DATE DEFAULT SYSDATE,
  end_date DATE DEFAULT start date);
• D.CREATE TABLE bookings (
  bk_id NUMBER(4) NOT NULL PRIMARY KEY,
  start_date DATE NOT NULL,
  end_date DATE DEFAULT SYSDATE);
• E.CREATE TABLE bookings (
  bk_id NUMBER(4) DEFAULT book_seq.NEXTVAL PRIMARY KEY,
  start_date DATE DEFAULT SYSDATE,
  end_date DATE DEFAULT SYSDATE NOT NULL);

Comment: *

Name: *

Email: *

Verification: *

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the creation and storage of data in the above table structure? (Choose two.)

• A.The CUST_STATUS column would give an error.
• B.The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.
• C.The TRANS_VALIDITY column would have a maximum size of one character.
• D.The CUST_CREDIT_LIMIT column would be able to store decimal values.
• E.The TRANS_VALIDITY column would give an error.
• F.The CUST_STATUS column would store exactly one character.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEES table:

Which two statements will run successfully?

• A.SELECT 'The first_name is \'' || first_name || '\'' FROM employees;
• B.SELECT 'The first_name is ''' ||first_name||''' FROM employees ;
• C.SELECT 'The first_name is '|| first_name|| '' FROM employees;
• D.SELECT 'The first_name is '' || first_name || '' FROM employees ;
• E.SELECT 'The first_name is '''||first_name ||'''' FROM employees ;

Comment: *

Name: *

Email: *

Verification: *