[Q87-Q108] Ultimate Guide to Prepare 1Z0-082 with Accurate PDF Questions [Aug 10, 2024] : Actual Test Materials : http://blog.actualtests4sure.com

NO.87 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.88 Which three statements are true about single-row functions? (Choose three.)

They can be used only in the WHERE clause of a SELECT statement

The argument can be a column name, variable, literal or an expression

The data type returned can be different from the data type of the argument

They can be nested to any level

They can accept only one argument

They return a single result row per table

NO.89 View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

Display suppliers whose PROD_LIST_PRICE is less than 1000

Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable

Display the total number of products supplied by supplier 102 which have a product status of obsolete

Display the minimum PROD_LIST_PRICE for each product status

NO.90 In which three situations does a new transaction always start? (Choose three.)

when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

when issuing a DML statement after a DML statement failed in the same session

NO.91 Which two are true about instance recovery for a database that is open in read write mode?
(Choose two.)

It is guaranteed to complete within fast_start_mttr_target number of seconds.

No users can log on until instance recovery has completed.

Only the CURRENT REDO log group is required to perform instance recovery.

It is always performed when opening a database.

It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.

The database opens after the roll forward phase of instance recovery has completed.

NO.92 Which two are true about RETENTION GUARANTEE? (Choose two.)

It is a tablespace attribute.

It prevents FLASHBACK DATABASE operation failure.

It prevents out-of-space errors.

It prevents “Snapshot too old” errors.

It is a static parameter.

NO.93 Which two statements are true about the DUAL table? (Choose two.)

It can be accessed only by the SYS user

It consists of a single row and single column of VARCHAR2 data type

It can display multiple rows but only a single column

It can be used to display only constants or pseudo columns

It can be accessed by any user who has the SELECT privilege in any schema

It can display multiple rows and columns

NO.94 Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

The value is changed only in the PFILE and takes effect at the next instance startup

The value is changed for the current instance and in the PFILE

It fails because the SCOPE clause is missing

Change is applied to the current instance, but does not persist after instance restart

NO.95 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?

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

WHERE ADD_MONTHS<start_date, 25) <= SYSDATE

WHERE TO_XUMBER(start_date – SYSDATE) <= 25

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

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

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.97 Which two statements are true about UNDO and REDO? (Choose two.)

The generation of UNDO generates REDO

DML modifies Oracle database objects and only generates UNDO

The generation of REDO generates UNDO

DML modifies Oracle database objects and only generates REDO

DML modifies Oracle database objects and generates UNDO and REDO

NO.98 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.99 Which three statements are true about the Oracle Data Dictionary? (Choose three.)

Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

The data dictionary is created and maintained by the database administrator

Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

Base tables can be queried directly

It is owned by the SYSTEM user

Usernames of all users including database administrators are stored in the data dictionary

NO.100 Examine the description of the members table:

Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?

ORDER BY 1, LNAME DESC

ORDER BY 1, 2

WHERE city LIKE *%AN%*

WHERE city = =%AN%’

WHERE city IN (*%AN%’)

ORDER BY last_narae DESC, city ASC

NO.101 The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

as SCOTT in DALLAS_DB

as SCOTT in BOSTON_DB

as SCOTT in BOSTON_DB and SYS in DALLAS_DB

as SYS in both the databases

as SCOTT in both the databases

NO.102 Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

The Oracle join syntax supports creation of a Cartesian product of two tables

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

The SQL:1999 compliant ANSI join syntax supports natural joins

The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

The Oracle join syntax only supports right outer joins

The Oracle join syntax supports natural joins

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

NO.103 Which two are true about complete and incomplete recovery? (Choose two.)

Uncommitted transactions will be rolled back after complete recovery completes.

The database must have FLASHBACK enabled in order to perform incomplete recovery.

Uncommitted transactions will be rolled back after incomplete recovery completes.

Incomplete recovery is possible only when the database is open.

Only incremental backups can be used to roll forward the database while performing complete recovery.

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

NO.105 Which two statements are true about the Oracle Data Dictionary?

It is owned by the sys user.

Data dictionary base tables can be queried directly.

It is owned by the system user.

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

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

NO.106 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.107 Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

The value is changed only in the PFILE and takes effect at the next instance startup

The value is changed for the current instance and in the PFILE

It fails because the SCOPE clause is missing

Change is applied to the current instance, but does not persist after instance restart

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

Revoke the CREATE SESSION privilege from other users

Revoke the CREATE SESSION privilege from user HR

Grant the CREATE SESSION privilege with ADMIN OPTION to other users

Execute DDL statements in the HR schema

Execute DML statements in the HR schema

[Q87-Q108] Ultimate Guide to Prepare 1Z0-082 with Accurate PDF Questions [Aug 10, 2024]

Difficulty in Writing of Oracle 1z0-082: Oracle Database Administration I Exam