Database Management System
Question What is data model? Explain briefly the E-R data model
NU Year 2012
Question Briefly describe different types of database system users.
NU Year 2012
Question Define Database Management System.Write Down the advantages of Database system over tradition all file processing system.
NU Year 2011 2010
Question What is Data abstruction?Discuss different types of Data abstruction
NU Year 2011
Question Explain the functional components of database system structure.
NU Year 2011
Question What do you mean by physical and logical data independence?
NU Year 2011
Question What do you mean by physical and logical data independence?
NU Year 2011
Question Define the following terms :weak and strong entity sets.derived and composite attributesprimary and candidate keys
NU Year 2011
Question Draw an E-R diagram that captures the following information :
NU Year 2011
Question Explain the outerjoin operation in relation algebra with example
NU Year 2011
Question What are aggregate functions?List aggregate functions supported by SQL
NU Year 2011
Question Define Functional dependency with example
NU Year 2011
Question Normalize with explanation of the following tables into 1NF, 2NF and 3NF :Project(proj-id, proj-name, pro-mgr-id,emp-name, emp-dept, emp-hrly-rate,total-hrs)
NU Year 2011
Question Compute the closure the following set F of functional dependencies for relation schema :R = (A,B,C,D,E,F)
NU Year 2011
Question Describes Armstrong axions rules
NU Year 2011
Question Distinguish between bit-level and block-level striping give example.
NU Year 2011
Question Describe how RAID level 2 work :
NU Year 2011
Question Define data dictionary.What types of information does it store?
NU Year 2011
Question Define Multilevel indexing.when is it preferable to use a multilevelindex rather than a single-level index?explain your answer.
NU Year 2011
Question What is transaction? show and explain the state diagram of a transaction
NU Year 2011
Question Draw and explain the general structure of a distributed database system.Mention some advantages and disadvantages of a distributed database system.
NU Year 2011 2010
Question What is data transparency.Explain different forms of data transparency in distributed database system.
NU Year 2011
Question Define local transaction and global transaction.
NU Year 2011
Question Define the term :(i) Database schema(ii) Database Instance(iii) Data definition language(iv) Data manipulation language(v) Data dictionary
NU Year 2012
Question What is data model?explain the briefly E-R data model.
NU Year 2012
Question Briefly describe different types of database system users
NU Year 2012
Question Define database administration.What are the major functions of database administration?
NU Year 2012
Question Differentiate between super key, primary key and candidate key with example.
NU Year 2012 2010
Question What is specialization?Explain the concept giving an example.
NU Year 2012
Question A university registar's office maintains data about the following entities :Course : including number, titles, credits, syllabus, prerequisitesCourse offerings including course number, year, semester, section, number, instructors, timing and classroom.Students: including student_id, name and program.Instructors : including identification number, name, department and title.
NU Year 2012
Question Briefly discuss different types of mapping cardinalities.
NU Year 2012
Question What are the reasons for having variable length records?What are the various ways to store variable length records?
NU Year 2012
Question Differentiate between natural and outer join with example
NU Year 2012
Question Explain the SQL operators between IN, LIKE and COUNT with suitable example
NU Year 2012
Question What is normalization? What are the different normalization form? briefly explain.
NU Year 2012
Question Briefly explain the meaning of the ACID properties.How do concurrency control and recovery management support the ACID properties?
NU Year 2012
Question What is distributed database?explain the advantages of distributed database over centralized database.
NU Year 2012
Question What is NULL?give an example of illustrate testing for NULL in SQL.
NU Year 2012
Question What are the main goal of RAID technology?Describe the levels 1 through 5
NU Year 2012
Question What is difference between primary and secondary index? List the advantages and disadvantages of using index.
NU Year 2012
Question What is storage manager?What are the components of storage manager and also state the purposes of storage manager.
NU Year 2012
Question What is parallel database system? Explain types of parallel database architecture.
NU Year 2012
Question What do you mean by database management system(DBMS)? What are different between DBMS and RDBMS?
NU Year 2013
Question Explain the difference between physical and logical data independence.
NU Year 2013
Question Define Data definition language(DDL).What is the result of compilation of DDL statements.
NU Year 2013
Question What are the significant difference between a file processing system and a DBMS?
NU Year 2013
Question What is E-R diagram? Consider an E-R diagram in which the same entity set appears several times.Why is allowing this redundancy a bad practice that one should avoid whenever possible.
NU Year 2013
Question Construct an E-R diagram for a hospital with a set of patients and a set ofmedical doctors.Associate with each patient a log of the various tests and examinations conducted.Document all assumptions that you make the mapping constraints.
NU Year 2013
Question Convert the E-R diagram you have just constructed as an answer of question 2(b) into a relational database schema be certain to indicate primary key and referential integrity constraints.
NU Year 2013
Question One limitation of E-R model is that, it can not express relationships among relationships.How would you overcome the limitation?
NU Year 2013
Question Define the concept of aggregation.Give two examples of where the concept is useful
NU Year 2013
Question Explain the distinction between disjoint and overlapping constratints.
NU Year 2013
Question What do you mean by view definition?describe with example.
Question What is data model? describe relational and hierarchical data model with example.
NU Year 2013
Question What is functional dependency, canonical cover, extraneous attributes?
NU Year 2013
Question What do you mean by decomposition and normalization? Describe data fragmentation.
NU Year 2013
Question Write all functional dependencies satisfied by the relation of the following :ABCa1b1c1a1b1c2a2b1c1a2b1c3
NU Year 2013
Question What do you mean by index?Describe briefly dense index, sparse index and secondary index with figure.
NU Year 2013
Question Describe update the briefly operation on indexing.
NU Year 2013
Question What is database security? How can we protect a database?
NU Year 2013
Question Describe the three levels of data abstruction.
NU Year 2010
Question Briefly explain various operations of relational database management system.
NU Year 2010
Question What are the major responsibility of DBA?
NU Year 2010
Question What is specialization? Explain with an example.
NU Year 2010
Question A university registar's office maintains data about the following entities :Course : including number, titles, credits, syllabus, prerequisitesCourse offerings including course number, year, semester, section, number, instructors, timing and classroom.Students: including student_id, name and program.Instructors : including identification number, name, department and title.Construct an E-R diagram for the registar's office.Document all assumptions that you make about the mapping constraints.
NU Year 2010
Question Explain the outerjoin operation in relational algebra with an example : why is it necessary?
NU Year 2010
Question What is functional dependency? Explain armstrongs axions used to find logically impelled functional dependencies.
NU Year 2010
Question What do you mean by normalization? Explain 2NF and 3NF with example.
NU Year 2010
Question Explain the desireable properties of decomposition.
NU Year 2010
Question What is distributed database? List some advantages of distributed database.
NU Year 2010
Question What is fragmentation?Why fragmentation is necessary? Explain horizontal and vertical fragmentation with example.
NU Year 2010
Question What do you mean by transparency and autonomy? Explain different types of transparency.
NU Year 2010
Question What is data dictionary?
NU Year 2010
Question What is difference between primary and secondary index?
NU Year 2010
Question Define Multilevel indexing.When is it preferable to use a multiple indexing rather than a single level index? Explain your answer :
NU Year 2010
Question Define data dictionary.What type of information does it store?
NU Year 2010
Question Define database and database management system (DBMS). Write down the advantages of database management system over tradional file processing system.
NU Year 2011
Question What is Data abstrac?on? Explain in brief different level in data abstracon.
NU Year 2008
Question Explain functional component of database management system.
NU Year 2011
Question What do you mean by Database Administrator. The responsibilities/function of a database administrator.
NU Year 2008
Question What do you mean by relational database. Write down the advantages of relational database.
NU Year 2010
Question Define DDL and DML. What are the Difference between procedural and nonprocedural DML.
NU Year 2009
Question Briefly describe 3-tier architecture of database management system.
NU Year 2009
Question Briefly explain various operation of relational database management system.
NU Year 2009
Question What is an E-R diagram? construct an E-R diagram for a car insurance company. Consider each customer owns a number of cars and each car is associated with a number of recorded accident.
NU Year 2008
Question What do you mean by physical and logical data independence.
Question What is data model? Describe relational Data Model with example.
NU Year 2008
Question What do you mean by instances and database schema. Difference between instances and database schema.
NU Year 2008
Question Explain different types of database language with example.
NU Year 2010
Question Explain transac?on management.
NU Year 2010
Question Write some application of database system.
NU Year 2010
Question Explain storage management.
NU Year 2010 2009
Question Difference between DDL and DML.
NU Year 2010
Question Difference between physical level and logical level.
NU Year 2009
Question Difference between file processing and DBMS.
NU Year 2010
Question What are the advantages and disadvantages of DBMS.
NU Year 2010
Question Describe different types of database system user.
NU Year 2010
Question What do you mean by Data model?Describe different types of Data models.
NU Year 2010
Question Explain the component of query processor.
NU Year 2009
Question Briefly describe the two-tier architecture of database management system.
NU Year 2010
Question Explain the entity relationship model.
NU Year 2008
Question Define entity, super key, attributes, candidate key and primary key with appropriate example.
NU Year 2008
Question What do you mean by Entity, Entity set and Attributes?
NU Year 2009
Question What is mapping cardinalities? Describe various mapping cardinalities.
NU Year 2009
Question What do you mean by simple, single-Valued, Multivalued, Null and Derived attributes?
NU Year 2010
Question Differentiate among super key, primary key, candidate key with example.
NU Year 2010
Question Define foreign key. Why it is used.
NU Year 2013
Question What are the component of an E-R diagram?
NU Year 2010
Question Explain strong entity set & weak entity set.
NU Year 2010
Question Explain difference between strong entity set and weak entity set.
NU Year 2010
Question Explain Specialization and Generalization. What are the difference between Specialization and Generalization.
NU Year 2010
Question Explain aggregation. Why it is used in E-R modeling.
NU Year 2010
Question What do you mean by Attribute Inheritance.
NU Year 2012
Question Define degree and tuple.
NU Year 2008
Question Consider the following Relational database where the primary keys are underlined. Give an expression in the relational algebra to express each of the following queries : Employee (person-name, street, city); Works (person-name, company-name, salary); Company (company-name, manager-name); Manager (person-name, manager-name); i. Find the names of all employees who do not work for First Bank Corporation. ii. Find the names, street address, and cities of residence of all employees who work for First Bank Corporation and earn more than $50,000 per annum. iii. Find the name of all employees who earn more than every employee of Small Bank Corporation. iv. Find the name of all employees who live in the same city as the company for which they work.
NU Year 2011
Question Consider the following Relational database where the primary keys are underlined. Give an expression in the relational algebra to express each of the following queries : Employee (person-name, street, city); Works (person-name, company-name, salary); Company (company-name, manager-name); Manager (person-name, manager-name); i. Find the names of all employees who work for Trust Bank. ii. Find the name of all employee who live in the same city and same street as Rana iii. Find the names, city of all employee who works for Trust bank and earn more than $5000.
NU Year 2010
Question Consider the following Relational database where the primary keys are underlined. Give an expression in the relational algebra to express each of the following queries : Branch (branch-name, branch-city, address); Works (loan-number, person-name, amount); Borrower (account-number, loan-number); Account (account-number, branch-name, balance); Depositor (customer-name, account-number); i. Find all customer of bank who have an account but not a loan. ii. Find the names of all customer who lives on the same street and in the same city as Smith. iii. Find the names of all branches with customer who have an account in the bank who live in Dhaka. iv. Delete all of Smith account records.
NU Year 2010
Question Explain the outer-join operation in Relational database with an example. Why itisnecessary.
NU Year 2010
Question What do you mean by relation, relational database schema, constraint and cardinality?
NU Year 2010
Question Define relational algebra.
NU Year 2011
Question Determine the differences between tuple relational calculus and domain relational calculus.
NU Year 2009
Question Write down the rules of relational model.
NU Year 2012
Question Explain the tuple relational calculus and domain relational calculus.
NU Year 2012
Question What are the fundamental operations of relational algebra? Briefly explain them.
NU Year 2010
Question What are the conditions for a union operation on two relations to be valid?
NU Year 2010
Question Define the set intersection and natural join operation.
NU Year 2010
Question What are the conditions for a set-difference operation on two relations to be valid?
NU Year 2010
Question Explain the different aggregate functions of relational algebra.
NU Year 2010
Question Explain Deletion, Insertion and Updating operation.
NU Year 2010
Question Explain different parts of SQL.
NU Year 2009
Question Explain the basic structure of SQL.
NU Year 2010
Question Define the rename operation.
NU Year 2009
Question Explain the string operations.
NU Year 2009
Question Explain the set operations and aggregate functions.
Question Define views.
NU Year 2010 2012
Question Explain the modification of database using SQL.
NU Year 2008 2010
Question Explain the data definition language in SQL.
NU Year 2011
Question Explain domain types in SQL.
NU Year 2010
Question Define different schema definitions in SQL.
NU Year 2010 2009
Question Difference between relation and reation schema.
NU Year 2011
Question Consider the following database where primary keys are underlined. Give an expression in SQL for each of the following queries: Branch(branch-name, branch-city, assets) customer(customer-name, customer-street, customer city) loan(loan-number, branch-name, amount) Borrower(customer-name, loan-number) account(account-number, branch-name, balance) depositor(customer-name, account-number) i. Find all customer who have an account but no loan at bank. ii. Find the number of depositors for each branch. iii. Pay 5% interest on account whose balance is greater than the average. iv. Find the total loan amounts.
NU Year 2009
Question Consider the following database where primary keys are underlined. Give an expression in SQL for each of the following queries: Branch(branch-name, branch-city, assets) customer(customer-name, customer-street, customer city) loan(loan-number, branch-name, amount) Borrower(customer-name, loan-number) account(account-number, branch-name, balance) depositor(customer-name, account-number) I. Find the average account balance at each branch. II. Find the number of depositors for each branch. III. Find the largest account balance in the bank. IV. Find the total loan amounts.
NU Year 2011
Question Consider the following database where primary keys are underlined. Give an expression in SQL for each of the following queries: Lives (person-name, street, city) Works (person-name, company-name, salary) Located in (company-name, city) Manages (person-name, manager-name) I. Modify the database so that karim now lives in “Dhaka”. II. Inserts the records in lives relation (“Rahim”,”North”,”Dhaka”) III. Delete all tuples in the works relation for employees of “Small Bank Corporation”. Find those companies who have an average salary of more than $30,000.
NU Year 2010
Question What dou you mean by transaction? Show and explainthe state diagram of a transaction.
NU Year 2010
Question Describe the ACID properties of transactions.
NU Year 2010
Question Explain consistency, atomicity and durability.
NU Year 2010
Question Explain the concurrent execution with an example comparing with serial execution of transactions.
NU Year 2010
Question Explain the usefulness of concurrent execution.
NU Year 2010
Question Define serializability. Explain the conflict and view serializability.
NU Year 2009
Question Explain the cascadeless schedules and recoverable schedules.
NU Year 2010
Question What do you mean by Domain Constraints?
NU Year 2011
Question What are Assertions?
NU Year 2011
Question What do you mean by Triggers?
NU Year 2013
Question What do you mean by Functional Dependency?(
NU Year 2012
Question Explain full and partial functional dependencies with example.
NU Year 2010
Question Explain the ways of using functional dependences.
NU Year 2010
Question Write down the rules of Functional Dependency.
NU Year 2010
Question What dou you mean by normalization? Explain different forms of Normal Form.
NU Year 2013
Question Explain Boyee-Code Normal Form(BCNF) with example.
NU Year 2010
Question Explain multivalued dependency (MVD).
NU Year 2010
Question Explain not null constraint, unique constraint.
NU Year 2010
Question Describe referential integrity.
NU Year 2010
Question What do you mean by transitive dependency?
NU Year 2012
Question Explain superkey in terms of functional dependency.
NU Year 2012
Question Explain trivial and nontrivial dependencies.
NU Year 2010
Question Explain join dependencies.
NU Year 2010
Question Show that join dependency is not equivalent to multi-valued dependency.
NU Year 2010
Question Normalize with explanation the following table into 1NF, 2NF and 3NF :- PROJECT (Proj-ID, Proj-Name, Pro-Mgr-ID, Emp-ID, Emp-name, Emp-Dept, Emp-Hrly-rate, Total-Hrs)
NU Year 2010
Question Normalize with explanation the following table into 1NF, 2NF and 3NF :- Emp-proj (SSN, Pnumber, hours, Ename, Pname, Ddate Address, Pnumber, Plocation, Dnames, DMGss)
NU Year 2010
Question Explain the difference between BCNF and 3NF.
NU Year 2010
Question Describe the Armstrong’s rules.
NU Year 2010
Question Explain the desirable properties of decomposition.
Question What do you mean by lossless and lossy decompositions? Give examples.
NU Year 2010
Question What is indexing and hashing?
NU Year 2010
Question Why indexing is used in database?
NU Year 2010
Question Define primary and secondary indices.
NU Year 2010
Question What are the difference between primary and secondary index?
NU Year 2011
Question Explain the types of indices.
NU Year 2010
Question Explain why dense indices are preferable.
NU Year 2010
Question Write short notes on B+ -Tree index files.
NU Year 2010
Question Write short notes on Hash file organization.
NU Year 2014
Question Difference between B Tree and B+ -tree indexing.
NU Year 2009
Question Define multilevel indexing. When it is preferable to use a multilevel index rather than a single-level index? Explain.
NU Year 2011
Question What are the limitation of order indexing over direct indexing technique?
NU Year 2011
Question What are the difference between dense and spares indexing.
NU Year 2010
Question Define memory. Differentiate between SRAM and DRAM.
NU Year 2012
Question Define Flip Flop. Design a 4-bit carry look-ahead adder and mention its work.
NU Year 2012
Question What do you mean by addressing mode? Discuss about immediate, indexed, relative and base register addressing modes.
NU Year 2012
Question List four applications which you have used, that most likely used a databasesystem to store persistent data.
Institute Tejgaon College 2014
Question List five responsibilities of a database-management system. For each responsibility,explain the problems that would arise if the responsibility were not discharged.
Institute North South University 2015
Question List at least two reasons why database systems support data manipulation usinga declarative query language such as SQL, instead of just providing a a libraryof C or C++ functions to carry out data manipulation.
Institute Daffodil International University 2013
Question Write an assertion for the bank database to ensure that the assets value for thePerryridge branch is equal to the sum of all the amounts lent by the Perryridgebranch.
Institute East West University 2014
Question Describe the circumstances in which you would choose to use embedded SQLrather than SQL alone or only a general-purpose programming language'
Institute East West University 2015
Question Write a Java function using JDBC metadata features that takes a ResultSet asan input parametel, and prints out the result in tabular form, with appropriatenames as column headings.
Institute East West University 2015
Question Write aJava function usingIDBC metadata features thatprints a list of all relationsin the database, displaying for each relation the nimes and types of itsattributes.
Institute East West University 2014
Question Compare the use of embedded SQL with the use in SeL of functions defined ina general-purpose programming language. Under what circumstances wouldyou use each of these features
Institute East West University 2013
Question In designing a database schema, we must ensure that we avoid two major pitfalls, what are those?
Institute Institute of Science and Technology, Bangladesh 2014
Question An E-R diagram can be viewed as a graph. What do the following mean in terms of the structure of an enterprise schema?a. The graphic disconnected.b. The graph is acyclic.
Institute East West University 2014
Question Explain the distinctions among the terms primary key, candidate key, and superkey.
Institute North South University 2012
Question Explain the difference between a weak and a strong entity set.
Institute Model Institute of Science & Technology (MIST) 2013
Question Construct an E-R diagram for a hospital with a set of patients and a set of medicaldoctors. Associate with each patient a log of the various tests and examinationsconducted.
Institute Ahsanullah Institute of Information and Communication Technology 2013
Question Define the concept of aggregation. Give two examples of where this concept is useful.
Institute Daffodil International University 2011
Question Explain the distinction between condition-defined and user-defined constraints.Which of these constraints can the system check automatically? Explain your answer.
Institute Daffodil International University 2014
Question Explain the distinction between disjoint and overlapping constraints
Institute East West University 2013
Question Use Armstrong's axioms to prove the soundness of the pseudo-transitivity rule.
Institute Ahsanullah Institute of Information and Communication Technology 2015
Question Explain what is meant by repetition of information and inability to represent information'Explain why each of these properties may indicate a bad relational database design.
Institute North South University 2014
Question In designing a relational database, why might we choose a non-BCNF design?
Institute Daffodil International University 2013
Question Explain why 4NF is a normal form more desirable than BCNF.
Institute East West University 2015