Database Management

d. determinant

Any attribute whose value determines other values within a row is known as a(n) _____. a. entity b. primary key c. surrogate d. determinant

a. 2NF

From a structural point of view, 3NF is better than _____. a. 2NF b. 3NF c. 5NF d. 6NF

a. Relational

SQL is used to interact with what kind of database? a. Relational b. Hierarchical c. Object-oriented d. Document

d. database system

The term _____ refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment. a. structured data b. transaction c. management system d. database system

a. views

Unnormalized tables yield no simple strategies for creating virtual tables known as _____. a. views b. attributes c. entities d. keys

b.SELECT

What SQL command do you use to query a database? a.WHERE b.SELECT c.FROM d.SET

c. SELECT

What sort of statement retrieves data in a SQL code? a. Retrieve b. READ c. SELECT d. GET

a. data integrity

What would you define as the condition in which all of the data in the database are consistent with the real-world events and conditions? a. data integrity b. data anomaly c. data ubiquity d. data quality

d. constraint

When creating a student roster, a school cannot enroll more than 20 students per course. This is an example of what data modeling building block? a. attribute b. entity c. relationship d. constraint

c. Internet

Which of the answers below is not consider as one of the five (5) major parts of the database system? a. Procedure b. Software c. Internet d. Data

c. They can serve as a communication tool between the users and designers.

Which of the following is true of business rules? a. They allow the designer to set company policies with regard to data. b. They allow the designer to develop business processes. c. They can serve as a communication tool between the users and designers. d. They provide a framework for the company's self-actualization.

a. two-to-one

Which of these is NOT a type of relationship in a relational database? a. two-to-one b. many-to-one c. many-to-many d. one-to-many

c. both A & C

Which statement about primary keys is true? a. a primary key value is required for every table. (B) b. Primary keys can be made up of one or more columns. (C) c. both A & C d. Primary key values must be unique. (A)

b. iterative

An ERD is created through which of the following processes? a. prescriptive b. iterative c. random d. conclusive

c.COUNT

Which function determines the number of rows in a table? a.ROW b.CALCULATE c.COUNT d.NUMBER

a. Desktop database

Which of the answers below is an example of a single-user database? a. Desktop database b. Workgroup database c. Office database d. Enterprise database

a. It improves the ability to understand the nature, role, and scope of data.

A new database designer is struggling with the process of identifying and documenting business rules. They are considering skipping this part of the process and moving forward. If you were their mentor, which statement would show the importance of this step to the new designer? a. It improves the ability to understand the nature, role, and scope of data. b. It helps to standardize the view of the company's data. c. It identifies management problems within the company. d. It makes it easy to recognize the data contained in an attribute.

a. entity

A noun in a business rule translates to a(n) _____ in the data model. a. entity b. attribute c. relationship d. constraint

c. relationship

A verb associating two nouns in a business rule translates to a(n) _____ in the data model. a. entity b. attribute c. relationship d. constraint

c. the primary key

According to a standard data-modeling checklist, the non-key entities in an entity-relationship (ER) data model must be fully dependent on _____. a. passive verbs b. the entity instance c. the primary key d. constraints

d. SELECT * FROM PROVIDERS WHERE PHONE LIKE '231%'

All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? a. SELECT * FROM PROVIDERS WHERE PHONE LIKE '___ 231 ___' b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' c. SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%' d. SELECT * FROM PROVIDERS WHERE PHONE LIKE '231%'

c. Systems development.

As a database architect, you usually explain that applications transform data into the information that forms the basis for decision making within the framework of __. a. Systems analysis b. Database analysis c. Systems development d. Information system

b. Map

As a database designer, the first step that you would take in creating the logical design is to ___ the conceptual model. a. Split b. Map c. Adopt d. Approve

b. Designing the database

As a database designer, which of the options below would you not include in the implementation phase of a database design? a.Loading data into the database b. Designing the database c.Creating the database storage structure d.Providing for data management

c. constraints

Business rules that are properly written will define entities, attributes, relationships, and _____. a. fields b. objects c. constraints d. classes

d. 1:M

Business rules use simple language to establish definitions of entities, attributes, relationships, and constraints. For instance, a business rule establishing that entities can have multiple attributes, and that each available attribute may be associated with only one entity, might be stated as "An employee may be assigned multiple devices" and "Each device may be assigned to only one employee". Classify the relationship between EMPLOYEES and DEVICES in this example using shorthand notation. a. 1..1 b. *..* c. M:N d. 1:M

b. be rendered in writing

Complete the following statement: Business rules must ______. a. be based only on end user perceptions b. be rendered in writing c. include constraints d. represent many-to-many (M:N) relationships

True

Dependency diagrams are very helpful in getting a bird's-eye view of all the relationships among a table's attributes. True False

d. Each CONTAINER contains between 0 and 100 UNITs.

Determine which of the following simple-language expressions represents a valid constraint. a. EMPLOYEE manages STORE b. CUSTOMER generates INVOICE c. STUDENT takes CLASS d. Each CONTAINER contains between 0 and 100 UNITs.

b. analysis

Discovery of user requirements, existing system evaluation, and logical system design are part of the _____ phase of the Systems Development Life Cycle (SDLC). a. planning b. analysis c. detailed systems design d. implementation

d. Limitations

For Jared, a database consultant, to avoid false expectations, he must make the end user aware of the ___ of both the DBMS and the database. a. Advantages b. Profitability c. Benefits d. Limitations

c. database administrator

In a situation whereby the data has been loaded into the database, John, the _____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints. a. programmer b. manager c. database administrator d. systems administrator

b. dependency

In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies. a. Chen b. dependency c. functionality d. ER

d. data redundancies

In exchange for possible reductions in performance, what unwanted element does normalization reduce? a. reporting requirements b. business rules c. functional dependencies d. data redundancies

d. normalization

In order for you to yield a useful ERD, you must combine ER modeling with which of the following entities? a. design process b. denormalization c. granularity d. normalization

c.* symbol

In the SELECT clause, you can indicate that you want to include all columns using the _____. a.\ symbol b./ symbol c.* symbol d.? symbol

True

In the context of partial dependencies, data redundancies occur because every row entry requires the duplication of data. True False

a. Data

Information is produced by processing _____. a. Data b. Information c. Scripts d. Context

c. CLIENT_ADDRESS

Jaiden is in the translation of business rules to data model components. How should he label the address attribute for an entity named CLIENT? a. ADDRESS b. CLADD c. CLIENT_ADDRESS d. BILLING_ADDRESS

b. DBMS features and tools

Jerry is a stakeholder in ABC company, he is considering ___ as one of the factors that will affect ABC company's purchasing decision of a DBMS, the items that he should consider include: some database software's variety of tools that facilitate application development. a. DBMS hardware requirements b. DBMS features and tools c. The original purchase price d. Underlying model

a. Data about data

Metadata is ___? a. Data about data b. Raw data c. Refined data d. Filtered data

b. three

Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process. a. two b. three c. four d. five

b. Database systems enable the data in the database to be shared among multiple applications or users.

One of the advantages of database systems is that ___ a. Database systems do not integrate many different users' data into a single all-encompassing data repository. b. Database systems enable the data in the database to be shared among multiple applications or users. c. Database systems maximizes data inconsistency d. Database systems decreases end user productivity

c. unnormalized

Raw data in its original state that has data anomalies such as redundant or multivalued data is _____ data. a. consistent b. normalized c. unnormalized d. relational

c. entity

Sally's Dog Grooming Salon is creating a database of every dog she grooms. She wants to collect specific information about the breed, height, weight, and age of each dog. What building block does "dog" represent in her data model? a. attribute b. relationship c. entity d. class

a. database design

Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC). a. database design b. database initial study c. implementation and loading d. testing and evaluation

a. ORDER BY

Sorting records returned by a SELECT statement is done with a _____ clause a. ORDER BY b. SORT ON c. ASCENDING d. GROUP BY

c. [schema name].[table name]

Standard two-part naming in SQL Server follows which convention? a. [server name].[table name] b. [database name].[schema name] c. [schema name].[table name] d. [server name].[database name]

d. Five

The Systems Development Life Cycle (SDLC) is divided into __ phases. a. Four b. Two c. Six d. Five

d. Collection of files

The database structure itself is stored as a __? a. Collection of metadata b. A single file c. Unlinked files d. Collection of files

b. Conceptual design

The first stage in the database design process is __? a. Physical design b. Conceptual design c. Logical design d. Linear design

a. Data analysis and requirements

The first step of the conceptual design is __? a. Data analysis and requirements b. Distributed database design c. Entity relationship modeling and normalization d. Data model verification

d. installing the DBMS

The implementation and loading phase of the Database Life Cycle (DBLC) involves _____. a. defining objectives b. introducing changes c. testing the database d. installing the DBMS

b. analysis

The logical systems design is created during the _____ phase of the Systems Development Life Cycle (SDLC). a. planning b. analysis c. implementation d. maintenance

b. data anomalies

The main goal of normalization is to eliminate _____. . a. dependencies b. data anomalies c. repeating group d. nonkey attributes

a. Recycle database

The options below are examples of databases except? a. Recycle database b. Workgroup database c. Distribution database d. Centralized database

b. logical design

The term _____ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS. a. internal schema b. logical design c. external model d. physical independence

a. Data

The term database system refers to an organization of components that define and regulate the collection, storage, management, and use of ___ within a database environment. a. Data b. Information c. Filters d. Queries

d. accomplish all of these goals

What does normalization help you do? a. reduce redundancy b. improve integrity c. organize tables d. accomplish all of these goals

b. Insert new rows into a table

What does the INSERT statement do? a. Fetch data from a database b. Insert new rows into a table c. Insert new columns into a table d. Insert a new table into a database

c. A value that represents missing or unknown data

What is a NULL value? a. An outdated value b. A known value c. A value that represents missing or unknown data d. A numerical value

d. 1

What is acceptable data for a column declared as a BIT and NOT NULL? a. yes b. 5 c. 3.14 d. 1

c. partial dependency

What type of dependency is shown during normalization, if the conversion to the second normal form involves removing all attributes dependent on only a part of a composite primary key? a. functional dependency b. transitive dependency c. partial dependency d. primary key dependency

c. Cloud database

When a database offers all the advantages of a local DBMS and resides on the internet, it is referred to as a(n) _____ database. a. In-memory database b. Big Data database c. Cloud database d. Very large database

a. In-memory database

When a database stores the majority of data in RAM rather than in hard disks, it is referred to as a(n) _____ database. a. In-memory database b. Big Data database c. Cloud database d. Very large database

b. verify

When identifying and documenting business rules, it is important to recognize that despite being crucial contributors to the development of business rules, it pays to _____ the end-user's perceptions of business operations. a. ignore b. verify c. describe d. prioritize

d. <>

Which comparison operator indicates a value is not equal? a. < b. <= c. >= d. <>

a. A spreadsheet allows for the manipulation of data in a tabular format

Which of the answers below is not one of the reasons a spreadsheet is not considered a database? a. A spreadsheet allows for the manipulation of data in a tabular format b. A spreadsheet does not support self-documentation through metadata c. A Spreadsheet does not support enforcement of data types or domains d. A Spreadsheet does not support defined relationships among tables

c. Improved data sharing

Which of the answers below is one of the advantages provided by the Database management system (DBMS)? a. Decreased end-user productivity b. Maximized data inconsistency c. Improved data sharing d. Less data integration

Which of the following is a hardware-induced database failure? a. Memory chip errors

Which of the following is a hardware-induced database failure? a. Memory chip errors b. Viruses c. Malware d. Abortion due to deadlock

b. User management

Which of the following is not a function of a DBMS? a. Data presentation management b. User management c. Data storage management d. Security management

b. a clearly defined area within a real-world environment that will be systematically addressed

Within the database environment, a data model represents data structures and their attributes, relations, constraints, and transformations with the purpose of supporting a specific problem domain. Define "problem domain" in the context of data models. a. a blueprint containing all necessary instructions for building a database that will meet all end-user requirements b. a clearly defined area within a real-world environment that will be systematically addressed c. a relatively simple and usually graphical representation of complex real-world objects or events d. the process of creating a specific data model for a particular set of real-world data to be addressed

b. logical design

You are designing a conceptual model and are in the process of matching the DBMS requirements to the entity-relationship diagram (ERD) to create a data model that is software-independent. Which stage of the design phase are you doing? a. internal schema b. logical design c. external model d. physical independence

c. Systems analysis

__ is the process that establishes the need for an information system and its extent. a. Information system b. Database development c. Systems analysis d. Systems development