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 - 14
1.The entity types, super classes and sub classes are classified as
A. ER schema overlapping
B. ER schema functions
C. ER schema objects
D. ER schema overlapping
2.In UML class diagrams, the inheritances that are permitted includes
A. single inheritance
B. multiple inheritance
C. shared schema inheritance
D. single inheritance
3. In 3NF, which form of dependency is removed _____?
A. Functional
B. Non-functional
C. Associative
D. Functional
4.A primary key that consists of more than one attribute is called a _____?
A. Foreign key
B. Composite key
C. Multivalued key
D. Foreign key
5.An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a _____?
A. Global key
B. Link key
C. Foreign key
D. Global key
6.One field or combination of fields for which more than one record may have the same combination of values is called _____?
A. Secondary key
B. Index
C. Composite key
D. Secondary key
7. Which field listed below is the most appropriate primary key _____?
A. A person's name
B. A person's street address
C. A person's birth date
D. A person's name
8.How many primary keys can a table have _____?
A. One
B. At least one, but not more than two
C. Between 1 and 5
D. One
9.Which of the following is NOT a good primary key _____?
A. Social security number
B. Order number
C. Zip code
D. Social security number
10.Which of the following describes the primary key _____?
A. It must be unique
B. It helps in indexing of a large database
C. It makes sorting quicker
D. It must be unique
11.Which of the following are properties of relations _____?
A. Each attribute has a unique name
B. No two rows in a relation are identical
C. There are no multivalued attributes in a relation
D. Each attribute has a unique name
12.An index can be used to _____?
A. Improve the performance of the database
B. Document the structure of the database itself
C. Reduce data dependency for application programs
D. Improve the performance of the database
13. A person, place, thing, event, or condition about which data is kept in the database is called _____?
A. Attribute
B. Field
C. Record
D. Attribute
14. Consider the following statements regarding relational database model:
A. (a) and (b) are true
B. (a) and (c) are true
C. (b) and (c) are true
D. (a) and (b) are true
15.Which of the following statements is/are True regarding some advantages that an object-oriented DBMS (OODBMS) offers over a relational database?
A. II and III only
B. I and IV only
C. I, II, and III only
D. II and III only
16. Consider the table R with attributes A, B and C. The functional dependencies that hold on R are : A → B, C → AB. Which of the following statements is/are True?
A. Only I
B. Only II
C. Both I and II
D. Only I
17.Consider a hash table of size m = 10000, and the hash function h(K)=floor(m(KAmod1)) for A = (√5 – 1)/2. The key 123456 is mapped to location ...............?
A. 46
B. 41
C. 43
D. 46
18.Consider a hash table of size m = 10000, and the hash function h(K)=floor(m(KAmod1)) for A = (√5 – 1)/2. The key 123456 is mapped to location ...............?
A. 46
B. 41
C. 43
D. 46
19.Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S:
A. I, III and IV are the same query.
B. II, III and IV are the same query.
C. I, II and IV are the same query.
D. I, III and IV are the same query.
20. Four DML commands
A. CREATE, UPDATE, DELETE, SELECT
B. INSERT, UPDATE, DROP, SELECT
C. CREATE, ALTER, DELETE, SELECT
D. CREATE, UPDATE, DELETE, SELECT
21.__________ character is a symbol that can be used as a general substitute for other characters or commands.
A. important
B. wildcard
C. any
D. important
22.Which of the following features is supported in the relational database model?
A. Complex data types
B. Associations with multiplicities
C. Multi-valued attributes
D. Complex data types
23.The links between rows of a master table and those of a nested table are maintained using:
A. pointers
B. foreign keys
C. determinants
D. pointers
24.Which SQL keyword must be used to remove duplicate rows from the result relation ?
A. DELETE
B. UNIQUE
C. NOT EXISTS
D. DELETE
25.Referential integrity controls relationships between:
A. tables in a database
B. instances of a class
C. attributes in a table
D. tables in a database
26.Which of the following is NOT a requirement for a table to be a relation?
A. The sequence of rows and columns cannot be modified.
B. The table must have a primary key.
C. Attributes must contain atomic data.
D. The sequence of rows and columns cannot be modified.
27.A relation containing minimum data redundancy and allowing insertion, deletion, and modification of rows without introducing data inconsistencies is considered to be:
A. generalized
B. well-structured
C. unified
D. generalized
28.Which of the following factors indicates that a table is not well-structured?
A. It contains multiple foreign keys
B. The primary key consists of more than one attribute
C. The data in the table represents more than one entity
D. It contains multiple foreign keys
29.The 'NULL' represents
A. 0
B. blank space
C. absence of any value
D. 0
30.Which SQL keyword is used to sort the result?
A. ORDER
B. SORT-ORDER
C. SORT
D. ORDER
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]