Relational Database Model Quiz, MCQs

Relational Database Model Questions and Answers, MCQs, Quiz No. 52:  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. 52: 

ODBC stands for
A. Object Database Connectivity.
B. Oral Database Connectivity.
C. Oracle Database Connectivity.
D. Open Database Connectivity.
Answer: D

Architecture of the database can be viewed as
A. two levels.
B. four levels.
C. three levels.
D. one level.
Answer: C

A relation in this form is free of all modification anomalies.
A. First normal form
B. Second normal form
C. Third normal form
D. Domain/key normal form
Answer: D

A tuple is a(n):
A. column of a table.
B. two dimensional table.
C. row of a table.
D. key of a table.
Answer: C

In a relational model, relations are termed as
A. Tuples.
B. Attributes
C. Tables.
D. Rows.
Answer: C

The database schema is written in
A. HLL
B. DML
C. DDL
D. DCL
Answer: C

The term _______ is used to refer to a row.
A. Attribute
B. Tuple
C. Field
D. Instance
Answer: B

A domain is atomic if elements of the domain are considered to be ____________ units.
A. Different
B. Indivisbile
C. Constant
D. Divisible
Answer: B

The tuples of the relations can be of ________ order.
A. Any
B. Same
C. Sorted
D. Constant
Answer: A

Download "Computer GK" Free Mobile App: https://play.google.com/store/apps/details?id=com.csurender.computer

Read More

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

Download "Computer GK" Free Mobile App: https://play.google.com/store/apps/details?id=com.csurender.computer

Read More

Data Abstraction MCQs, Questions in DMBS

DMBS Data Abstraction MCQs, Objective Questions with Answers:

Which among the following is NOT Valid level of data abstraction in DMBS ?

A. Physical Level

B. Remote Level

C. Logical Level

D. View Level

Answer: B

How many levels of abstraction in DBMS ?

A. 2

B. 3

C. 4

D. 5

Answer: C

The type data abstraction which allows the conceptual representation of data in database management system is considered as

A. logical design model

B. data model

C. interface model

D. user friendly model

Answer: B

Which is the transformation of requests and results between different levels of abstraction:

A. Evaluation

B. Mapping

C. Compiler

D. Precompiler

Answer: B

Considering abstraction concepts, the process of assigning the similar entities to similar entity types systematically is called

A. classification

B. instantiation

C. identification

D. exception abstract

Answer: A

Which provides precise partition between abstract characteristics of the data type and its implementation specifications:

A. Data

B. Data item

C. File

D. Data abstraction

Answer: D

The identification, aggregation and instantiation are abstraction concepts used in

A. intension and extension models

B. classes and nodes models

C. concrete models

D. semantic data models

Answer: D

The process of abstraction in which the objects and classes are identified with some kind of identifier is classified as

A. classification

B. instantiation

C. identification

D. exception abstract

Answer: C

Which services are insulated by abstraction from the fundamental physical data:

A. DDL

B. ODBC

C. SOA

D. ADSL

Answer: C

Read More

Normalization Primitive and Composite data Types

Normalization Primitive and Composite data Types: Normally in basic database we use numbers and strings as common datatype which is primitive datatypes while complex datatype are called composite data type in simple word. 

Primitive datatypes are the basic units of a language; each primitive value contains a single datum (as opposed to an array of multiple items) and describes that datum literally. Primitive data is very straightforward. Primitive datatypes are, as their name suggests, simple. They can hold text messages, frame numbers, movie clip size values, and so on, but they don't readily accommodate higher levels of complexity.

Examples: Number, string, boolean, undefined, and null. 

Composite data Types are complex data type. For more elaborate data handling -- such as simulating the physics of a dozen bouncing balls or managing a quiz with 500 questions and answers -- we turn to composite datatypes. Using composite data, we can manage multiple pieces of related data as a single datum. Whereas a single number is a primitive datum, a list (i.e., an array) of multiple numbers is a composite datum. 

Examples: Suppose we wanted to track the profile of a customer named Derek. We could create a series of variables that store Derek's attributes as primitive values, like this:

Read More

Conceptual Database Design Questions

Conceptual Database Design, ER Diagram Questions, MCQs: Conceptual database design involves modelling the collected information at a high-level of abstraction without using a particular data model or DBMS.

Need of Conceptual Database Design:

• Independent of DBMS.
• Allows for easy communication between end-users and developers.
• Has a clear method to convert from high-level model to relational model.
• Conceptual schema is a permanent description of the database requirements.
• ER Diagram is Most popular conceptual model for database design.

Entity Relationship (ER) Model:

• Most popular conceptual model for database design
• Basis for many other models
• Describes the data in a system and how that data is related
• Describes data as entities, attributes and relationships

Conceptual Database Design, ER Diagram Questions, MCQs: 

Normalization is --------- database design technique ?

A. Bottom Up approach

B. Top down Approach

C. Both A&B

D. None of above

Answer: A

An entity which depends on other entity for its existence is a ------ ?

A. Strong Entity

B. Weak entity

C. Partial Entity

D. Dummy Entity ?

Answer: B

Attribute in ER Diagram can be ?

A. Composite

B. Multivalued

C. Null

D. All of above

Answer: D

In an E-R diagram attributes are represented by
A. rectangle
B. square
C. ellipse
D. triangle
Answer: C

In an E-R diagram an entity set is represent by a
A. rectangle
B. ellipse
C. diamond box
D. circle
Answer: A

If an attribute can be split into components, it is called a ------ attribute ?

A. Single

B. Multi-valued

C. composite

D. None of above

Answer: C

Which among the following is valid Cardinality of a Relationship ?

A. One to one (1:1) relationship

B. One to many (1:N) relationship

C. Many to many (M:N) relationship

D. All of above

Answer: D

Read More

Computer GK Sample Paper 50

Computer GK Sample Question Paper No. 50:  Computer GK Sample Question Paper as part of Computer GK Sample Papers based on RPSC Analyst Cum Programmer (ACP) / Dy Director Examination 2011 (Paper-1).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

Computer GK Sample Question Paper No. 50: 

What is big size of IPv6 addresses?
A. 16 bits
B. 32 bits
C. 64 bits
D. 128 bits
Answer: D

Full form of MAC Address?
A. Machine Access Coding Address
B. Mode Access Control Address
C. Master Access Code Address
D. Media Access Control Address
Answer: D

How many layers does OSI network architecture has?
A. Five
B. Eight
C. Seven
D. Six
Answer: C

DNS is the abbreviation of -
A. Dynamic Name System
B. Domain Network Service
C. Domain Name System
D. Dynamic Network Service
Answer: C

Primary function of the network layer is?
A. Error detection
B. Routing
C. Setup a session
D. Encryption
Answer: B

Layer-1 of the OSI model is?
A. Link Layer
B. Physical Layer
C. Presentation Layer
D. Session Layer
Answer: B

What is a Firewall in the Computer Network?
A. The Operating System of Computer Network
B. The Physical boundary of the Network
C. A system designed to prevent unauthorised access
D. A web browsing Software
Answer: C

IPv4 address is?
A. 8 bits
B. 16 bits
C. 32 bits
D. 64 bits
Answer: C

DHCP is the abbreviation of -
1. Dynamic Host Control Protocol
2. Dynamic Hyper Configuration Protocol
3. Dynamic Hyper Control Protocol
4. Dynamic Host Configuration Protocol
Answer: D

What does WINS stand for?
A. Windows Internet Name Standard
B. Windows Internal Name Service
C. Windows Internet Name Service
D. Windows Internal Name Standard
Answer: C

Download "Computer GK" Free Mobile App: https://play.google.com/store/apps/details?id=com.csurender.computer

Read More

e-mail inventor Ray Tomlinson passes away at 74

Ray Tomlinson, the inventor of email and the man who picked the @ symbol for addresses, passed away at the age of 74 in Washington on 6th March 2016. Tomlinson invented direct electronic messages between users on different machines on a certain network in 1971. Before that, users could only write messages to others using the same computer. 

Read More