QUESTION 1 What are the components of a data model? Structure, constraints, inde

Question

QUESTION 1

What are the components of a data model?

Structure, constraints, independence

Structure, constraints, operations

Operations, independence, states

Operations, constraints, languages

QUESTION 2

Employee names are stored using a maximum of 50 characters. This information is an example of which of the following?

Meta-data

Data retrieval

Data model

Record instance

2 points   

QUESTION 3

Which of the following best characterizes Physical Data Independence?

The ability to use a Data Manipulation Language (DML)

The ability to change the internal schema without changing the conceptual schema

The ability to change the conceptual schema without having to change the internal schema

The ability to connect directly to a DBMS server

QUESTION 4

Which of the following best characterizes the difference between a centralized and a decentralized DBMS?

A centralized DBMS uses multiple computers with multiple databases, whereas a distributed DBMS uses a single computer with one database.

A centralized DBMS uses a two-tier client-server architecture, whereas a distributed DBMS uses a three-tier client-server architecture.

A centralized DBMS uses a single computer with one database, whereas a distributed DBMS uses multiple computers with multiple databases.

A centralized DBMS uses a three-tier client-server architecture, whereas a distributed DBMS uses a two-tier client-server architecture.

QUESTION 5

Which of the following database functions would be performed using a Data Definition Language (DDL)?

Updating data in a database

Retrieving data from a database

Inserting new data into a database

Creating a new table in a database

QUESTION 6

Which of the following best characterizes Logical Data Independence?

The ability to connect directly to a DBMS server.

The ability to use a Data Manipulation Language (DML).

The ability to change the conceptual schema without changing the external schema

The ability to change the internal schema without having to change the conceptual schema

  

QUESTION 7

A client tells you that they need a database to keep track of employees, vendors, and customers. Which of the following terms best fits the client’s description?

Schema diagrams

Internal schemas

Schema constructs

Database state

  

QUESTION 8

Anthony looks up client information that is stored in his company database. Which of the following DBMS functions did he perform?

Data modification

Data definition

Data loading

Data retrieval

QUESTION 9

Which of the following is NOT an advantage of using the database approach?

Complex relationships can be represented among data

Security measures can be implemented to restrict unauthorized access to data

Integrity constraints can be enforced in the database

Data is repeated with frequency in the database

QUESTION 10

Lorena meets with bank tellers at a local bank to discuss how they will use a DBMS. Which of the following best describes Lorena’s position?

Sophisticated user

System programmer

System analyst

Tool developer

QUESTION 11

Which of the following best characterizes the difference between a two-tier and a three-tier client-server DBMS architecture?

A two-tier architecture uses a single computer with a single database, whereas a three-tier architecture uses a multiple computers with multiple databases.

In a two-tier architecture, the client connects directly to the DBMS server and in a three-tier architecture, the client connects to an intermediate layer to connect to the DBMS server.

In a two-tier architecture, the client connects to an intermediate layer to connect to the DBMS server, and in a three-tier architecture, the client connects directly to the DBMS.

A two-tier architecture uses multiple computers with multiple databases, whereas a three-tier architecture uses a single computer with one database.

QUESTION 12

Which of the following database functions would be performed using a Data Manipulation Language (DML)?

Dropping a table from a database

Shutting down a database

Updating data in a database

Creating a new table in a database

QUESTION 13

Brittany just pulled up a database table with employee information that contains 50 records of employees at her company. Which of the following terms best fits what she sees?

Architecture

Operations

Instances

Schemas

Structure, constraints, independence

Structure, constraints, operations

Operations, independence, states

Operations, constraints, languages

Explanation / Answer

QUESTION 1 - What are the components of a data model? - Structure, constraints, operations

QUESTION 2 - Employee names are stored using a maximum of 50 characters. This information is an example of which of the following? - Data retrieval

QUESTION 3 - Which of the following best characterizes Physical Data Independence? - The ability to change the internal schema without changing the conceptual schema

QUESTION 4 - Which of the following best characterizes the difference between a centralized and a decentralized DBMS? - A centralized DBMS uses a single computer with one database, whereas a distributed DBMS uses multiple computers with multiple databases.

QUESTION 5 - Which of the following database functions would be performed using a Data Definition Language (DDL)? - Creating a new table in a database (via CREATE TABLE command)

QUESTION 6 - Which of the following best characterizes Logical Data Independence? - The ability to change the conceptual schema without changing the external schema

QUESTION 7 - A client tells you that they need a database to keep track of employees, vendors, and customers. Which of the following terms best fits the client’s description? - Schema diagrams

QUESTION 8 - Anthony looks up client information that is stored in his company database. Which of the following DBMS functions did he perform? - Data retrieval

QUESTION 9 - Which of the following is NOT an advantage of using the database approach? - Data is repeated with frequency in the database.

Please let me know in case of any clarifications required. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.