Winter Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Question # 4

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

A.

It Is held Inside an Oracle database schema.

B.

The ADR base is specified In the diagnostic_dest database parameter.

C.

It is only used for Oracle Database diagnostic information.

D.

It is a file-based repository held outside any database.

E.

It can be used for problem diagnosis of a database when that database's instance is down.

Full Access
Question # 5

Which three statements are true about views in an Oracle database? (Choose three.)

A.

Views can be updated without the need to re-grant privileges on the view

B.

Tables in the defining query of a view must always exist in order to create the view

C.

The WITH CHECK clause prevents certain rows from being displayed when querying the view

D.

Data Manipulation Language (DML) can always be used on views

E.

Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

F.

Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

G.

The WITH CHECK clause prevents certain rows from being updated or inserted

Full Access
Question # 6

Which two statements are true about UNDO and REDO? (Choose two.)

A.

The generation of UNDO generates REDO

B.

DML modifies Oracle database objects and only generates UNDO

C.

The generation of REDO generates UNDO

D.

DML modifies Oracle database objects and only generates REDO

E.

DML modifies Oracle database objects and generates UNDO and REDO

Full Access
Question # 7

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.

Only the EMPLOYEE_ID column is indexed.

Rows exist for employees 100 and 200.

Examine this statement:

Which two statements are true? (Choose two.)

A.

Employee 100 will have SALARY set to the same value as the SALARY of employee 200

B.

Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

C.

Employee 200 will have SALARY set to the same value as the SALARY of employee 100

D.

Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

E.

Employees 100 and 200 will have the same JOB_ID as before the update command

F.

Employees 100 and 200 will have the same SALARY as before the update command

Full Access
Question # 8

Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.

Which two queries will execute successfully?

A.

SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';

B.

SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';

C.

SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

D.

SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK

E.

SELECT prod_id I I q' ('s not available) • 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK

F.

SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;

Full Access
Question # 9

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

A.

Private Temporary Tables (PTTS) store metadata in memory only

B.

An index created with the UNUSABLE attribute has no segment

C.

If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

D.

An index that is altered to be UNUSABLE will retain its segment

E.

A table that is truncated will always have its segment removed

Full Access
Question # 10

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

A.

PCTFREE defaults to 10% for all blocks in all segments for all compression methods

B.

ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

C.

Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

D.

Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

E.

A block will always be eligible for inserts if the row is short enough to fit into the block

Full Access
Question # 11

Examine this SQL statement:

SELECT cust_id, cust_last_name “Last Name”

FROM customers

WHERE country_id = 10

UNION

SELECT cust_id CUST_NO, cust_last_name

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

A.

ORDER BY “Last Name”

B.

ORDER BY 2, 1

C.

ORDER BY 2, cust_id

D.

ORDER BY CUST_NO

E.

ORDER BY “CUST_NO”

Full Access
Question # 12

Examine this description of the books table containing 100 rows:

Now examine this sequence of statements Issued In a new session;

Examine this description of the books table containing 100 rows:

Which three statements are true?

A.

The second rollback command restores the row that was inserted.

B.

The first rollback command leaves the table's 100 original rows locked.

C.

The second rollback command rolls back the rollback to savepoint a command.

D.

The first rollback command leaves the inserted row locked.

E.

The first RollBack command restores the row that was inserted.

F.

The second rollback command restores the 100 rows that were in the table originally.

G.

The first rollback command restores the 100 rows that were in the table originally.

Full Access
Question # 13

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?

A.

WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25

B.

WHERE ADD_MONTHS

C.

WHERE TO_XUMBER(start_date - SYSDATE) <= 25

D.

WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25

Full Access
Question # 14

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

A.

Duplicates are eliminated automatically by the UNION ALL operator

B.

The number of columns selected in each SELECT statement must be identical

C.

The names of columns selected in each SELECT statement must be identical

D.

The output is sorted by the UNION ALL operator

E.

NULLS are not ignored during duplicate checking

Full Access
Question # 15

Which two statements are true about the Oracle Data Dictionary?

A.

It is owned by the sys user.

B.

Data dictionary base tables can be queried directly.

C.

It is owned by the system user.

D.

Data dictionary views are always created with queries that join two or more base tables.

E.

All data dictionary view joins base tables to dynamic performance views.

Full Access
Question # 16

In one of your databases, you create a user, HR, and then execute this command:

GRANT CREATE SESSION TO hr WITH ADMIN OPTION;

Which three actions can HR perform? (Choose three.)

A.

Revoke the CREATE SESSION privilege from other users

B.

Revoke the CREATE SESSION privilege from user HR

C.

Log in to the database instance

D.

Grant the CREATE SESSION privilege with ADMIN OPTION to other users

E.

Execute DDL statements in the HR schema

F.

Execute DML statements in the HR schema

Full Access
Question # 17

The customers table has a cust_last_name column of data type varchar2.

The table has two rows whose "jst_last_name values are Andersen and Ausson.

Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?

A.

SELECT REPLACE FROM customers;

B.

SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;

C.

SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;

D.

SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

Full Access
Question # 18

Which two statements are true about Enterprise Manager (EM) Express?

A.

You can use a single instance of EM Express to manage multiple database running on the same server.

B.

EM Express uses a separate repository database to store target database metadata.

C.

By default, EM express is available for a database after database creation using DBCA.

D.

You can shut down a database instance using EM Express.

E.

You cannot start up a database instance using EM Express.

Full Access
Question # 19

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.

Examine this command:

SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);

Which segment or segments, if any, are created as a result of executing the command?

A.

T1, an index segment for the primary key, a LOB segment, and a lobindex segment

B.

no segments are created

C.

T1 only

D.

T1 and an index segment created for the primary key only

E.

T1, an index segment for the primary key, and a LOB segment only

Full Access
Question # 20

Which three statements are true about a self join? (Choose three.)

A.

The ON clause must be used

B.

The query must use two different aliases for the table

C.

It must be an equijoin

D.

It must be an inner join

E.

The ON clause can be used

F.

It can be an outer join

Full Access
Question # 21

Examine the description of the product_details table:

Which two statements are true?

A.

PRODUCT _ic can be assigned the PRIMARY KEY constraint.

B.

PRODUCT _price contains the value zero by default if no value is assigned to it.

C.

PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.

D.

EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.

E.

PRODUCT_NAKE cannot contain duplicate values.

F.

EXPIRY_ DATE cannot be used in arithmetic expressions.

Full Access