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 clients 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 Lorenas 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