DatabaseManagementSystems - Study24x7
Social learning Network

Warning: include(./views/auth.php): failed to open stream: Permission denied in /var/www/html/live/loginRightSlider.php on line 18

Warning: include(): Failed opening './views/auth.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/live/loginRightSlider.php on line 18
databasemanagamentsystems Cover image
databasemanagamentsystems
DatabaseManagementSystems

  • Warning: Use of undefined constant Followers - assumed 'Followers' (this will throw an Error in a future version of PHP) in /var/www/html/live/makepage.php on line 1760
    Followers
  • Latest Feeds
  • Articles
  • Question
  • Course
  • About
  • Review
Interests
Databases Microsoft Technologies Web Development IIT-JEE
See more
Articles
Question
Course
About
Review
Gallery
DatabaseManagementSystems
45 followers study24x7 01 Jan 1970 05:30 AM 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

Databases Microsoft Technologies IIT-JEE
Like | 1 Comment Share
study24x7
Write a comment
DatabaseManagementSystems
45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

A relational database developer refers to a record as

A

A criteria.

B

A relation.

C

A tuple.

D

An attribute.

Databases Microsoft Technologies IIT-JEE
Like | 1 Comment Share
study24x7
Write a comment
DatabaseManagementSystems
45 followers study24x7 01 Jan 1970 05:30 AM 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

Databases Microsoft Technologies IIT-JEE
Like Comment Share
study24x7
Write a comment
DatabaseManagementSystems
45 followers study24x7 01 Jan 1970 05:30 AM 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.

Databases Microsoft Technologies IIT-JEE
Like Comment Share
study24x7
Write a comment
DatabaseManagementSystems
45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

Why is MySQL called RDBMS?

Databases Web Development IIT-JEE
Like | 1 Comment | 1 Share
study24x7
Write a comment
  • Serge
    • is a program used to maintain a relational database.
    Like
    Reply 01 Jan 1970 05:30 AM
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

    How does an RDBMS work?

    Databases Web Development IIT-JEE
    Like | 1 Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

    What is the difference between oracle, SQL and RDBMS?

    Databases Web Development IIT-JEE
    Like Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

    What is the difference between RDBMS and SQL?

    Databases Web Development IIT-JEE
    Like Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

    What is the best way to teach RDBMS to beginners?

    Databases Web Development IIT-JEE
    Like Comment Share | 1
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

    How can I start learning about RDBMS or SQL?

    Databases Web Development IIT-JEE
    Like Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

    What are the various data abstraction levels?

    Databases Web Development IIT-JEE
    Like Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

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

    Databases Web Development IIT-JEE
    Like Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

    How will you define a relational database model?

    Databases Web Development IIT-JEE
    Like Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

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

    Databases Web Development IIT-JEE
    Like Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM 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

    Databases Web Development IIT-JEE
    Like Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

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

    A

    Union

    B

    Join

    C

    Product

    D

    Intersect

    Databases Web Development IIT-JEE
    Like | 1 Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM 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

    Databases Web Development IIT-JEE
    Like Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM 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

    Databases Web Development IIT-JEE
    Like | 1 Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

    Which one of the following is procedural language?

    A

    Domain relational calculus

    B

    Tuple relational calculus

    C

    Relational algebra

    D

     Query language

    Databases Web Development IIT-JEE
    Like Comment Share
    study24x7
    Write a comment
    DatabaseManagementSystems
    45 followers study24x7 01 Jan 1970 05:30 AM 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

    Databases Web Development IIT-JEE
    Like Comment Share
    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
    ❮ ❯