Database Management Midterm

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

a

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

b

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

b

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

c

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

c

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

d

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

d

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

true

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

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

a

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

a

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

a

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

a

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

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

a

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

a

The options below are examples of databases except? a. recycle database b. workgroup database c. distribution database d. centralized database

a

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

a

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

a

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

a

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

a

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

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

a

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

a

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

a

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

b

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

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

b

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

b

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

b

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

b

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

b

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

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

b

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

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

b

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

b

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

b

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

b

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

b

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

b

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

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

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

c

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

c

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

c

Consider the STUDENT table given below: CODE NAME. GPA YEAR 291 ALEX 3.1 2 938 MICHELE 2.3 1 931 JHON 3.3 1 182 JOE 3.4 2 190 REY 2.0 2 330 RON 3.9 3 What is the result from the query below? SELECT MAX(GPA) FROM STUDENT WHERE STUDENT.YEAR = 2 a. 3 b. 3.3 c. 3.4 d. 3.9

c

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

c

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

c

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

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

c

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]

c

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

c

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

c

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

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

c

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

c

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

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

c

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.

c

Which statement about primary keys is true? 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)

c

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

d

Below are some rows of the PROVIDERS table for a factory: PCODE. NAME. PHONE 10192. Hans, Inc. 231 - 3092 98411. Tools and More. 231 - 1029 0489035. Motors Inc. 993 - 1821 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%'

d

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

d

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.

d

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

d

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

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

d

The DBMS may be referred to as the database system's ___? a. brain b. memory c. spine d. heart

d

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

d

The database structure is stored as a __? a. collection of metadata b. a single file c. unlinked files d. collection of files

d

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

d

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

d

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

d

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

true