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

Question #27

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 be the value of the SERVICE_NAMES parameter on the client side

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

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

Discussion 0

Correct Answer: A Vote an answer

Question #28

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

A. Dynamic service registration cannot be used for this database instance

B. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port
1521 on the same host as the database instances

C. The LREG process registers services dynamically with the LISTENER_1 listener

D. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Discussion 0

Correct Answer: D Vote an answer

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

Question #29

Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL,
NULL);
SAVEPOINT a;
DELETE FROM books;
ROLLBACK TO SAVEPOINT a;
ROLLBACK;
Which two statements are true? (Choose two.)

A. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

B. The second ROLLBACK command does nothing

C. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

D. The second ROLLBACK command replays the delete

E. The second ROLLBACK command undoes the insert

Discussion 0

Correct Answer: C,E Vote an answer

Question #30

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

A. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

B. PCTFREE defaults to 10% for all blocks in all segments for all compression methods

C. A block will always be eligible for inserts if the row is short enough to fit into the block

D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

E. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

Discussion 0

Correct Answer: A,C Vote an answer

Question #31

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 #32

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

A. A table row piece can be chained across several database blocks

B. Data block free space is always contiguous in the middle of the block

C. Index block free space is always contiguous in the middle of the block

D. Multiple row pieces from the same row may be stored in the same block

E. Multiple row pieces from the same row may be stored in different database blocks

F. Data block headers contain their own Data Block Address (DBA)

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #33

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?
(Choose three.)

A. analysis of privileges that a user has on their own schema objects that they did use

B. analysis of all privileges used by all users but excluding administrative users in the database

C. analysis of all privileges used by all users including administrative users in the database

D. analysis of privileges that a user has on their own schema objects that they did not use

E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role

F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Discussion 0

Correct Answer: C,D,F Vote an answer

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

Question #34

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 #35

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

A. The control file is read

B. The Oracle background processes are started

C. The online data files are opened

D. The online redo logs are opened

E. The alert log records the execution details

F. The initialization parameter file is read

Discussion 0

Correct Answer: A,B Vote an answer

Question #36

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

A. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;

B. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

C. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

D. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;

E. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

Discussion 0

Correct Answer: B,C Vote an answer

Question #37

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

A. the ability to prevent a password from ever being reused

B. the maximum amount of CPU time allowed for a user's sessions before their account is locked

C. the maximum number of sessions permitted for a user before the account is locked

D. the number of days for which an account is locked after the configured number of login attempts has been reached

E. the number of hours for which an account is locked after the configured number of login attempts has been reached

F. the number of password changes required within a period of time before a password can be reused

G. the number of days for which an account may be inactive before it is locked

Discussion 0

Correct Answer: A,C,D,F Vote an answer

Question #38

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

A. Uncommitted transactions will be rolled back after incomplete recovery completes.

B. Incomplete recovery is possible only when the database is open.

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

D. Only incremental backups can be used to roll forward the database while performing complete recovery.

E. Uncommitted transactions will be rolled back after complete recovery completes.

Discussion 0

Correct Answer: D,E Vote an answer

Question #39

While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.
Which two statements are true?

A. V$DATAFILE displays the new names for the data files.

B. DBA_DATA_FILES displays the new name for the data files.

C. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.

D. DBA_DATA _FILES displays both the new name and the old name for the data files.

E. DBA_DATA_FILES displays the original name for the data files.

Discussion 0

Correct Answer: D,E Vote an answer

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

Download Free Oracle 1Z1-082 Demo