Oracle 1Z1-082 Cert Guide PDF 100% Cover Real Exam Questions [Q66-Q87]

Oracle 1Z1-082 Cert Guide PDF 100% Cover Real Exam Questions [Q66-Q87]

Rate this post

Oracle 1Z1-082 Cert Guide PDF 100% Cover Real Exam Questions

Pass 1Z1-082 Exam – Real Questions and Answers

Oracle 1Z1-082 Exam Syllabus Topics:

Section	Weight	Objectives
Managing Storage Structures	15%	– Managing Redo Log Files – Managing Undo Data – Managing Control Files – Managing Tablespaces and Data Files
Configuring and Managing Oracle Network	10%	– Configuring Listener and Naming Methods – Managing Network Connections
Managing Database Instances	20%	– Starting Up and Shutting Down Databases – Managing Alert Log and Trace Files – Using Initialization Parameters – Using Data Dictionary and Dynamic Performance Views
Administering User Accounts and Security	15%	– Managing Privileges and Roles – Implementing Security Policies – Creating and Managing Users
Understanding Oracle Database Architecture	20%	– Understanding Memory Structures – Understanding Multitenant Architecture – Understanding Background Processes – Overview of Oracle Database Architecture – Explaining Storage Structures
Backup and Recovery Concepts	10%	– Performing Complete and Incomplete Recovery – Using RMAN for Backup and Recovery – Understanding Backup and Recovery Architecture
Managing Data and Concurrency	10%	– Managing Transactions – Managing Locks and Concurrency – Using SQL to Manage Data

QUESTION 66
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

Column names in each SELECT in the compound query can be different

The number of columns in each SELECT in the compound query can be different

Reversing the order of the intersected tables can sometimes affect the output

INTERSECT returns rows common to both sides of the compound query

INTERSECT ignores NULLs

QUESTION 67
Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

QUESTION 68
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

QUESTION 69
Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) “Maximum Order”
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) “Maximum Order”
FROM order_items
GROUP BY order_id;
Which two statements are true?

Statement 1 returns only one row of output.

Statement 2 returns only one row of output.

Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

Both the statements give the same output.

Statement 2 may return multiple rows of output.

QUESTION 70
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

QUESTION 71
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

QUESTION 72
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

QUESTION 73
While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.
Which two statements are true?

DBA_DATA_FILES displays the original name for the data files.

V$DATAFILE displays the new names for the data files.

DBA_DATA _FILES displays both the new name and the old name for the data files.

DBA_DATA_FILES displays the new name for the data files.

DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.

QUESTION 74
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;

QUESTION 75
Examine this command:

Which two statements are true?

Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.

DML may be performed on tables with one or more extents in this data file during the execution of this command.

It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.

The “to” clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

Tables with one or more extents in this data file may be queried during the execution of this command.

QUESTION 76
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

QUESTION 77
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

QUESTION 78
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

QUESTION 79
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.

QUESTION 80
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

QUESTION 81
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

QUESTION 82
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

QUESTION 83
In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which four actions can HR perform? (Choose four.)

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

QUESTION 84
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions?
(Choose two.)

CONCAT (qty_sold, invoice_date) : requires explicit conversion

invoice_date = ’15-march-2019′ : uses implicit conversion

invoie_date > ’01-02-2019′ : uses implicit conversion

qty_sold BETWEEN `101′ AND ‘110’ : uses implicit conversion

qty_sold = `0554982′ uses implicit conversion

QUESTION 85
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

Column positions must be used in the ORDER BY clause

Only column names from the first SELECT statement in the compound query are recognized

The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

Each SELECT statement in the compound query must have its own ORDER BY clause

Each SELECT statement in the compound query can have its own ORDER BY clause

QUESTION 86
Examine the description of the product_details table:

Which two statements are true?

PRODUCT _ic can be assigned the PRIMARY KEY constraint.

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

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

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

PRODUCT_NAKE cannot contain duplicate values.

EXPIRY_ DATE cannot be used in arithmetic expressions.

QUESTION 87
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

Oracle Net Manager can be used to centrally configure listeners on any database server target

Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server

The lsnrctl utility requires a listener.ora file to exist before it is started

The Oracle Net Configuration Assistant is only used when running the Oracle installer

Oracle Net Manager can be used to locally configure naming methods on a database server

100% Free 1Z1-082 Daily Practice Exam With 165 Questions: https://www.test4engine.com/1Z1-082_exam-latest-braindumps.html

Exam for engine

Oracle 1Z1-082 Cert Guide PDF 100% Cover Real Exam Questions [Q66-Q87]

Oracle 1Z1-082 Exam Syllabus Topics:

Leave a Reply Cancel reply

1Z1-082 Practice Tests

Related Certifications

Recent Posts

Recent Comments

Archives

Categories