In this type of DBMS architecture, the database is readily available on the client machine, any request made by client doesn’t require a network connection to perform the action on the database.

(a)  

One of the Three-Level DBMS Architecture that is also called view level.

(a)  

Conceptual Schema/Level is also called (a)   where the whole design of the database such as relationship among data, schema of data etc. are described in this level.

To ease the user interaction with database, the developers hide internal irrelevant details from users. This process of hiding irrelevant details from user is called (a)   .

Design of a database is called the (a)   .

The data stored in database at a particular moment of time is called (a)   .

This is the lowest level of data abstraction. It describes how data is actually stored in database. You can get the complex data structure details at this level.

(a)  

Highest level of data abstraction. This level describes the user interaction with database system.

(a)  

A DBMS language that is used for specifying the database schema. It is used for creating tables, schema, indexes, constraints etc. in database.

(a)  

TYPE 'ONE' FOR TRUE AND ZERO FOR FALSE.

RDBMS does not support distributed databases.

(a)  

TYPE 'ONE' FOR TRUE AND ZERO FOR FALSE.

RDBMS supports single user.

(a)  

TYPE 'ONE' FOR TRUE AND ZERO FOR FALSE.

DBMS can establish relationship between files.

TYPE 'ONE' FOR TRUE AND ZERO FOR FALSE.

RDBMS is suitable for large organization.

(a)  

TYPE 'ONE' FOR TRUE AND ZERO FOR FALSE.

In two-tier architecture, the client application communicates with server application and the server application internally communicates with the database system present at the server.

(a)  

TYPE 'ONE' FOR TRUE AND ZERO FOR FALSE.

The conceptual schema hides information about the physical storage structures and focuses on describing data types, entities, relationships, etc.

(a)  

TYPE 'ONE' FOR TRUE AND ZERO FOR FALSE.

The changes in the database that we made using DML commands are either performed or rollbacked using TCL.

(a)  

TYPE 'ONE' FOR TRUE AND ZERO FOR FALSE.

The physical separation of the tiers can affect the performance of the Database.

(a)  

TYPE 'ONE' FOR TRUE AND ZERO FOR FALSE.

With Database Schema, faster migration to new graphical environments is possible.

(a)  

TYPE 'ONE' FOR TRUE AND ZERO FOR FALSE.

One of the goals of 3 level/schema of Database is the user need not to deal directly with physical database storage detail.

(a)  

21-24: Commands under DML

(Make sure your answers are separated with a comma[,])

25-30: Commands under DDL

(Make sure your answers are separated with a comma[,])

31-32: Commands under DCL

(Make sure your answers are separated with a comma[,])

33-34: Commands under TCL

(Make sure your answers are separated with a comma[,])

35-37: Three Levels of Abstraction

(Make sure your answers are separated with a comma[,])

38-40: Three Types of DBMS Architecture

(Make sure your answers are separated with a comma[,])