Online Access Free 1z0-061 Exam Questions

Evaluate the following SQL statements:
Exhibit:

Exhibit:

The above command fails when executed. What could be the reason?

• A.The BETWEEN clause cannot be used for the CHECK constraint
• B.ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY
• C.The CHECK constraint cannot be placed on columns having the DATE data type
• D.SYSDATE cannot be used with the CHECK constraint

Which two statements are true regarding single row functions?

• A.TRUNC: can be used with number and date values
• B.TRIM: can be used to remove all the occurrences of a character from a string
• C.CONCAT: can be used to combine any number of values
• D.INSTR: can be used to find only the first occurrence of a character in a string
• E.SYSDATE: returns the database server current date and time
• F.MOD: returns the quotient of a division

Which describes the default behavior when you create a table?

• A.You must specify the schema when the table is created.
• B.Tables are created in the public schema.
• C.Tables are created in your schema.
• D.The table is accessible to all users.
• E.Tables are created in the DBA schema.

Consider these three statements:
create synonym s1 for employees; create public synonym s1 for departments; select * from s1; Which of the following statements is correct?

• A.The third statement will show the contents of the table S1, if such a table exists in the current schema.
• B.The third statement will show the contents of DEPARTMENTS.
• C.The third statement will show the contents of EMPLOYEES.
• D.The second statement will fail because an object S1 already exists.

In which two cases would you use an outer join? (Choose two.)

• A.The tables being joined have both matched and unmatched data.
• B.The columns being joined have NULL values.
• C.The tables being joined have NOT NULL columns.
• D.The tables being joined have only matched data.
• E.The tables being joined have only unmatched data.
• F.Only when the tables have a primary key/foreign key relationship.