Free Oracle 1Z0-082 Practice Test & Real Exam Questions, Page 1

Question #1

Which two are true about complete recovery? (Choose two.)

A. Incremental backups can be used to roll forward the database while performing it.

B. It is possible only when the database is in MOUNT state

C. The database must have FLASHBACK enabled in order to perform it.

D. Uncommitted transactions will be rolled back after it completes.

E. Only RMAN backupsets can be used to restore a database as part of it.

Discussion 0

Correct Answer: B,C Vote an answer

Question #2

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

A. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

B. Connect Time Failover requires the use of Transparent Application Failover (TAF)

C. Connect Time Failover requires the connect string to have two or more listener addresses configured

D. Source Routing requires the use of a name server

E. Load Balancing requires the use of a name server

F. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

Discussion 0

Correct Answer: A,C,D Vote an answer

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

Question #3

You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON'), `dd "Monday for"
fmMonth rrrr')
What is the result?

A. It returns the date for the last Monday of the current month

B. It executes successfully but does not return any result

C. It returns the date for the first Monday of the next month

D. It generates an error

Discussion 0

Correct Answer: C Vote an answer

Question #4

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?

A. 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;

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

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

D. 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;

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

Discussion 0

Correct Answer: A Vote an answer

Question #5

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A. The names and number of columns must be identical for all SELECT statements in the query.

B. 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.

C. The number, but not names, of columns must be identical for all SELECT statements in the query.

D. 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.

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

Discussion 0

Correct Answer: B,E Vote an answer

Question #6

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

A. A sequence can Issue duplicate values.

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

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

D. Sequences can always have gaps.

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

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

Discussion 0

Correct Answer: A,B,F Vote an answer

Question #7

Which three statements are true about Oracle synonyms? (Choose three.)

A. A SEQUENCE can have a synonym

B. A synonym created by one user can refer to an object belonging to another user

C. A synonym cannot be created for a PL/SQL package

D. A synonym can be available to all users

E. Any user can drop a PUBLIC synonym

Discussion 0

Correct Answer: A,B,D Vote an answer

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

Question #8

Which two statements are true about substitution variables?

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 double 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 single quotation marks.

Discussion 0

Correct Answer: B Vote an answer

Question #9

Which statement is true about the INTERSECT operator used in compound queries?

A. INTERSECT is of lower precedence than UNION or UNION ALL

B. Multiple INTERSECT operators are not possible in the same SQL statement

C. It processes NULLs in the selected columns

D. It ignores NULLs

Discussion 0

Correct Answer: C Vote an answer

Question #10

Which two are true about shrinking a segment online? (Choose two.)

A. It always eliminates all migrated rows if any exist in the table

B. To shrink a table it must have a PRIMARY KEY constraint

C. To shrink a table it must have a UNIQUE KEY constraint

D. It is not possible to shrink either indexes or Index Organized Tables (IOTs)

E. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

F. To shrink a table it must have row movement enabled

Discussion 0

Correct Answer: B,F Vote an answer

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

Question #11

Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.
Which two queries will execute successfully?

A. SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

B. SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';

C. SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;

D. SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK

E. SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';

F. SELECT prod_id I I q' ('s not available) ?'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK

Discussion 0

Correct Answer: D,E Vote an answer

Question #12

Which three statements are true about roles?

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

B. Roles must be password protected.

C. Object privileges may not be granted to roles.

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

E. Roles may be granted to roles.

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

Discussion 0

Correct Answer: C,E,F Vote an answer

Question #13

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

A. They cannot be partitioned

B. External table files can be used for other external tables in a different database

C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

D. They support UPDATEs but not INSERTs and DELETEs

E. The ORACLE_LOADER access driver can be used to unload data from a database into an external table

F. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

Discussion 0

Correct Answer: B,D,E Vote an answer

Question #14

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(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;

B. SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), '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;

Discussion 0

Correct Answer: B Vote an answer

Question #15

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months.
Which where clause can be used?

A. WHERE TO_XUMBER(start_date - SYSDATE) <= 25

B. WHERE ADD_MONTHS<start_date, 25) <= SYSDATE

C. WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25

D. WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25

Discussion 0

Correct Answer: D Vote an answer

Free Oracle 1Z0-082 Practice Test & Real Exam Questions

Download Free Oracle 1Z0-082 Demo