Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
explain the role of a database administratora defining the schema the dba describes the schema which consists of the structure of the data in
what is outer join they can be employed while we want to keep all the tuples in r or all those in s or all those in both relations in the result
explain the theta-join and equijoinrefer tables car and boat which list models of cars and boats and their relevant prices assume a customer wants to
explain the natural joinnatural join is a binary operator which is written as r s in which r and s are relations the effect of the natural join is
what are deadlocks how can they be avoided ans deadlock considers to a particular condition when two or more processes are every waiting for
differentiate between static hashing and dynamic hashing ans static hashing comprises the number of primary pages in the directory fixed so while
how does a query tree represent a relational algebra expression ans this includes transforming an initial expression tree into an
what is indexed sequential file organization what are the applications of this organization ans an index file can be employed to effectively
what are the reasons of bucket overflow explain any two methods for solving this problemans it is general for file structures to be divided into
define the boyce-codd normal form with instance and also compare bcnf and 3nf ans bcnf for each functional dependency x-gty in a set f of
what is ddl make a list of commands with short description used in ddlans data definition language that is abbreviated as ddl is a computer language
how relational calculus is different from relational algebra what do understand by trc queries and drc queries ans relational calculus contain two
explain the steps for reduction of e-r model into relational modelansa entity set in e-r model will be considered as table name in relational modelb
explain the shadow paging recovery technique ans shadow paging is a method used to acquire atomic and durable transactions and provides the
what is a view make a view of emp table named dept 20 to display the employees in department 20 and their annual salary ans view is a
what are the general transformation rules for relational operations ans the transformation rules transform one relational algebra expression to
define radix conversion method one clever way to transform binary numbers to bcd notation binary-coded decimal is the double dabble algorithm it
explain the relational completenesscodd described the term relational completeness to consider to a language that is complete with respect to
explain the query processing data query processing permits a user to report or analyze structured and unstructured data pulled from multiple data
define the third normal form the third normal form 3nf is a normal form employed in database normalization 3nf was initially defined by ef codd in
discuss the problem of spurious tuples and how we may prevent it ans a spurious tuple is mainly a record in a database that gets created
what is the difference between serial and sequential files how searching is applied on both ans a serial file is one where the records have
what are the dbms languages explain ans a data definition languages ddl it is employed to specify database schema for example create drop
describe the difference between a one-to-many and a many-to-many relationship which logical data structures comprise one-to-many and which comprise
define physical and logical independence ans physical data independence the ability to modify physical level without causing application program