[Sep 25, 2022] Valid 1Z0-082 Test Answers & Oracle 1Z0-082 Exam PDF [Q46-Q67]

Rate this post

[Sep 25, 2022] Valid 1Z0-082 Test Answers & Oracle 1Z0-082 Exam PDF

Realistic 1Z0-082 Exam Dumps with Accurate & Updated Questions

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

Tablespace free space can be viewed in V$TABLESPACE

V$TABLESPACE displays information that is contained in the controlfile about tablespaces

V$TABLESPACE 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

NEW QUESTION 47
Which is true about roles?

A role can be granted to other roles.

Roles can be created only by SYS or SYSTEM.

Roles containing object privileges can be created only by the object owner.

All roles belong to the SYSTEM schema.

A role can be password-protected only if it has been granted system privileges.

NEW QUESTION 48
Which two statements are true about the PMON background process? (Choose two.)

It registers database services with all local and remote listeners known to the database instance

It frees resources held by abnormally terminated processes

It records checkpoint information in the control file

It frees unused temporary segments

It kills sessions that exceed idle time

NEW QUESTION 49
Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

INTERSECT

UNION ALL

UNION

SUBTRACT

MINUS

NEW QUESTION 50
Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

SELECT * FROM customers WHERE city LIKE ‘D_%’;

SELECT * FROM customers WHERE city = ‘%D_’;

SELECT * FROM customers WHERE city LIKE ‘D_’;

SELECT * FROM customers WHERE city = ‘D_%’;

NEW QUESTION 51
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

Duplicates are eliminated automatically by the UNION ALL operator

The number of columns selected in each SELECT statement must be identical

The names of columns selected in each SELECT statement must be identical

The output is sorted by the UNION ALL operator

NULLS are not ignored during duplicate checking

NEW QUESTION 52
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

NEW QUESTION 53
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

NEW QUESTION 54
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

SYSDATE can be queried only from the DUAL table

CURRENT_DATE returns the current date and time as per the session time zone

SYSDATE can be used in expressions only if the default date format is DD-MON-RR

SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

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

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

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

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

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

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

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

NEW QUESTION 56
Which three activities are recorded in the database alert log? (Choose three.)

Data Definition Language (DDL) statements

non-default database parameters

block corruption errors

deadlock errors

session logins and logouts

NEW QUESTION 57
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

NEW QUESTION 58
The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017-03-06T12:15:17.183438+05:30
statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended due to ORA-01536: space quota exceeded for tablespace ‘DATA’ Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

Add a data file to DATA

Drop other U1 objects in DATA

Increase U1’s quota sufficiently in DATA

Set DEFERRED_SEGMENT_CREATION to TRUE

Grant UNLIMITED TABLESPACE to U1

Set AUTOEXTEND ON for data files in DATA

NEW QUESTION 59
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

NEW QUESTION 60
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

NEW QUESTION 61
Which two are true about conventional path SQL load? (Choose two.)

It does not generate UNDO.

It cannot load data into clustered tables.

It locks objects being processed.

It enforces referential integrity constraints.

It always generates redo.

NEW QUESTION 62
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

NEW QUESTION 63
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

NEW QUESTION 64
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

NEW QUESTION 65
Which three statements are true about a self join? (Choose three.)

The ON clause must be used

The query must use two different aliases for the table

It must be an equijoin

It must be an inner join

The ON clause can be used

It can be an outer join

NEW QUESTION 66
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

The CURRENT_TIMESTAMP function returns data without time zone information

A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

A TIMESTAMP data type column contains information about year, month, and day

The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

NEW QUESTION 67
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