Quiznetik
DataBase Management System (DBMS) | Set 3
1. The normal form which satisfies multivalued dependencies and which is in BCNF is
A. 4 NF
B. 3 NF
C. 2 NF
D. All of the mentioned
Correct : A. 4 NF
2. Which of the following is a tuple-generating dependencies?
A. Functional dependency
B. Equality-generating dependencies
C. Multivalued dependencies
D. Non-functional dependency
Correct : B. Equality-generating dependencies
3. The main task carried out in the __________ is to remove repeating attributes to separate tables.
A. First Normal Form
B. Second Normal Form
C. Third Normal Form
D. Fourth Normal Form
Correct : A. First Normal Form
4. Which forms has a relation that possesses data about an individual entity?
A. 2NF
B. 3NF
C. 4NF
D. 5NF
Correct : B. 3NF
5. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
A. A many-to-many relationship set
B. A multivalued attribute of an entity set
C. A one-to-many relationship set
D. None of the mentioned
Correct : A. A many-to-many relationship set
6. Fifth Normal form is concerned with
A. Functional dependency
B. Multivalued dependency
C. Join dependency
D. Domain-key
Correct : B. Multivalued dependency
7. n which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
A. A many-to-many relationship set
B. A multivalued attribute of an entity set
C. A one-to-many relationship set
D. None of the mentioned
Correct : B. A multivalued attribute of an entity set
8. In 2NF
A. No functional dependencies (FDs) exist
B. No multivalued dependencies (MVDs) exist
C. No partial FDs exist
D. No partial MVDs exist
Correct : B. No multivalued dependencies (MVDs) exist
9. Where is metadata stored in MySQL?
A. in the mysql database meta
B. in the mysql database metasql
C. in the mysql database metadata
D. in the mysql database mysql
Correct : D. in the mysql database mysql
10. What MySQL property is used to create a surrogate key in MySQL?
A. identical
B. unique
C. auto_increment
D. sequence
Correct : C. auto_increment
11. A relational database consists of a collection of
A. keys
B. records
C. tables
D. fields
Correct : C. tables
12. A Database Management System (DBMS) is:
A. collection of data describing one particular enterprise
B. collection of programs to access data
C. all options are correct
D. collection of interrelated data
Correct : C. all options are correct
13. Which of the following is not a level of data abstraction?
A. view level
B. physical level
C. logical level
D. critical level
Correct : D. critical level
14. Disadvantages of File systems to store data is:
A. data isolation
B. data redundancy and inconsistency
C. difficulty in accessing data
D. all options are correct
Correct : D. all options are correct
15. In an Entity Relationship Diagram Rectangles represents
A. tables
B. attributes
C. database
D. entity sets
Correct : D. entity sets
16. Which of the following is not a Storage Manager Component?
A. transaction manager
B. logical manager
C. file manager
D. buffer manager
Correct : B. logical manager
17. Data Manipulation Language enables users to
A. retrieval of information stored in database
B. insertion of new information into the database
C. deletion of information from the database
D. all the options are correct
Correct : D. all the options are correct
18. Which of the following is not an Schema?
A. logical schema
B. physical schema
C. database schema
D. critical schema
Correct : D. critical schema
19. Which of the following is Database Language?
A. data definition language
B. data manipulation language
C. data query language
D. all of the options
Correct : D. all of the options
20. Which of the following in not a function of DBA?
A. network maintenance
B. schema definition
C. authorization for data access
D. routine maintenance
Correct : A. network maintenance
21. Which of the following is a Data Model?
A. entity relationship model
B. object based data model
C. all of the options are correct
D. relational data model
Correct : C. all of the options are correct
22. A Database Management System (DBMS) is
A. collection of interrelated data
B. collection of data describing one particular enterprise
C. all of the options
D. collection of programs to access data
Correct : C. all of the options
23. Which of the following is not a level of data abstraction?
A. physical level
B. view level
C. critical level
D. logical level
Correct : C. critical level
24. Disadvantages of File systems to store data is:
A. data redundancy and inconsistency
B. data isolation
C. all of the options
D. difficulty in accessing data
Correct : C. all of the options
25. Which of the following is not a Storage Manager Component?
A. transaction manager
B. buffer manager
C. file manager
D. logical manager
Correct : D. logical manager
26. Data Manipulation Language enables users to
A. retrieval of information stored in database
B. deletion of information from the database
C. all of the above
D. insertion of new information into the database
Correct : C. all of the above
27. Which of the following is not an Schema?
A. logical schema
B. critical schema
C. database schema
D. physical schema
Correct : B. critical schema
28. Which of the following is Database Language?
A. all of the options
B. query language
C. data definition language
D. data manipulation language
Correct : A. all of the options
29. Which of the following in not a function of DBA?
A. authorization for data access
B. network maintenance
C. routine maintenance
D. schema definition
Correct : B. network maintenance
30. Which of the following is a Data Model?
A. object-based data model
B. all of the options
C. entity-relationship model
D. relational data model
Correct : B. all of the options
31. Column header is refer as
A. table
B. domain
C. attributes
D. relation
Correct : C. attributes
32. _______ allow us to identify uniquely a tuple in the relation.
A. schema
B. superkey
C. domain
D. attribute
Correct : B. superkey
33. Minimal Superkeys are called
A. schema keys
B. attribute keys
C. candidate keys
D. domain keys
Correct : C. candidate keys
34. Which of the following is not Modification of the Database
A. updating
B. sorting
C. deletion
D. insertion
Correct : B. sorting
35. Which of the following in not Outer join?
A. left outer join
B. full outer join
C. all of the options
D. right outer join
Correct : C. all of the options
36. Set of premitted values of each attribute is called
A. tuple
B. schema
C. domain
D. relation
Correct : C. domain
37. Which of the following is true regarding Null Value?
A. null<0
B. null=0
C. null<>0
D. null>0
Correct : C. null<>0
38. Logical design of database is called
A. all of the options
B. database schema
C. database instance
D. database snapshot
Correct : B. database schema
39. Snapshot of the data in the database at a given instant of time is called
A. database instance
B. all of the options
C. database schema
D. database snapshot
Correct : A. database instance
40. Which of the following is not Unary operation?
A. rename
B. union
C. select
D. project
Correct : B. union
41. Which of the following is not binary operation?
A. union
B. set difference
C. cartesian product
D. project
Correct : D. project
42. Which of the following is correct regarding Aggregate functions?
A. it takes a single value and returns a single value as result
B. it takes a list of values and return a single values as result
C. it takes a list of values and return a list of values as result
D. it takes a single value and returns a list of values as result
Correct : B. it takes a list of values and return a single values as result
43. The Primary key must be
A. non null
B. unique
C. option a or b
D. option a and b
Correct : D. option a and b
44. A command to remove a relation from an SQL database
A. delete table
B. erase table
C. alter table
D. drop table
Correct : D. drop table
45. which of the following is not an Aggregate function?
A. select
B. avg
C. min
D. max
Correct : A. select
46. The attribute that can be divided into other attributes is called
A. composite attribute
B. derived attribute
C. simple attribute
D. multi-valued attribute
Correct : A. composite attribute
47. What is ACID properties of Transactions?
A. atomicity, consistency, isolation, database
B. automatically, concurrency, isolation, durability
C. atomicity, consistency, isolation, durability
D. atomicity, consistency, inconsistent, durability
Correct : C. atomicity, consistency, isolation, durability
48. If every non-key attribute is functionally dependent on the primary key, the relation will be in
A. fourth formal form
B. third normal form
C. first normal form
D. second normal form
Correct : B. third normal form
49. Database locking concept is used to solve the problem of
A. inconsistent data
B. all of the options
C. lost update
D. uncommitted dependency
Correct : B. all of the options
50. UML is stands for
A. universal modeling language
B. united modeling language
C. uni modeling language
D. unified modeling language
Correct : D. unified modeling language
51. Data Manipulation Language (DML) is not to
A. insertion of new information into the database
B. modification of information in the database
C. create information table in the database
D. deletion of information in the database
Correct : C. create information table in the database
52. Which of the following in true regarding Referential Integrity?
A. every primary-key value must match a primary-key value in an associated table
B. every primary-key value must match a foreign-key value in an associated table
C. every foreign-key value must match a foreign-key value in an associated table
D. every foreign-key value must match a primary-key value in an associated table
Correct : D. every foreign-key value must match a primary-key value in an associated table
53. Which of the following option is use to retrieval of data?
A. stack
B. data structure
C. linked list
D. query
Correct : D. query
54. ODBC stands for ______
A. none of above
B. open database connection
C. offline database connection
D. oriented database connection
Correct : B. open database connection
55. Which of the following is an unary operation?
A. selection operation
B. primitive operation
C. projection operation
D. generalized selection
Correct : D. generalized selection
56. Which SQL Query is use to remove a table and all its data from the database?
A. none of these
B. drop table
C. create table
D. alter table
Correct : B. drop table
57. In precedence of set operators the expression is evaluated from:
A. left to right
B. right to left
C. left to left
D. right to right
Correct : A. left to right
58. In DBMS, FD stands for _______
A. facilitate data
B. functional data
C. facilitate dependency
D. functional dependency
Correct : D. functional dependency
59. How many types of keys in Database Design?
A. foreign key
B. all of the options
C. candidate key
D. primary key
Correct : B. all of the options
60. Which of the following is based on Multi Valued Dependency?
A. third
B. fourth
C. first
D. second
Correct : B. fourth
61. Which of the following is the structure of the Database?
A. table
B. none of these
C. schema
D. relation
Correct : C. schema
62. The minimal set of super key is called
A. primary key
B. secondary key
C. foreign key
D. candidate key
Correct : D. candidate key
63. ______________ is a classical approach to database design?
A. bottom – up approach
B. top – down approach
C. left – right approach
D. right – left approach
Correct : B. top – down approach
64. _____________ refers to the correctness and completeness of the data in a database?
A. data independence
B. data integrity
C. data security
D. data constraint
Correct : B. data integrity
65. A table that displays data redundancies yields ____________ anomalies
A. insertion
B. deletion
C. update
D. all of the options
Correct : D. all of the options
66. A lock that allows concurrent transactions to access different rows of the same table is known as a
A. row-level lock
B. database-level lock
C. field-level lock
D. table-level lock
Correct : C. field-level lock
67. A type of query that is placed within a WHERE or HAVING clause of another query is called
A. multi-query
B. sub query
C. super query
D. master query
Correct : B. sub query
68. A form defined
A. none of the options
B. where data is placed on the screen
C. the width of each field
D. both where data is placed on the screen and the width of each field
Correct : B. where data is placed on the screen
69. If a piece of data is stored in two places in the database, then
A. in can be more easily accessed
B. both storage space is wasted and changing the data in one spot will cause data inconsistency
C. storage space is wasted
D. changing the data in one spot will cause data inconsistency
Correct : B. both storage space is wasted and changing the data in one spot will cause data inconsistency
70. Which of the following is a problem of file management system?
A. data redundancy and program dependence
B. all of the options
C. difficult to update
D. lack of data independence
Correct : B. all of the options
71. Which of the following is not an advantage of the database approach
A. elimination of data redundancy
B. ability of associate deleted data
C. increased security and program/data independence
D. all of the above
Correct : D. all of the above
72. An audit trail
A. none of the options
B. is the recorded history of operations performed on a file
C. is used to make backup copies
D. can be used to restore lost information
Correct : B. is the recorded history of operations performed on a file
73. One approach to standardization storing of data?
A. codasyl specification
B. none of the options
C. mis
D. structured programming
Correct : A. codasyl specification
74. Report generators are used to
A. store data input by a user
B. answer queries
C. both retrieve information from files and answer queries
D. retrieve information from files
Correct : C. both retrieve information from files and answer queries
75. Which of the following is true of a network structure?
A. it will be dominant data base of the future
B. it allows a many-to-many relationship
C. it is a physical representation of the data
D. it is conceptually simple
Correct : B. it allows a many-to-many relationship
76. A record management system
A. can handle many files of information at a time
B. always uses a list as its model
C. both can handle many files of information at a time and always uses a list as its model
D. can be used to extract information stored in a computer file
Correct : D. can be used to extract information stored in a computer file
77. One data dictionery software package is called
A. db/dc dictionary
B. datapac
C. total
D. access
Correct : A. db/dc dictionary
78. The function of a database is ...
A. to check all input data
B. to output data
C. to collect and organize input data
D. to check all spelling
Correct : C. to collect and organize input data
79. A command that lets you change one or more fields in a record is
A. none of the options
B. modify
C. insert
D. lookup
Correct : B. modify
80. What is the language used by most of the DBMSs for helping their users to access data?
A. high level language
B. 4gl
C. query language
D. sql
Correct : C. query language
81. Information can be transferred between the DBMS and a
A. spreadsheet program
B. word processor program
C. graphics program
D. all of the options
Correct : D. all of the options
82. The relational database environment has all of the following components except
A. users
B. database
C. query languages
D. separate files
Correct : D. separate files
83. The ascending order of a data hirerchy is:
A. bit-byte-file-record-field-database
B. bit-byte-field-record-file-database
C. bit-byte-record-field-file-database
D. byte-bit-field-record-file-database
Correct : B. bit-byte-field-record-file-database
84. Primitive operations common to all record management system include
A. look-up
B. all of the options
C. print
D. sort
Correct : A. look-up
85. Which of the following is not a relational database?
A. dbase iv
B. foxpro
C. reflex
D. 4th dimension
Correct : C. reflex
86. A top-to-bottom relationship among the items in a database is established by a
A. hierarchical schema
B. all of the options
C. network schema
D. relational schema
Correct : A. hierarchical schema
87. Choose the RDBMS which supports full fledged client server application development
A. dbase v
B. ingress
C. oracle 7.1
D. foxpro 2.1
Correct : C. oracle 7.1
88. The highest level in the hierarchy of data organization is called
A. data base
B. data record
C. data bank
D. data file
Correct : A. data base
89. The management information system (MIS) structure with one main computer system is called a
A. decentralized mis structure
B. centralized mis structure
C. hierarchical mis structure
D. distributed mis structure
Correct : B. centralized mis structure
90. In the DBMS approach, application programs perform the
A. storage function
B. access control
C. all of the options
D. processing functions
Correct : D. processing functions
91. Which of the following is not true of the traditional approach to information processing
A. it is file oriented
B. it is inflexible
C. there is common sharing of data among the various applications
D. programs are dependent on the file
Correct : C. there is common sharing of data among the various applications
92. Batch processing is appropriate if
A. only a few transactions are involved
B. none of the options
C. large computer system is available
D. only a small computer system is avilbale
Correct : B. none of the options
93. Large collection of files are called
A. sectors
B. database
C. fields
D. records
Correct : B. database
94. A transparent DBMS
A. both can not hide sensitive information from users and keeps its logical structure hidden from users
B. keeps its physical structure hidden from users
C. can not hide sensitive information from users
D. keeps its logical structure hidden from users
Correct : B. keeps its physical structure hidden from users
95. A file produced by a spreadsheet
A. none of the options
B. is generally stored on disk in an ascii text fromat
C. can be used as is by the dbms
D. both is generally stored on disk in an ascii text fromat and can be used as is by the dbms
Correct : B. is generally stored on disk in an ascii text fromat
96. The model for a record management system might be
A. all of the options
B. a business form
C. handwritten list
D. a rolodex card file
Correct : A. all of the options
97. Database management systems are intended to
A. eliminate data redundancy
B. establish relationship among records in different files
C. manage file access and maintain data integrity
D. all of the options
Correct : D. all of the options
98. The language used application programs to request data from the DBMS is referred to as the
A. ddl
B. all of the options
C. dml
D. query language
Correct : C. dml
99. A set of programs that handle a firm's database responsibilities is called
A. database management system (dbms)
B. data management system (dms)
C. all of the options
D. database processing system (dbps)
Correct : C. all of the options
100. In a large DBMS
A. each subschema contains every field in the logical schema
B. each user can access every subschema
C. none of the options
D. each user can "see" only a small part of the entire database
Correct : D. each user can "see" only a small part of the entire database