15 November, 2020

Virtual Oracle 1z0-082 Exam Online

Cause all that matters here is passing the Oracle 1z0-082 exam. Cause all that you need is a high score of 1z0-082 Oracle Database Administration I exam. The only one thing you need to do is downloading Passleader 1z0-082 exam study guides now. We will not let you down with our money-back guarantee.

Online Oracle 1z0-082 free dumps demo Below:

Page: 1 / 7

Total 90 questions Full Exam Access

Question 1

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 databaseserver target

Question 2

Which three statements are true about the DESCRIBE command? (Choose three.)

It displays the PRIMARY KEY constraint for any column or columns that have that constraint

It can be used from SQL Developer

It displays the NOT NULL constraint for any columns that have that constraint

It can be used to display the structure of an existing view

It displays all constraints that are defined for each column

It can be used only from SQL *Plus

Question 3

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

the number of hours for which an account is locked after the configured number of login attempts has been reached

the number of days for which an account may be inactive before it is locked

the maximum amount of CPU time allowed for a user’s sessions before their account is locked

the ability to prevent a password from ever being reused

the number of password changes required within a period of time before a password can be reused

the number of days for which an account is locked after the configured number of login attempts has been reached

the maximum number of sessions permitted for a user before the account is locked

Question 4

You execute this command:
1Z0-082 dumps exhibit

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

Question 5

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.

An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.

Partition key columns cannot be dropped.

A DROP COLUMN command can be rolled back

A column that is set to UNUSED still counts towards the limit of 1000 columns per table

Question 6

Examine the description of the PROMOTIONS table:
1Z0-082 dumps exhibit

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

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

Question 8

View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries? (Choose two.)
1Z0-082 dumps exhibit

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

Question 9

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

Question 10

Which three are types of segments in an Oracle Database? (Choose three.)

undo

index

stored procedures

sequences

tables

clusters

Question 11

A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql What will happen upon execution?

The command succeeds and HR will be connected to the orcl and abc.sql databases

The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed

The command fails because the script must refer to the full path name

The command fails and reports an error because @ is used twice

Question 12

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:
1Z0-082 dumps exhibit

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

Question 13

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query

WHERE and HAVING clauses can be used in the same statement only if applied to different table columns

The HAVING clause can be used with aggregating functions in subqueries

The WHERE clause can be used to exclude rows before dividing them into groups

The WHERE clause can be used to exclude rows after dividing them into groups

Question 14

Examine the description of the SALES1 table:
1Z0-082 dumps exhibit

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

Question 15

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

Question 16

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

Question 17

Which two tasks can you perform using DBCA for databases? (Choose two.)

Configure a nonstandard block size for a new database

Change the standard block size of an existing database

Configure incremental backups for a new database

Enable flashback database for an existing database

Question 18

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set

The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

It supports diagnostics for Automatic Storage Management (ASM)

It supports diagnostics for Oracle Clusterware

It is held inside an Oracle database schema

Question 19

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

PCTFREE defaults to 10% for all blocks in all segments for all compression methods

ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

A block will always be eligible for inserts if the row is short enough to fit into the block

Question 20

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)

Question 21

You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

SELECT TO_CHAR(SYSDATE, ‘DD-MON-YYYY’) – ’01-JAN-2019’ FROM DUAL;

SELECT ROUND(SYSDATE – ’01-JAN-2019’) FROM DUAL;

SELECT ROUND(SYSDATE – TO_DATE(‘01/JANUARY/2019’)) FROM DUAL;

SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ‘01/JANUARY/2019’ FROM DUAL;

SELECT SYSDATE – TO_DATE(’01-JANUARY-2019’) FROM DUAL;

Question 22

You execute this command:
1Z0-082 dumps exhibit

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

AUTOEXTEND is possible for the datafile

It must be bigger than the largest SMALLFILE tablespace

Additional data files may not be added

It will be a dictionary-managed tablespace by default

It will always have a 32K blocksize

Question 23

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

External table files can be used for other external tables in a different database

The ORACLE_LOADER access driver can be used to unload data from a database into an external table

The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

They cannot be partitioned

The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

They support UPDATEs but not INSERTs and DELETEs

Page: 1 / 7

Total 90 questions Full Exam Access