Examine the description of the CUSTOMERStable:

CUSTNOis the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result? (Choose two.)

• A.RIGHT OUTER JOINwith self join
• B.LEFT OUTER JOINwith self join
• C.self join
• D.subquery
• E.FULL OUTER JOINwith self join

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about GLOBAL TEMPORARY TABLES?

• A.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• B.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• C.A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.
• D.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• E.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• F.GLOBAL TEMPORARY TABLE space allocation occurs at session start.

Comment: *

Name: *

Email: *

Verification: *

Examine this business rule:
Each student can work on multiple projects and each project can have multiple students. _ You must design an Entity Relationship (ER) model for optimal data storage and allow for generating reports in this format:
STUDEN_ID FIRST_NAMK LASTNAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true?

• A.STUDENT_ID must be the primary key In the students entity and foreign key In the projects entity.
• B.The ER must have a many-to-many relationship between the students and projects entitles tb.it must be resolved Into one-to-many relationships.
• C.PORJECTI_ID must be the primary key In the projects entity and foreign key in the students The ER must have a one-to-many relationship between the students and projects entitles.
• D.An associative table must be created with a composite key of student_id and project_id, which is the foreign key linked to the Stand projects entitles.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements?

• A.DELTE and TRUNCATE statements can have a rollback done to restore data into a table.
• B.DELETE but not TRUNCATE statement can be used to selectively remove rows from a table.
• C.DELETE but not TRUNCATE statement can be used to remove data from selective columns and rows of a table.
• D.DELETE and TRUNCATE statements remove all indexes for the tables on which they are performed.

Comment: *

Name: *

Email: *

Verification: *

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command? (Choose two.)

• A.It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• B.It fails because no SQL *Loader data file location is specified.
• C.It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• D.It fails because no SQL *Loader control file location is specified.

Comment: *

Name: *

Email: *

Verification: *