Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
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