Examine the description of the CUSTOMERStable:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.
Examine this partial query:

Which two WHEREconditions give the required result? (Choose two.)

• A.
• B.
• C.
• D.
• E.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the MEMBERStable:

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 returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query? (Choose two.)

• A.ORDER BY last_name DESC, city ASC
• B.WHERE city IN ('%AN%')
• C.ORDER BY 1, LNAME DESC
• D.ORDER BY 1, 2
• E.WHERE city = '%AN%'
• F.WHERE city LIKE '%AN%'

Comment: *

Name: *

Email: *

Verification: *

View the Exhibits and examine the structure of the costs and promotions tables.
You want to display prod_ids whose promotion cost is less than the highest cost PR0D_ID in a promotion time interval.
Examine this SQL statement:

What will be the result?

• A.It gives an error because the ROUP BY clause is not valid.
• B.It gives an error because the all keyword is not valid.
• C.It executes successfully but does not give the required result.
• D.It executes successfully and gives the required result.

Comment: *

Name: *

Email: *

Verification: *

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully?

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

Comment: *

Name: *

Email: *

Verification: *

Examine the business rule:
Each student can work on multiple projects and each project can have multiple students.
You need to design an Entity Relationship Model (ERD) for optimal data storage and allow for generating reports in this format:
STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true in this scenario?

• A.The ERD must have a 1:M relationship between the STUDENTS and PROJECTS entities.
• B.The ERD must have a M:M relationship between the STUDENTS and PROJECTS entities that must be resolved into 1:M relationships.
• C.STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.
• D.PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.
• E.An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.

Comment: *

Name: *

Email: *

Verification: *