Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
what is the purpose of storage managerthe storage manager is responsible for the followinga interaction with the file managerb translation of dml
what are the components of storage managerthe storage manager components includea authorization and integrity managerb transaction managerc buffer
what is storage managera storage manager is a program module that gives the interface among the low level data keeps in a database and the
define data modela data model is a collection of conceptual tools for explaining data data relationships data semantics and consistency
what is conceptual schemathe schemas at the view level are known as subschema that describe dissimilar views of the
define the terms 1 physical schema 2 logical schemaphysical schema the physical schema explains the database design at the physical level which is
define instance and schemainstance collection of data stored in the data base at a certain moment isschema the overall design of the data base is
give the levels of data abstractionthere are three levels of data abstractiona physical levelb logical levelc view
what are the advantages of using a dbmsthe benefits of using a dbms area controlling redundancyb restricting unauthorized accessc giving multiple
what are the disadvantages of file processing systemthe drawbacks of file processing systems area data redundancy and inconsistencyb complexity in
list any eight applications of dbmsa universitiesb airlinesc bankingd credit card transactionse tele communicationf salesgfinanceh manufacturingi
define database management systemdatabase management system dbms is a set of interrelated data and a combination of programs to access those
question discuss the problem which may arise during concurrency control and recovery in distributed database which are not encountered in controlized
the advantages of a database management system dbms include -data integrity and elimination of
as with other software databases can potentially be used for unethical purposes as a database developer and a consumer you should recognize database
can you assist me in database management system i need help in my courses please email me at and get back me
how is oracle used in plsql define the features of process and how they are definedplsql - plsql is oracles procedural language pl superset
what is data model explain object based and record based data modelsans a data model is an abstract model in which describes how data is represented
explain the disadvantages of a file processing systemans disadvantages of file processing systems include 1 data redundancy 2 data inconsistency 3
explain the following functions of oracle with suitable examples i tochar ii count iii trim iv length ans i tochar the tochar function converts a
what are the key features of oracle key features of oracle are as followsbull read consistencybull concurrencybull locking mechanismsbull quiesce
explain instance and schemasinstances and schemas databases changes over time as the information is deleted and inserted the collection of
what are the disadvantages of relational approachdisadvantages of relational approachbull substantial hardware and system software overheadbull may
write short notes on relational constraintsrelational constraints are1not null2unique3primary key4foreign key5table
consider the relationsemployeeemp name assignedtoproject emp projectproject projectname chief express the subsequent queries in relational algebrai