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 |
Explain how you would restore a database using RMAN to Point in Time?
How do you resize a data file?
i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Give two examples of referential integrity constraints.
how can you schedule a job in database?
Explain an ORA-01555
How do you tell what your machine name is and what is its IP address?
What are the commands used in dcl? : sql server DBA
who owns the operating system files created by the utl_file package?
what is the use of recording information about current session?
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)