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
    (C)   Both
    (D)   None

2   Which command defines its columns, integrity constraint in create table?
    (A)   Create command
    (B)   Drop table command
    (C)   Alter table command
    (D)   All of these

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
    (C)   Write key
    (D)   None of these

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
    (C)   UNIQUE
    (D)   None

5   Which constraint that identifies a column or combination of columns as a unique key:
    (A)   IS NULL
    (B)   NOT NULL
    (C)   UNIQUE
    (D)   None

6   Which command is use for removing a table and all its data from the database?
    (A)   Create command
    (B)   Drop table command
    (C)   Alter table command
    (D)   All of these

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
    (C)   Drop table command
    (D)   Alter table command

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
    (C)   Full outer join
    (D)   Half outer join

9   How many set operations support the oracle SQL?
    (A)   2
    (B)   3
    (C)   4
    (D)   5

10   ______ operator merges the result sets of two component queries:
    (A)   UNION
    (B)   UNION ALL
    (C)   INTERSECT
    (D)   MINUS

11   How many component queries are combined using the set operators?
    (A)   1
    (B)   2
    (C)   3
    (D)   4

12   In precedence of set operators the expression is evaluated from______:
    (A)   Left to Left
    (B)   Right to Right
    (C)   Left to Right
    (D)   Right to Left

13   View in SQL a view may be defined as a
    (A)   Stored query
    (B)   Virtual table
    (C)   Both
    (D)   None

14   How many types of views in SQL:
    (A)   1
    (B)   2
    (C)   3
    (D)   4

15   Which are the types of views in SQL?
    (A)   Inline view
    (B)   Database view
    (C)   Materialized view
    (D)   All of these

16   Which operation is allowed in a join view?
    (A)   UPDATE
    (B)   INSERT
    (C)   DELETE
    (D)   All of these

17   The materialized view was introduced by:
    (A)   Oracle 6
    (B)   Oracle 7
    (C)   Oracle 8
    (D)   Oracle 9

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
    (C)   Two and One
    (D)   None of these

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
    (C)   Updatable join view
    (D)   All of these

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
    (C)   WITH WRITE OPTION
    (D)   WITH OPTION

21   Which command is used to add the views to the database?
    (A)   DATABASE VIEW
    (B)   CREATE VIEW
    (C)   CREATE OPTION
    (D)   None of these

22   Which option is used with the WHERE clause:
    (A)   DATABASE
    (B)   WITH CHECK OPTION
    (C)   WITH WRITE OPTION
    (D)   WITH OPTION

23   Which option may be used to create the inline view as a constrained view?
    (A)   DATABASE
    (B)   WITH CHECK OPTION
    (C)   WITH WRITE OPTION
    (D)   WITH OPTION

24   In which year ORACLE, an SQL product was released:
    (A)   1976
    (B)   1977
    (C)   1978
    (D)   1979

25   The prototype for SQL was originally developed by:
    (A)   INTEL
    (B)   APPLE
    (C)   IBM
    (D)   All of these

26   In which year relational algebra became prominent after the relational model of database was published:
    (A)   1969
    (B)   1970
    (C)   1971
    (D)   1972

27   Relational algebra became prominent after the relational model of database was published by:
    (A)   Codds
    (B)   F.F. Codd
    (C)   E.E. Codd
    (D)   None of these

28   Which is an ANSI standard and has many different versions?
    (A)   IBM
    (B)   SQL
    (C)   RDBMS
    (D)   ORACLE

29   Which is used for interfacing with RDBMS?
    (A)   IBM
    (B)   SQL
    (C)   ANSI
    (D)   ORACLE

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
    (C)   RDBMS
    (D)   None of these

31   FD stands for:
    (A)   Functional dependency
    (B)   Facilitate dependency
    (C)   Functional data
    (D)   Facilitate data

32   In which model of database data is stored in tables:
    (A)   Network model
    (B)   Relational model
    (C)   Hierarchical model
    (D)   None of these

33   The relational database model and after that by a researcher at _______:
    (A)   IBM
    (B)   Apple
    (C)   Intel
    (D)   All of these

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
    (C)   Related database
    (D)   None of these

35   A table can be defined as a set of______:
    (A)   Rows
    (B)   Columns
    (C)   Both
    (D)   None

36   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

37   How many types of keys in relation database design?
    (A)   Primary key
    (B)   Candidate key
    (C)   Foreign key
    (D)   All of these

38   Which keys are used that are a column in the table?
    (A)   Primary key
    (B)   Candidate key
    (C)   Foreign key
    (D)   All of these

39   Which key is referencing a primary key in a table?
    (A)   Primary key
    (B)   Candidate key
    (C)   Foreign key
    (D)   All of these

40   Which key is used to find the customer from the table?
    (A)   Primary key
    (B)   Candidate key
    (C)   Foreign key
    (D)   All of these

41   Which key have a common meaning:
    (A)   Foreign key
    (B)   Primary key
    (C)   Both
    (D)   None

42   A domain is a collection of values from where the columns are_____:
    (A)   Deleted
    (B)   Created
    (C)   Maintained
    (D)   All of these

43   Which access provides a partial support to domains?
    (A)   Microsoft
    (B)   Microprocessor
    (C)   Microcomputer
    (D)   Memory

44   Which database relationship is considered only between pairs of tables?
    (A)   Service database
    (B)   Relational database
    (C)   Related database
    (D)   None of these

45   In relationships how many different ways in which two tables may be related?
    (A)   1
    (B)   2
    (C)   3
    (D)   4

46   In which ways two tables may be related:
    (A)   One-one
    (B)   One-many
    (C)   Many-many
    (D)   All of these

47   Which rules are defined in relational models which from an essential part of any relation database:
    (A)   Integrity rules
    (B)   Database
    (C)   Record
    (D)   Memory

48   How many types of integrity rules:
    (A)   1
    (B)   2
    (C)   3
    (D)   4

49   Which are the types of integrity rule?
    (A)   General
    (B)   Database specific
    (C)   Both
    (D)   None

50   How many general rules in a relational model, and being general rules, these are applicable to all databases:
    (A)   2
    (B)   3
    (C)   4
    (D)   5

51   Which rules are known as ’entity integrity’ and ‘referential integrity’:
    (A)   General
    (B)   Database specific
    (C)   Both
    (D)   None

52   ______states that primary keys should not be null:
    (A)   Entity integrity
    (B)   Referential integrity
    (C)   Both
    (D)   None

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
    (C)   General integrity rule
    (D)   Database specific integrity rule

54   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

55   In creating a table a row contains:
    (A)   Memory
    (B)   Record
    (C)   Field
    (D)   None

56   In creating a table a column contains:
    (A)   Memory
    (B)   Record
    (C)   Field
    (D)   None

57   Which have not have client/server architecture:
    (A)   DBS
    (B)   DBMS
    (C)   RDBMS
    (D)   All of these

58   Which command creates database objects like tables views and indexes?
    (A)   Create command
    (B)   Update command
    (C)   Both
    (D)   None

59   Which command enables alteration the data stored in existing records?
    (A)   Create command
    (B)   Update command
    (C)   Deletion command
    (D)   All of these

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
    (C)   ANSI
    (D)   ORACLE

61   Which valued facts formalize the concept of functional dependency?
    (A)   Single-valued
    (B)   Double-valued
    (C)   Both
    (D)   None

62   Which relationship model provides a starting point for identifying schemas and integrity constraints?
    (A)   Entity
    (B)   Referential
    (C)   Both
    (D)   None

63   FD stands for:
    (A)   Formal dependency
    (B)   Functional dependency
    (C)   Fact dependency
    (D)   Superset dependency

64   Which is derived from mathematical theory?
    (A)   IBM
    (B)   SQL
    (C)   ANSI
    (D)   FD

65   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

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
    (C)   FD
    (D)   All of these

67   How many various types of dependencies:
    (A)   1
    (B)   2
    (C)   3
    (D)   4

68   Which are the dependencies types?
    (A)   Full functional dependency
    (B)   Partial dependency
    (C)   Trivial functional dependency
    (D)   All of these

69   FDs are the types of constraints that are based on______:
    (A)   Key
    (B)   Key revisited
    (C)   Superset key
    (D)   None of these

70   What is a super key?
    (A)   Key
    (B)   Key revisited
    (C)   Superset key
    (D)   None of these

71   Which s essential a business problem not a data problem:
    (A)   Data
    (B)   Database
    (C)   Database design
    (D)   All of these

72   Which is primarily the result of a thorough understanding of information about an enterprise?
    (A)   Data
    (B)   Database
    (C)   Database design
    (D)   Data modeling

73   McFadden has defined normalization in his which book___________:
    (A)   Database modern management
    (B)   Management database of modern
    (C)   Modern database management
    (D)   Database management

74   The database design prevents some data from being represented due to _______:
    (A)   Deletion anomalies
    (B)   Insertion anomalies
    (C)   Update anomaly
    (D)   None of these

75   How many types of insertion anomalies:
    (A)   1
    (B)   2
    (C)   3
    (D)   4

76   Who developed the normalization process?
    (A)   E.F. Codd
    (B)   F.F. Codd
    (C)   E.E. Codd
    (D)   None of these

77   E.F. Codd developed the normalization process in the early:
    (A)   1969
    (B)   1970
    (C)   1971
    (D)   1972

78   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

79   Which is the process of breaking a relation into multiple relations?
    (A)   Functional dependency
    (B)   Database modeling
    (C)   Normalization
    (D)   Decomposition

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
    (C)   Normalization
    (D)   Decomposition

81   In decomposition technique of splitting a relation into_____ relation:
    (A)   ONE or MORE
    (B)   TWO or MORE
    (C)   C .THREE or MORE
    (D)   FOUR or MORE

82   Codd suggested how many forms in normalization process:
    (A)   1
    (B)   2
    (C)   3
    (D)   4

83   Consequently R.Boyce-Codd jointly launched powerful definition for the third normal form called______:
    (A)   Boyce-Codd normal form
    (B)   First normal form
    (C)   Second normal form
    (D)   All of these

84   BCNF stands for:
    (A)   Basic -Codd normal form
    (B)   Build -Codd normal form
    (C)   Boyce-Codd normal form
    (D)   None of these

85   Which forms simplify and ensure that there are minimal data aggregates and repetitive groups:
    (A)   1NF
    (B)   2NF
    (C)   3NF
    (D)   All of these

86   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

87   Which forms is required when although NF is present more normalization is required:
    (A)   1NF
    (B)   2NF
    (C)   3NF
    (D)   4NF

88   Which forms has a relation that possesses data about an individual entity:
    (A)   2NF
    (B)   3NF
    (C)   4NF
    (D)   5NF

89   PJNF stands form:
    (A)   Practically –join normal form
    (B)   Project –join normal form
    (C)   Pages –join normal form
    (D)   Programming –join normal form

90   Which forms are based on the concept of functional dependency?
    (A)   1NF
    (B)   2NF
    (C)   3NF
    (D)   4NF

91   Which one is based on multi-valued dependency?
    (A)   First
    (B)   Second
    (C)   Third
    (D)   Fourth

92   Which is the various key?
    (A)   Super key
    (B)   Primary key
    (C)   Secondary key
    (D)   Alternate key
    (E)   Candidate key
    (F)   Foreign key
    (G)   Concatenated key
    (H)   All of these
    (I)   None of these

93   Which are the join types in join condition?
    (A)   Cross join
    (B)   Natural join
    (C)   Join with USING clause
    (D)   Outer join
    (E)   Join with ON clause
    (F)   All of these

94   In which are interface provided by oracle:
    (A)   SQL *PLUS
    (B)   SQL*PLUS command line interface
    (C)   SQL Plus Worksheet (introduced in ORACLE8i)
    (D)   SQL *PLUS(introduced in ORACLE9i)
    (E)   All of these
    (F)   None of these

95   Which are the primitive operators of relation algebra as proposed by Codd?
    (A)   Selection
    (B)   Projection
    (C)   Cartesian product
    (D)   Set union
    (E)   Set difference
    (F)   Rename
    (G)   All of these
    (H)   None of these

96   Which is the advantage of database?
    (A)   Prevents Data redundancy
    (B)   Restricts unauthorized access
    (C)   Persistent storage
    (D)   Backup and recovery
    (E)   Integrity Constraints
    (F)   All of these

97   Which interface is provided by oracle?
    (A)   SQL*PLUS
    (B)   SQL*PLUS command line interface
    (C)   SQLPlus Worksheet
    (D)   iSQL*PLUS
    (E)   All of these

98   Which the types of changeover methods:
    (A)   Direct
    (B)   Parallel
    (C)   Pilot
    (D)   Staged or phased
    (E)   All of these

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
    (C)   Adding
    (D)   De-normalization
    (E)   Tuning
    (F)   Converting
    (G)   Reduction of chain length
    (H)   All of these
    (I)   None of these

100   Which are the set operations supports the oracle SQL:
    (A)   UNION
    (B)   UNION ALL
    (C)   INTERSECT
    (D)   MINUS
    (E)   All of these

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

Back to Top