Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
what functions does a data dictionary perform in a dbmsdata management system the principal functions performed by the data dictionary are management
what is a data dictionary data dictionary is a main source of data in a data management system its major function is to carry the creation and
mention the type of constraints we can specify in the create command of ddlthe type of constraints that can be specified are as follows-primary key
create a view empdep containing ename and number of dependents from the tables employee and dependent of icreate view empdept as select ename count
create role named roletable that allows a user to create tables using roletable allow users kripa and reena to create tablescreate role roletable
consider employee table of i and list names of departments for which average salary for department is more than 10000select dname from dept where
consider the table student and list names of students in the departments other than maths and computerselect stdname frm student where deptname not
define where a program generation activity aims program generation activity aims at automatic generation of
define approaches that require knowledge of the system state answer deadlock detection deadlock prevention deadlock
a constraint named lessthan20 was defined on the field dateofbirth of table student delete this constraintalter table student drop constraint
define lsquolrursquo page replacement policy lru is least recently used page replacement
consider student stdid stdname dateofbirth phone deptname put the data for a student with student id200 name arun birth date 1 february 1985 phone
consider employee eno ename esalary dcode deptdcode dname and dependent depndtname eno relation show the names of employees in purchase and accounts
what is the function of the transport system and workbench organizerthe function of the transport system and the workbench organizer is to handle any
define a state which is not a fundamental process state answer blocked state is not a fundamental process
consider the following relationsbranch bno street area city pcode telno faxno staff sno fname lname address position salary bno express the
define program preemptionthe forced de-allocation of the cpu from a program which is executing on the cpu is known as program
how memory utilization factor shall be computed memory utilization factor shall be defined as memory in usetotal memory
differentiate between primary and secondary storageprimary and secondary storage - primary storage device stores the data temporarily primary storage
differentiate between key and superkeykey and superkey - a key a single attribute or a combination of two or more attributes of an entity set in
define database layerthe database layer defines the data formats used in the
differentiate between procedural and non procedural languages procedural and non procedural languages - a procedural language specifies the
explain the relevance of data dictionary in a database systemdata dictionary is a database in its own right residing on the disk that consist of meta
a well-maintained relational dbms has a high level of data integrity what features of a relational dbms contribute towards this level of
define what can be used as a criterion for classification of data structures utilized in language