Online Access Free 1z0-071 Exam Questions

Which statement executes successfully?

• A.SELECT TO_DATE(INTERVAL '800' SECOND,'HH24:MM') FROM DUAL;
• B.SELECT TO_CHAR(INTERVAL '800' SECOND, 'HH24:MM') FROM DUAL;
• C.SELECT TO_NUMBER(INTERVAL'800' SECOND, 'HH24:MM') FROM DUAL;
• D.SELECT TO_NUWBER(TO_DATE(INTERVAL '800' SECOND)) FROM DUAL;
• E.SELECT TO_DATE(TO_NUMBER(INTERVATL '800' SECOND)) FROM DUAL;

Examine this statement:

Which two things must be changed for it to execute successfully?

• A.The primary key constraint on BMP_ID must have a name.
• B.One of the LONG columns must be changed to a VARCHAR2 or CLOB.
• C.The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.
• D.The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.
• E.The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.

You and your colleague Andrew have these privileges on the EMPLOYEE_RECORDS table:
1. SELECT
2. INSERT
3. UPDATE
4. DELETE
You connect to the database instance an perform an update to some of the rows in EMPLOYEE_RECORDS, but don't commit yet.
Andrew connects to the database instance and queries the table
No othet user are accessing the table
Which two statements ate true at this point?

• A.Andrew will be unable to see the changes you have made
• B.Andrew will be able to modify any rows in the table that have not been modified by your transaction
• C.Andrew will be able to SELECT from the table, but be unable to modify any existing rows.
• D.Andrew will be able to see the changes you habe made
• E.Andrew will be unable to perform any INSERT, UPDATE of DELETE on the teble

You have been asked to create a table for a banking application.
One of the columns must meet three requirements:
1: Be stored in a format supporting date arithmetic without using conversion functions
2: Store a loan period of up to 10 years
3: Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

• A.INTERVAL YEAR TO MONTH
• B.TIMESTAMP WITH LOCAL TIMEZONE
• C.INTERVAL DAY TO SECOND
• D.TIMESTAMP
• E.TIMESTAMP WITH TIMEZONE

Examine this partial command:

Which two clauses are required for this command to execute successfully?

• A.the LOCATION clause
• B.the access driver TYPE clause
• C.the REJECT LIMIT clause
• D.the ACCESS PARAMETERS clause
• E.the DEFAULT DIRECTORY clause