MI0025-DBMS-Model_question_paper

MI0025-DBMS-Model_question_paper - MBA Third Semester Model...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
MBA Third Semester Model Question Paper -2009 Database Management Systems (DBMS) (2 Credits) Question Number 1 to 20 -1 mark Question. Question Number 21 to 31-2 Marks Question. Question Number 32 to 38 - 4 Marks Question. Q.N o. Statement and Options 1 A __________ is complex set of software programs that controls the organization, storage & retrieval of data in a database. a. Repository b. DBMS c. Software d. Program 2 A major drawback of the static hashing is that address space is ________. a. dynamic b. fixed c. variable d .collide 3 Third normal form is based on the concept of ________________ a. functional dependency b. full functional dependency c. semi functional dependency d. transitive dependency 4 In _______________ Data can be accessed by users at other remote sites through the distributed database management
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
system software. a. Transparency b. Data sharing c. Easier expansion d. Data tracing 5 ________________ is known as UNDO/REDO algorithm. a. Immediate update b. deferred update c. the redo logs d. rolled back 6 These are Design Driven a. Database Management Systems b. Management Information Systems c. Centralized systems d. File systems 7 Whenever a record is larger than a block, we must use a _____________ Organization. a. Spanned b. unspanned c. sequential d. random access. 8 ______________ is one of the major factor s in database Management. a. Integrity b. Security c. Consistency d. Concurrency 9 Only retrieving of data is called
Background image of page 2
b. write transaction c. read only transaction. d. read & write transaction 10 If many of the attributes do not take any values, we insert _____________ values. a. Data b. NULL c. attribute d. Schema 11 The ________________ differs from the tuple calculas in the type of variables used in formulas. a. Relational calculas b. Relational algebra c. Domain calculas d. Tuple calculas 12 _____________ is a pointer to s disk block a. second field b. first field c. clustering index d. secondary index 13 For each attribute there is a set of permitted values called the ___________ of that attribute a. domain b. value c. atomic value d. schema 14 The ______________ are used to alter the database tables. a. DML statement
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/15/2010 for the course MBA mba taught by Professor Smu during the Spring '10 term at Manipal University.

Page1 / 10

MI0025-DBMS-Model_question_paper - MBA Third Semester Model...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online