Oracle Certified 1Z0-082 Dumps Questions Valid 1Z0-082 Materials [Q54-Q72] : Best Free Exam Guide : http://free.exams4sures.com

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

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

Q56. Which three statements are true about table data storage in an Oracle Database? (Choose three.)

Data block headers contain their own Data Block Address (DBA)

A table row piece can be chained across several database blocks

Multiple row pieces from the same row may be stored in different database blocks

Multiple row pieces from the same row may be stored in the same block

Data block free space is always contiguous in the middle of the block

Index block free space is always contiguous in the middle of the block

Q57. In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

Set OS_AUTHENT_PREFIX to OPS$

Have the OS administrator add KING to the OSDBA group

Grant DBA to KING

Unset REMOTE_LOGIN_PASSWORDFILE

Alter user KING to be IDENTIFIED EXTERNALLY

Q58. Which two statements are true about interval data types?

INTERVAL year TO month columns support yearly intervals.

The value in an interval day to SECOND column can be copied into an interval year to month column.

INTERVAL day to second columns support fractions of seconds.

INTERVAL year to month columns only support monthly Intervals within a single year.

INTERVAL year to month columns only support monthly intervals within a range of years.

The year field in an interval year to month column must be a positive value.

Q59. You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

It must be smaller than the smallest BIGFILE tablespace

Free space is managed using freelists

Any data files added to the tablespace must have a size of 5 gigabytes

It uses the database default blocksize

It is a locally managed tablespace

Q60. View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

It gives an error because the ALL keyword is not valid

It gives an error because the GROUP BY clause is not valid

It executes successfully but does not give the required result

It executes successfully and gives the required result

Q61. Which two actions can you perform using DBCA for an existing database?

Create a template that can be used to clone the database.

Change the server mode from dedicated to shared, and vice versa.

Change the character set.

Create an additional listener.

Create nonstandard block size tablespaces.

Q62. What is true about non-equijoin statement performance? (Choose two.)

Table aliases can improve performance

The BETWEEN condition always performs better than using the >= and <= conditions

The join syntax used makes no difference to performance

The BETWEEN condition always performs less well than using the >= and <= conditions

The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

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

The ON clause must be used

The query must use two different aliases for the table

It must be an equijoin

It must be an inner join

The ON clause can be used

It can be an outer join

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

Q65. You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

analysis of all privileges used by all users including administrative users in the database

analysis of all privileges used by all users but excluding administrative users in the database

analysis of privileges that a user has on their own schema objects that they did not use

analysis of privileges that a user has on their own schema objects that they did use

analysis of privileges granted directly to a role that are then used by a user who has been granted that role

analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

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

Q67. Examine the description of the customers table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000.
Examine this partial query:
SELECT cust_last_name, cust_credit_limit FROM customers
Which two where conditions give the required result?
A)

C)

D)

E)

Option A

Option B

Option C

Option D

Option E

Q68. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

Dynamic service registration cannot be used for this database instance

The LREG process registers services dynamically with the LISTENER_1 listener

LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Q69. What is true about non-equijoin statement performance? (Choose two.)

Table aliases can improve performance

The BETWEEN condition always performs better than using the >= and <= conditions

The join syntax used makes no difference to performance

The BETWEEN condition always performs less well than using the >= and <= conditions

The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

Q70. Which two statements are true about the SET VERIFY ON command? (Choose two.)

It can be used only in SQL*Plus

It displays values for variables used only in the WHERE clause of a query

It can be used in SQL Developer and SQL*Plus

It displays values for variables created by the DEFINE command

It displays values for variables prefixed with &&

Q71. Which two functions are performed by a listener?

creating a user session in the System Global Area (SGA)

verifying the service name in an incoming user request

verifying a user’s authentication credentials

maintaining the connection to a client’s user process until the user request is completed

returning the results of processing from the server process to the user process

connecting a user process to a server process

Q72. What two are benefits of Data Pump? (Choose two.)

It can execute in parallel.

It can restart failed export jobs.

It makes use of client system resources.

It can export data into sequential media, such as tapes.

It represents database metadata information as DDL statements in the dump file.