Database Administration Questions


Q:

What are different types of DBMS?

Answer

1. DBMS


2. RDBMS (Relational)


3. ORDBMS (Object Relational)


4. DDBMS (Distributed)


5. FDBMS (Federated)


6. HDDBMS (Homogeneous)


7. HDBMS (Hierarchical)


8. NDBMS (Networked)

Report Error

View answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2598
Q:

The capacity to change the conceptual schema without having to change external schemas or application programs is called

A) Physical Data Independence B) Logical Data Independence
C) Both A and B D) None
 
Answer & Explanation Answer: B) Logical Data Independence

Explanation:

LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 3376
Q:

What is schema?

Answer

The description of a data base is called the database schema , which is specified during database design and is not expected to change frequently . A displayed schema is called schema diagram .We call each object in the schema as schema construct.

Report Error

View answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2795
Q:

Physical data models describe the details of how data is stored in the computers

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

They describe the details of how data is stored in the computers

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2708
Q:

Representation level data models provide the concepts that are close to the way many users perceive data

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

High level data models provide the concepts that are close to the way many users perceive data

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2805
Q:

Database is a collection of concepts that can be used to describe the structure of a database

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

Database provides necessary means to achieve this abstraction. By structure of a database we mean the data types, relations, and constraints that should hold on the data.

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2683
Q:

A subset of the database which contain virtual data that is derived from the database files but is not explicitly stored is called

A) Touple B) View
C) Relation D) Key
 
Answer & Explanation Answer: B) View

Explanation:

A view may be a subset of the database or it may contain virtual data that is derived from the database files but is not explicitly stored .

 

 

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 2730
Q:

What is the difference between routable and non- routable protocols?

Answer

Routable protocols can work with a router and can be used to build large networks. Non-Routable protocols are designed to work on small, local networks and cannot be used with a router

Report Error

View answer Workspace Report Error Discuss

Subject: Networking
Job Role: Database Administration

0 3000