Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
explain data sublangauges data sublanguage in relational database theory the term sublanguage first used for this purpose through e f codd in the
explain controlled redundancycontrolled redundancy the replication of data within the data warehouse for the purposes of improved data access or
define dba database administratordba a database administrator dba is a person who is responsible for the environmental aspects of a database in
what is database utilitydatabase utility is the interface among the abap4 dictionary and the underlying the sap
define what a macro definition consists of
describe parameteric end usersparametric end users might be given update access but are commonly not permitted to change the structure of
how many types of views are there there are four types of views- database view help view projection view maintenance
define the features are needed to implement top down parsing
define catalog and meta data a catalog is a compilation of records elaborating the contents of a particular collection or group of collections
what is a viewa view is a logical view on one or more tables a view on one or more tables ie the data from a view is not actually physically kept
determine the syntax of the assembler directive equ the following is syntax of the assembler directive equltsymbolgtequltaddress
determine a processing that is not a part of synthesis phase perform lc processing is not a part of synthesis
locality of reference entails that the page reference being made by a process locality of reference entails that the page reference being made by
can we delete data element which is being used by table fields no we cant delete data
can a domain assigned to a data element be changedyes we can do so by just overwriting the entry in the field
an operating system involves 3 user processes each one requiring 2 units of resource r the minimum number of units of r like no deadlocks will ever
determine a critical section is a program segment critical section is where shared resources are
explain the functions of data managerfunctions of data manager - convert operations in users queries coming directly through query processor or
describe disk manager and their workdisk manager responsible for fetching data regulated through file manager from disk storage within main memory
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