Conceptual Quiz

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

* symbol

What is acceptable data for a column declared as a BIT and NOT NULL? Question 15 yes 5 3.14 1

1

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. 1..1 *..* M:N 1:M

1:M

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

2NF

Which comparison operator indicates a value is not equal? < <= >= <>

<>

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

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

What is a NULL value? Question 14Select one:a. An outdated value A known value A value that represents missing or unknown data A numerical value

A value that represents missing or unknown data

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

Analysis

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

Analysis

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

CLIENT_ADDRESS

Which function determines the number of rows in a table? ROW CALCULATE COUNT NUMBER

COUNT

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

Cloud Database

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

Collection of Files

The first stage in the database design process is __? Physical design Conceptual design Logical design Linear design

Conceptual Design

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. DBMS hardware requirements DBMS features and tools The original purchase price Underlying model

DBMS Features and Tools

Information is produced by processing _____. Data Information Scripts Context

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. Data Information Filters Queries

Data

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

Data Anomalies

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

Data Redundancies

Metadata is? Data about Data Raw Data Refined Data Filtered Data

Data about Data

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

Data analysis and requirements

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? Data integrity Data anomaly Data ubiquity Data quality

Data integrity

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

Database Design

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

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

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

Designing the database

Which of the answers below is an example of a single-user database? Desktop Database Workgroup Database Office Database Enterprise Database

Desktop Database

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

Determinant

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

Each CONTAINER contains between 0 and 100 UNITs.

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

Five

The DBMS may be referred to as the database system's ___? Brain Memory Spine Heart

Heart

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

Improved data sharing

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

In-memory database

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

Insert new rows into a table

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

Installing the DBMS

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

Internet

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? It improves the ability to understand the nature, role, and scope of data. It helps to standardize the view of the company's data. It identifies management problems within the company. It makes it easy to recognize the data contained in an attribute.

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

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. Advantages Profitability Benefits Limitations

Limitations

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

Map

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

Memory chip errors

Sorting records returned by a SELECT statement is done with a _____ clause ORDER BY Correct SORT ON ASCENDING GROUP BY

ORDER BY

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? functional dependency transitive dependency partial dependency primary key dependency

Partial Dependency

The options below are examples of databases except? Recycle database Workgroup database Distribution database Centralized database

Recycle database

SQL is used to interact with what kind of database? Relational Correct Hierarchical Object-oriented Document

Relational

What SQL command do you use to query a database? WHERE SELECT FROM SET

SELECT

What sort of statement retrieves data in a SQL code? Retrieve READ SELECT GET

SELECT

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? SELECT * FROM PROVIDERS WHERE PHONE LIKE '___ 231 ___' SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE '231%'

SELECT * FROM PROVIDERS WHERE PHONE LIKE '231%'

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 __.. Systems analysis Database analysis Systems development. Information system

Systems Development

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

Systems analysis

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

The primary Key

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

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

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. two three four five

Three

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

True

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

True

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

Unnormalized

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

User management

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. ignore verify describe prioritize

Verify

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

Views

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

[schema name].[table name]

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 blueprint containing all necessary instructions for building a database that will meet all end-user requirements a clearly defined area within a real-world environment that will be systematically addressed a relatively simple and usually graphical representation of complex real-world objects or events the process of creating a specific data model for a particular set of real-world data to be addressed

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

What does normalization help you do? improve integrity organize tables reduce redundancy accomplish all of these goals

accomplish all of these goals

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

be rendered in writing

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

both A & C

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? attribute entity relationship constraint

constraint

Business rules that are properly written will define entities, attributes, relationships, and _____ fields objects constraints classes

constraints

. 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. programmer manager database administrator systems administrator

database administrator

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

dependency

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

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? attribute relationship entity class

entity

An ERD is created through which of the following processes? prescriptive iterative random conclusive

iterative

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

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 internal schema logical design external model physical independence

logical design

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

normalization

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

relationship

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

two-to-one