Explain an ORA-01555
Answers were Sorted based on User's Feedback
Answer / daid kumar
When we Perform the larg DML operation on a table then this
Error is occure
ORA-01555 snapshot too old
to remove this error in 8i or below version You have to
increase the size or rollback segment
and in above version You can Increase the Size Of Undo
tablespace
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / ashok
increase the size of undo tablespace
increase retention period
| Is This Answer Correct ? | 0 Yes | 1 No |
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
Give two examples of referential integrity constraints.
what are the differences of where and if in SAS?
How would you determine the time zone under which a database was operating?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
when does an alert gets signaled?
how can you create a user-defined lock?
wat is global index and local indes
What would you do with an "in-doubt" distributed transaction?
What is transparent data encryption? : sql server DBA
how can you implement fine-grained auditing?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)