What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer / monal
Live Lock occurs when exclusive lock is denied continuously
by series of overlapping shared locks keep on interfering
each other and they keep changing status further preventing
them to complete the task.
| Is This Answer Correct ? | 2 Yes | 1 No |
You have just compiled a PL/SQL package but got errors, how would you view the errors?
How would you determine what sessions are connected and what resources they are waiting for?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
What is blocking and how would you troubleshoot it?
Explain an ORA-01555
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Give two examples of referential integrity constraints.
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
How do you tell what your machine name is and what is its IP address?
Query processing is slow(eg select query)how will u solve that
What are the different ways of moving data or databases between servers and databases in SQL Server?
what is the purpose of catlaog in oracle rman?
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)