DatabaseManagementSystems - Study24x7
Social learning Network

Welcome Back

Get a free Account today !

or
databasemanagamentsystems Cover image
databasemanagamentsystems
DatabaseManagementSystems
  • Followers
  • Latest Feeds
  • Articles
  • Question
  • Course
  • About
  • Review
Interests
Databases Microsoft Technologies Web Development Engineering
See more
38 followers study24x7 13 Apr 2021 01:16 PM study24x7 study24x7

The method in which records are physically stored in a specified order according to a key field in each record is

A

Hash

B

Direct

C

Sequential

D

All of the above

study24x7
Write a comment
38 followers study24x7 13 Apr 2021 01:05 PM study24x7 study24x7

A relational database developer refers to a record as

A

A criteria.

B

A relation.

C

A tuple.

D

An attribute.

study24x7
Write a comment
38 followers study24x7 13 Apr 2021 01:03 PM study24x7 study24x7

 The property / properties of a database is / are :

A

It is an integrated collection of logically related records.

B

It consolidates separate files into a common pool of data records.

C

Data stored in a database is independent of the application programs using it

D

All of the above

study24x7
Write a comment
38 followers study24x7 13 Apr 2021 01:00 PM study24x7 study24x7

 The way a particular application views the data from the database that the application uses is a

A

Module.

B

Relational model.

C

Schema.

D

Sub schema.

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:49 PM study24x7 study24x7

Why is MySQL called RDBMS?

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:49 PM study24x7 study24x7

How does an RDBMS work?

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:48 PM study24x7 study24x7

What is the difference between oracle, SQL and RDBMS?

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:48 PM study24x7 study24x7

What is the difference between RDBMS and SQL?

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:47 PM study24x7 study24x7

What is the best way to teach RDBMS to beginners?

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:46 PM study24x7 study24x7

How can I start learning about RDBMS or SQL?

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:45 PM study24x7 study24x7

What are the various data abstraction levels?

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:45 PM study24x7 study24x7

Have you ever used a Stored procedure (SP) in RDBMS?

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:45 PM study24x7 study24x7

How will you define a relational database model?

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:44 PM study24x7 study24x7

What are different Codd’s 12 rules for Relational Database?

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:37 PM study24x7 study24x7

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

Union

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:36 PM study24x7 study24x7

The _______operation performs a set union of two “similarly structured” tables

A

Union

B

Join

C

Product

D

Intersect

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:35 PM study24x7 study24x7

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match is?

A

 Join

B

Cartesian product

C

Intersection

D

Set difference

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:34 PM study24x7 study24x7

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

Intersection

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:33 PM study24x7 study24x7

Which one of the following is procedural language?

A

Domain relational calculus

B

Tuple relational calculus

C

Relational algebra

D

 Query language

study24x7
Write a comment
38 followers study24x7 02 Apr 2021 06:28 PM study24x7 study24x7

Student(ID, name, dept name, tot_cred) In this query which attribute form the primary key?

A

Name

B

Dept

C

Tot_cred

D

ID

study24x7
Write a comment
About

This page will help you clear your database management systems (DBMS) concepts. We post various MCQs on a daily basis to let you become an expert in this subject
See More

Ratings
5.0
out of 5
1 Ratings
5 study24x7
 
1.0
4 study24x7
 
0.0
3 study24x7
 
0.0
2 study24x7
 
0.0
1 study24x7
 
0.0
Related Pages

General Knowledge An..

1905 followers

GOVERNMENT JOB NOTIF..

1745 followers

RAU IAS COACHING

1644 followers

SSC 2021 Preparation..

1558 followers

UPSC Civil Services ..

1532 followers

Study24x7

1133 followers

Abhiyan Civil Servic..

1037 followers

Maths By Uttam Sir

784 followers

Results Alert

752 followers

Learn Advance REASON..

608 followers

Pavitra Language Poi..

601 followers

English Scholar

487 followers

Hansraj Academy

434 followers

Astronomy

335 followers

KBC Q And A

81 followers

BANKING UPDATE 2020

42 followers

Web Technology

23 followers