Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
a table joined with itself is called a table joined with itself is known as self join table normal 0 false false false en-in x-none
which method of access uses key transformationa hash method of access uses key
what is a virtual table that draws its data from the result of an sql select statementview is a virtual table that draws its data from the result of
in e-r diagram how generalization is representedin e-r diagram generalization is represented by triangle
which data manipulation command combines the records from one or more tables join data manipulation command combines the records from one or more
what function divides one numeric expression by another and returns the remaindermod function divides one numeric expression by another and returns
a b-tree of order how much children m has maximum m has maximum m mchildren in a b
what is the aim of logical schema the main motive of the logical schema is to ensure the portability of procedures and models on various physical
which operator is used to compare a value to a list of literals values that have been specifiedbetween operator is used to compare a value to a list
to delete a particular column in a relation which command is used to delete a particular column in a relation alter command is
hierarchical model is also known bya hierarchical model is also known as a tree
in e-r diagram how relationship type is represented in e-r diagram relationship type is represented as a
what will be create when a primary key if combined with a foreign keya primary key if combined with a foreign key it creates parent-child
where does view definition storeda view definition is permanently stored as part of the
the natural join is equal to which productthe natural join is equal to combination of projection and cartesian
consider the join of a relation r with relation s if r has m tuples and s has n tuples then the maximum size of join isif r has m tuples and s has n
an instance of relational schema r a b c has distinct values of a including null values then a is a candidate key or notif relational schema r a b c
in e-r diagram how derived attribute are represented in e-r diagram by dashed ellipse derived attribute are
what it creates while a primary key is combined with a foreign keyit creates parent-child relation ship between the tables that connect them while a
using relational algebra which query finds customers who have a balance of over 1000 using relational algebra pi customername sigma balance
the physical location of a record is determined by which mathematical formula that transforms a file key into a record locationthe physical location
a file manipulation command that extracts some of the records from a file is called a file manipulation command that extracts some of the records
what does data dictionary is a special file contains the data dictionary is a special file contain the name of all fields in all filesthe width of
which model is record based logical modelnetwork modelis basically known as record based logical
which database object does not physically exista view database object does not physically