DBMS MCQ 04

1.      FD stands for:

a.      Functional dependency

b.      Facilitate dependency

c.       Functional data

d.      Facilitate data

2.      In which model of database data is stored in tables:

a.       Network model

b.      Relational model

c.       Hierarchical model

d.      None of these

3.      The relational database model and after that by a researcher at _______:

a.      IBM

b.      Apple

c.       Intel

d.      All of these

4.      The database containing tables related to each other that help in the smooth processing of data is called ______:

a.       Service database

b.      Relation database

c.       Related database

d.      None of these

5.        A table can be defined as a set of______:

a.       Rows

b.      Columns

c.       Both

d.      None

6.      Which is very essential as no single set has a specific sot order for its elements:

a.       Rows

b.      Columns

c.       Tables

d.      All of these

7.      How many types of keys in relation database design:

a.       Primary key

b.      Candidate key

c.       Foreign key

d.      All of these

8.      Which  keys are used that are a column in the table:

a.       Primary key

b.      Candidate key

c.       Foreign key

d.      All of these

9.      Which key is referencing a primary key in a table:

a.      Primary key

b.      Candidate key

c.       Foreign key

d.      All of these

10.  Which key is used to fined the customer from the table:

a.       Primary key

b.      Candidate key

c.       Foreign key

d.      All of these

11.  Which key have a common meaning:

a.       Foreign key

b.      Primary key

c.       Both

d.      None

12.  A domain is a collection of values from where the columns are_____:

a.       Deleted

b.      Created

c.       Main tend

d.      All of these

13.  Which access provides a partial support to domains:

a.      Microsoft

b.      Microprocessor

c.       Microcomputer

d.      Memory

14.  Which database relationship is considered only between pairs of tables:

a.       Service database

b.      Relational database

c.       Related database

d.      None of these

15.  In relationships how many different ways in which two tables may be related:

a.       1

b.      2

c.       3

d.      4

16.  In which ways two tables may be related:

a.       One-one

b.      One-many

c.       Many-many

d.      All of these

17.  Which rules are defined in relational models they from as an essential part of any relation database:

a.      Integrity rules

b.      Database

c.       Record

d.      Memory

18.  How many types of integrity rules:

a.       1

b.      2

c.       3

d.      4

19.  Which are the types of integrity rule:

a.       General

b.      Database specific

c.       Both

d.      None

20.  How many general rules in a relational model and being general rules these are applicable to all database:

a.      2

b.      3

c.       4

d.      5

21.  Which rules are know as ’entity integrity’ and ‘referential integrity’:

a.      General

b.      Database specific

c.       Both

d.      None

22.  ______states that primary keys should not be null:

a.      Entity integrity

b.      Referential integrity

c.       Both

d.      None

23.   Integrity constraints that do not fall under the preceding two integrity rules are referred to as______:

a.       Entity integrity rule

b.      Referential integrity rule

c.       General integrity rule

d.      Database specific integrity rule

24.  Which has support for specification of global rule applicable to the whole table:

a.       Microsoft access1.0

b.      Microsoft access1.5

c.       Microsoft access2.0

d.      Microsoft access2.5

25.  In creating a table a row contains:

a.       Memory

b.      Record

c.       Field

d.      None

26.  In creating a table a column contains:

a.       Memory

b.      Record

c.       Field

d.      None

27.  Which have not have client/server architecture:

a.       DBS

b.      DBMS

c.       RDBMS

d.      All of these

28.  Which command creates database objects like tables views and indexes:

a.      Create command

b.      Update command

c.       Both

d.      None

29.  Which command enables alteration the data stored in existing records:

a.       Create command

b.      Update command

c.       Deletion command

d.      All of these

30.  Which query joins many dimension of tables to a fact table which contains large amount of rows and uses aggregate:

a.       IBM

b.      SQL

c.       ANSI

d.      ORACLE

31.  Which valued facts formalize the concept of functional dependency:

a.      Single-valued

b.      Double-valued

c.       Both

d.      None

32.  Which relationship model provides a starting point for identifying schemas and integrity constraints:

a.       Entity  

b.      Referential

c.       Both

d.      None

33.   FD stands for:

a.       Formal dependency

b.      Functional dependency

c.       Fact dependency

d.      Superset dependency

34.  Which is derived from mathematical theory:

a.       IBM

b.      SQL

c.       ANSI

d.      FD

35.  Which are dependent on the information of what can be stored in the relation and serve as integrity constraints:

a.       IBM

b.      SQL

c.       ANSI

d.      FD

36.  A relation state r of R that satisfies the functional dependency constraints is called_____ of R:

a.      Legal relation state

b.      Unlegal relation state

c.       FD

d.      All of these

37.  How many various types of dependencies:

a.       1

b.      2

c.       3

d.      4

38.  Which are the dependencies types:

a.       Full functional dependency

b.      Partial dependency

c.       Trivial functional dependency

d.       All of these

39.  FDs are the types of constraints that are based on______:

a.      Key

b.      Key revisited

c.       Superset key

d.      None of these

40.  What is a super key:

a.        Key

b.      Key revisited

c.       Superset key

d.      None of these

41.  Which s essential a business problem not a data problem:

a.       Data

b.      Database

c.       Database design

d.      All of these

42.  Which is primarily the result of a thorough understanding of information about an enterprise:

a.       Data

b.      Database

c.       Database design

d.      Data modeling

43.  McFadden has defined normalization in his which book___________:

a.       Database modern management

b.      Management database of modern

c.       Modern database management

d.       Database management

44.  The database design prevents some data from being represented due to _______:

a.       Deletion anomalies

b.      Insertion anomalies

c.       Update anomaly

d.      None of these

45.   How many types of insertion anomalies:

a.       1

b.      2

c.       3

d.      4

46.  Who developed the normalization process:

a.      E.F. codd

b.      F.F. codd

c.       E.E. codd

d.      None of these

47.  E.F.Codd developed the normalization process in the which early:

a.       1969

b.      1970

c.       1971

d.      1972

48.  Which is a bottom-up approach to database design that design by examining the relationship between attributes:

a.       Functional dependency

b.      Database modeling

c.       Normalization

d.      Decomposition

49.  Which is the process of breaking a relation into multiple relations:

a.        Functional dependency

b.      Database modeling

c.       Normalization

d.      Decomposition

50.  Which formal method that locates and analyses relation schemas on the basis of their primary, candidate keys, and the FD’s that are present among the attributes of these schemas:

a.       Functional dependency

b.      Database modeling

c.       Normalization

d.      Decomposition

51.  In decomposition technique of splitting a relation into_____ relation:

a.       ONE or MORE

b.      TWO or MORE

c.       THREE or MORE

d.      FOUR or MORE

52.  Codd suggested how many forms in normalization process:

a.       1

b.      2

c.       3

d.      4

53.  Consequently R.Boyce-Codd jointly launched  powerful definition for the thired normal form called______:

a.      Boyce-Codd normal form

b.      First normal form

c.       Second normal form

d.      All of these

54.  BCNF stands for:

a.       Basic -Codd normal form

b.      Build -Codd normal form

c.       Boyce-Codd normal form

d.      None of these

55.  Which forms simplifies and ensures that there is minimal data  aggregates and repetitive groups:

a.      1NF

b.      2NF

c.       3NF

d.      All of these

56.  Which forms every non-prime attribute is fully dependent functionally on the candidate key of a relational schema:

a.       1NF

b.      2NF

c.       3NF

d.      5NF

57.  Which forms is required when although NF is present more normalization is required:

a.       1NF

b.      2NF

c.       3NF

d.      4NF

58.  Which forms has a relation that possesses data about an individual entity:

a.       2NF

b.      3NF

c.       4NF

d.      5NF

59.  PJNF stands form:

a.       Practically –join normal form

b.      Project –join normal form

c.       Pages  –join normal form

d.      programming –join normal form

60.  Which forms are based on the concept of functional dependency:

a.       1NF

b.      2NF

c.       3NF

d.      4NF

61.  Which one is based on multi-valued dependency:

a.       First

b.      Second

c.       Third

d.      Fourth