Oracle Database Administration I (1Z1-082) Free Practice Test

Question 1

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions?
(Choose two.)

A. qty_sold BETWEEN `101' AND '110' : uses implicit conversion

B. CONCAT (qty_sold, invoice_date) : requires explicit conversion

C. invoie_date > '01-02-2019' : uses implicit conversion

D. invoice_date = '15-march-2019' : uses implicit conversion

E. qty_sold = `0554982' uses implicit conversion

Correct Answer: A,D

Question 2

Which two are true about the roles? (Choose two.)

A. The SET ROLE statement can be used once per session.

B. A role must be disabled before it can be revoked from a user.

C. The ALTER USER statement must be used to set specific default roles for a user.

D. All privileges and roles granted to a user are enabled by default when the user logs in.

E. The SET ROLE statement enables as well as disables roles in a session.

Correct Answer: D,E

Question 3

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

A. The Oracle join syntax supports creation of a Cartesian product of two tables

B. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

C. The SQL:1999 compliant ANSI join syntax supports natural joins

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

E. The Oracle join syntax supports natural joins

F. The Oracle join syntax only supports right outer joins

G. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

Correct Answer: C,E,G

Question 4

Which three statements are true regarding single row subqueries?

A. They must be placed on the left side of the comparison operator or condition.

B. They must return a row to prevent errors in the SQL statement.

C. They can be used in the where clause.

D. A SQL statement may have multiple single row subquery blocks.

E. They must be placed on the right side of the comparison operator or condition.

F. They can be used in the having clause.

Correct Answer: C,D,F

Question 5

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

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

B. Base tables can be queried directly

C. The data dictionary is created and maintained by the database administrator

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

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

F. It is owned by the SYSTEM user

Correct Answer: A,B,D

Question 6

The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully?

A. SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;

B. SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;

C. SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;

D. SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;

E. SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

Correct Answer: B,E

Question 7

Examine the description of the customers table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000.
Examine this partial query:
SELECT cust_last_name, cust_credit_limit FROM customers
Which two where conditions give the required result?

A.

B.

C.

D.

E.

Correct Answer: A,D

Question 8

Which two statements are true about the SET VERIFY ON command? (Choose two.)

A. It displays values for variables prefixed with &&

B. It displays values for variables created by the DEFINE command

C. It can be used in SQL Developer and SQL*Plus

D. It displays values for variables used only in the WHERE clause of a query

E. It can be used only in SQL*Plus

Correct Answer: B,E

Question 9

Examine this command and some partial output:

Why does the DB01.abc.comservice show unknown status?

A. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

B. The service DB01.abc.com is statically registered

C. The listener is not listening on the default port 1521

D. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

E. The service DB01.abc.com is dynamically registered

Correct Answer: D

Question 10

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?

A. UNION ALL

B. MINUS

C. INTERSECT

D. UNION

E. SUBTRACT

Correct Answer: B

Question 11

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

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

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

C. It can be used only from SQL*Plus

D. It displays all constraints that are defined for each column

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

F. It can be used from SQL Developer

Correct Answer: A,B,C

Question 12

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

A. A sequence can Issue duplicate values.

B. A sequence can only be dropped by a DBA.

C. Sequences can always have gaps.

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

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

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

Correct Answer: A,D,F

Question 13

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

A. An index created with the UNUSABLE attribute has no segment

B. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

C. A table that is truncated will always have its segment removed

D. Private Temporary Tables (PTTS) store metadata in memory only

E. An index that is altered to be UNUSABLE will retain its segment

Correct Answer: A,B

Question 14

Which two are true about instance recovery for a database that is open in read write mode?
(Choose two.)

A. It is always performed when opening a database.

B. The database opens after the roll forward phase of instance recovery has completed.

C. Only the CURRENT REDO log group is required to perform instance recovery.

D. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.

E. It is guaranteed to complete within fast_start_mttr_target number of seconds.

F. No users can log on until instance recovery has completed.

Correct Answer: A,D

Welcome to TestSimulate

Oracle Database Administration I (1Z1-082) Free Practice Test