Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
consider the relations empenoenameagebasicsalary workinenodno deptdnodnamecity express the following queries in sqli find names of employees who work
consider a table student stdid stdname dateofbirth percentmarks deptname write a qbe query to display names of computer science department students
differentiate between join and outer joinouter joins return all rows from at least one of the tables or views mentioned within the from clause as
consider the relations projectprojprojnamechiefarchitect employeeempempname assignedprojemp use relational algebra to express the subsequent queriesi
what do you understand by raid explain raid level 4 and level5raid - it is stands for redundant array of inexpensive disks as named by the inventor
differentiate pre-emptive and non-preemptive schedulingin a pre-emptive scheduling technique cpu can be taken away from a process if there is a
what is hash file organization what are the causes of bucket overflow within a hash file organization what can be completed to decrease the
explain what is aggregationaggregation aggregation is an significant concept in database design whereas composite objects could be modelled during
define specialisation and generalization in briefspecialisation generalization generalization or specialization represents the is a relationship set
define identify relationshipidentifying relationship an identifying relationship means in which the child table cannot be uniquely recognize without
explain the terms primary key candidate key alternate key and secondary key in the given table identify every keystudentsidregno name cityprimary
what are the dbms languages briefly explain data definition language ddla database schema is specified through a set of definitions expressed
discuss the differences among the candidate keys and the primary key of a relation give instance to describe your answera candidate key is one that
explain the types of system callsthe major types of system calls are like thisa process control these types of system calls are employed to control
define system calla system call is a request that is made by any program to the operating system for carrying out tasks - picked from a predefined
define disadvantages of top down parsing of backtrackingthe disadvantages of top down parsing of backtrackingi semantic actions cannot be carried
what is parsingparsing is the procedure of analyzing a text made of a sequence of tokens to define its grammatical structure regarding to a given
what is d command work in the respect of qbed it is the command inside qbe to delete tuples from the
explain the alphabet and stringa finite set of symbols is known as alphabet an alphabet is frequently denoted by sigma yet can be given any nameb 0
explain terminal symbolsterminal symbols are literal strings that are forming the input of a formal grammar and cannot be broken down into smaller
explain p command in the respect of qbep it is the command in which is used to print logically display the value of the attribute in
explain formal language grammara formal language grammar is a set of formation rules which explain which strings formed from the alphabet of a formal
explain i command in qbe i it is the command in qbe that is used to insert tuple s into the
explain cnt in the respects of qbe cnt it is one of the aggregation commands given in qbe it is used to identify number of
discuss in detail table management techniques an assembler employs the subsequent tablesoptab operation code table consists of