Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Oracle 1Z0-031 Exam -

Free 1Z0-031 Sample Questions:

1. While updating the rows in a table you realize that one of the rows violates a constraint on the table,
thereby causing the update to fail. Which statement is true in this scenario?
A.The undo data is moved to a temporary segment.
B.The undo data is retained and marked as obsolete.
C.The undo data is retained and reused when the update is executed again.
D.The space used by undo data is freed up to be reused by another transaction.
Answer: D

2. Which two statements are true for a bitmap index? (Choose two.)
A.It is recommended for the columns that have unique values.
B.It stores a string of bits that represent the key column values.
C.It can be converted to a B­Tree index by using the ALTER INDEX command.
D.The updating to the key column locks the whole bitmap segment that contains the bit for the key value
to be updated.
Answer: B, D

3. You want the Oracle server to force all the users of the administration department to change their passwords at regular intervals. What would you use to implement this?
C.system privilege
D.database trigger
E.Database Resource Manager
Answer: B

4. The SALES_ORDERS table has millions of rows. You want to avoid free list contention while users are querying and manipulating the rows concurrently. Which type of storage structure would you use to store the data?
A.clustered table with the tables stored in multiple tablespaces
B.regular table with the indexes stored in a different tablespace
C.partitioned table with partitions spread across multiple tablespaces
D.index­organized table with the indexes stored in a different tablespace
Answer: C

5. You accepted the position of DBA with a new company. The company has a database that operates in a 24x7 environment. You need to know if the database has been started using a text initialization parameter (PFILE) or a server parameter file (SPFILE).
Which two options help you to determine this? (Choose two.)
B.query the V$INSTANCE view
Answer: A, D

6. You want to store data in a table that should provide fast key­based access for queries involving exact matches and range searches. Which type of table would you use?
A.clustered table
B.index­organized table
C.regular partitioned table
D.regular table with referential integrity
Answer: B

7. You are using automatic undo management in your database. The database is using SPFILE and the
UNDO_TABLESPACE parameter is set to UNDO01. You created another undo tablespace, UNDO2. How would you ensure that the new undo tablespace is used for the new transactions? bringing the UNDO2 undo tablespace online setting the UNDO_TABLESPACE parameter to UNDO2 explicitly assigning the UNDO2 undo tablespace to the users explicitly assigning the UNDO2 undo tablespace to the transactions
Answer: B

8. In which two scenarios does a checkpoint occur? (Choose two.)
A.when a log switch occurs
B.when a segment is dropped
C.when a tablespace is dropped
D.when a tablespace is taken offline in NORMAL mode
Answer: A, D

9. A user connects to the Oracle server in dedicated server mode and executes a query to fetch rows from a table.
Which are the processes that are always involved in this task? (Choose all that apply.)
A.user process
B.server process
C.log writer (LGWR)
D.system monitor (SMON)
E.database writer (DBWn)
Answer: A, B

10. Because of poor response time on queries, you are asked to allocate more space to the component that holds SQL execution plans. To which component would you allocate more space?
A.Java Pool
B.Large Pool
C.Shared Pool
D.Row Cache
Answer: C

11. Which of the following files defines the characteristics of an Oracle instance? file
B.control file
C.archived redo log files
D.parameter file redo log file
Answer: D

12. Identify three components of an Oracle instance for which you can change the size dynamically.
(Choose three.)
A.Java Pool
B.Large Pool
C.Shared Pool
D.Redo Log Buffer
E.Database Buffer Cache
Answer: B, C, E

13. Which statement regarding the KEEP buffer pool is true assuming that it is sized correctly?
A.The buffer pool can be used for data blocks of standard size only.
B.The buffer pool can be used for data blocks of both standard and nonstandard sizes.
C.The buffer pool eliminates data blocks from memory when they are no longer needed.
D.The buffer pool holds data blocks from schema objects that are not assigned to any buffer pool.
Answer: A

14. A session in the database should not have access to the uncommitted changes made by other sessions. How does the Oracle server ensure this? using the redo log buffer using the undo segment using the temporary tables using the online redo log files using the temporary segment
Answer: B

15. You are working on an OLTP system where transactions are being performed. In which two situations will the log writer (LGWR) write redo entries to the online redo log files? (Choose two.)
A.every three seconds
B.when a transaction commits
C.when the redo log buffer is one­fourth full
D.after database writer (DBWn) writes dirty buffers to the data files
E.when there is more than 1 KB of changes recorded in the redo log buffer
Answer: A, B

16. Which statement regarding a session is true?
A.It starts when the user is validated by the Oracle server.
B.It starts when a connected user executes the first data manipulation language (DML) statement.
C.It starts when a connected user executes the first data definition language (DDL) statement.
D.It starts when a connected user executes the first SELECT statement on the database.
Answer: A

17. Which two statements regarding the database writer (DBWn) background process are true? (Choose two.)
A.It is an optional background process.
B.It writes dirty buffers to the data files whenever a checkpoint occurs.
C.It writes dirty buffers to the data files whenever a transaction commits.
D.It writes dirty buffers to the data files before the log writer (LGWR) writes. E.It is possible to have more than one database writer in an Oracle instance.
Answer: B, E

18. A user executes a query on a table. Which process is responsible for reading the user's data stored in the table from the data files into the database buffer cache?
A.user process
B.server process
C.checkpoint (CKPT)
D.system monitor (SMON)
E.database writer (DBWn)
F.process monitor (PMON)
Answer: B

19. Which three functions are provided by undo segments? (Choose three.) avoid dead locks maintain read consistency roll back an erroneous transaction record the old values of a transaction record both old and new values of a transaction
Answer: B, C, D

20. Which two statements regarding a server process are true? (Choose two.)
A.It is one of the mandatory background processes in an Oracle instance.
B.It starts on the client system when a user establishes a connection to the database instance.
C.It can be used by different user sessions one at a time if the database is in shared server mode.
D.It starts on the server when a user establishes a dedicated connection to the database instance.
E.It starts on the client system when the user starts a SQL*Plus session to interact with the database.
Answer: C, D

21. A user executes an update statement. Before the user could commit the transaction, the session terminated abnormally. What would happen in this scenario? (Choose two.)
A.Recoverer (RECO) performs session recovery.
B.PMON releases the locks held by the user session.
C.Process Monitor (PMON) rolls back the user's transaction.
D.System Monitor (SMON) rolls forward the user's transaction.
E.Checkpoint (CKPT) releases the locks held by the user session.
Answer: B, C

© 2014, All Rights Reserved