Menu
Popular Courses
Search

MCQs


Total Questions : 18 | Page 1 of 2 pages
Question 1. Which one of the following is a procedural language ?
  1.    Domain relational calculus
  2.    Tuple relational calculus
  3.    Relational algebra
  4.    Query language
 Discuss Question
Answer: Option C. -> Relational algebra


Relational algebraDomain and Tuple relational calculus are non-procedural language.Query language is a method through which the database entries can be accessed.


Question 2. The _______operation performs a set union of two "similarly structured tables
  1.    Union
  2.    Join
  3.    Product
  4.    Intersect
 Discuss Question
Answer: Option A. -> Union


UnionUnion just combines all the values of relations of same attributes.


Question 3. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
  1.    Join
  2.    Projection
  3.    Select
  4.    Union
 Discuss Question
Answer: Option C. -> Select


SelectSelect is used to view the tuples of the relation with or without some constraints.


Question 4. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
  1.    Join
  2.    Cartesian product
  3.    Intersection
  4.    Set difference
 Discuss Question
Answer: Option B. -> Cartesian product


Cartesian productCartesian product is the multiplication of all the values in the attributes.


Question 5. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
  1.    Select
  2.    Join
  3.    Union
  4.    Intersection
 Discuss Question
Answer: Option B. -> Join


JoinJoin finds the common tuple in the relations and combines it.


Question 6. A ________ in a table represents a relationship among a set of values.
  1.    Column
  2.    Key
  3.    Row
  4.    Entry
 Discuss Question
Answer: Option C. -> Row


Column has only one set of values.Keys are constraints and row is one whole set of attributes.Entry is just a piece of data.


Question 7. A relational database consists of a collection of
  1.    Tables
  2.    Fields
  3.    Records
  4.    Keys
 Discuss Question
Answer: Option A. -> Tables


Fields are the column of the relation or tables.Records are each row in relation.Keys are the constraints in a relation .


Question 8. The term _______ is used to refer to a row.
  1.    Attribute
  2.    Tuple
  3.    Field
  4.    Instance
 Discuss Question
Answer: Option B. -> Tuple


TupleTuple is one entry of the relation with several attributes which are fields.


Question 9. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
  1.    Domain
  2.    Relation
  3.    Set
  4.    Schema
 Discuss Question
Answer: Option A. -> Domain


The values of the attribute should be present in the domain.Domain is a set of values permitted .


Question 10. The term attribute refers to a ___________ of a table.
  1.    Record
  2.    Column
  3.    Tuple
  4.    Key
 Discuss Question
Answer: Option B. -> Column


Attribute is a specific domain in the relation which has entries of all tuples.


Share this page with your friends!

Share this page with your friends!

Latest Videos

Chapter 1 - GLOBAL STEEL SCENARIO & INDI Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE 2024
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Chapter 1.1 : INTRODUCTION Chapter 1 : Raw Material Handling Plant GPOE/GPA 2024
Chapter 1.1 : Personnel Functions- An ov Chapter 1 : Personnel Management GFM 2024
Chapter 3.1 : INTRODUCTION Chapter 3 : Sinter Plant GPOE/GPA 2024
Chapter 2.3 : COAL HANDLING PLANT - Set Chapter 2 : Coke Ovens and Coal Chemicals GPOE/GPA 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management GFM 2024