Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
describe the responsibilities of the dba and the database designer the responsibilities of dba and database designer are1 planning for the databases
what are segments in oraclesegments - each table has single field of disk space known as segment set aside for it in the tablespace segments consist
explain data dictonary on oracle data dictionary - data dictionaries are the system tables in which contain descriptions of the database objects and
what is data blockdata block - in oracle the data blocks are referred to as tablespaces a tablespace is an fields of disk consisting of one or more
describe drop table command of sql along with both the options - cascade and restrict drop table command - this command drops the specified table
given the following relations vehicle regno make colour personeno name address ownereno regno write expressions in the relational algebra to answer
given the following relationstrain name start destticket pnrno start dest fare passenger name address pnrno write sql expressions for the following
define a relation relation - a relations is a named two-dimensional table of data mathematically a relation can be described as a subset of the
differance between ddl and sdlddl and sdl - the data definition language ddl is used through dba and database designers to describe internal schema
what is conceptual schemaconceptual schema - conceptual schema elaborates the structure of the overall database for a community of users it hides the
what is catalog in dbmscatalog - a relational dbms maintains information about every table and index in which it contains a catalog is a collection
explain degree of relationdegree of a relation - the degree or arity of a relation is the number of attributes n of its relation
explain interblock gapinterblock gap - a track of a disk is separated into equal-sized disk blocks blocks are separated through fixed-size gaps
what is distributed system distributed system - a distributed system consists of a number of processing parts in which are interconnected through a
what is derived and stored attributederived and stored attribute - in a few cases two or more attribute values are associated for example age and
what are the purpose for having variable length records what kinds of separator characters are required for each variable-length records -
describe participation constraintsparticipation constraints - the participation constraint exacts whether the existence of an entity depends on its
what is cardinality ratiocardinality ratios - the cardinality ratios for relationship kinds specifies the maximum number of relationship instances in
with the help of an example display how records can be deleted and updated in qbe i increase payrate of employees along with the skill of lsquocook
describe interfaces for the dbainterfaces for the dba - most database systems holds privileged commands which could be used only through the dbas
explain interfaces for parametric usersinterfaces for parametric users - parametric users such as bank tellers frequent have a little set of
what is natural language interfacesnatural language interfaces - these interfaces accept requests written within english or a few other language and
describe graphical user interfacegraphical user interfaces guis - a gui typically displays a schema to the user in diagrammatic form the user can
define forms based interfacesforms-based interfaces - a forms-based interface display a form to each user forms are commonly designed and programmed
describe the menu based interfaces for web clients or browsingmenu-based interfaces for web clients or browsing - these interfaces present the user