Free Oracle 1Z0-071 Exam Dumps and 1Z0-071 Exam Questions

Question No: 51

MultipleChoice

Which two are true about savepoints?

Options

AAfter issuing a savepoint, you cannot roll back the complete transaction.

BYou can commit updates done between two savepoints without committing other updates In the current transaction.

CAfter issuing a savepoint, you can roll back to the savepoint name within the current transaction.

DThey make uncommitted updates visible to other sessions owned by the? same user.

EA rollback to savepoint command issued before the start of a transaction results In an error.

FThey make uncommitted updates visible to sessions owned by other users.

Question No: 52

MultipleChoice

Examine the description of the EMPLOYERS table:

Examine these requirements:

Disable the manager ID and salary of the lowest paid employees for that manager.

Exclude anyone whose manager is not known.

Exclude any managers where the minimum salary is 6000 or less.

Sort the output by minimum salary with the highest salary shown first.

Which statement will do this?

Options

ASELECT manager_id, MTN(salary)
FROM employees
WHERE manager_ id IS NOT NULL
GROUP BY manager_id
HAVING MlN (salary) > 6000
ORDER BV MlN (salary);

BSELECT managar_id, MIN (salary)
FROM employees
HAVING MIN(salary) > 6000
WHERE manager_id IS NOT NULL
GROUP BY manager_id
ORDER BY MTN(salary) DESC;

CSELECT manager_id, HTN(salary)
FROM employees
WHERE manager_id IS NOT NULL
HAVING MIN (salary) > 6000
GROUP BY manager_id
ORDEU BY MIN (salary) DESC;

DSELECT manager_id, MIN(salary)
FROM employees
WHERE manager_id IS NOT NULL
AND MIN(salary) > 6000
GROUP BY manager_id
ORDER BY MlN (salary) DESC;

Question No: 53

MultipleChoice

Examine the contents of the EMP table:

What is the result?

Options

AIt will return the six employees earning the highest salaries. In descending order.

BIt will return the six employees earning the lowest salaries. In ascending order.

CIt will return the five employee's earning the lowest salaries. In ascending order.

DIt will return the five employees earning the highest salaries. In descending order.

Question No: 54

MultipleChoice

Examine this statement:

On which two columns of the table will an index be created automatically?

Options

ASTATUS

BORDER_ID

CPRODUCT_ID

DSERIAL_NO

EORDER_TOTAL

FORDER_DATE

Question No: 55

MultipleChoice

Which statement fails to execute successfully?

A)

B)

C)

D)

Options

AOption A

BOption B

COption C

DOption D

Question No: 56

MultipleChoice

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?

Options

AThe ER must have a many-to-many relationship between the students and projects entitles tb.it must be resolved Into one-to-many relationships.

BAn 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.

CSTUDENT_ID must be the primary key In the students entity and foreign key In the projects
entity.

DPORJECTI_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.

Question No: 57

MultipleChoice

Which three; statements are true about built-in data types?

Options

AA char column definition does not require the length to be specified.

BA BFILE stores unstructured binary data In operating system files.

CA varchar2 column definition does not require the length to be specified.

DA varchar2 blank pads column values only if the data stored Is non-numeric and contains no Special characters.

EThe default length for a char column Is always one character.

FA blob stores unstructured binary data within the database.

Question No: 58

MultipleChoice

Which two statements are true about current_timestamp?

Options

AIt returns the same date as CURRENT_date.

BThe time is In the time zone of DBTIMEZONE.

CThe value varies depending on the setting of SESSIONTIMEZONE.

DIt returns a value of data type timestamp.

EIt always returns the same value as SYSTIMESTAMP.

FThe date Is In the time zone of DBTIMEZONE.

Question No: 59

MultipleChoice

Table HR. employees contains a row where the employee_id is 109.

User ALICE has no privileges to access HR.employees.

User ALICE starts a session.

User HR starts a session and successfully executes these statements:

GRANT DELETE ON employees to ALICE;

UPDATE employees SET salary = 24000 WHERE employee_id 109;

In her existing session ALICE then executes:

DELETE FROM HR.employees WHERE employee_ID =109;

What Is the result?

Options

AThe delete command will wait for HR's transaction to end them delete the row.

BThe delete command will wait for HR's transaction to end then return an error.

CThe delete command will immediately return an error.

DThe delete command will immediately delete the row.

Question No: 60

MultipleChoice

Examine these statements:

CREATE TABLE alter_test (c1 VARCHAR2 (10) , c2 NUMBER (10);

INSERT INTO alter-test VALUES ('123', 123);

Which is true about modifying the columns in Alter_TEST?

Which is true about modifying the columns in ALTER_TEST?

Options

Ac1 can be changed to varchar2 (5) and c2 can be changed to number (13, 2) .

Bc1 can be changed to number (10) and c2 can he changed to vahchar2 (10) .

Cc2 can be changed to varchar2 (10) but el cannot be changed to number (10).

Dc2 can be changed to number (5) but ci cannot be changed to varchar2 (5) .

Ec2 can be changed to number (10) but c2 cannot be changed to varchab2 (10) .