Join Us ::

Menu Home Classes GK Engineering Past Papers Current Affairs Technical GAT Subject Programming Medical Papers

Database :: All Aptitude Test ::

Home » Technical » Database » Aptitude Test - 4
1.An is a set of entities of the same type that share the same properties, or attributes?
A. Entity set
B. Attribute set
C. Relation set
D. Entity set
2.Entity is a?
A. Object of relation
B. Present working model
C. Thing in real world
D. Object of relation
3.The descriptive property possessed by each entity set is?
A. Entity
B. Attribute
C. Relation
D. Entity
4.The function that an entity plays in a relationship is called that entity’s?
A. Participation
B. Position
C. Role
D. Participation
5. The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called?
A. Simple attribute
B. Composite attribute
C. Multivalued attribute
D. Simple attribute
6.The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is?
A. Single valued
B. Multi valued
C. Composite
D. Single valued
7.Not applicable condition can be represented in relation entry as?
A. NA
B. 0
C. NULL
D. NA
8.Which of the following can be a multi-valued attribute?
A. Phone_number
B. Name
C. Date_of_birth
D. Phone_number
9.Which of the following is a single valued attribute?
A. Register_number
B. Address
C. SUBJECT_TAKEN
D. Register_number
10.In a relation between the entities the type and condition of the relation should be specified. That is called as attribute?
A. Desciptive
B. Derived
C. Recursive
D. Desciptive
11.Which express the number of entities to which another entity can be associated via a relationship set?
A. Mapping Cardinality
B. Relational Cardinality
C. Participation Constraints
D. Mapping Cardinality
12.An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as?
A. One-to-many
B. One-to-one
C. Many-to-many
D. One-to-many
13.An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A?
A. One-to-many
B. One-to-one
C. Many-to-many
D. One-to-many
14.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. Control who is allowed access to the data
15.Which one of the following uniquely identifies the elements in the relation?
A. Secondary Key
B. Primary key
C. Foreign key
D. Secondary Key
16.Drop Table cannot be used to drop a table referenced by a constraint?
A. Local Key
B. Primary Key
C. Composite Key
D. Local Key
17.What is preferred method for enforcing data integrity ?
A. Constraints
B. Stored Procedure
C. Triggers
D. Constraints
18.Which of the following gives a logical structure of the database graphically?
A. Entity-relationship diagram
B. Entity diagram
C. Database diagram
D. Entity-relationship diagram
19.The entity relationship set is represented in E-R diagram as?
A. Double diamonds
B. Undivided rectangles
C. Dashed lines
D. Double diamonds
20.The Rectangles divided into two parts represents?
A. Entity set
B. Relationship set
C. Attributes of a relationship set
D. Entity set
21.We indicate roles in E-R diagrams by labeling the lines that connect ?
A. Diamond , diamond
B. Rectangle, diamond
C. Rectangle, rectangle
D. Diamond , diamond
22.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. Strong entity set
23.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. Identifying set
24.Weak entity set is represented as?
A. Underline
B. Double line
C. Double diamond
D. Underline
25.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. Relation
26.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. Relation
27.The primary key in the section relation is?
A. Course_id
B. Sec_id
C. Both A & B
D. Course_id
28.Which of the following Id is selected for the following query?
A. 1003
B. 1001
C. Error message appears
D. 1003
29.Which of the following Id are displayed?
A. 1003
B. 1001
C. Both A & B
D. 1003
30.The query which selects the Course_id ‘CS-101’ from the section relation is?
A. Select Course_id from section where Building = ‘Richard’;
B. Select Course_id from section where Year = ‘2009’;
C. Select Course_id from teaches where Building = ‘Packyard’;
D. Select Course_id from section where Building = ‘Richard’;
Related Subjects

Date to Date Current Affairs 2022

PakMCQs.net

Quick Links

GAT Subject



   Computer Science    English Mcqs    Agriculture    

Engineering



   Computer Science    Civil Engineering    

Technical



   Networking    Electronics    Database    

Past Papers



   Model Papers    FPSC Papers    
Our Team | Career | Contact | JoinUs | Privacy Policy | DMC

© 2020-2024 by Pak-MCQs.net All Rights Reserved.

Email: [email protected]