McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Computer Science Engineering (CSE) , Bachelor of Science in Computer Science FY (BSc CS) , Bachelor of Science in Computer Science SY (BSc CS) , Bachelor of Science in Information Technology SY (BSc IT) , Bachelor of Computer Applications (BCA) .
Chapters
| 201. |
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 |
| Answer» A. 4 NF | |
| 202. |
Which of the following is a tuple-generating dependencies? |
| A. | Functional dependency |
| B. | Equality-generating dependencies |
| C. | Multivalued dependencies |
| D. | Non-functional dependency |
| Answer» B. Equality-generating dependencies | |
| 203. |
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 |
| Answer» A. First Normal Form | |
| 204. |
Which forms has a relation that possesses data about an individual entity? |
| A. | 2NF |
| B. | 3NF |
| C. | 4NF |
| D. | 5NF |
| Answer» B. 3NF | |
| 205. |
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 |
| Answer» A. A many-to-many relationship set | |
| 206. |
Fifth Normal form is concerned with |
| A. | Functional dependency |
| B. | Multivalued dependency |
| C. | Join dependency |
| D. | Domain-key |
| Answer» B. Multivalued dependency | |
| 207. |
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 |
| Answer» B. A multivalued attribute of an entity set | |
| 208. |
In 2NF |
| A. | No functional dependencies (FDs) exist |
| B. | No multivalued dependencies (MVDs) exist |
| C. | No partial FDs exist |
| D. | No partial MVDs exist |
| Answer» B. No multivalued dependencies (MVDs) exist | |
| 209. |
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 |
| Answer» D. in the mysql database mysql | |
| 210. |
What MySQL property is used to create a surrogate key in MySQL? |
| A. | identical |
| B. | unique |
| C. | auto_increment |
| D. | sequence |
| Answer» C. auto_increment | |
| 211. |
A relational database consists of a collection of |
| A. | keys |
| B. | records |
| C. | tables |
| D. | fields |
| Answer» C. tables | |
| 212. |
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 |
| Answer» C. all options are correct | |
| 213. |
Which of the following is not a level of data abstraction? |
| A. | view level |
| B. | physical level |
| C. | logical level |
| D. | critical level |
| Answer» D. critical level | |
| 214. |
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 |
| Answer» D. all options are correct | |
| 215. |
In an Entity Relationship Diagram Rectangles represents |
| A. | tables |
| B. | attributes |
| C. | database |
| D. | entity sets |
| Answer» D. entity sets | |
| 216. |
Which of the following is not a Storage Manager Component? |
| A. | transaction manager |
| B. | logical manager |
| C. | file manager |
| D. | buffer manager |
| Answer» B. logical manager | |
| 217. |
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 |
| Answer» D. all the options are correct | |
| 218. |
Which of the following is not an Schema? |
| A. | logical schema |
| B. | physical schema |
| C. | database schema |
| D. | critical schema |
| Answer» D. critical schema | |
| 219. |
Which of the following is Database Language? |
| A. | data definition language |
| B. | data manipulation language |
| C. | data query language |
| D. | all of the options |
| Answer» D. all of the options | |
| 220. |
Which of the following in not a function of DBA? |
| A. | network maintenance |
| B. | schema definition |
| C. | authorization for data access |
| D. | routine maintenance |
| Answer» A. network maintenance | |
| 221. |
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 |
| Answer» C. all of the options are correct | |
| 222. |
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 |
| Answer» C. all of the options | |
| 223. |
Which of the following is not a level of data abstraction? |
| A. | physical level |
| B. | view level |
| C. | critical level |
| D. | logical level |
| Answer» C. critical level | |
| 224. |
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 |
| Answer» C. all of the options | |
| 225. |
Which of the following is not a Storage Manager Component? |
| A. | transaction manager |
| B. | buffer manager |
| C. | file manager |
| D. | logical manager |
| Answer» D. logical manager | |
| 226. |
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 |
| Answer» C. all of the above | |
| 227. |
Which of the following is not an Schema? |
| A. | logical schema |
| B. | critical schema |
| C. | database schema |
| D. | physical schema |
| Answer» B. critical schema | |
| 228. |
Which of the following is Database Language? |
| A. | all of the options |
| B. | query language |
| C. | data definition language |
| D. | data manipulation language |
| Answer» A. all of the options | |
| 229. |
Which of the following in not a function of DBA? |
| A. | authorization for data access |
| B. | network maintenance |
| C. | routine maintenance |
| D. | schema definition |
| Answer» B. network maintenance | |
| 230. |
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 |
| Answer» B. all of the options | |
| 231. |
Column header is refer as |
| A. | table |
| B. | domain |
| C. | attributes |
| D. | relation |
| Answer» C. attributes | |
| 232. |
_______ allow us to identify uniquely a tuple in the relation. |
| A. | schema |
| B. | superkey |
| C. | domain |
| D. | attribute |
| Answer» B. superkey | |
| 233. |
Minimal Superkeys are called |
| A. | schema keys |
| B. | attribute keys |
| C. | candidate keys |
| D. | domain keys |
| Answer» C. candidate keys | |
| 234. |
Which of the following is not Modification of the Database |
| A. | updating |
| B. | sorting |
| C. | deletion |
| D. | insertion |
| Answer» B. sorting | |
| 235. |
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 |
| Answer» C. all of the options | |
| 236. |
Set of premitted values of each attribute is called |
| A. | tuple |
| B. | schema |
| C. | domain |
| D. | relation |
| Answer» C. domain | |
| 237. |
Which of the following is true regarding Null Value? |
| A. | null<0 |
| B. | null=0 |
| C. | null<>0 |
| D. | null>0 |
| Answer» C. null<>0 | |
| 238. |
Logical design of database is called |
| A. | all of the options |
| B. | database schema |
| C. | database instance |
| D. | database snapshot |
| Answer» B. database schema | |
| 239. |
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 |
| Answer» A. database instance | |
| 240. |
Which of the following is not Unary operation? |
| A. | rename |
| B. | union |
| C. | select |
| D. | project |
| Answer» B. union | |
| 241. |
Which of the following is not binary operation? |
| A. | union |
| B. | set difference |
| C. | cartesian product |
| D. | project |
| Answer» D. project | |
| 242. |
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 |
| Answer» B. it takes a list of values and return a single values as result | |
| 243. |
The Primary key must be |
| A. | non null |
| B. | unique |
| C. | option a or b |
| D. | option a and b |
| Answer» D. option a and b | |
| 244. |
A command to remove a relation from an SQL database |
| A. | delete table |
| B. | erase table |
| C. | alter table |
| D. | drop table |
| Answer» D. drop table | |
| 245. |
which of the following is not an Aggregate function? |
| A. | select |
| B. | avg |
| C. | min |
| D. | max |
| Answer» A. select | |
| 246. |
The attribute that can be divided into other attributes is called |
| A. | composite attribute |
| B. | derived attribute |
| C. | simple attribute |
| D. | multi-valued attribute |
| Answer» A. composite attribute | |
| 247. |
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 |
| Answer» C. atomicity, consistency, isolation, durability | |
| 248. |
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 |
| Answer» B. third normal form | |
| 249. |
Database locking concept is used to solve the problem of |
| A. | inconsistent data |
| B. | all of the options |
| C. | lost update |
| D. | uncommitted dependency |
| Answer» B. all of the options | |
| 250. |
UML is stands for |
| A. | universal modeling language |
| B. | united modeling language |
| C. | uni modeling language |
| D. | unified modeling language |
| Answer» D. unified modeling language | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.