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

Question 1

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?

A. SELECT &col1, &col2
FROM &&table
WHERE &condition;

B. SELECT &&col1, &&col2
FROM &table
WHERE &&condition;

C. SELECT &col1, &col2
FROM "&table"
WHERE &condition;

D. SELECT `&&col1', `&&col2'
FROM &table
WHERE `&&condition' = `&cond';

E. SELECT &&col1, &&col2
FROM &table
WHERE &&condition = &&cond;

Correct Answer: A

Question 2

The customers table has a cust_last_name column of data type varchar2. The table has two rows whose "jst_last_name values are Andersen and Ausson. Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?

A. SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;

B. SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;

C. SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

D. SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;

Correct Answer: A

Question 3

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

A. It Is held Inside an Oracle database schema.

B. The ADR base is specified In the diagnostic_dest database parameter.

C. It is only used for Oracle Database diagnostic information.

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

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

Correct Answer: A,B,D

Question 4

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

A. It must be the name of the server running the database to whose instance HR wishes to connect

B. It must be the name of the database to whose instance HR wishes to connect

C. It must resolve to a valid connect descriptor in the client's tnsnames.ora file

D. It must resolve to a valid connect descriptor in the server's tnsnames.ora file

E. It must be the value of the SERVICE_NAMES parameter on the client side

Correct Answer: A

Question 5

View the Exhibit and examine the description of the tables.
You execute this SQL statement:

Which three statements are true?

A. A customer can exist in many countries.

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

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

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

E. The sales table has five foreign keys.

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

Correct Answer: C,E,F

Question 6

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

A. SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;

B. SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;

C. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;

D. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

E. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

Correct Answer: A,E

Question 7

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

B. GLOBAL TEMPORARY TABLE space allocation occurs at session start.

C. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

D. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

E. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

F. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

Correct Answer: A,B,C

Question 8

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

Question 9

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

A. ROW STORE COMPRESS ADVANCED

B. ROW STORE COMPRESS BASIC

C. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

D. COLUMN STORE COMPRESS FOR QUERY LOW

E. COLUMN STORE COMPRESS FOR ARCHIVE LOW

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 10

Which three statements are true about roles?

A. Roles must be password protected.

B. All roles granted to a user are set on by default when the user logs in,

C. The SET ROLE statement can disable one or more roles for a session.

D. Object privileges may not be granted to roles.

E. The SET ROLE statement can enable one or more roles for a session.

F. Roles may be granted to roles.

Correct Answer: C,D,F

Welcome to TestSimulate

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