Free Feb-2023 UPDATED Oracle 1Z1-082 Exam Questions & Answer [Q52-Q69]

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

Q53. Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.

The number, but not names, of columns must be identical for all SELECT statements in the query.

The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

The names and number of columns must be identical for all SELECT statements in the query.

The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Q54. Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

Local naming can be used if Connect-Time Failover Is required.

A client can connect to an Oracle database instance even If no client side network admin has been configured.

Directory Naming requires setting the TNS_ADMIN environment variable on the client side.

Local Naming requires setting the TNS_ADMIN environment variable on the client side.

Directory Naming can be used if Connect-Time Failover is required.

Easy Connect supports TCP/IP and SSL.

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

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

Q57. You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

You can no longer monitor it

You can reattach to it and monitor it

It is paused and can be resumed

It continues to run in the background

It terminates

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

Q59. Which three statements are true about inner and outer joins? (Choose three.)

A full outer join returns matched and unmatched rows

An inner join returns matched rows

Outer joins can only be used between two tables per query

A full outer join must use Oracle syntax

Outer joins can be used when there are multiple join conditions on two tables

A left or right outer join returns only unmatched rows

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

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

Q62. Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

Tablespace free space can be viewed in VSTABLESPACE

VSTABLESPACE displays information that is contained in the controlfile about tablespaces

VSTABLESPACE displays information about tablespaces contained in the data dictionary

Tablespace free space can be viewed in DBA_TABLESPACES

A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

Q63. Which two statements are true about Database Instances and Real Application Clusters (RAC)?

A RAC database can have one Instance.

A RAC database can have instances on separate servers.

Two RAC databases can share their instances.

A RAC database must have three or more Instances.

A RAC database must have two or more instances.

Q64. Examine these commands:

Which two statements are true about the sqlldrexecution? (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

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

Q66. Which three statements are true about inner and outer joins? (Choose three.)

A full outer join returns matched and unmatched rows

An inner join returns matched rows

Outer joins can only be used between two tables per query

A full outer join must use Oracle syntax

Outer joins can be used when there are multiple join conditions on two tables

A left or right outer join returns only unmatched rows

Q67. Which compression method is recommended for Direct-Path Insert operations?

COLUMN STORE COMPRESS BASIC

COLUMN STORE COMPRESS ADVANCED

RON STORE COMPRESS BASIC

ROW STORE COMPRESS ADVANCED

Q68. Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

Oracle Managed Files (OMF)

Online table segment shrink

Online index segment shrink

Automatic data file extension (AUTOEXTEND)

Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

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

Free Feb-2023 UPDATED Oracle 1Z1-082 Exam Questions & Answer [Q52-Q69]

Introduction to Oracle 1z0-082: Oracle Database Adminstration 1 Exam

Who should take the Oracle 1z0-082: Oracle Database Administration I Exam

Average Salary for Oracle 1z0-082: Oracle Database Administration 1 Exam

Be the first to reply

Leave a Reply Cancel reply

Introduction to Oracle 1z0-082: Oracle Database Adminstration 1 Exam

Who should take the Oracle 1z0-082: Oracle Database Administration I Exam

Average Salary for Oracle 1z0-082: Oracle Database Administration 1 Exam