Join Us ::

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

Technical :: All Aptitude Test ::

Home » Technical » Aptitude Test - 35
Hassan
1.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
2.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
3. 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
4.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
5.Which of the following is NOT a good primary key _____?
A. Social security number
B. Order number
C. Zip code
D. Social security number
6.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
7.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
8.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
9. 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
10. 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
11.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
12. 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
13.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
14.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
15.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.
16. Four DML commands
A. CREATE, UPDATE, DELETE, SELECT
B. INSERT, UPDATE, DROP, SELECT
C. CREATE, ALTER, DELETE, SELECT
D. CREATE, UPDATE, DELETE, SELECT
17.__________ 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
18.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
19.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
20.Which SQL keyword must be used to remove duplicate rows from the result relation ?
A. DELETE
B. UNIQUE
C. NOT EXISTS
D. DELETE
21.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
22.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.
23.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
24.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
25.The 'NULL' represents
A. 0
B. blank space
C. absence of any value
D. 0
26.Which SQL keyword is used to sort the result?
A. ORDER
B. SORT-ORDER
C. SORT
D. ORDER
27.To change the value of a customer’s discount from 3 to 5, what command do we need to use:
A. INSERT
B. SELECT
C. DELETE
D. INSERT
28.The WHERE keyword comes before the condition in a normal Select query. When using the command GROUP BY in the Select query, what keyword is used to start the condition section ?
A. Having
B. Find
C. Order
D. Having
29.Higher normal forms are better than lower normal forms because higher normal forms yield fewer _____________ _______________ in the database.
A. update, delete
B. data storage
C. data redundancies
D. update, delete
30.The 2NF describes the tabular format in which:
A. there are no repeating groups in the table
B. all attributes are dependent on the primary key
C. A & B with no partial dependency
D. there are no repeating groups in the table
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]