Curious about Actual Oracle Database (1Z0-082) Exam Questions?

Here are sample Oracle Database Administration I (1Z0-082) Exam questions from real exam. You can get more Oracle Database (1Z0-082) Exam premium practice questions at TestInsights.

Page: 1 /
Total 142 questions

Want more questions? Get Premium Access.

Question 1

Examine this description of the books table containing 100 rows:

Now examine this sequence of statements Issued In a new session;

Examine this description of the books table containing 100 rows:

Which three statements are true?

AThe second rollback command restores the row that was inserted.

BThe first rollback command leaves the table's 100 original rows locked.

CThe second rollback command rolls back the rollback to savepoint a command.

DThe first rollback command leaves the inserted row locked.

EThe first RollBack command restores the row that was inserted.

FThe second rollback command restores the 100 rows that were in the table originally.

GThe first rollback command restores the 100 rows that were in the table originally.

Correct : A, C, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AThe second rollback command restores the row that was inserted.

BThe first rollback command leaves the table's 100 original rows locked.

CThe second rollback command rolls back the rollback to savepoint a command.

DThe first rollback command leaves the inserted row locked.

EThe first RollBack command restores the row that was inserted.

FThe second rollback command restores the 100 rows that were in the table originally.

GThe first rollback command restores the 100 rows that were in the table originally.

0 / 1500

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?

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

BSELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;

CSELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;

DSELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

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

BSELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;

CSELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;

DSELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

0 / 1500

Question 3

Examine this command:

Which two statements are true?

ACompressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.

BDML may be performed on tables with one or more extents in this data file during the execution of this command.

CIt overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.

DThe 'to' clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

ETables with one or more extents in this data file may be queried during the execution of this command.

Correct : B, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ACompressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.

BDML may be performed on tables with one or more extents in this data file during the execution of this command.

CIt overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.

DThe 'to' clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

ETables with one or more extents in this data file may be queried during the execution of this command.

0 / 1500

Question 4

The orders table has a column ORDER_DATE of data type date.

The default display format for a date Is DD-MON-RR.

Which two where conditions demonstrate the correct usage of conversion functions?

AWHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

BWHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'

CWHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')

DWHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))

EWHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')

Correct : B, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AWHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

BWHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'

CWHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')

DWHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))

EWHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')

0 / 1500

Question 5

Which two statements are true about Database Instances and Real Application Clusters (RAC)?

AA RAC database can have one Instance.

BA RAC database can have instances on separate servers.

CTwo RAC databases can share their instances.

DA RAC database must have three or more Instances.

EA RAC database must have two or more instances.

Correct : A, B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AA RAC database can have one Instance.

BA RAC database can have instances on separate servers.

CTwo RAC databases can share their instances.

DA RAC database must have three or more Instances.

EA RAC database must have two or more instances.

0 / 1500

Page: 1 / 29
Total 142 questions

Unlock Full
1Z0-082 Exam Features

In Just $49 You can Access

All Official Question Types
Interactive Web-Based Practice Test Software
No Installation or 3rd Party Software Required
Customize your practice sessions (Free Demo)
24/7 Customer Support

Get Full Access Now

Marked Questions
1Z0-082 Exam

1Z0-082 Exam Question 1
1Z0-082 Exam Question 2
1Z0-082 Exam Question 3
1Z0-082 Exam Question 4
1Z0-082 Exam Question 5

Download PDF File Demo

Try Web-Based Exam Practice Software Demo

Commenting

In order to participate in the comments you need to be logged-in.
You can sign-up or login