Database Management System-6

Multiple Choice Questions (MCQs)

Go To pages -> 0/1/2/3/4/5/6/7

1 Which is a join condition contains an equality operator?

(A) Equijoins

(B) Cartesian

(D) None

[showhide type=”button7c1″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

2 Which command defines its columns, integrity constraint in create table?

(A) Create command

(B) Drop table command

(D) All of these

[showhide type=”button7c2″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

3 It refers to set of one or more columns that designates the ______ key in a referential integrity constraint:

(A) Select key

(B) Foreign key

(D) None of these

[showhide type=”button7c3″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

4 Which constraint that requires that the column contain a value when it is initially inserted into the table:

(A) IS NULL

(B) NOT NULL

(D) None

[showhide type=”button7c4″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

5 Which constraint that identifies a column or combination of columns as a unique key:

(A) IS NULL

(B) NOT NULL

(D) None

[showhide type=”button7c5″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

6 Which command is use for removing a table and all its data from the database?

(A) Create command

(B) Drop table command

(D) All of these

[showhide type=”button7c6″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

7 Which command that allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained?

(A) TRUNCATE command

(B) Create command

(D) Alter table command

[showhide type=”button7c7″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

8 Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

(A) Left outer join

(B) Right outer join

(D) Half outer join

[showhide type=”button7c8″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

9 How many set operations support the oracle SQL?

(A) 2

(B) 3

(D) 5

[showhide type=”button7c9″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

10 ______ operator merges the result sets of two component queries:

(A) UNION

(B) UNION ALL

(D) MINUS

[showhide type=”button7c10″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

11 How many component queries are combined using the set operators?

(A) 1

(B) 2

(D) 4

[showhide type=”button7c11″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

12 In precedence of set operators the expression is evaluated from______:

(A) Left to Left

(B) Right to Right

(D) Right to Left

[showhide type=”button7c12″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

13 View in SQL a view may be defined as a

(A) Stored query

(B) Virtual table

(D) None

[showhide type=”button7c13″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

14 How many types of views in SQL:

(A) 1

(B) 2

(D) 4

[showhide type=”button7c14″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

15 Which are the types of views in SQL?

(A) Inline view

(B) Database view

(D) All of these

[showhide type=”button7c15″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

16 Which operation is allowed in a join view?

(A) UPDATE

(B) INSERT

(D) All of these

[showhide type=”button7c16″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

17 The materialized view was introduced by:

(A) Oracle 6

(B) Oracle 7

(D) Oracle 9

[showhide type=”button7c17″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

18 We can delete from join view provided there is__________ key preserved table in the join:

(A) One and Only One

(B) One and Two

(D) None of these

[showhide type=”button7c18″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

19 Which view that contains more than one table in the top-level FROM clause of the SELECT statement:

(A) Join view

(B) Datable join view

(D) All of these

[showhide type=”button7c19″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

20 Which option is used to create a view as a constrained view and prohibit specific insert and update operations with the view:

(A) DATABASE

(B) WITH CHECK OPTION

(D) WITH OPTION

[showhide type=”button7c20″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

21 Which command is used to add the views to the database?

(A) DATABASE VIEW

(B) CREATE VIEW

(D) None of these

[showhide type=”button7c21″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

22 Which option is used with the WHERE clause:

(A) DATABASE

(B) WITH CHECK OPTION

(D) WITH OPTION

[showhide type=”button7c22″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

23 Which option may be used to create the inline view as a constrained view?

(A) DATABASE

(B) WITH CHECK OPTION

(D) WITH OPTION

[showhide type=”button7c23″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

24 In which year ORACLE, an SQL product was released:

(A) 1976

(B) 1977

(D) 1979

[showhide type=”button7c24″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

25 The prototype for SQL was originally developed by:

(A) INTEL

(B) APPLE

(D) All of these

[showhide type=”button7c25″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

26 In which year relational algebra became prominent after the relational model of database was published:

(A) 1969

(B) 1970

(D) 1972

[showhide type=”button7c26″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

27 Relational algebra became prominent after the relational model of database was published by:

(A) Codds

(B) F.F. Codd

(D) None of these

[showhide type=”button7c27″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

28 Which is an ANSI standard and has many different versions?

(A) IBM

(B) SQL

(D) ORACLE

[showhide type=”button7c28″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

29 Which is used for interfacing with RDBMS?

(A) IBM

(B) SQL

(D) ORACLE

[showhide type=”button7c29″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

30 Which is the basis for SQL and also for all other contemporary database system like MS SQL Server, IBM DB2, Oracle, My SQL and MICROSOFT Access?

(A) DDL

(B) SDL

(D) None of these

[showhide type=”button7c30″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

31 FD stands for:

(A) Functional dependency

(B) Facilitate dependency

(D) Facilitate data

[showhide type=”button8c1″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

32 In which model of database data is stored in tables:

(A) Network model

(B) Relational model

(D) None of these

[showhide type=”button8c2″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

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

(A) IBM

(B) Apple

(D) All of these

[showhide type=”button8c3″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

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

(A) Service database

(B) Relation database

(D) None of these

[showhide type=”button8c4″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

35 A table can be defined as a set of______:

(A) Rows

(B) Columns

(D) None

[showhide type=”button8c5″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

36 Which is very essential as no single set has a specific sot order for its elements?

(A) Rows

(B) Columns

(D) All of these

[showhide type=”button8c6″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

37 How many types of keys in relation database design?

(A) Primary key

(B) Candidate key

(D) All of these

[showhide type=”button8c7″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

38 Which keys are used that are a column in the table?

(A) Primary key

(B) Candidate key

(D) All of these

[showhide type=”button8c8″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

39 Which key is referencing a primary key in a table?

(A) Primary key

(B) Candidate key

(D) All of these

[showhide type=”button8c9″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

40 Which key is used to find the customer from the table?

(A) Primary key

(B) Candidate key

(D) All of these

[showhide type=”button8c10″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

41 Which key have a common meaning:

(A) Foreign key

(B) Primary key

(D) None

[showhide type=”button8c11″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

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

(A) Deleted

(B) Created

(D) All of these

[showhide type=”button8c12″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

43 Which access provides a partial support to domains?

(A) Microsoft

(B) Microprocessor

(D) Memory

[showhide type=”button8c13″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

44 Which database relationship is considered only between pairs of tables?

(A) Service database

(B) Relational database

(D) None of these

[showhide type=”button8c14″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

45 In relationships how many different ways in which two tables may be related?

(A) 1

(B) 2

(D) 4

[showhide type=”button8c15″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

46 In which ways two tables may be related:

(A) One-one

(B) One-many

(D) All of these

[showhide type=”button8c16″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

47 Which rules are defined in relational models which from an essential part of any relation database:

(A) Integrity rules

(B) Database

(D) Memory

[showhide type=”button8c17″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

48 How many types of integrity rules:

(A) 1

(B) 2

(D) 4

[showhide type=”button8c18″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

49 Which are the types of integrity rule?

(A) General

(B) Database specific

(D) None

[showhide type=”button8c19″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

50 How many general rules in a relational model, and being general rules, these are applicable to all databases:

(A) 2

(B) 3

(D) 5

[showhide type=”button8c20″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

51 Which rules are known as ’entity integrity’ and ‘referential integrity’:

(A) General

(B) Database specific

(D) None

[showhide type=”button8c21″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

52 ______states that primary keys should not be null:

(A) Entity integrity

(B) Referential integrity

(D) None

[showhide type=”button8c22″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

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

(A) Entity integrity rule

(B) Referential integrity rule

(D) Database specific integrity rule

[showhide type=”button8c23″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

54 Which has support for specification of global rule applicable to the whole table?

(A) Microsoft access1.0

(B) Microsoft access1.5

(D) Microsoft access2.5

[showhide type=”button8c24″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

55 In creating a table a row contains:

(A) Memory

(B) Record

(D) None

[showhide type=”button8c25″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

56 In creating a table a column contains:

(A) Memory

(B) Record

(D) None

[showhide type=”button8c26″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

57 Which have not have client/server architecture:

(A) DBS

(B) DBMS

(D) All of these

[showhide type=”button8c27″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

58 Which command creates database objects like tables views and indexes?

(A) Create command

(B) Update command

(D) None

[showhide type=”button8c28″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

59 Which command enables alteration the data stored in existing records?

(A) Create command

(B) Update command

(D) All of these

[showhide type=”button8c29″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

60 Which query joins many dimensions of tables to a fact table which contains large amount of rows and uses aggregate?

(A) IBM

(B) SQL

(D) ORACLE

[showhide type=”button8c30″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

61 Which valued facts formalize the concept of functional dependency?

(A) Single-valued

(B) Double-valued

(D) None

[showhide type=”button9c1″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

62 Which relationship model provides a starting point for identifying schemas and integrity constraints?

(A) Entity

(B) Referential

(D) None

[showhide type=”button9c2″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

63 FD stands for:

(A) Formal dependency

(B) Functional dependency

(D) Superset dependency

[showhide type=”button9c3″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

64 Which is derived from mathematical theory?

(A) IBM

(B) SQL

(D) FD

[showhide type=”button9c4″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

65 Which are dependent on the information of what can be stored in the relation and serve as integrity constraints?

(A) IBM

(B) SQL

(D) FD

[showhide type=”button9c5″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

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

(A) Legal relation state

(B) Illegal relation state

(D) All of these

[showhide type=”button9c6″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

67 How many various types of dependencies:

(A) 1

(B) 2

(D) 4

[showhide type=”button9c7″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

68 Which are the dependencies types?

(A) Full functional dependency

(B) Partial dependency

(D) All of these

[showhide type=”button9c8″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

69 FDs are the types of constraints that are based on______:

(A) Key

(B) Key revisited

(D) None of these

[showhide type=”button9c9″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

70 What is a super key?

(A) Key

(B) Key revisited

(D) None of these

[showhide type=”button9c10″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

71 Which s essential a business problem not a data problem:

(A) Data

(B) Database

(D) All of these

[showhide type=”button9c11″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

72 Which is primarily the result of a thorough understanding of information about an enterprise?

(A) Data

(B) Database

(D) Data modeling

[showhide type=”button9c12″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

73 McFadden has defined normalization in his which book___________:

(A) Database modern management

(B) Management database of modern

(D) Database management

[showhide type=”button9c13″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

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

(A) Deletion anomalies

(B) Insertion anomalies

(D) None of these

[showhide type=”button9c14″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

75 How many types of insertion anomalies:

(A) 1

(B) 2

(D) 4

[showhide type=”button9c15″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

76 Who developed the normalization process?

(A) E.F. Codd

(B) F.F. Codd

(D) None of these

[showhide type=”button9c16″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

77 E.F. Codd developed the normalization process in the early:

(A) 1969

(B) 1970

(D) 1972

[showhide type=”button9c17″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

78 Which is a bottom-up approach to database design that design by examining the relationship between attributes?

(A) Functional dependency

(B) Database modeling

(D) Decomposition

[showhide type=”button9c18″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

79 Which is the process of breaking a relation into multiple relations?

(A) Functional dependency

(B) Database modeling

(D) Decomposition

[showhide type=”button9c19″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

80 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

(D) Decomposition

[showhide type=”button9c20″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

81 In decomposition technique of splitting a relation into_____ relation:

(A) ONE or MORE

(B) TWO or MORE

(D) FOUR or MORE

[showhide type=”button9c21″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

82 Codd suggested how many forms in normalization process:

(A) 1

(B) 2

(D) 4

[showhide type=”button9c22″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

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

(A) Boyce-Codd normal form

(B) First normal form

(D) All of these

[showhide type=”button9c23″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

84 BCNF stands for:

(A) Basic -Codd normal form

(B) Build -Codd normal form

(D) None of these

[showhide type=”button9c24″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

85 Which forms simplify and ensure that there are minimal data aggregates and repetitive groups:

(A) 1NF

(B) 2NF

(D) All of these

[showhide type=”button9c25″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

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

(A) 1NF

(B) 2NF

(D) 5NF

[showhide type=”button9c26″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

87 Which forms is required when although NF is present more normalization is required:

(A) 1NF

(B) 2NF

(D) 4NF

[showhide type=”button9c27″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

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

(A) 2NF

(B) 3NF

(D) 5NF

[showhide type=”button9c28″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

89 PJNF stands form:

(A) Practically –join normal form

(B) Project –join normal form

(D) Programming –join normal form

[showhide type=”button9c29″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

90 Which forms are based on the concept of functional dependency?

(A) 1NF

(B) 2NF

(D) 4NF

[showhide type=”button9c30″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

91 Which one is based on multi-valued dependency?

(A) First

(B) Second

(D) Fourth

[showhide type=”button10c1″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

92 Which is the various key?

(A) Super key

(B) Primary key

(D) Alternate key

(E) Candidate key

(F) Foreign key

(G) Concatenated key

(H) All of these

(I) None of these

[showhide type=”button10c2″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: H [/showhide]

93 Which are the join types in join condition?

(A) Cross join

(B) Natural join

(D) Outer join

(E) Join with ON clause

(F) All of these

[showhide type=”button10c3″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: F [/showhide]

94 In which are interface provided by oracle:

(A) SQL *PLUS

(B) SQL*PLUS command line interface

(D) SQL *PLUS(introduced in ORACLE9i)

(E) All of these

(F) None of these

[showhide type=”button10c4″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: E [/showhide]

95 Which are the primitive operators of relation algebra as proposed by Codd?

(A) Selection

(B) Projection

(D) Set union

(E) Set difference

(F) Rename

(G) All of these

(H) None of these

[showhide type=”button10c5″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: G [/showhide]

96 Which is the advantage of database?

(A) Prevents Data redundancy

(B) Restricts unauthorized access

(D) Backup and recovery

(E) Integrity Constraints

(F) All of these

[showhide type=”button10c6″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: F [/showhide]

97 Which interface is provided by oracle?

(A) SQL*PLUS

(B) SQL*PLUS command line interface

(D) iSQL*PLUS

(E) All of these

[showhide type=”button10c7″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: E [/showhide]

98 Which the types of changeover methods:

(A) Direct

(B) Parallel

(D) Staged or phased

(E) All of these

[showhide type=”button10c8″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: E [/showhide]

99 Primary steps for converting a logical data model to preliminary physical data model are:

(A) Converting entities into file

(B) Converting relationship for accessing paths using keys

(D) De-normalization

(E) Tuning

(F) Converting

(G) Reduction of chain length

(H) All of these

(I) None of these

[showhide type=”button10c9″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: H [/showhide]

100 Which are the set operations supports the oracle SQL:

(A) UNION

(B) UNION ALL

(D) MINUS

(E) All of these

[showhide type=”button10c10″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: E [/showhide]

Go To pages -> 0/1/2/3/4/5/6/7