Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
what is the function of a domaina domain defines the technical settings of a table fielda domain describes a value range which sets the permissible
what are the responsibility of file managerfile manager manager allocation of space on disk storage and the data structures used to represent within
explain transaction manager and their worktransaction manager ensure the database remains in a constant correct state despite system failure and in
explain authorization and integrity manager authorization and integrity manager tests for the satisfaction of integrity constraints and checks the
describe query evaluation enginequery evaluation engine vehicle executes low-level instructions obtained through the dml compilerthe storage manager
what is dml compilerdml compiler translates dml statements in a query language within low level instructions understandable through the query
determine a scheduling policy that is most suitable for a time-shared operating system round-robin is a scheduling policy that is most
define a linker program a linker program links the program along with other programs required for its
determine the task of the pass ii in a two-pass assemblersynthesize the target program is the task of the pass
determine what the expansion of nested macro calls follows the expansion of nested macro calls follows the last in first out lifo
the data of a view is not physically stored but derived from one or more tablestrue the data of a view is not physically
determine a parser which is a variant of top-down parsing without backtracking recursive descend parser is a variant of top-down parsing without
describe the functions and features of foreign keyforeign key the primary key of one file or table that is implanted in another file or table to
determine the syntax of the fork and join primitive answer syntax of the fork and join primitive is as followfork ltlabelgtjoin
describe the candidate key functions candidate key and alternate key in some instances an entity will have more than one attribute which can serve as
describe the primary key functionsprimary key the primary key is an attribute or a set of attributes in which uniquely identify a specific example
explain the concept of qbequery-by-example represents a visualgraphical approach for accessing information in a database by the use of query
what is the max no of structures that can be included in a table or
what are the causes of bucket overflow in a hash file organization what can be done to reduce the occurrence of bucket overflow when a record is
determine a component of a process precedence sequenceprocess name sequence operator lsquorsquo and concurrency operator
determine what the ldquoblocking factorrdquo of a file isblocking factor is the number of logical records in one physical
define the ldquothroughputrdquo of a system throughput is number of programs processed by it per unit
what are the advantages of by using an index and what are its disadvantages in difference if the search key of a secondary index is not a candidate
determine the reasons for poor response timeprocess busy or high io rates or high paging
what are the aggregate objects in the data dictionary views match codes lock