Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
differance between procedural and non procedural dmlprocedural and non procedural dml procedural dml exactly what data is require and how to obtain
explain data abstractiondata abstraction data abstraction is a methodology in which enables us to isolate how a compound data object is utilized from
explain the term high level dmlhigh level dml a high-level or non-procedural dml permit the user to specify what data is needed without specifying
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
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 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
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
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
the data of a view is not physically stored but derived from one or more tablestrue the data of a view is not physically
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
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