Quiz
It
This quiz has question types that open in the usual player.
Questions in this quiz (156)
1For efficiency purposes, data analysis should be done on the production database.
- ATrue
- BFalse
2A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).
- ATrue
- BFalse
3A relational database can be defined as a self-describing collection of related tables.
- ATrue
- BFalse
4Metadata is the user data stored in the database.
- ATrue
- BFalse
5The DBMS is used to create the database itself.
- ATrue
- BFalse
6Application programs are responsible for creating, maintaining, and supporting database backup and recovery systems.
- ATrue
- BFalse
7Usually, a database table containing both rows and columns is designed to store data for exactly two themes.
- ATrue
- BFalse
8SQL stands for Structural Question Language.
- ATrue
- BFalse
9The DBMS receives data update requests from the application program.
- ATrue
- BFalse
10In the general division of labor between database applications and the DBMS, the application program determines which tables need to be modified.
- ATrue
- BFalse
11Personal DBMS products, such as Microsoft Access, create a clear distinction between the DBMS and the database application.
- ATrue
- BFalse
12Microsoft Access 2019 is a personal database that combines a DBMS with an application generator.
- ATrue
- BFalse
13Microsoft Access 2019 databases are stored using the file extension .accdb.
- ATrue
- BFalse
14Microsoft Access 2019 uses the AutoNumber data type to create surrogate keys.
- ATrue
- BFalse
15Theoretically, databases could store instances in columns and characteristics in rows, instead of the other way around.
- ATrue
- BFalse
16An advantage of keeping data in lists is that if you update a data value in one row of data in a list, other occurrences of the same data item in other rows will be automatically updated as well.
- ATrue
- BFalse
17Regarding Big Data, what does the term NoSQL really mean?
- ANon-Blocking Query Langauge
- BNotational Query Language
- CNonrelational Database
- DNo SQL used
- ENortonOS Query Language
18Which of the following is not a basic component of a database system?
- AUser
- BDatabase applications
- CDatabase
- DDBMS
- EERD
19The component of a database that makes it self-describing is the ________.
- Ametadata
- Blibrary
- Cdata set
- Drelated tables
- Eapplications
20The creation of a database and its tables is a function of which component of the database system?
- AUsers
- BDatabase
- CApplication
- DWebserver
- EDBMS
21Microsoft SQL Server is an example of a ________.
- Atable
- Bdatabase management system
- Cdata manipulation system
- Ddatabase
- Elist manager
22The Microsoft Access application generator is not responsible for _______.
- Acreating reports
- Bsorting queries
- Ccreating tables
- Dcreating forms
- Ecreating queries
23A relational database stores data in the form of ________.
- Alists
- Bspreadsheets
- Cforms
- Dtables
- Ecolumns
24The statement
SELECT STUDENT.StudentNumber, STUDENT.StudentName,
FROM STUDENT
WHERE STUDENT.StudentNumber = S12345678;
is an example of ________.- AC++
- BJava
- CQBE
- DQLE
- ESQL
25Which of the following is not a function of the database application in a database system?
- AProcess user queries
- BCreate and process reports
- CExecute application logic
- DControl concurrency
- ECreate and process forms
26The default file format for Microsoft Access 2019 database files is the ________.
- AAccess 2007 format
- BSQL Server format
- CXBD format
- DAccess XP format
- EAccess 2003 format
27Which of the following problems associated with storing data in a list is avoided by storing data in a relational database?
- ALack of necessary bandwidth
- BCPU processing inefficiencies
- CDuplication of data items
- DIncorrect data typing
- ERunning out of memory storage
28A database may be used to help people with all of the following except ________.
- Acheck on the estimated arrival time of an incoming flight at an airport
- Btrack which student is assigned to a particular advisor
- Cdebug existing program code
- Dknow the current inventory levels of products their company sells
- Elookup their checking account balance over the Internet
29A key must be unique.
- ATrue
- BFalse
30A double arrow notation, A→→ B, is used to indicate a multivalued dependency.
- ATrue
- BFalse
31While the relational model for databases appears to hold much promise, few commercial databases have implemented it.
- ATrue
- BFalse
32In the relational model, each row of a table contains data that represents an attribute of the entity.
- ATrue
- BFalse
33Candidate keys may or may not be unique.
- ATrue
- BFalse
34Null values can cause problems because they are ambiguous.
- ATrue
- BFalse
35Given the functional dependency for the attributes of ENTITY1, X → (A, B, C), X is a candidate key for the relation ENTITY1 (A, B, C, X).
- ATrue
- BFalse
36Since surrogate keys are used to uniquely identify rows, their values are normally displayed prominently on all forms and reports for the users to see.
- ATrue
- BFalse
37Normalization is the process of removing all functional dependencies from a relation.
- ATrue
- BFalse
38Any table that meets the definition of a relation is said to be in second normal form.
- ATrue
- BFalse
39In the normalization process, it is not necessary to identify all the functional dependencies in a relation.
- ATrue
- BFalse
40In the normalization process, if you find a candidate key that is not a primary key, then you have determined that the relation needs to be broken into two or more other relations.
- ATrue
- BFalse
41Since Microsoft Access is a personal database, it is not subject to the modification problems that occur in other relational databases.
- ATrue
- BFalse
42In Microsoft Access, foreign keys are designated by using the Foreign Key button in the toolbar.
- ATrue
- BFalse
43To represent a relationship in the relational model, the primary key of one relation is placed into a second relation.
- ATrue
- BFalse
44Every table is a relation, but not every relation is a table.
- ATrue
- BFalse
45Which of the following terms is synonymous with "tuple"?
- ARelation
- BAttribute
- CRow
- DTable
- EField
46Which of the following terms is synonymous with "relation"?
- ARow
- BTuple
- CAttribute
- DRecord
- ETable
47A key that contains more than one attribute is called a(n) ________.
- Acandidate key
- Bmulti-key
- Cn-key
- Dcomposite key
- Ecomplex key
48A candidate key is ________.
- Aa combination of two or more attributes
- Bnever a primary key
- Cis always automatically generated by the DBMS
- Da candidate to be the primary key
- Enone of the above
49A surrogate key may be appropriate under which of the following circumstances?
- AThe primary key is numeric.
- BThe primary key is not unique.
- CThe available candidate keys would be prone to typographical errors.
- DThe available candidate keys have little meaning to the users.
- EThe relation only has one attribute.
50In SQL Server, the starting value of a surrogate key is called the ________.
- Aidentity
- Bidentity Seed
- Cidentity Start
- Didentity increment
- Eidentity property
51One important relational design principle is that ________.
- Aevery determinant must be functionally dependent on the primary key
- Bevery candidate key must not be a determinant
- Cevery primary key must be a surrogate key
- Devery determinant must be a candidate key
- Eevery primary key must be functionally dependent on every determinant
52A table that meets the requirements of a relation is said to be in which normal form?
- ARelation normal form (RNF)
- BFirst normal form
- CBoyce-Codd normal form
- DSecond normal form
- EDomain/key normal form
53In the normalization process, it is not necessary to ________.
- Aidentify all the foreign keys of a relation
- Bdetermine if every determinant is a candidate key
- Cidentify all the candidate keys of a relation
- Didentify all the functional dependencies of a relation
- Eidentify all the determinants of a relation
54In the normalization process, if you find a candidate key that is not a determinant then you should not ________.
- Aleave a copy of the determinant as a foreign key in the original relation
- Bcreate a referential integrity constraint between the original relation and the new relation
- Cplace the columns of the functional dependency in a new relation
- Dmake the determinant of the functional dependency the primary key of the new relation
- Erename the determinant to another attribute description
55When the primary key of one relation is placed into a second relation, it is called a ________.
- Arelocated key
- Bfield key
- Ccandidate key
- Dreferential integrity
- Eforeign key
56A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called ________.
- Aa referential integrity constraint
- Ba functional dependency
- Csynchronization
- Da key matching constraint
- Enormalization
57In Microsoft Access, a relationship between two tables is created ________.
- Aby entering the name of the foreign key in the appropriate table in Design View
- Bby dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window
- Cby entering the name of the primary key in the appropriate table in Design View
- Dby dragging the primary key column of one table onto the primary key column of the other table in the Relationships window
- Eby dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window
58In Microsoft Access, the relationship between two tables is not actually created until ________.
- Athe OK button in the Edit Relationships dialog box is clicked
- Bthe Create button in the Create Relationships dialog box is clicked
- Cthe Create button in the Edit Relationships dialog box is clicked
- Dthe OK button in the Create Relationships dialog box is clicked
- Ethe Join button in the Edit Relationships dialog box is clicked
59Which of the following is true about a relation?
- AA relation may have multiple names.
- BA relation may have duplicate column names.
- CA relation may have duplicate rows.
- DThe order of the columns in a relation must go from largest to smallest.
- EAll entries in any column must be of the same kind.
60Although Microsoft Access is a personal database, the database tables in Access are still subject to [blank_start]modification problems[blank_end] if they are not well-formed.
- Amodification problems
61A key that contains two or more attributes is called a(n) [blank_start]composite[blank_end] key.
- Acomposite
62The relationship between two attributes that denotes that if the value of the first attribute is known, then the value of the second attribute can be determined, is called a(n) [blank_start]functional dependency[blank_end]
- Afunctional dependency
63A(n) [blank_start]surrogate key[blank_end] is a unique, numeric value that is appended to the relation to serve as the primary key.
- Asurrogate key
64Any table that meets the requirements of a(n) [blank_start]relation[blank_end] is in first normal form.
- Arelation
65A rule that requires every value in a foreign key to match values in the corresponding primary key is called a(n) [blank_start]referential integrity[blank_end] constraint.
- Areferential integrity
66In Microsoft Access, the Relationships window is accessed by using the [blank_start]relationship[blank_end] button on the Database tools command tab.
- Arelationship
67In Microsoft Access, referential integrity constraints are created in the [blank_start]Edit Relationships dialog box[blank_end].
- AEdit Relationships dialog box
68In Microsoft Access, relationships between tables are built in the [blank_start]relationship window[blank_end].
- Arelationship window
69What is the name of Microsoft's cloud services? [blank_start]Azure[blank_end]
- AAzure
70Data that the database keeps about its own structure is called [blank_start]metadata[blank_end].
- Ametadata
71[blank_start]Referential integrity[blank_end] constraints are rules that the DBMS enforces to ensure that data values in one table have corresponding values in another related table.
- AReferential integrity
72Microsoft Access is a(n) [blank_start]personal database[blank_end], which combines a DBMS and an application generator.
- Apersonal database
73Microsoft Access 2019 database files are stored using the [blank_start].accdb[blank_end] file extension.
- A.accdb
74Microsoft Access 2019 generates surrogate key values when the [blank_start]AutoNumber[blank_end] data type is used.
- AAutoNumber
75It is almost always best to design a table in a database so that it contains data on [blank_start]one[blank_end] theme.
- Aone
76In a database system, the [blank_start]database application[blank_end] creates and processes forms.
- Adatabase application
77The purpose of a database is to help people [blank_start]keep track of things[blank_end].
- Akeep track of things
78The result for SELECT statements in SQL is a relation unless the result is a single number.
- ATrue
- BFalse
79In SQL, the WHERE clause is used to specify which columns will be included in the result.
- ATrue
- BFalse
80In SQL, to refer to a range of values in a WHERE clause, use the WITHIN keyword.
- ATrue
- BFalse
81In SQL, the LIKE keyword can be used to select on partial values.
- ATrue
- BFalse
82In SQL, the IS NULL keyword can be used to select on records containing NULL values in a particular column.
- ATrue
- BFalse
83The SUM built-in function in SQL is used to total the values in a numeric column.
- ATrue
- BFalse
84Standard SQL does not allow built-in functions to be used in a WHERE clause.
- ATrue
- BFalse
85Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.
- ATrue
- BFalse
86SQL is a data sublanguage, not a complete programming language.
- ATrue
- BFalse
87When using SQL to create a table, specifying the NULL property for a column indicates that only null values may be stored in that column.
- ATrue
- BFalse
88For a column to be defined as the primary key using table constraints, the column must have been given the property NULL.
- ATrue
- BFalse
89You can use foreign key constraints to define foreign keys and their associated referential integrity constraints.
- ATrue
- BFalse
90Microsoft Access SQL commands are run within the SQL View of a Query window.
- ATrue
- BFalse
91To open a new Microsoft Access Query window, click the Query Design button on the Create command tab.
- ATrue
- BFalse
92In Microsoft Access, default values must be set as a field property while the table is in Design View.
- ATrue
- BFalse
93The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.
- ATrue
- BFalse
94Using standard SQL, unmatched rows will not appear in the result of a join.
- ATrue
- BFalse
95A subquery is appropriate only if the final result contains only data from a single table.
- ATrue
- BFalse
96Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?
- ADISTINCT
- BUNIQUE
- CREDUCE
- DSORT
- EORDER BY
97Conditions after the WHERE keyword require single quotes around the values for columns that have which data type?
- AInteger
- BDecimal
- CDate/Time
- DNumeric
- EChar
98Which symbol is used in standard SQL as a wildcard to represent a single, unspecified character?
- A? (question mark)
- B; (semi-colon)
- C! (exclamation mark)
- D_ (underscore)
- E% (percent sign)
99Which SQL keyword can be used in conjunction with wildcards to select partial values?
- ALIKE
- BFIND
- CSELECT
- DSUBSTRING
- ESEARCH
100Which of the following is not one of the five SQL built-in functions?
- AAVG
- BCOUNT
- CMAX
- DMODE
- ESUM
101Given the table
CUSTOMER(CustID, Name, PhoneNum, AcctBalance)
what is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?
- AWHERE (CUSTOMER-AcctBalance > 50)
- BWHERE CUSTOMER-AcctBalance > 50
- CHAVING AcctBalance > 50
- DWHERE AcctBalance > 50
- EWHERE (AcctBalance > 50)
102Microsoft Access SQL commands are run in ________.
- Athe QBE window
- Bthe SQL window
- Cthe Query View of an SQL window
- Dthe Design View of a Query window
- Ethe SQL View of a Query window
103To open a new Microsoft Access Query window ________.
- Aclick the New button on the Home command tab
- Bclick the New Query in Design view button on the Create command tab
- Cclick the Create Query button on the Create command tab
- Dclick the New Query button on the Home command tab
- Eclick the Query Design button on the Command tab
104Which of the following data types used in SQL would define a fixed-length text field of 10 characters?
- AFixed(10)
- BChar(10)
- CVarChar(10)
- DText(10)
- ELength(10)
105Which of the following is not a standard data type used in SQL?
- AText
- BChar
- CInteger
- DVarChar
- ENumeric
106A composite primary key can be defined using the CONSTRAINT phrase in which SQL command?
- ACHANGE TABLE
- BBUILD TABLE
- CMODIFY TABLE
- DCREATE TABLE
- ESET TABLE
107Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?
- AMODIFY Advisor SET STUDENT = 'Smith';
- BSET STUDENT Advisor = 'Smith';
- CUPDATE STUDENT SET Advisor = 'Smith';
- DMODIFY STUDENT SET Advisor = 'Smith';
- EUPDATE Advisor = 'Smith';
108In Microsoft Access, standard SQL table creation syntax items not supported by Access SQL can generally be implemented by ________.
- Arunning an ALTER TABLE query in Access SQL
- Bsetting the Data Types in Access table Design View
- Csetting the referential integrity properties in the Edit Relationship dialog box
- Dsetting the field properties in Access table Design View
- Esetting the relationship properties in the Edit Relationship dialog box
109Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT?
- ADELETE TABLE STUDENT;
- BSELECT * FROM STUDENT THEN DROP;
- CDELETE FROM STUDENT;
- DREMOVE TABLE STUDENT;
- EDROP TABLE STUDENT;
110Which type of join, although not included in standard SQL, was created to allow unmatched rows to appear in the result of a join operation?
- AODD JOIN
- BINNER JOIN
- COPEN JOIN
- DCOMBINE JOIN
- EOUTER JOIN
111Conditions in an SQL INSERT command and after the SQL [blank_start]WHERE[blank_end] keyword require single quotes around values for Char and VarChar columns, but not around values for Integer and Numeric columns.
- AWHERE
112SQL stands for [blank_start]Structured Query Language[blank_end].
- AStructured Query Language
113SQL was developed by [blank_start]IBM[blank_end] in the late 1970s.
- AIBM
114An SQL data type of [blank_start]VarChar(75)[blank_end] would indicate a variable-length character string with maximum length 75.
- AVarChar(75)
115Microsoft Access SQL commands are run in the [blank_start]SQL View[blank_end] of a Query window.
- ASQL View
116In Microsoft Access, tables are added to a QBE Query window by selecting the tables from the [blank_start]show table[blank_end] dialog box.
- Ashow table
117The values of existing data can be modified using the SQL [blank_start]UPDATE[blank_end] command, which can be used to change several column values at once.
- AUPDATE
118Existing tables in a database can be structurally modified by using the SQL [blank_start]Alter Table[blank_end] command.
- AAlter Table
119Microsoft Access SQL allows table structures to be modified by using the standard SQL [blank_start]Alter Table[blank_end] command.
- AAlter Table
120Using SQL commands, multiple tables can be queried using either subqueries or [blank_start]JOINS[blank_end].
- AJOINS
121One or more entities can be associated together in relationships.
- ATrue
- BFalse
122Recursive relationships can be represented as 1:N or N:M, but not 1:1.
- ATrue
- BFalse
123Unified Modeling Language (UML) has quickly replaced the E-R Model as the most popular technique for creating data models.
- ATrue
- BFalse
124An entity class is described by the structure of the entities in that class.
- ATrue
- BFalse
125The E-R Model assumes that all instances of a given entity class have the same attributes.
- ATrue
- BFalse
126The number of entity classes involved in a relationship is the cardinality of the relationship.
- ATrue
- BFalse
127Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class.
- ATrue
- BFalse
128Subtype entities may be either exclusive or inclusive.
- ATrue
- BFalse
129During the implementation phase of developing a database system, the data model is transformed into a database design.
- ATrue
- BFalse
130During the design phase of developing a database system, the users are asked about the need for changes to existing forms and reports.
- ATrue
- BFalse
131Use cases can be used to validate the data model, design, and implementation.
- ATrue
- BFalse
132In crow's foot E-R notation, a circle indicates a minimum cardinality of zero.
- ATrue
- BFalse
133In a traditional E-R diagram, the relationship is symbolized by a diamond.
- ATrue
- BFalse
134System requirements as documented by use cases, business rules, forms, reports, and queries are sufficient to design the database without using a formal data model.
- ATrue
- BFalse
135Microsoft Access wizards allow easy mock-ups of forms and reports for prototyping.
- ATrue
- BFalse
136The implementation step is a process that starts with the final system design as its input and produces a final system as its output.
- ATrue
- BFalse
137An entity cannot be both weak and strong.
- ATrue
- BFalse
138In the Entity-Relationship data model, all instances of an entity of a given type are grouped into ___.
- Aidentifiers
- Bclass objects
- Centity attributes
- Dentity classes
- Eentity objects
139The number of entity classes involved in a relationship is known as the relationship's ______.
- Adegree
- Bmaximum cardinality
- Cminimum cardinality
- Dclass
- Eordinality
140An ID-dependent entity is ________.
- Aa special type of weak entity
- Ban entity in which the identifier of the entity includes the identifier of another entity
- Ca strong entity
- Dan entity with a maximum cardinality of one
- EBoth A and B
141Which of the following activities is not performed during the implementation phase of developing a database system?
- ACreating forms
- BCreating reports
- CFilling the database with data
- DWriting application programs
- ETransforming the data model into a database design
142Microsoft Access can be used to build a prototype database, which allows users ________.
- Ato validate the data model by demonstrating the consequences of data modeling decisions
- Bto normalize the tables in the E-R diagram
- Cto determine the functional dependencies in the data model
- Dto draw a crow's foot E-R diagram themselves
- Eto determine the appropriate primary and foreign keys in the data model
143The Microsoft Access form editor is a(n) _____.
- AASCII form editor
- BWYSIWYG form editor
- CWeb-based form editor
- Dwizard-based form editor
- Ebanded form editor
144In crow's foot style E-R diagrams, a hash mark across the relationship line near an entity indicates ________.
- Aa minimum cardinality of optional
- Ba maximum cardinality of one
- Ca minimum cardinality of mandatory
- Da maximum cardinality of many
- EBoth B and C
145In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates ________.
- Aa maximum cardinality of many
- Ba minimum cardinality of mandatory
- Ca maximum cardinality of one
- Da minimum cardinality of optional
- EBoth B and C
146Given only the following excerpt of an E-R model:
Which of the following is known to be true?
- AA single instance of ENTITY B may be related to many instances of ENTITY A.
- BThe degree of the relationship is "many."
- CA single instance of ENTITY A must be related to many instances of ENTITY B.
- DENTITY A has a minimum cardinality of one.
- EThere are more instances of ENTITY A than there are instances of ENTITY B in the user's environment.
147Given only the following excerpt of an E-R model:
Which of the following is known to be true?- AMany instances of ENTITY A may be related to one instance of ENTITY B.
- BENTITY B has a degree of many.
- CENTITY B is a weak entity.
- DA single instance of ENTITY A must be related to one instance of ENTITY B.
- EBoth A and C are true.
148The representation of the content, relationships, and constraints of the data needed to support the system requirements is the ________.
- Aapplication program
- Brelation design
- Cdata model
- Ddata view
- Eimplementation
149A use case can be used to perform which of the following tasks?
- AImplement business rules
- BDevelop applications
- CValidate the data model
- DTransform the data model into the database design
- EFill the database with data
150Recursive relationships occur when an entity has a relationship with [blank_start]itself[blank_end].
- Aitself
151Relationships with the degree two are often called [blank_start]binary[blank_end] relationships.
- Abinary
152A(n) [blank_start]prototype[blank_end] is a working demonstration of selected portions of the future system.
- Aprototype
153[blank_start]Microsoft Access[blank_end] can be used to build prototype databases.
- AMicrosoft Access
154An [blank_start]associative[blank_end] entity is used whenever pure a N:M relationship cannot properly hold attributes that are describing aspects of the relationship between two entities.
- Aassociative
155Microsoft Access uses [blank_start]banded[blank_end] form and report editors.
- Abanded
156The [blank_start]data model[blank_end] is a representation of the content, relationships, and constraints of the data needed to support the system requirements.
- Adata model
Information
- Description
- Quiz on It, created by E I on 04/02/2021.
- Author
- E I
- Language
- English
- Views
- 7
- Rating
- No ratings yet Rate this quiz