Which three statements are true about inner and outer joins? (Choose three.)

• A.A full outer join returns matched and unmatched rows
• B.An inner join returns matched rows
• C.Outer joins can only be used between two tables per query
• D.A full outer join must use Oracle syntax
• E.Outer joins can be used when there are multiple join conditions on two tables
• F.A left or right outer join returns only unmatched rows

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqlldrexecution? (Choose two.)

• A.It uses the database buffer cache to load data
• B.It overwrites data in EMP with data in EMP.DAT
• C.It appends data from EMP.DAT to EMP
• D.It generates a sql script that it uses to load data from EMP.DAT to EMP
• E.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Oracle synonyms? (Choose three.)

• A.A synonym cannot be created for a PL/SQL package
• B.A synonym can be available to all users
• C.A SEQUENCE can have a synonym
• D.A synonym created by one user can refer to an object belonging to another user
• E.Any user can drop a PUBLIC synonym

Comment: *

Name: *

Email: *

Verification: *

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

• A.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• B.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
• C.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• D.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• E.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

• A.The data dictionary is created and maintained by the database administrator
• B.Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
• C.Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
• D.Base tables can be queried directly
• E.It is owned by the SYSTEM user
• F.Usernames of all users including database administrators are stored in the data dictionary

Comment: *

Name: *

Email: *

Verification: *