Join Us ::

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

Computer Science :: All Aptitude Test ::

Home » GAT Subject » Computer Science » Aptitude Test - 24
1.Which one of the following cannot be taken as a primary key ?
A. Id
B. Register number
C. Dept_id
D. Id
2.A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .?
A. Candidate
B. Primary
C. Super
D. Candidate
3.The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called?
A. Referential relation
B. Referencing relation
C. Referenced relation
D. Referential relation
4.The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation .?
A. Referential relation
B. Referencing relation
C. Referenced relation
D. Referential relation
5.Row is synonymous with the term:
A. record
B. relation
C. column
D. record
6.The primary key is selected from the:
A. composite keys
B. determinants
C. candidate keys
D. composite keys
7.A relation is considered a:
A. Column
B. one-dimensional table
C. two-dimensional table
D. Column
8.In the relational model, relationships between relations or tables are created by using:
A. composite keys
B. determinants
C. candidate keys
D. composite keys
9.Table is synonymous with the term:
A. record
B. relation
C. column
D. record
10.Which of the following is not a restriction for a table to be a relation?
A. The cells of the table must contain a single value.
B. All of the entries in any column must be of the same kind.
C. The columns must be ordered.
D. The cells of the table must contain a single value.
11.A key:
A. must always be composed of two or more columns.
B. can only be one column.
C. identifies a row.
D. must always be composed of two or more columns.
12.An attribute is a(n):
A. column of a table.
B. two dimensional table.
C. row of a table.
D. column of a table.
13.A tuple is a(n):
A. column of a table.
B. two dimensional table.
C. row of a table.
D. column of a table.
14.Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.?
A. Relational
B. Structural
C. Procedural
D. Relational
15. Which of the following is a fundamental operation in relational algebra?
A. Set intersection
B. Natural join
C. Assignment
D. Set intersection
16.PredictiveIn a natural join if the two are equivalent in an expression, is said to be?
A. Definitive
B. Predictive
C. Associative
D. Definitive
17.PredictiveIn a natural join if the two are equivalent in an expression, is said to be?
A. Definitive
B. Predictive
C. Associative
D. Definitive
18.The predicate of a selection statement may include comparisons between:
A. Two attributes
B. Multiple attributes
C. Two relations
D. Two attributes
19.In the relational algebra, the select, project, and rename operations are known as:
A. Dimensional operations
B. Multidimensional operations
C. Unary operations
D. Dimensional operations
20.The operation of projection is a:
A. Dimensional operations
B. Multidimensional operations
C. Unary operations
D. Dimensional operations
21.The projection that allows extension of operations, i.e. arithmetic and string functions to be used in the projection list, is known as?
A. Embedded Projection
B. Extended Projection
C. Generalized Projection
D. Embedded Projection
22. The relational Algebra is a ____________ Query language.?
A. Structured
B. Procedural
C. Logical
D. Structured
23.Which of the following are the fundamental operations in the Relational Algebra?
A. Select and Project
B. Project and Cartesian product
C. Union and set Difference
D. Select and Project
24.The select, project and rename operations are called____?
A. Binary operations
B. Ternary Operations
C. Unary operations
D. Binary operations
25.Which of the following is the Binary Operations?
A. Set difference, Union, Project
B. Rename, union, Set difference
C. Cartesian product, Set difference and project
D. Set difference, Union, Project
26.The select operation selects tuples that satisfy a given predicate. We use the lowercase______ to denote selection?
A. Greek letter rho (ρ)
B. Greek letter Pi (π)
C. Greek letter sigma (σ)
D. Greek letter rho (ρ)
27.Suppose we want to list all loan numbers and the amount of the loans, but do not care about the branch name. Which of the following operation allows us to produce this relation?
A. Set difference
B. Union
C. Cartesian product
D. Set difference
28. The Binary operation Union, denoted, as in the set theory by:
A. U
B. p
C. σ
D. U
29.If we want to include attributes from two different relations, which of the following operations is needed?
A. Set difference
B. Union
C. Cartesian product
D. Set difference
30. Which of the following operation allows us to find the tuples that are in one relation but are not in another relation?
A. Set difference
B. Union
C. Cartesian product
D. Set difference
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-2025 by Pak-MCQs.net All Rights Reserved.

Email: [email protected]