Get Instant Access of 100% Real Oracle 1Z0-082 Exam Questions with Verified Answers [Q84-Q102]

4/5 - (1 vote)

Get Instant Access of 100% Real Oracle 1Z0-082 Exam Questions with Verified Answers

Exam Dumps for the Preparation of Latest 1Z0-082 Exam Questions

Oracle 1Z1-082 Certification Exam includes a wide range of topics such as configuring Oracle databases, managing various components, including storage and recovery, database security, and ensuring high availability. It also covers database architecture, installation, and maintenance. Oracle Database Administration I certification exam is designed to assess your knowledge and understanding of the Oracle database administration concepts and your ability to apply these concepts in real-world scenarios.

Oracle Database is widely used in the industry and is known for its reliability, scalability, and security features. As a result, there is a high demand for professionals who are proficient in administering Oracle Databases. The Oracle 1Z0-082 exam is the perfect opportunity for individuals to showcase their skills and knowledge in this field. It is an industry-recognized certification that can open doors to new job opportunities and career growth.

NO.84 Which statement is true about aggregate functions?

Aggregate functions can be nested to any number of levels

The AVG function implicitly converts NULLS to zero

Aggregate functions can be used in any clause of a SELECT statement

The MAX and MIN functions can be used on columns with character data types

NO.85 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.86 You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?

INTERVAL YEAR TO MONTH

INTERVAL DAY TO SECOND

TIMESTAMP WITH LOCAL TIMEZONE

TIMESTAMP

TIMESTAMP WITH TIMEZONE

NO.87 You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
SELECT &&col1, &&col2

FROM &table
WHERE &&condition = &&cond;
SELECT &col1, &col2

FROM &&table
WHERE &condition;
SELECT &col1, &col2

FROM “&table”
WHERE &condition;
SELECT ‘&&col1’, ‘&&col2’

FROM &table
WHERE ‘&&condition’ = ‘&cond’;
SELECT &&col1, &&col2

FROM &table
WHERE &&condition;

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

Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.

NO.89 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.90 Examine these commands:

Which two statements are true about the sqiidr execution?

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

It overwrites the data for Alan and adds data for Curl and Bob

It appends data from EMP.DAT TO EMP.

It overwrites all data in emp with data from emp.dat.

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

NO.91 In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

T1, an index segment for the primary key, a LOB segment, and a lobindex segment

no segments are created

T1 only

T1 and an index segment created for the primary key only

T1, an index segment for the primary key, and a LOB segment only

Explanation/Reference:

NO.92 Which statement is true about aggregate functions?

Aggregate functions can be nested to any number of levels

The AVG function implicitly converts NULLS to zero

Aggregate functions can be used in any clause of a SELECT statement

The MAX and MIN functions can be used on columns with character data types

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

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm

NO.94 You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO 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

Explanation/Reference:

NO.95 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.96 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.97 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

NO.98 The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

SELECT NVL(cust_credit_linit * .15, ‘Not Available’) FROM customers;

SELECT NVL2(cust_credit_linit * .15, ‘Not Available’) FROM customers;

SELECT NVL(TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

SELECT TO_CHAR(NVL(cust_credit_limit * .15, ‘Not Available’)) FROM customers;

SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

NO.99 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 &&

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

https://oracle-base.com/articles/9i/ansi-iso-sql-support

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

Reference:
https://en.wikipedia.org/wiki/DUAL_table

NO.102 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 NUMBERand DATEvalues

CONCAT : can be used to combine any number of values

CEIL : can be used for positive and negative numbers

Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Single-Row- Functions.html#GUID-B93F789D-B486-49FF-B0CD-0C6181C5D85C

Loading …