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
| 501. |
Data integrity constraints are used to: |
| A. | control who is allowed access to the data |
| B. | ensure that duplicate records are not entered into the table |
| C. | improve the quality of data entered for a specific property |
| D. | prevent users from changing the values stored in the table |
| Answer» C. improve the quality of data entered for a specific property | |
| 502. |
Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of: |
| A. | attributes |
| B. | data integrity constraints |
| C. | method constraints |
| D. | referential integrity constraints |
| Answer» B. data integrity constraints | |
| 503. |
Which of the following can be addressed by enforcing a referential integrity constraint? |
| A. | all phone numbers must include the area code |
| B. | certain fields are required (such as the email address, or phone number) before the record is accepted |
| C. | information on the customer must be known before anything can be sold to that customer |
| D. | then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’) |
| Answer» C. information on the customer must be known before anything can be sold to that customer | |
| 504. |
is a special type of integrity constraint that relates two relations & maintains consistency across the relations. |
| A. | entity integrity constraints |
| B. | referential integrity constraints |
| C. | domain integrity constraints |
| D. | domain constraints |
| Answer» B. referential integrity constraints | |
| 505. |
Which one of the following uniquely identifies the elements in the relation? |
| A. | secondary key |
| B. | primary key |
| C. | foreign key |
| D. | composite key |
| Answer» B. primary key | |
| 506. |
Drop Table cannot be used to drop a table referenced by a constraint. |
| A. | local key |
| B. | primary key |
| C. | composite key |
| D. | foreign key |
| Answer» D. foreign key | |
| 507. |
is preferred method for enforcing data integrity |
| A. | constraints |
| B. | stored procedure |
| C. | triggers |
| D. | cursors |
| Answer» A. constraints | |
| 508. |
The entity relationship set is represented in E-R diagram as |
| A. | double diamonds |
| B. | undivided rectangles |
| C. | dashed lines |
| D. | diamond |
| Answer» D. diamond | |
| 509. |
The Rectangles divided into two parts represents |
| A. | entity set |
| B. | relationship set |
| C. | attributes of a relationship set |
| D. | primary key |
| Answer» A. entity set | |
| 510. |
We indicate roles in E-R diagrams by labeling the lines that connect to |
| A. | diamond , diamond |
| B. | rectangle, diamond |
| C. | rectangle, rectangle |
| D. | diamond, rectangle |
| Answer» D. diamond, rectangle | |
| 511. |
An entity set that does not have sufficient attributes to form a primary key is termed a |
| A. | strong entity set |
| B. | variant set |
| C. | weak entity set |
| D. | variable set |
| Answer» C. weak entity set | |
| 512. |
For a weak entity set to be meaningful, it must be associated with another entity set, called the |
| A. | identifying set |
| B. | owner set |
| C. | neighbour set |
| D. | strong entity set |
| Answer» A. identifying set | |
| 513. |
Weak entity set is represented as |
| A. | underline |
| B. | double line |
| C. | double diamond |
| D. | double rectangle |
| Answer» C. double diamond | |
| 514. |
If you were collecting and storing information about your music collection, an album would be considered a(n) |
| A. | relation |
| B. | entity |
| C. | instance |
| D. | attribute |
| Answer» B. entity | |
| 515. |
What term is used to refer to a specific record in your music database; for instance; information stored about a specific album? |
| A. | relation |
| B. | instance |
| C. | table |
| D. | column |
| Answer» B. instance | |
| 516. |
Which one of the following can be treated as a primary key in teaches relation? |
| A. | id |
| B. | semester |
| C. | sec_id |
| D. | year |
| Answer» A. id | |
| 517. |
The primary key in the section relation is |
| A. | course_id |
| B. | sec_id |
| C. | both course_id and sec_id |
| D. | all the attributes |
| Answer» C. both course_id and sec_id | |
| 518. |
The relation with primary key can be created using |
| A. | create table instructor (id, name) |
| B. | create table instructor (id, name, primary key(name)) |
| C. | create table instructor (id, name, primary key (id)) |
| D. | create table instructor ( id unique, name ) |
| Answer» C. create table instructor (id, name, primary key (id)) | |
| 519. |
How can the values in the relation teaches be deleted? |
| A. | drop table teaches; |
| B. | delete from teaches; |
| C. | purge table teaches; |
| D. | delete from teaches where id =’null’; |
| Answer» B. delete from teaches; | |
| 520. |
In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows? |
| A. | 2 |
| B. | 4 |
| C. | 5 |
| D. | 1 |
| Answer» A. 2 | |
| 521. |
The relation changes can be got back using command |
| A. | flashback |
| B. | purge |
| C. | delete |
| D. | getback |
| Answer» A. flashback | |
| 522. |
Let us consider phone_number ,which can take single or several values . Treating phone_numberas an permits instructors to have several phone numbers (including zero) associated with them. |
| A. | entity |
| B. | attribute |
| C. | relation |
| D. | value |
| Answer» A. entity | |
| 523. |
The total participation by entities is represented in E-R diagram as |
| A. | dashed line |
| B. | double line |
| C. | double rectangle |
| D. | circle |
| Answer» B. double line | |
| 524. |
Given the basic ER and relational models, which of the following is INCORRECT? |
| A. | an attribute of an entity can have more than one value |
| B. | an attribute of an entity can be composite |
| C. | in a row of a relational table, an attribute can have more than one value |
| D. | in a row of a relational table, an attribute can have exactly one value or a null value |
| Answer» C. in a row of a relational table, an attribute can have more than one value | |
| 525. |
Which of the following indicates the maximum number of entities that can be involved in a relationship? |
| A. | minimum cardinality |
| B. | maximum cardinality |
| C. | erd |
| D. | greater entity count |
| Answer» B. maximum cardinality | |
| 526. |
In E-R diagram generalization is represented by |
| A. | ellipse |
| B. | dashed ellipse |
| C. | rectangle |
| D. | triangle |
| Answer» D. triangle | |
| 527. |
What is a relationship called when it is maintained between two entities? |
| A. | unary |
| B. | binary |
| C. | ternary |
| D. | quaternary |
| Answer» B. binary | |
| 528. |
Which of the following is a low level operator? |
| A. | insert |
| B. | update |
| C. | delete |
| D. | directory |
| Answer» D. directory | |
| 529. |
Key to represent relationship between tables is called |
| A. | primary key |
| B. | secondary key |
| C. | foreign key |
| D. | none of the mentioned |
| Answer» C. foreign key | |
| 530. |
A window into a portion of a database is |
| A. | schema |
| B. | view |
| C. | query |
| D. | data dictionary |
| Answer» B. view | |
| 531. |
A primary key is combined with a foreign key creates |
| A. | parent-child relation ship between the tables that connect them |
| B. | many to many relationship between the tables that connect them |
| C. | network model between the tables that connect them |
| D. | none of the mentioned |
| Answer» A. parent-child relation ship between the tables that connect them | |
| 532. |
The entity set person is classified as student and employee. This process is called |
| A. | generalization |
| B. | specialization |
| C. | inheritance |
| D. | constraint generalization |
| Answer» B. specialization | |
| 533. |
Which relationship is used to represent a specialization entity? |
| A. | isa |
| B. | ais |
| C. | onis |
| D. | whois |
| Answer» A. isa | |
| 534. |
The refinement from an initial entity set into successive levels of entity subgroupings represents a design process in which distinctions are made explicit. |
| A. | hierarchy |
| B. | bottom-up |
| C. | top-down |
| D. | radical |
| Answer» C. top-down | |
| 535. |
There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called |
| A. | commonality |
| B. | specialization |
| C. | generalization |
| D. | similarity |
| Answer» C. generalization | |
| 536. |
If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has |
| A. | hierarchy |
| B. | multilevel inheritance |
| C. | single inheritance |
| D. | multiple inheritance |
| Answer» D. multiple inheritance | |
| 537. |
A constraint requires that an entity belong to no more than one lower- level entity set. |
| A. | disjointness |
| B. | uniqueness |
| C. | special |
| D. | relational |
| Answer» A. disjointness | |
| 538. |
Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is |
| A. | overlapping |
| B. | disjointness |
| C. | uniqueness |
| D. | relational |
| Answer» A. overlapping | |
| 539. |
The completeness constraint may be one of the following: Total generalization or specialization, Partial generalization or specialization. Which is the default? |
| A. | total |
| B. | partial |
| C. | should be specified |
| D. | cannot be determined |
| Answer» B. partial | |
| 540. |
Functional dependencies are a generalization of |
| A. | key dependencies |
| B. | relation dependencies |
| C. | database dependencies |
| D. | none of the mentioned |
| Answer» A. key dependencies | |
| 541. |
Which of the following is another name for a weak entity? |
| A. | child |
| B. | owner |
| C. | dominant |
| D. | all of the mentioned |
| Answer» A. child | |
| 542. |
Which is the main relation which is used in the university database which is referenced by all other relation of the university? |
| A. | teaches |
| B. | course |
| C. | department |
| D. | section |
| Answer» C. department | |
| 543. |
The department relation has the an entry budget whose type has to be replaced by |
| A. | varchar (20) |
| B. | varchar2 (20) |
| C. | numeric (12,2) |
| D. | numeric |
| Answer» C. numeric (12,2) | |
| 544. |
In the above DDL command the foreign key entries are got by using the keyword |
| A. | references |
| B. | key reference |
| C. | relating |
| D. | none of the mentioned |
| Answer» A. references | |
| 545. |
Identify the error in the section relation |
| A. | no error |
| B. | year numeric (4,0) |
| C. | building varchar (15) |
| D. | sec_id varchar (8) |
| Answer» A. no error | |
| 546. |
Which of the following can be used as a primary key entry of the instructor relation. |
| A. | dept_name |
| B. | name |
| C. | id |
| D. | all of the mentioned |
| Answer» C. id | |
| 547. |
In the section relation which of the following is used as a foreign key? |
| A. | course_id |
| B. | course_id,sec_id |
| C. | room_number |
| D. | course_id,sec_id,room_number |
| Answer» A. course_id | |
| 548. |
To replace the relation section with some other relation the initial step to be carried out is |
| A. | delete section; |
| B. | drop section; |
| C. | delete from section; |
| D. | replace section new_table ; |
| Answer» B. drop section; | |
| 549. |
Select distinct Dept_name from instructor ; How many row(s) are displayed ? |
| A. | 4 |
| B. | 3 |
| C. | 5 |
| D. | error |
| Answer» A. 4 | |
| 550. |
Which function is used to find the count of distinct departments? |
| A. | dist |
| B. | distinct |
| C. | count |
| D. | count,dist |
| Answer» A. dist | |
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.