Monday, March 14, 2016

Relational Model Questions and Answers

Relational Database Model Questions and Answers, MCQs, Quiz No. 51:  Computer GK Sample Question Paper as part of Computer GK Sample Papers.This Sample paper will also help candidates in Competitive Exams, PSU Exam, State Govt & Central Govt. Examinations held each years. Computer GK Questions which you can access from our Free Mobile App of "COMPUTER GK" from Link: DOWNLOAD COMPUTER GK Mobile App . Here is sample Question paper as part of Computer GK Questions for upcoming examinations. 
For "Computer GK" you can Download "Computer GK" Mobile App: https://play.google.com/store/apps/details?id=com.csurender.computer

Relational Database Model Questions and Answers, MCQs, Quiz No. 51
A relational database consists of a collection of
A. Tables
B. Fields
C. Records
D. Keys
Answer: A

A ________ in a table represents a relationship among a set of values.
A. Column
B. Key
C. Row
D. Entry
Answer: C

The different classes of relations created by the technique for preventing modification anomalies are called:
A. normal forms.
B. referential integrity constraints.
C. functional dependencies.
D. None of the above is correct.
Answer: A

The format or data type must be specified for
A. table ender
B. entity domain
C. range
D. domain
Answer: D

In the relational modes, cardinality is termed as:
A. Number of tuples.
B. Number of attributes.
C. Number of tables.
D. Number of constraints.
Answer: A

Relational calculus is a
A. Procedural language.
B. Non- Procedural language.
C. Data definition language.
D. High level language.
Answer: B

The view of total database content is
A. Conceptual view.
B. Internal view.
C. External view.
D. Physical View.
Answer: A

Cartesian product in relational algebra is
A. a Unary operator.
B. a Binary operator.
C. a Ternary operator.
D. not defined.
Answer: B

DML is provided for
A. Description of logical structure of database.
B. Addition of new structures in the database system.
C. Manipulation & processing of database.
D. Definition of physical structure of database system.
Answer: C

‘AS’ clause is used in SQL for
A. Selection operation.
B. Rename operation.
C. Join operation.
D. Projection operation.
Answer: B

2 comments:

  1. The Assam Higher Secondary Education Council was established on 1st June,1984.Assam Higher Secondary Education Council or AHSEC is renowned board for 10+2 education in north-eastern India. The AHSEC have its head Office at AHSEC HS Question Paper 2023 Bamunimaidam, Guwahati. It regulate, supervise and develop Higher Secondary Education in the state of Assam.

    ReplyDelete
  2. Madhya Pradesh Board Conducts All 6th, 7th, 8th, 9th, 10th Public Exams in Kerala, This Kerala High School Level Exam Attended Every Year More than 40 Laks of Students, Students Studying MP 6th, 7th, 8th, 9th, 10th Class Revised Syllabus 2023 helps Students to Learn Logic and order and hence, MP Board 10th Class Syllabus MP Board 6th, 7th, 8th, 9th, 10th Class Syllabus 2023 is Designed in Accordance with the NCERT Based Guidelines and helps Students to get an Overview of the Hindi, English Medium All Subject, MPBSE keeps a 6th, 7th, 8th, 9th, 10th Class Exam Pattern with the aim to Provide a Quality Education for All Students, On the basis of the Current Educational Demands.

    ReplyDelete