1z0-071 무료 덤프문제 온라인 액세스

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

• A.SYSDATE can be queried only from the DUAL table.
• B.CURRENT_DATE returns the current date and time as per the session time zone.
• C.SYSDATE can be used in expressions only if the default date format is DD-MON-RR.
• D.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.
• E.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.
• F.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds.

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

• A.Primary key and foreign key constraints can be defined at both the column and table level
• B.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
• C.A table can have only one primary key and one foreign key
• D.A table can have only one primary key but multiple foreign keys
• E.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• F.The foreign key columns and parent table primary key columns must have the same names
• G.Only the primary key can be defined at the column and table level

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

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

View the Exhibit and examine the data in EMPand DEPTtables.

In the DEPTtable, DEPTNOis the PRIMARY KEY.
In the EMPtable, EMPNOis the PRIMARY KEYand DEPTNOis the FOREIGN KEYreferencing the DEPTNO column in the DEPTtable.
What would be the outcome of the following statements executed in the given sequence?
DROP TABLE emp;
FLASHBACK TABLE emp TO BEFORE DROP;
INSERT INTO emp VALUES (2, 'SCOTT', 10);
INSERT INTO emp VALUES (3, 'KING', 55);

• A.Only the SECOND INSERT statement would succeed because all the constraints except referential integrity constraints that reference other tables are retrieved automatically after the table is flashed back.
• B.Only the first INSERT statement would succeed because all constraints except the primary key constraint are automatically retrieved after a table is flashed back.
• C.Both the INSERT statements would fail because the constraints are automatically retrieved when the table is flashed back.
• D.Both the INSERT statements would succeed because none of the constraints on the table are automatically retrieved when the table is flashed back.

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

• A.Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.
• B.Rows added through a view are deleted from the table automatically when the view is dropped.
• C.The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.
• D.The OR REPLACE option is used to change the definition of an existing view without dropping and re- creating it.
• E.A simple view in which column aliases have been used cannot be updated.
• F.A subquery used in a complex view definition cannot contain group functions or joins.