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

Question No: 31

MultipleChoice

An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table.

In which three situations does the transactions complete thereby committing the updates? (Choose three.)

Options

Awhen a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

Bwhen a CREATE INDEX statement is executed successfully in the same session

Cwhen a COMMIT statement is issued by the same user from another session in the same database instance

Dwhen the session logs out successfully

Ewhen a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

Fwhen a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

Question No: 32

MultipleChoice

The ORDERS table has a primary key constraint on the ORDER_ID column.

The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table.

The constraint is defined with ON DELETE CASCADE.

There are rows in the ORDERS table with an ORDER_TOTAL of less than 1000.

Which three DELETE statements execute successfully?

Options

ADELETE order_id FROM orders WHERE order_total < 1000;

BDELETE FROM orders WHERE order_total < 1000;

CDELETE orders WHERE order_total < 1000;

DDELETE * FROM orders WHERE order_total < 1000;

EDELETE FROM orders;

Question No: 33

MultipleChoice

Which three are true about the CREATE TABLE command? (Choose three.)

Options

AIt can include the CREATE..INDEX statement for creating an index to enforce the primary key constraint

BIt implicitly executes a commit

CA user must have the CREATE ANY TABLE privilege to create tables

DIt implicitly rolls back any pending transactions

EThe owner of the table should have space quota available on the tablespace where the table is defined

FThe owner of the table must have the UNLIMITED TABLESPACE system privilege

Question No: 34

MultipleChoice

Which three actions can you perform by using the ORACLE_DATAPUMP access driver? (Choose three.)

Options

ARead data from an external table and load it into a table in the database

BCreate a directory object for an external table

CExecute DML statements on an external table

DQuery data from an external table

ERead data from a table in the database and insert it into an external table

FCreate a directory object for a flat file

Question No: 35

MultipleChoice

Which three privileges can be restricted to a subset of columns in a table? (Choose three.)

Options

AALTER

BDELETE

CUPDATE

DSELECT

EINDEX

FREFERENCES

GINSERT

Question No: 36

MultipleChoice

Examine these statements and the result:

CREATE SEQUENCE customer_seq CACHE 10;

SELECT customer_seq. NEXTVAL FROM DUAL; NEXTVAL

1

Now examine this command:

ALTER SEQUENCE customer_soq ;

What must replace missing clause for customer_seq. nfxtvai. to return 11?

Options

Acycle 11

BNOCACHE

CSTART WITH 11

DMINVALUE 11

EINCREMENT BY 10

Question No: 37

MultipleChoice

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS?

Options

AThe name off each column in the first Select list must match the name of the corresponding column In each subsequent select list.

BThe must be an equal number of columns In each select list.

CNone of the set operators can be used when selecting CLOB columns.

DEach select statement In the query can have an order by clause.

EThe FOR update clause cannot be specified.

Question No: 38

MultipleChoice

Examine this list of queries:

1. SELECT ROUND (TRUNC (15, 193, 1)) ''Results'' FROM DUAL;

2. SELECT ROUND (15, 193, 1)) ''Results'' FROM DUAL;

3. SELECT (TRUNC (15, 193, 1)) ''Results'' FROM DUAL;

4. SELECT ROUND (ROUND (15. 193, 1)) ''Results'' FROM DUAL;

Which two statements are true?

Options

A1 and 4 give different results.

B2 and 3 give the same result.

C2 returns the value 20.

D1 and 4 give the same result.

E3 returns an error.

Question No: 39

MultipleChoice

Examine these statements which execute successfully:

Both statements display departments ordered by their average salaries.

Which two are true?

Options

ABoth statements will display departments with no employees.

BOnly the first statement will display departments with no employees.

COnly the first statement will execute successfully if you add E.AVG_SAL to the select list.

DOnly the second statement will execute successfully if you add E.AVG_SAL to the select list.

EBoth statements will execute successfully If you add E.AVG_SAL. to the select list.

FOnly the second statement will display departments with no employees.

Question No: 40

MultipleChoice

Which two are true about multitable insert statements?

Options

AThe conditional insert all statement inserts rows into a single table by aggregating source rows.

BThe unconditional insert all statement must have the same number of columns In both the source and target tables.

CThe conditional insert first statement always Inserts a row Into a single table.

DThey always use subqueries.

EThey can transform a row from a source table Into multiple rows In a target table.