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 - 1
1.A relational database consists of a collection of?
A. Tables
B. Fields
C. Records
D. Tables
2.A in a table represents a relationship among a set of values?
A. Column
B. Key
C. Row
D. Column
3.The term is used to refer to a row?
A. Attribute
B. Tuple
C. Field
D. Attribute
4.The term attribute refers to a which of a table?
A. Record
B. Column
C. Tuple
D. Record
5.For each attribute of a relation, there is a set of permitted values, called the which of that attribute?
A. Domain
B. Relation
C. Set
D. Domain
6.A domain is atomic if elements of the domain are considered to be which units?
A. Different
B. Indivisbile
C. Constant
D. Different
7.The tuples of the relations can be of what order?
A. Any
B. Same
C. Sorted
D. Any
8.Using which language can a user request information from a database?
A. Query
B. Relational
C. Structural
D. Query
9.In this query which attributes form the primary key?
A. Name
B. Dept
C. Tot_cred
D. Name
10.Which one of the following is a procedural language?
A. Domain relational calculus
B. Tuple relational calculus
C. Relational algebra
D. Domain relational calculus
11.The operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple?
A. Select
B. Join
C. Union
D. Select
12.The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match?
A. Join
B. Cartesian product
C. Intersection
D. Join
13.The operation performs a set union of two “similarly structured” tables?
A. Union
B. Join
C. Product
D. Union
14.The most commonly used operation in relational algebra for projecting a set of tuple from a relation is?
A. Join
B. Projection
C. Select
D. Join
15.The operator takes the results of two queries and returns only rows that appear in both result sets?
A. Union
B. Intersect
C. Difference
D. Union
16.A is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys?
A. Schema diagram
B. Relational algebra
C. Database diagram
D. Schema diagram
17.The provides a set of operations that take one or more relations as input and return a relation as an output?
A. Schematic representation
B. Relational algebra
C. Scheme diagram
D. Schematic representation
18.Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
A. DML(Data Manipulation Language)
B. DDL(Data Definition Language)
C. Query
D. DML(Data Manipulation Language)
19.What type of statement is this?
A. DML
B. DDL
C. View
D. DML
20.What type of statement is this?
A. DML
B. DDL
C. View
D. DML
21.The basic data type char(n) is a length character string and varchar(n) is length character?
A. Fixed, equal
B. Equal, variable
C. Fixed, variable
D. Fixed, equal
22.To remove a relation from an SQL database, we use the command?
A. Delete
B. Purge
C. Remove
D. Delete
23.This command performs which of the following action?
A. Remove relation
B. Clear relation entries
C. Delete fields
D. Remove relation
24.What type of statement is this?
A. Query
B. DML
C. Relational
D. Query
25.Updates that violate which are disallowed?
A. Integrity constraints
B. Transaction control
C. Authorization
D. Integrity constraints
26.Which of these query will display the the table given below?
A. Select employee from name
B. Select name
C. Select name from employee
D. Select employee from name
27.Here which of the following displays the unique values of the column?
A. All
B. From
C. Distinct
D. All
28.The query given below will not give an error. Which one of the following has to be replaced to get the desired output?
A. Salary*1.1
B. ID
C. Where
D. Salary*1.1
29.Which clause is used to list the attributes desired in the result of a query?
A. Where
B. Select
C. From
D. Where
30.This Query can be replaced by which one of the following?
A. Select name,course_id from teaches,instructor where instructor_id=course_id;
B. Select name, course_id from instructor natural join teaches;
C. Select name, course_id from instructor;
D. Select name,course_id from teaches,instructor where instructor_id=course_id;
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]