7484828
Description
Quiz by Jamonero Blanco, updated more than 1 year ago
|
Created by Jamonero Blanco
about 7 years ago
|
|
Question 1
Question
1. Changes made with an UPDATE statement in a transaction are permanent in the data-base and visible to other users after what occurs?
Answer
-
A. DBWR flushes the changes to disk.
-
B. You issue a SAVEPOINT statement.
-
C. You issue a COMMIT statement.
-
D. A checkpoint occurs.
Question 2
Question
2. Which of the following commands returns an error if the transaction starts with SET
TRANSACTION READ ONLY ?
Answer
-
A. ALTER SYSTEM
-
B. SET ROLE
-
C. ALTER USER
-
D. None of the above
Question 3
Question
3. Guaranteed undo retention can be specified for which of the following objects?
Answer
-
A. A tablespace
-
B. A table
-
C. The database
-
D. A transaction
-
E. The instance
Question 4
Question
4. Which of the following lock modes permits concurrent queries on a table but prohibits
updates to the locked table?
Answer
-
A. ROW SHARE
-
B. ROW EXCLUSIVE
-
C. SHARE ROW EXCLUSIVE
-
D. All of the above
Question 5
Question
5. Select the statement that is not true regarding undo tablespaces.
Answer
-
A. Undo tablespaces will not be created if they are not specified in the CREATE DATABASE command.
-
B. Two undo tablespaces can be active if a new undo tablespace was specified and the old one contains pending transactions.
-
C. You can switch from one undo tablespace to another while the database is online.
-
D. UNDO_MANAGEMENT cannot be changed dynamically while the instance is running.
Question 6
Question
6. To resolve a lock conflict, which of the following methods can you use? Choose all
that apply.
Answer
-
A. Oracle automatically resolves the lock after a short but predefined time period by killing the session that is holding the lock.
-
B. The DBA can kill the session holding the lock.
-
C. The user can either roll back or commit the transaction that is holding the lock.
-
D. Oracle automatically resolves the lock after a short but predefined period by killing the session that is requesting the lock.
Question 7
Question
7. Two transactions occur at the wall clock times in the following table. What happens
at 10:05?
Answer
-
A. Session 2 will wait for session 1 to commit or roll back.
-
B. Session 1 will wait for session 2 to commit or roll back.
-
C. A deadlock will occur, and both sessions will hang unless one of the users cancels their statement or the DBA kills one of the sessions.
-
D. A deadlock will occur, and Oracle will cancel one of the statements.
-
E. Neither session is updating the same column, so no waiting or deadlock will occur.
Question 8
Question
8. If all extents in an undo segment fill up, which of the following occurs next? Choose
all that apply.
Answer
-
A. A new extent is allocated in the undo segment if all existing extents still contain active transaction data.
-
B. Other transactions using the segment are moved to another existing segment with enough free space.
-
C. A new undo segment is created, and the transaction that filled up the undo segment is moved in its entirety to another undo segment.
-
D. The first extent in the segment is reused if the undo data in the first extent is not needed.
-
E. The transaction that filled up the undo segment spills over to another undo segment.
Question 9
Question
9. Which of the following commands returns control to the user immediately if a table is
already locked by another user?
Answer
-
A. LOCK TABLE HR.EMPLOYEES IN EXCLUSIVE MODE WAIT DEFERRED;
-
B. LOCK TABLE HR.EMPLOYEES IN SHARE MODE NOWAIT;
-
C. LOCK TABLE HR.EMPLOYEES IN SHARE MODE WAIT DISABLED;
-
D. LOCK TABLE HR.EMPLOYEES IN EXCLUSIVE MODE NOWAIT DEFERRED;
Question 10
Question
10. Undo information falls into all the following categories except for which one?
Answer
-
A. Uncommitted undo information
-
B. Undo information required in case an instance crash requires a roll forward operation when the instance is restarted
-
C. Committed undo information required to satisfy the undo retention interval
-
D. Expired undo information that is no longer needed to support a running transaction
Question 11
Question
11. Undo segments are owned by which user?
Answer
-
A. SYSTEM
-
B. The user who initiated the transaction
-
C. SYS
-
D. The user who owns the object changed by the transaction
Question 12
Question
12. The EM Database Express Undo Advisor uses what to recommend the new size of the
undo tablespace?
Answer
-
A. The value of the parameter UNDO_RETENTION
-
B. The number of Snapshot too old errors
-
C. The current size of the undo tablespace
-
D. The desired amount of time to retain undo data
-
E. The most recent undo generation rate
Question 13
Question
13. Choose the option that is true regarding locks in Oracle Database 12c.
Answer
-
A. When session 1 has a table locked using the LOCK TABLE...EXCLUSIVE MODE statement, all DML statements and queries wait until session 1 does a COMMIT or ROLLBACK .
-
B. When SELECT...FOR UPDATE is performed, the table is locked.
-
C. The DDL_LOCK_TIMEOUT parameter can be set to TRUE to not return the ORA-00054 error.
-
D. The LOCK TABLE statement can include the WAIT clause to specify the number of seconds to wait for acquiring the lock.
Question 14
Question
14. The following table shows the timestamp and actions by two users. Choose the best
option that describes the outcome of the actions.
Answer
-
A. John’s query will return the same results all three times it is executed as they are run in the same session.
-
B. John’s queries run at 10:16 and 10:20 produce the same result, which is different from the one at 10:14.
-
C. John’s query run at 10:16 waits until 10:18 to produce results, waiting for the com- mit to happen.
-
D. John’s queries run at 10:14 and 10:16 produce the same result, which is different from the one at 10:20.
Question 15
Question
15. Which statement is true regarding the locking behavior of Oracle Database 12c?
Answer
-
A. Readers block writers.
-
B. Writers block readers.
-
C. Readers block writers.
-
D. Writers do not block readers.
Question 16
Question
16. Identify the operation that does not generate redo.
Answer
-
A. An INSERT statement reading from a global temporary table into a persistent table
-
B. An INSERT statement reading from a persistent table into a global temporary table
-
C. Roll back an UPDATE operation
-
D. Writing undo records during a DML operation
Question 17
Question
17. User Maria just called to let you know that the long-running query she runs every
week just received a Snapshot Too Old error. What is the best action you can take?
Answer
-
A. Tell Maria to rerun the query.
-
B. Increase Undo Retention.
-
C. The materialized view used in the query is stale and needs to be refreshed.
-
D. Increase the undo tablespace size.
Question 18
Question
18. Which two statements regarding undo and transactions are true?
Answer
-
A. Multiple active transactions can write concurrently to the same extent in an undo segment.
-
B. Multiple active transactions can write concurrently to the same undo segment.
-
C. Each transaction acquires an extent in the undo segment and does not share the extent.
-
D. Each transaction acquires a segment in the undo tablespace and does not share the segments.
Question 19
Question
19. Which statement ends a transaction?
Answer
-
A. UPDATE
-
B. ALTER TABLE
-
C. ALTER SESSION
-
D. ALTER SYSTEM
Question 20
Question
20. Which statement regarding lock is true?
Answer
-
A. A developer must lock the row before performing an update to prevent others from changing the same row.
-
B. When a row in a table is locked, the table is locked and no other transactions can update the table.
-
C. When two sessions try to update the same row at the same time, both sessions fail.
-
D. When a session tries to update the row already updated by another session, it waits until the other session does a commit or rollback.
Want to create your own Quizzes for free with GoConqr? Learn more.