Pass Oracle 1Z0-082 Exam with Guarantee Updated 145 Questions [Q16-Q33] : Top Exam Collection : http://blog.topexamcollection.com

NO.16 Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL,
NULL);
SAVEPOINT a;
DELETE FROM books;
ROLLBACK TO SAVEPOINT a;
ROLLBACK;
Which two statements are true? (Choose two.)

The second ROLLBACK command does nothing

The second ROLLBACK command replays the delete

The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

The second ROLLBACK command undoes the insert

The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

NO.17 Which two statements are true about Enterprise Manager Database Express? (Choose two.)

It is available only when the database is open

It can be used to perform database recovery

The same port number can be used for Database Express configurations for databases on different hosts

It can be used to switch a database into ARCHIVELOGMODE

The same port number can be used for multiple Database Express configurations for multiple databases on the same host

NO.18 Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

writing inbound request to the common request queue from all shared server connections

checking for outbound shared server responses on the common outbound response queue

receiving inbound requests from processes using shared server connections

sending each connection input request to the appropriate shared server input queue

broadcasting shared server session responses back to requesters on all connections

sending shared server session responses back to requesters on the appropriate connection

NO.19 Examine this command and some partial output:

Why does the DB01.abc.comservice show unknown status?

The service DB01.abc.com is dynamically registered

The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

The service DB01.abc.com is statically registered

The listener is not listening on the default port 1521

The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

NO.20 Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

UNDO_RETENTION specifies how long all types of UNDO are retained.

Unexpired UNDO is always retained.

Active UNDO is always retained.

UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

NO.21 Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

Connect Time Failover requires the use of Transparent Application Failover (TAF)

Source Routing requires the use of a name server

Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

Load Balancing requires the use of a name server

Connect Time Failover requires the connect string to have two or more listener addresses configured

NO.22 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.)

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

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

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

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

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

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

NO.23 Which statement is true about database links?

Private database link creation requires the same user to exist in both the local and the remote databases.

A public database link can be created only by sys.

A database link can be created only between two Oracle databases.

A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

A database link created in a database allows a connection from that database’s instance to the target database’s Instance, but not vice versa.

NO.24 Which three activities are recorded in the database alert log? (Choose three.)

Data Definition Language (DDL) statements

non-default database parameters

block corruption errors

deadlock errors

session logins and logouts

NO.25 Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

SELECT DISTINCT promo_cost || ‘ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;

SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;

SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

NO.26 Which two statements are true about the rules of precedence for operators? (Choose two.)

The concatenation operator | | is always evaluated before addition and subtraction in an expression

NULLS influence the precedence of operators in an expression

The + binary operator has the highest precedence in an expression in a SQL statement

Arithmetic operators with equal precedence are evaluated from left to right within an expression

Multiple parentheses can be used to override the default precedence of operators in an expression

NO.27 Examine the description of the BOOKS_TRANSACTIONS table:

WHERE borrowed_date = SYSDATE AND transaction_type = ‘RM*) OR member_id IN (‘A101’, ‘A102’);

WHERE borrowed_date = SYSDATE AND {transaction_type = ‘RM* AND (raeraber_id = ‘A101’ OR member_id = ‘A102));

WHERE borrowed_date = SYSDATE AND (transaction_ype = ‘RM’ AND .-neraber_id = ‘A101’ OR member_id = ‘A102’);

WHERE borrowed_date = SYSDATE AND (transaction_type = ‘RM* OR member_id IN (‘A101’, ‘A102’));

NO.28 In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

It succeeds and the generated undo is stored in SYSTEM.

It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’ “.

It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

It succeeds and the generated undo is stored in SYSAUX.

It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

NO.29 Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

The number, but not names, of columns must be identical for all SELECT statements in the query.

The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

The names and number of columns must be identical for all SELECT statements in the query.

The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

NO.30 Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.

The number, but not names, of columns must be identical for all SELECT statements in the query.

The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

The names and number of columns must be identical for all SELECT statements in the query.

The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

NO.31 Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

SELECT promo_cost, promo_category FROM promotions ORDER BY 1;

SELECT DISTINCT promo_cost || ‘ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;

SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;

SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

NO.32 You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY’) ?’01-JAN-2019′ FROM DUAL;

SELECT ROUND(SYSDATE ?’01-JAN-2019′) FROM DUAL;

SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019′)) FROM DUAL;

SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY’) ?`01/JANUARY/2019′ FROM DUAL;

SELECT SYSDATE ?TO_DATE(’01-JANUARY-2019′) FROM DUAL;

NO.33 Which two statements are true about Enterprise Manager Database Express? (Choose two.)

It is available only when the database is open

It can be used to perform database recovery

The same port number can be used for Database Express configurations for databases on different hosts

It can be used to switch a database into ARCHIVELOGMODE

The same port number can be used for multiple Database Express configurations for multiple databases on the same host