[2024] 1Z0-082 Answers 1Z0-082 Free Demo Are Based On The Real Exam [Q81-Q97] : Latest Exam Prep : http://certify.vceprep.com

NO.81 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

NO.82 Which two are true about shrinking a segment online? (Choose two.)

It is not possible to shrink either indexes or Index Organized Tables (IOTs)

It always eliminates all migrated rows if any exist in the table

To shrink a table it must have a PRIMARY KEY constraint

To shrink a table it must have a UNIQUE KEY constraint

To shrink a table it must have row movement enabled

It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

NO.83 Which two statements are true about substitution variables?

A substitution variable prefixed with & always prompts only once for a value in a session.

A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session

A substitution variable can be used only in a select statement.

A substitution variable used to prompt for a column name must be enclosed in single quotation marks.

A substitution variable can be used with any clause in a select statement.

A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

NO.84 Which two statements are true regarding a SAVEPOINT? (Choose two.)

Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

Rolling back to a SAVEPOINT can undo a TRUNCATE statement

Only one SAVEPOINT may be issued in a transaction

A SAVEPOINT does not issue a COMMIT

Rolling back to a SAVEPOINT can undo a DELETE statement

NO.85 The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

The sales user must have a quota on the TEMP tablespace

The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

The sales user must have been granted the CREATE SESSION privilege

The sales user must have their quota on the users tablespace removed

The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

The sales user must have been granted the CREATE TABLE privilege

NO.86 Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

It overwrites data in EMP with data in EMP.DAT

It uses the database buffer cache to load data

It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

It generates a sql script that it uses to load data from EMP.DAT to EMP

It appends data from EMP.DAT to EMP

NO.87 Which two statements are true about single row functions? (Choose two.)

MOD : returns the quotient of a division operation

FLOOR : returns the smallest integer greater than or equal to a specified number

TRUNC : can be used with NUMBER and DATE values

CONCAT : can be used to combine any number of values

CEIL : can be used for positive and negative numbers

NO.88 Which three statements are true about roles?

All roles granted to a user are set on by default when the user logs in,

Object privileges may not be granted to roles.

The SET ROLE statement can disable one or more roles for a session.

Roles must be password protected.

Roles may be granted to roles.

The SET ROLE statement can enable one or more roles for a session.

NO.89 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

NO.90 Which three statements are true about Oracle synonyms? (Choose three.)

A synonym cannot be created for a PL/SQL package

A synonym can be available to all users

A SEQUENCE can have a synonym

A synonym created by one user can refer to an object belonging to another user

Any user can drop a PUBLIC synonym

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

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

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

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

You can shut down a database instance using EM Express.

You cannot start up a database instance using EM Express.

NO.92 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.93 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.94 Which two statements are true about trace files produced by the Oracle Database server?
(Choose two.)

They can be written by server processes

Trace files are written to the Fast Recovery Area (FRA)

They can be written by background processes

All trace files contain error information that require contacting Oracle Support

Trace file names are based on the database name concatenated with a sequential number

NO.95 Which three statements are true concerning logical and physical database structures? (Choose three.)

All tablespaces may have one or more data files

The extents of a segment must always reside in the same datafile

A smallfile tablespace might be bigger than a bigfile tablespace

A segment can span multiple data files in some tablespaces

A segment’s blocks can be of different sizes

A segment might have only one extent

Segments can span multiple tablespsaces

NO.96 You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON’), `dd “Monday for”
fmMonth rrrr’)
What is the result?

It executes successfully but does not return any result

It returns the date for the first Monday of the next month

It generates an error

It returns the date for the last Monday of the current month

NO.97 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set

The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

It supports diagnostics for Automatic Storage Management (ASM)

It supports diagnostics for Oracle Clusterware

It is held inside an Oracle database schema