1z0-082 Oracle Database Administration I Questions and Answers

SELECT join_date FROM employees WHERE join_date > '10-02-2018';

SELECT join_date I I ' ' II salary FROM employees;

SELECT SUBSTR

SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;

Table aliases can improve performance

The BETWEEN condition always performs better than using the >= and <= conditions

The join syntax used makes no difference to performance

The BETWEEN condition always performs less well than using the >= and <= conditions

The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

after successfully executing a commit or rollback followed by a select statement

after successfully executing a create table as select statement followed by a select for update statement

after successfully executing a commit or rollback followed by a DML statement

after successfully executing a create table statement followed by a create index statement

after successfully executing a DML statement following a failed DML statement

after successfully executing a truncate statement followed by a DML statement

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

The online redo logs are opened

The online data files are opened

The alert log records the execution details

The Oracle background processes are started

The initialization parameter file is read

The control file is read

undo

index

stored procedures

sequences

tables

clusters

writing inbound request to the common request queue from all shared server connections

checking for outbound shared server responses on the common outbound response queue

receiving inbound requests from processes using shared server connections

sending each connection input request to the appropriate shared server input queue

broadcasting shared server session responses back to requesters on all connections

sending shared server session responses back to requesters on the appropriate connection

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

SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;

SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;

SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

An undo segment may be used by multiple transactions simultaneously

Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

Undo segments have a minimum of three extents

Undo segments can extend when a transaction fills the last extent of the undo segment

A single transaction may use multiple undo segments simultaneously

Undo segments must be stored in a BIGFILE tablespace

Undo segments must be stored in a SMALLFILE tablespace

It has its own commands that are separate from any SQL statements.

It must be downloaded from the Oracle Technology Network (OTN).

It can run scripts entered at the SQL prompt.

It can run Recovery Manager (RMAN) commands.

It has both command-line and graphical user interfaces (GUI).

It can run scripts passed to it by a shell script.

It Is held Inside an Oracle database schema.

The ADR base is specified In the diagnostic_dest database parameter.

It is only used for Oracle Database diagnostic information.

It is a file-based repository held outside any database.

It can be used for problem diagnosis of a database when that database's instance is down.

The statement will fall if a row already exists in the sales table for product 23.

The sales table has five foreign keys.

A product can have a different unit price at different times.

A customer can exist in many countries.

The statement will execute successfully and a new row will be inserted into the sales table.

The statement will fail because a subquery may not be contained in a values clause.

Create a template that can be used to clone the database.

Change the server mode from dedicated to shared, and vice versa.

Change the character set.

Create an additional listener.

Create nonstandard block size tablespaces.

It is owned by the sys user.

Data dictionary base tables can be queried directly.

It is owned by the system user.

Data dictionary views are always created with queries that join two or more base tables.

All data dictionary view joins base tables to dynamic performance views.

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.

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

SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 “DUES” FROM transactions;

SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 DUES FROM transactions;

SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 “DUES AMOUNT” FROM transactions;

SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE, amount + 100 ‘DUES AMOUNT’ FROM transactions;