1. Home
  2. Oracle
  3. Oracle Database 19c
  4. 1z0-082
  5. Oracle Database Administration I Questions and Answers

Pass the Oracle Oracle Database 19c 1z0-082 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 5 pages
Viewing questions 1-10 out of questions
Questions # 1:

Examine the description of the product_details table:

Question # 1

Which two statements are true?

Options:
A.

PRODUCT _ic can be assigned the PRIMARY KEY constraint.

B.

PRODUCT _price contains the value zero by default if no value is assigned to it.

C.

PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.

D.

EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.

E.

PRODUCT_NAKE cannot contain duplicate values.

F.

EXPIRY_ DATE cannot be used in arithmetic expressions.

Questions # 2:

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

Options:
A.

Oracle Managed Files (OMF)

B.

Online table segment shrink

C.

Online index segment shrink

D.

Automatic data file extension (AUTOEXTEND)

E.

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

Questions # 3:

Which three statements are true about sequences in a single instance Oracle database?

Options:
A.

Sequences can always have gaps.

B.

A sequence can Issue duplicate values.

C.

A sequence's unallocated cached values are lost if the instance shuts down.

D.

Two or more tables cannot have keys generated from the same sequence.

E.

A sequence can only be dropped by a DBA.

F.

A sequence number that was allocated can be rolled back if a transaction fails.

Questions # 4:

Which two statements are true about substitution variables?

Options:
A.

A substitution variable prefixed with & always prompts only once for a value in a session.

B.

A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session

C.

A substitution variable can be used only in a select statement.

D.

A substitution variable used to prompt for a column name must be enclosed in single quotation marks.

E.

A substitution variable can be used with any clause in a select statement.

F.

A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

Questions # 5:

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?

Options:
A.

SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

B.

SELECT &col1, &col2FROM &&tableWHERE &condition;

C.

SELECT &col1, &col2FROM “&table”WHERE &condition;

D.

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

E.

SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Questions # 6:

Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

Options:
A.

A single database instance can support connections for multiple service names.

B.

A service name is created by a listener.

C.

A single connection string can refer to multiple database instances.

D.

A connection string including a service name must be defined in the cnsnames.ora file.

E.

A connection string must include the SID of a database Instance.

F.

Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.

Questions # 7:

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

Options:
A.

A full outer join returns matched and unmatched rows

B.

An inner join returns matched rows

C.

Outer joins can only be used between two tables per query

D.

A full outer join must use Oracle syntax

E.

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

F.

A left or right outer join returns only unmatched rows

Questions # 8:

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

Options:
A.

Configure a nonstandard block size for a new database

B.

Register a new database with an available Enterprise Manager Management server

C.

Change the standard block size of an existing database

D.

Configure incremental backups for a new database

E.

Enable flashback database for an existing database

Questions # 9:

Which three statements are true about Deferred Segment Creation in Oracle databases?

Options:
A.

It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

B.

Sessions may dynamically switch back and forth from deferred to immediate segment creation.

C.

It Is the default behavior for tables and indexes.

D.

It is supported for SYS-owned tables contained in locally managed tablespaces.

E.

Indexes inherit the deferred or immediate segment creation attribute from their parent table

Questions # 10:

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

Options:
A.

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

B.

A table can have only one primary key and one foreign key

C.

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

D.

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

E.

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

F.

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

G.

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

Viewing page 1 out of 5 pages
Viewing questions 1-10 out of questions