Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
define a loader that is executed when a system is first turned on or restartedbootstrap loader is executed when a system is first turned on or
what are the basic objects of the data dictionary tables domains data elements structures foreign
what are the uses of the information in the data dictionary the following information is directly taken from the data dictionary information on
determine an imperative statementimperative statement points out an action to be carried out during execution of assembled
what is the difference among a primary index and a secondary indexprimary index a primary index is an ordered file whose records are of fixed length
define drawback of distributed systemsreliability is a drawback of distributed
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