What are the various kinds of interactions catered by dbms?
No Answer is Posted For this Question
Be the First to Post Answer
How a Store Procedure called with a cursor out parameter.?
Explain the Surrogate Key in DBMS.
What are the different levels of abstraction in the dbms?
What is second normal form?
Where the Databases overall structure is maintained ?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
Define the relationship between ‘view’ and ‘data independence’.
What is in a database?
Explain armstrong rules? How they are complete and/or sound?
What is the purpose of normalization in dbms?
Can we update table which is created from view?
2 Answers IBM, Punjab National Bank,
What do you understand by fragmentation?
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)