A user receives the following error while executing a query ORA-01555 snapshot too old

Explore topic-wise MCQs in Oracle Database.

This section includes 1 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle Database knowledge and support exam preparation. Choose a topic below to get started.

1.	A user receives the following error while executing a query: ORA-01555: snapshot too old
A.	nPredict one way to avoid such errors in near future.
B.	Increase the size of redo log files
C.	Increase the size of the undo tablespace
D.	Increase the size of the Database Buffer Cache
E.	Increase the size of the default temporary tablespace
Answer» C. Increase the size of the undo tablespace

Discussion

Explore topic-wise MCQs in Oracle Database.

A user receives the following error while executing a query: ORA-01555: snapshot too old