Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
explain the concept of qbequery-by-example represents a visualgraphical approach for accessing information in a database by the use of query
what is the max no of structures that can be included in a table or
what are the causes of bucket overflow in a hash file organization what can be done to reduce the occurrence of bucket overflow when a record is
what are the advantages of by using an index and what are its disadvantages in difference if the search key of a secondary index is not a candidate
what are the aggregate objects in the data dictionary views match codes lock
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
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
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
a constraint named lessthan20 was defined on the field dateofbirth of table student delete this constraintalter table student drop constraint
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
consider the following relationsbranch bno street area city pcode telno faxno staff sno fname lname address position salary bno express the