Database Chapter #2

What is physical data independence?

What type of data model describes how data is stored?

When should constructs be enforced in a data model?

What is a self-describing data model?

In Logical Two-Tier Client Server Architecture, which of the following standards are used for database access?

Examples of free relational DBMSs include:

Data Definition Language (DDL) is used by the DBA and database designers to?

What are constraints in a data model?

What is a conceptual data model?

To access the corresponding data from the database server in Three-Tier Client-Server Architecture, you use:

The role of the intermediate layer in Three-Tier Client-Server Architecture is:

What can DML commands (data sublanguage) be embedded in?

Which describes the difference between conceptual, physical, and implementation data models?

What does a database schema include?

What is the main purpose of an implementation data model?

What is another way DML commands can be applied, besides being embedded in a programming language?

What does the Three-Schema Architecture help ALSO support?

What do constructs typically include in a data model?

The intermediate layer (Application Server or Web Server) in Three-Tier Client-Server Architecture stores:

The intermediate layer in Three-Tier Client-Server Architecture is:

In Logical Two-Tier Client Server Architecture, how do applications running on clients access server databases?

What does the Three-Schema Architecture support?

What is true about user connections in a Centralized DBMS?

What is the initial database state?

"certain file structures are reorganized or new indexes are created to improve database performance" is an example of?

Which data model is used by commercial DBMS implementations?

Which of the following DBMSs classifications is typically used for personal computers?

What is a database schema?

What is a database state?

When a lower-level schema changes, ________ need to be changed in a DBMS that supports data independence.

In Logical Two-Tier Client Server Architecture, what type of machines can clients be?

What are operations used for in a data model?

The classification of DBMSs includes:

i do need dua pls

which of the following is the standard for Java programming access to databases?

In Logical Two-Tier Client Server Architecture, what do clients access and utilize through the client software module?

What are operations in a data model?

What is Data Manipulation Language (DML) used for?

Web applications are common in:

In Logical Two-Tier Client Server Architecture, relational DBMS servers are often called which of the following?

What does a data model include?

What is a schema construct?

What is the main characteristic of a physical data model?

What is a valid database state?

Distributed Database Systems are now known as:

In Logical Two-Tier Client Server Architecture, what services do DBMS servers provide to clients?

What is logical data independence?

What does a physical data model provide?

What is another name for a conceptual data model?

What are constructs used for in a data model?

In many DBMSs, what else is DDL used for besides defining the conceptual schema?

In a Centralized DBMS, where is all the processing done?

In Logical Two-Tier Client Server Architecture, how are clients connected to the servers?