Provide Oracle 1Z1-082 Dumps Updated Mar 14, 2023 With 145 QA's [Q33-Q49] : IT Certification Exam Braindumps : http://blog.braindumpsit.com

NEW QUESTION 33
The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING
`dallas_db’;
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

as SCOTT in DALLAS_DB

as SCOTT in BOSTON_DB

as SCOTT in BOSTON_DB and SYS in DALLAS_DB

as SYS in both the databases

as SCOTT in both the databases

NEW QUESTION 34
Which two statements are true about Enterprise Manager Database Express? (Choose two.)

It is available only when the database is open

It can be used to perform database recovery

The same port number can be used for Database Express configurations for databases on different hosts

It can be used to switch a database into ARCHIVELOGMODE

The same port number can be used for multiple Database Express configurations for multiple databases on the same host

NEW QUESTION 35
Examine the description of the EMPLOYEES table:

Which query is valid?

SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

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

NEW QUESTION 37
Which three statements are true about the Oracle Data Dictionary? (Choose three.)

Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

The data dictionary is created and maintained by the database administrator

Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

Base tables can be queried directly

It is owned by the SYSTEM user

Usernames of all users including database administrators are stored in the data dictionary

NEW QUESTION 38
Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND due_amount IS NOT NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND cust_credit_level !=NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level <> NULL
AND due_amount <> NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND due_amount != NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL;

NEW QUESTION 39
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 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.

NEW QUESTION 40
You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression
Which compression option is best suited for this?

COLUMN STORE COMPRESS FOR QUERY LOW

ROW STORE COMPRESS BASIC

COLUMN STORE COMPRESS FOR ARCHIVE LOW

COLUMN STORE COMPRESS FOR ARCHIVE HIGH

ROW STORE COMPRESS ADVANCED

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

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

NEW QUESTION 43
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 tablespaces

NEW QUESTION 44
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 45
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

A table can have only one primary key but multiple foreign keys

A table can have only one primary key and foreign key

The foreign key columns and parent table primary key columns must have the same names

It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

Only the primary key can be defined at the column and table level

Primary key and foreign key constraints can be defined at both the column and table level

NEW QUESTION 46
Examine this command:

Which two statements are true? (Choose two.)

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

The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

The file is renamed and stored in the same location

NEW QUESTION 47
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 tablespaces

NEW QUESTION 48
Which two types of files are opened by a database instance in the NOMOUNT state?

control files

the alert log

the initialization parameter file

data files

online redo logs

NEW QUESTION 49
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.