Join Us ::

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

GAT Subject :: All Aptitude Test ::

Home » GAT Subject » Aptitude Test - 33
Hassan
1.Domain constraints, functional dependency and referential integrity are special forms of _________.?
A. Foreign key
B. Primary key
C. Assertion
D. Foreign key
2.A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.?
A. Rows
B. Key
C. Attribute
D. Rows
3.Which one of the following attribute can be taken as a primary key ?
A. Name
B. Street
C. Id
D. Name
4.Which one of the following cannot be taken as a primary key ?
A. Id
B. Register number
C. Dept_id
D. Id
5.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
6.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
7.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
8.Row is synonymous with the term:
A. record
B. relation
C. column
D. record
9.The primary key is selected from the:
A. composite keys
B. determinants
C. candidate keys
D. composite keys
10.A relation is considered a:
A. Column
B. one-dimensional table
C. two-dimensional table
D. Column
11.In the relational model, relationships between relations or tables are created by using:
A. composite keys
B. determinants
C. candidate keys
D. composite keys
12.Table is synonymous with the term:
A. record
B. relation
C. column
D. record
13.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.
14.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.
15.An attribute is a(n):
A. column of a table.
B. two dimensional table.
C. row of a table.
D. column of a table.
16.A tuple is a(n):
A. column of a table.
B. two dimensional table.
C. row of a table.
D. column of a table.
17.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
18. Which of the following is a fundamental operation in relational algebra?
A. Set intersection
B. Natural join
C. Assignment
D. Set intersection
19.PredictiveIn a natural join if the two are equivalent in an expression, is said to be?
A. Definitive
B. Predictive
C. Associative
D. Definitive
20.PredictiveIn a natural join if the two are equivalent in an expression, is said to be?
A. Definitive
B. Predictive
C. Associative
D. Definitive
21.The predicate of a selection statement may include comparisons between:
A. Two attributes
B. Multiple attributes
C. Two relations
D. Two attributes
22.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
23.The operation of projection is a:
A. Dimensional operations
B. Multidimensional operations
C. Unary operations
D. Dimensional operations
24.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
25. The relational Algebra is a ____________ Query language.?
A. Structured
B. Procedural
C. Logical
D. Structured
26.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
27.The select, project and rename operations are called____?
A. Binary operations
B. Ternary Operations
C. Unary operations
D. Binary operations
28.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
29.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 (ρ)
30.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
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]