Home / Tests / Database Management System Test 2 Online MCQs

Database Management System Test 2 Online MCQs

Test Name	Database Management System Test 2
Subject	Computer
Test Type	MCQs
Total Question	15
Total Marks	30
Total Time	15 Mints
Test Help For	Basic Knowledge about IT IT General Knowledge Quiz Computer History IT & Computer Tests General Ability Competitive Exams.

Database Management System Test 2 Online MCQs

Show paginator

Hide paginator

Computer

1. mark review A heterogeneous distributed database is which of the following?

The same DBMS is used at each location and data are not distributed across all nodes

The same DBMS is used at each location and data are distributed across all nodes

A different DBMS is used at each location and data are distributed across all nodes

A different DBMS is used at each location and data are not distributed across all nodes

Question 1 of 15

2. mark review Which of the following is a problem of life management system?

All of these

Difficult to update

Lack of data independence

Program dependence

Question 2 of 15

3. mark review The active data warehouse architecture includes which of the following?

All of these

Near real-time updates

Data that can extracted from numerous internal and external sources

At least one data mart

Question 3 of 15

4. mark review Which of the following is true of a network structure?

It allows a many-to-many relationship

It will be dominant data base of the future

It is conceptually simple

It is a physical representation

Question 4 of 15

5. mark review Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

Instance entity

Supertype entity

Archetype entity

Subtype entity

Question 5 of 15

6. mark review A star schema has what type of relationship between a dimension and fact table?

All of the above

One-to-one

Many-to-many

One-to-many

Question 6 of 15

7. mark review The function of a database is ……

To output data

To check all spelling

To check all input data

To collect and organize input data

Question 7 of 15

8. mark review Entities of a given type are grouped into a(n).

ERD

Database

Attribute

Entity class

Question 8 of 15

9. mark review The model for a record management system might be

A business form

A Rolodex card file

All of the above

Handwritten list

Question 9 of 15

10. mark review An attribute that names or identifies entity instances is a(n):

Attribute

Relationship

Entity

Identifier

Question 10 of 15

11. mark review A data warehouse is which of the following?

Contains numerous naming conventions and formats

Organized around important subject areas

Contains only current data

Can be updated by end users

Question 11 of 15

12. mark review A snowflake schema is which of the following types of tables?

Helper

All of these

Dimension

Fact

Question 12 of 15

13. mark review In a large DBMS

All of the above

Each user can access every subschema

Each user can “see” only a small part of the entire database

Each subschema contains every field in the logical schema

Question 13 of 15

14. mark review Reconciled data is which of the following?

Current data intended to be the single source for all decision support systems

Data that has been selected and formatted for end-user support application

Data stored in on operational system in the organization

Data stored in the various operational systems throughout the organization

Question 14 of 15

15. mark review Information can be transferred between the DBMS and a

Spreadsheet program

Graphic program

All of the above

Word processor program

Question 15 of 15

Related Post

Exim Bank Of India Management Trainees Recruitment 2023
Management Courses After 12th class in India Best Career…
KVPY Exams 2023 Test Preparation Online Mock Test MCQs
UPC MET 2023 Preparation Online Test Free Mock Test For…
SSC CGL Exams 2023 Test Preparation Online Practice Mock…
CGTET Exams 2023 Test Preparation Online Mock Test MCQs

Test By Subject	Computer Science
Test By Topics	Computer General

Have any Problem or Error please mention in below comments section.

2021-01-16

Test Advisor

Database Management System Test 2 Online MCQs

Database Management System Test 2 Online MCQs

Computer

Leave a Reply Cancel reply