Which two statements are true regarding constraints? (Choose two.)

• A.You can have more than one column in a table as part of a primary key.
• B.A constraint is enforced only for an INSERT operation on a table.
• C.A column with the UNIQUE constraint can store NULLS.
• D.A foreign key cannot contain NULL values.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

• A.listing of customers who do not have a credit limit and were born before 1980
• B.finding the number of customers, in each city, whose marital status is 'married'
• C.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
• D.listing of those customers whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'
• E.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding single-row functions? (Choose three.)

• A.The data type returned, can be different from the data type of the argument that is referenced.
• B.They can accept column names, expressions, variable names, or a user-supplied constants as arguments.
• C.They can accept only one argument.
• D.They can return multiple values of more than one data type.
• E.They can be nested up to only two levels.
• F.They can be used in SELECT, WHERE, and ORDER BY clauses.

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? (Choose two.)

• A.The ERD must have a 1:M relationship between the STUDENTSand PROJECTSentities.
• B.The ERD must have a M:M relationship between the STUDENTSand PROJECTSentities that must be resolved into 1:M relationships.
• C.STUDENT_IDmust be the primary key in the STUDENTSentity and foreign key in the PROJECTSentity.
• D.PROJECT_IDmust be the primary key in the PROJECTSentity and foreign key in the STUDENTSentity.
• 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: *

Evaluate the following query:
SQL> SELECT TRUNC (ROUND(156.00, -1),-1)
FROM DUAL;
What would be the outcome?

• A.150
• B.200
• C.160
• D.16
• E.100

Comment: *

Name: *

Email: *

Verification: *