Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
what is disadvantages of dbms 1 cost of software and hardware and migration - a important disadvantage of the dbms system is cost2 reduced response
what are the advantages of dbms 1 centralized management and control - one of the major advantages of using a database system is in which the
what is a databasedatabase - basically in simple terms a database is a collection of inter related data andor information stored so which it is
which two files are used during operation of the dbmsdata dictionary and transaction log are two files used during operation of the
which data type can store unstructured dataraw data type can store unstructured
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