Quiz
Final IT
Dieses Quiz enthält Fragetypen, die sich im gewohnten Player öffnen.
Fragen in diesem Quiz (200)
1The technique for representing E-R relationships in the relational model is dependent on the minimum cardinality.
- ARichtig
- BFalsch
2Relationships that are 1:1 do not require referential integrity constraints.
- ARichtig
- BFalsch
3When applied to 1:N relationships, the term "parent" refers to the many side of the relationship since a child may have many parents.
- ARichtig
- BFalsch
4To represent a 1:N relationship in the relational model, the key of either entity may be placed as a foreign key in the other entity.
- ARichtig
- BFalsch
5To represent a M:N relationship in the relational model, an intersection table is created to represent the relationship itself.
- ARichtig
- BFalsch
6Microsoft Access uses the same pure N:M relationships that occur in data modeling.
- ARichtig
- BFalsch
7As far as Microsoft Access is concerned, there are no 1:N relationships.
- ARichtig
- BFalsch
8To create a 1:1 relationship in Microsoft Access, the Indexed property of the foreign key column must be set to Yes (No Duplicates).
- ARichtig
- BFalsch
9Recursive relationships can be represented in the relational model using the same techniques that are used for binary relationships.
- ARichtig
- BFalsch
10If a weak entity is ID-dependent but not existence-dependent, it can be represented using the same techniques as a strong entity.
- ARichtig
- BFalsch
11The first step in representing entities using the relational model is to determine which identifier will be used as the key.
- ARichtig
- BFalsch
12When creating a table in the relational database design from an entity in the extended E-R model, the attributes of the entity become the rows of the table.
- ARichtig
- BFalsch
13The ideal primary key is short, numeric, and nonchanging.
- ARichtig
- BFalsch
14One of the important properties of an attribute is whether or not it is required.
- ARichtig
- BFalsch
15Relations should always be normalized to the highest degree possible.
- ARichtig
- BFalsch
16Given the tables
PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
as shown in the figure below, which of the following would represent the correct placement of foreign keys?
- APRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID) - B)
PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID) - CPRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber) - DPRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber) - EPRODUCT (ProductID, Description, Cost, ContactName)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
- APRODUCT (ProductID, Description, Cost, SupplierID)
17In many-to-many relationships in a relational database design, ________.
- Athe key of the child is placed as a foreign key into the parent
- Bthe key of the parent is placed as a foreign key into the child
- Cthe keys of both tables are placed in a third table
- Dthe keys of both tables are joined into a composite key
- EBoth C and D
18Given the tables
PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
as shown in the figure below, which of the following would represent the correct placement of foreign keys?
- APRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID) - BPRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID) - CPRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber) - DPRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID, PhoneNumber) - EPRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
- APRODUCT (ProductID, Description, Cost)
19What relationship pattern is illustrated in the following schema?
PRODUCT (ProductID, Description)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID, Cost)
ProductID in PRODUCT_SUPPLIER must exist in ProductID in PRODUCT
SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCT- ARecursive relationship
- BAssociation relationship
- CSupertype/subtype relationship
- DIntersection relationship
- EStrong entity relationship
20Which of the following is not true about representing subtypes in a relational database design?
- AA subtype and its supertype are representations of the same underlying table.
- BThe key of the supertype is made the key of the subtypes.
- CAn instance of the supertype may be related to one instance each of several subtypes.
- DAll of the attributes of the supertype are added to the subtype relations.
- EOne table is created for the supertype and one for each subtype.
21As far as Microsoft Access is concerned, there are no ________.
- AN:1 relationships
- B1:1 relationships
- Crecursive relationships
- DN:M relationships
- E1:N relationships
22To create a 1:1 relationship between two tables in Microsoft Access ________.
- Athe Indexed property of the foreign key column must be set to No
- Bthe Smart Tag property of the foreign key column must be set to Foreign Key
- Cthe Indexed property of the foreign key column must be set to Yes (Duplicates OK)
- Dthe Data Type of the foreign key column must be set to AutoNumber
- Ethe Indexed property of the foreign key column must be set to Yes (No Duplicates)
23Which of the following is not true of recursive relationships?
- AThe rows of a single table can play two different roles.
- BWhen the recursive relationship is N:M, an intersection table is created.
- CRecursive relationships can be 1:1, 1:N, or N:M relationships.
- DThe techniques for representing the tables are the same as for non-recursive relationships except the rows are in the same table.
- EEven when the relationship is 1:N, a new table must be defined to represent the relationship.
24When transforming an E-R data model into a relational database design, the key of the parent entity should be placed as part of the primary key into the child entity ________.
- Awhen the child entity is non-ID-dependent
- Bwhen the child entity has a 1:N relationship with the parent entity
- Cwhen the child entity is ID-dependent
- Dwhen the child entity has a 1:1 relationship with the parent entity
- Ewhen the child entity has a recursive relationship with the parent entity
25Each attribute of an entity becomes a(n) ________ of a table.
- Aalternate key
- Bforeign key
- Cprimary key
- Dcolumn
- Eeither B or D
26A surrogate key should be considered when ________.
- Aa relationship is N:M
- Ba composite key is required
- Can index needs to be created
- Dthe key contains a lengthy text field
- Ethe key contains a number
27One of the important properties of a column is whether or not it is ________.
- Arequired
- Bsubject to denormalization
- Cfound in more than one entity
- Dsubject to normalization
- Echaracter or numeric
28After a 1:1 relationship has been created between two tables in Microsoft Access, the Relationship Type of One-To-One appears ________.
- Ain the Relationship Type property of the foreign key column in table Design View
- Bin the table object in the Relationships window
- Cin the Show Table dialog box
- Din the Relationship Type property of the primary key column in table Design View
- Ein the Edit Relationships dialog box
29Which of the following would be a reason to denormalize a relation?
- ARelax security
- BEnd user preference
- CImprove performance
- DLack of design time
- ENone of the above
30As far as Microsoft Access is concerned, there are no [blank_start]N:M relationships[blank_end].
- AN:M relationships
31To create a 1:1 relationship between two tables in Microsoft Access, the Indexed property of the foreign key column must be set to [blank_start]Yes (No Duplicates)[blank_end].
- AYes (No Duplicates)
32A(n) [blank_start]recursive relationship[blank_end] is a relationship among entities of the same class.
- Arecursive relationship
33The first step of database design is to define a table for each [blank_start]entity[blank_end].
- Aentity
34Once a table has been defined, it should be examined according to [blank_start]normalization[blank_end] criteria.
- Anormalization
35There are cases where it is possible to normalize a table too far, in which case there may be a need for [blank_start]denormalization[blank_end].
- Adenormalization
36The simplest and most feasible means of recovering a database is through reprocessing.
- ARichtig
- BFalsch
37The simplest and most feasible means of recovering a database is through reprocessing.
- ARichtig
- BFalsch
38Concurrent processing of a database only poses problems when two or more processes attempt to use the same data.
- ARichtig
- BFalsch
39Statement-level consistency means that all statements within a transaction will access consistent rows across the lifetime of the entire transaction.
- ARichtig
- BFalsch
40One advantage of optimistic locking is that the lock is obtained only after the transaction is processed.
- ARichtig
- BFalsch
41Transactions should be written to the log before they are applied to the database itself.
- ARichtig
- BFalsch
42The acronym DBA refers to either the office or the manager.
- ARichtig
- BFalsch
43Microsoft Access 2019 uses a user-level security system.
- ARichtig
- BFalsch
44Microsoft Access 2019 databases cannot be secured by password encryption.
- ARichtig
- BFalsch
45When Microsoft Access 2019 uses user-level security with an Access 2003 file, the database is stored in a(n) *.accdb file.
- ARichtig
- BFalsch
46Database security is easy to achieve since all security is handled by the DBMS, which is a single point of entry into the database.
- ARichtig
- BFalsch
47One way to prevent concurrent processing problems is to lock data that are retrieved for update.
- ARichtig
- BFalsch
48Two-phase locking can be used to ensure that transactions are serializable.
- ARichtig
- BFalsch
49Computer systems fail for which of the following reasons except?
- APeople make mistakes.
- BHardware breaks.
- CDatabases randomly changed field values.
- DPrograms have bugs.
- EElectrical power fails.
50An ACID transaction is one that is all but ________.
- Aconsistent
- Batomic
- Cisolated
- Dguaranteed
- Edurable
51What concurrent processing problem occurs when a transaction rereads data and finds new rows that were inserted by a different transaction since the prior read?
- ADirty reads
- BNonrepeatable reads
- CPhantom reads
- DUnlocked reads
- ESerialized reads
52Which is not a typical processing application for a database?
- ADisk Defragmenter
- BSQL/Persistent Stored Modules
- CStored Procedures in PHP
- DUser-defined triggers
- EWeb forms
53Which type of lock assumes that no conflicts will occur?
- AOpen locks
- BExplicit locks
- CShared locks
- DOptimistic locks
- EGranular locks
54What is the least restrictive isolation level that will prevent dirty reads?
- ARead Committed
- BSerializable
- CRead Uncommitted
- DAtomic Read
- ERepeatable Read
55The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ________.
- Areprocessing
- Bcheckpointing
- Ctransaction logging
- Drollforward
- Erollback
56When Microsoft Access 2019 secures a database just by storing the database in a trusted location, the database file will be a(n) ________.
- A*.accdb file
- B*.mdw file
- C*.mdb file
- D*.accdc file
- E*.accde file
57When Microsoft Access 2019 compiles VBA code in a database, the database file will be a(n) ________.
- A*.mdw file
- B*.accde file
- C*.accdc file
- D*.mdb file
- E*.accdb file
58When Microsoft Access 2019 uses user-level security with an Access 2003 file, the database is stored in a(n) ________.
- A*.mdb file
- B*.accdb file
- C*.accdc file
- D*.mdw file
- E*.accde file
59When a transaction functions in such a way that either all of the transaction actions are completed or none of them will be, the transaction is said to be ________.
- Aatomic
- Blocked
- Clogical
- Dconsistent
- Eisolated
60Whether a lock applies to data at the record level, page level, table level, or database level is referred to as ________.
- Alock phasing
- Block sharing
- Cserializable locking
- Dlock exclusivity
- Elock granularity
61Database administrators must make sure that [blank_start]backup[blank_end] and [blank_start]recovery[blank_end] techniques and procedures are operating to protect the database in case of failure and to recover it as quickly and accurately as possible when necessary.
- Abackup
- Brecovery
62The recovery method where the database is restored using the saved data, and all transactions since the save are reapplied is called [blank_start]rollforward[blank_end] recovery.
- Arollforward
63Standard SQL defines four [blank_start]isolation levels[blank_end], which specify which of the concurrency control problems are allowed to occur.
- Aisolation levels
64[blank_start]Database administration[blank_end] is an important business function whose purpose is to manage the database to maximize its value to the organization.
- ADatabase administration
65Microsoft Access 2019 can secure database files by creating [blank_start]trusted location[blank_end].
- Atrusted location
66Microsoft Access 2019 can secure databases by deploying databases packaged with a(n) [blank_start]digital signiture[blank_end].
- Adigital signiture
67When Microsoft Access 2019 uses user-level security with an Access 2003 database file, it stores the database in a(n) [blank_start].mdb[blank_end] file.
- A.mdb
68A(n) [blank_start]static[blank_end] cursor takes a snapshot of a relation and processes that snapshot, while changes from other sources are not visible to this type of cursor.
- Astatic
69NoSQL really stands for "Not only SQL."
- ARichtig
- BFalsch
70Column family databases are indistinguishable from relational database tables.
- ARichtig
- BFalsch
71Business Intelligence (BI) systems are information systems that help users analyze and use data.
- ARichtig
- BFalsch
72Business Intelligence (BI) systems obtain data from three possible sources.
- ARichtig
- BFalsch
73The CAP theorem defines three properties of distributed database systems; namely consistency, availability, and partition tolerance.
- ARichtig
- BFalsch
74The simplest way to lease cloud services is SaaS.
- ARichtig
- BFalsch
75Data Mining uses sophisticated statistical and mathematical techniques to perform what-if analyses, to make predictions, and to facilitate decision making.
- ARichtig
- BFalsch
76Problematic data include so-called "dirty data."
- ARichtig
- BFalsch
77Data warehouses are populated with data prepared by extract, transform, and load (ETL) systems.
- ARichtig
- BFalsch
78Operational databases store historical data.
- ARichtig
- BFalsch
79Dimensional databases use the star schema.
- ARichtig
- BFalsch
80A star schema resembles a star, with a dimension table at the center and fact tables radiating out from the center.
- ARichtig
- BFalsch
81OLAP provides the ability to sum, count, average and perform other simple arithmetic operations on groups of data.
- ARichtig
- BFalsch
82To create an OLAP report for an Access 2019 database, use the PivotTable tool in Excel 2019.
- ARichtig
- BFalsch
83Excel 2019 allows us to connect directly to an Access 2019 database when building a PivotTable.
- ARichtig
- BFalsch
84Although Excel 2019 will create a PivotTable report using Access 2019 data, it does not have formatting tools that can be used with the report.
- ARichtig
- BFalsch
85Non-relational DBMSs associated with the NoSQL movement include all of the following except ________.
- AColumn family
- BHierarchical
- CKey-value
- DGraph
- EDocument
86In the MapReduce process, the first step is the ________ step.
- Asuper column
- Breduce
- Ccolumn
- Dmap
- Ecolumn family
87Business Intelligence (BI) systems do which of the following?
- AAnalyze current and past activities
- BPredict future events
- CSupport routine operational activities
- DBoth A and B
- ERecord and process transactions
88Business Intelligence (BI) reporting systems can do which of the following operations?
- AGroup data
- BFilter data
- CModify data
- DBoth A and B
- ESecure data
89Data mining applications are used to accomplish all of the following tasks except ________.
- Amake predictions
- Bperform what-if analysis
- Cincorporate results into some other report/system
- Dclassify entities
- Efacilitate decision making
90When distributed databases break the database into sections and store the sections on different servers, this is known as ________.
- Areplication
- Bpartitioning
- Cdistributed two-phase locking
- Ddisbursing
- ENone of the above
91Which of the following is a reason that operational data are difficult to read?
- ANon-integrated data
- BInconsistent data
- CDirty data
- DSlow performance of the system
- EMissing values
92We have obtained access to the company's operational data. We examine 50 records for customers with phone numbers that should use the current area code of 345. Of these 50 records, we find 10 that still use an older area code of 567. This is an example of ________.
- Aa "wrong format" problem
- Ba "too much data" problem
- Cdirty data
- Dinconsistent data
- Enon-integrated data
93A data mart differs from a data warehouse in these ways except ________.
- Ait has a smaller database
- Bdata warehouses receive their data from the data marts
- Cdata marts receive their data from the data warehouse
- Ddata mart users do not have the data management expertise of data warehouse employees
- Eit deals with a particular component or functional area of the business
94Slowly changing dimensions are handled by a(n) ________.
- Adimensional database
- Boperational database
- Cdistributed database
- Deither A or B
- Estructured storage
95Star schemas have a ________ at the center of the star.
- Amap table
- Bfact table
- Cdimension table
- Dreduce table
- ENone of the above
96OLAP stands for ________.
- AOnline Analysis Process
- BOnline Analytical Processing
- COffline Analysis Process
- DOld, Lazy, And Particular
- EOffline Analytical Processing
97To create an OLAP report for an Access 2019 database, we can build a PivotTable in ________.
- AMicrosoft Word 2016
- BMicrosoft PowerPoint 2016
- CMicrosoft Access 2019
- DMicrosoft Excel 2019
- EMicrosoft Visio 2016
98To use Access 2019 data in an Excel 2019 PivotTable, we use the ________.
- A"From Access" command on the Access Data command tab
- B"From Access" command on the Excel Data command tab
- C"Get Data" command on the Excel Data command tab
- D"To Excel" command on the Access Data command tab
- E"To Excel" command on the Excel Data command tab
99To format a PivotTable in Excel 2019, we use the ________.
- ADesign command tab in the Report Tools contextual command tab
- BReport Tools command tab
- CDesign command tab in the PivotTable Tools contextual command tab
- DFormat command tab in the Report Tools contextual command tab
- EFormat command tab in the PivotTable Tools contextual command tab
100The term for the enormous datasets generated by Web 2.0 applications is [blank_start]Big Data[blank_end].
- ABig Data
101Hadoop is a(n) [blank_start]distributed file system (DFS)[blank_end].
- Adistributed file system (DFS)
102Business Intelligence (BI) systems fall into two broad categories: [blank_start]reporting[blank_end] and [blank_start]data mining[blank_end].
- Areporting
- Bdata mining
103Business Intelligence (BI) [blank_start]reporting systems[blank_end] are used to filter data, sort data, group data and make simple calculations based on the data.
- Areporting systems
104Objects have [blank_start]methods[blank_end], which are computer programs that perform some task.
- Amethods
105A(n) [blank_start]data mart[blank_end] is a collection of data that addresses a particular component or functional area of a business.
- Adata mart
106Data warehouses are populated with data prepared by [blank_start]Extract, Transform, and Load (ETL)[blank_end] programs.
- AExtract, Transform, and Load (ETL)
107A variant of the star schema is the [blank_start]snowflake schema[blank_end].
- Asnowflake schema
108To deal with data values that change over time, dimensional databases use a(n) [blank_start]slowly changing dimension[blank_end].
- Aslowly changing dimension
109[blank_start]OLAP[blank_end] provides the ability to sum, count, average and perform other simple arithmetic operations on groups of data.
- AOLAP
110OLAP reports can be created using the Excel 2019 [blank_start]PivotTables[blank_end] tool.
- APivotTables
111When creating an OLAP report based on Access 2019 data, it is often a good idea to create a(n) [blank_start]view equivalent[blank_end] query to organize the data needed for the OLAP report.
- Aview equivalent
112To control the placement of columns and rows in an Excel 2019 PivotTable, we use the [blank_start]PivotTable Field List[blank_end] pane.
- APivotTable Field List
113Which of the following is not a key element of an E-R model?
- AIdentifiers
- BEntities
- CObjects
- DAttributes
- ERelationships
114Attributes may be ________.
- Acomposite
- Belement
- Cmultivalued
- DA (composite) and C (multivalued)
- EB (element) and C (multivalued)
115An identifier may be ________.
- Acomposite
- Ba single attribute
- Ca relationship
- DA (composite) and B (a single attribute)
- EA (composite), B (a single attribute), and C (a relationship)
116A composite attribute is an attribute that ________.
- Ais multivalued
- Bdescribes a characteristic of the relationship
- Cconsists of a group of attributes
- Dis calculated at run-time
- Eis an identifier
117For a relationship to be considered a binary relationship it must satisfy which of the following conditions?
- AIt must involve exactly two entity classes.
- BIt must have a maximum cardinality of 1:1.
- CIt must have a maximum cardinality of 1:N
- DA and B
- EA and C
118Maximum cardinality refers to ________.
- Athe most instances of one entity class that can be involved in a relationship instance with another entity class
- Bthe minimum number of entity classes involved in a relationship
- Cwhether or not an instance of one entity class is required to be related to an instance of another entity class
- Dwhether or not an entity is a weak entity
- ENone of the above.
119You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above, and are asked to draw the relationship between them. If a given customer can place only one order and a given order can be placed by at most one customer, which of the following should be indicated in the relationship symbol between the two entities?
- A0:1
- B1:1
- C1:N
- DN:1
- EN:M
120You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above, and are asked to draw the relationship between them. If a given customer can place many orders and a given order can be placed by at most one customer, which of the following should be indicated in the relationship symbol between the two entities?
- A0:1
- B1:1
- C1:N
- DN:1
- EN:M
121You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above, and are asked to draw the relationship between them. If a given customer can place many orders and a given order can be by one or more customers, which of the following should be indicated in the relationship symbol between the two entities?
- A0:1
- B1:1
- C1:N
- DN:1
- EN:M
122Minimum cardinality refers to ________.
- Athe most instances of one entity class that can be involved in a relationship with one instance of another entity class
- Bthe minimum number of entity classes involved in a relationship
- Cwhether or not an instance of one entity class is required to be related to an instance of another entity class
- Dwhether or not an entity is a weak entity
- ENone of the above.
123In a minimum cardinality, minimums are generally stated as ________.
- A0
- B1
- CN
- DA (0) or B (1)
- EA (0) or B (1) or C (N)
124A circle across the relationship line near an entity indicates ________.
- Aa maximum cardinality of "zero"
- Ba maximum cardinality of "one"
- Ca minimum cardinality of "optional"
- Da minimum cardinality of "required"
- ENone of the above.
125You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above. What does the symbol next to the ORDER entity indicate?
ORDER -0-----N:M------|-CUSTOMER- AA maximum cardinality of "zero"
- BA maximum cardinality of "one"
- CA minimum cardinality of "optional"
- DA minimum cardinality of "required"
- ENone of the above.
126You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above. What does the symbol next to the CUSTOMER entity indicate?
ORDER -0-----N:M------|-CUSTOMER- AA maximum cardinality of "zero"
- BA maximum cardinality of "one"
- CA minimum cardinality of "optional"
- DA minimum cardinality of "required"
- ENone of the above.
127An entity whose existence depends on the presence of another entity, but whose identifier does not include the identifier of the other entity is a(n) ________.
- Astrong entity
- Bweak entity
- CID-dependent entity
- DA (strong) and C (ID-dependent)
- EB (weak) and C (ID-dependent)
128An entity that holds specialized attributes that distinguish it from one or more other similar entities is a(n) ________.
- Asupertype
- Bsubtype
- Cdiscriminator
- DA (supertype) and C (discriminator)
- EB (subtype) and C (discriminator)
129Which of the following is not true about subtype entities?
- ASubtypes may be exclusive.
- BThe supertype and subtypes will have the same identifier.
- CSubtypes are used to avoid a situation in which some attributes are required to be null.
- DSubtypes have attributes that are required by the supertype.
- ESubtypes can produce a closer-fitting data model.
130An attribute that determines which subtype should be used is a(n) ________.
- Asupertype
- Bsubtype
- Cdiscriminator
- DA (supertype) and C (discriminator)
- EB (subtype) and C (discriminator)
131Discriminators can be ________.
- Aexclusive only
- Binclusive only
- Cdecisive only
- DA (exclusive) or B (inclusive)
- EB (inclusive) or C (decisive)
132To represent an association pattern in an E-R model, ________.
- Acreate a new ID-dependent entity with a 1:1 relationship to one other entity
- Bcreate a new weak, but not ID-dependent entity with a 1:1 relationship to one other entity
- Ccreate a new strong entity with a 1:1 relationship to one other entity
- Dcreate a new ID-dependent entity with a 1:N relationship to one of two parent entities
- Ecreate a new weak, but not ID-dependent entity with a 1:N relationship to one of two parent entities
133To represent a multivalued attribute in an E-R model, ________.
- Acreate a new ID-dependent entity with a 1:N relationship
- Bcreate a new weak, but not ID-dependent entity with a 1:N relationship
- Ccreate a new strong entity with a 1:1 relationship
- Dcreate a new ID-dependent entity with a 1:1 relationship
- Ecreate a new weak, but not ID-dependent entity with a 1:1 relationship
134To represent an archetype/instance pattern in an E-R model, ________.
- Acreate a new ID-dependent entity with a 1:N relationship
- Bcreate a new weak, but not ID-dependent entity with a 1:N relationship
- Ccreate a new strong entity with a 1:1 relationship
- Dcreate a new ID-dependent entity with a 1:1 relationship
- Ecreate a new weak, but not ID-dependent entity with a 1:1 relationship
135To represent a M:N relationship in the relational model, an intersection relation is created to represent the relationship itself.
- ARichtig
- BFalsch
136To represent a 1:N relationship in the relational model, the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.
- ARichtig
- BFalsch
137The technique for representing E-R relationships in the relational model is dependent on the minimum cardinality.
- ARichtig
- BFalsch
138DK/NF requires that all constraints on data values be logical implications of the definitions of domains and keys.
- ARichtig
- BFalsch
139Boyce-Codd Normal Form was created to address the problem of multivalued dependencies.
- ARichtig
- BFalsch
140The key for an intersection relation is always the combination of the keys of the parent entities.
- ARichtig
- BFalsch
141DK/NF requires:
- Aevery determinant must be a logical consequence of the definition of domains.
- Bevery domain of data values must be a logical consequence of the definition of keys.
- Cevery constraint on data values must be a logical consequence of the definition of domains and keys.
- Devery key must be a logical consequence of the definition of constraints and determinants.
- Eevery consequence of data values must originate in the definition of determinants and keys.
142Given the generic relation:
GENERIC (PKey1, PKey2, Attribute1, Attribute2, Attribute3), and the functional dependencies:
(PKey1, PKey2) → Attribute1 and PKey2 → (Attribute2, Attribute3), which of the following is true?- AGENERIC is not fully normalized.
- BPKey1 is a determinant.
- CPKey2 is a candidate key.
- DGENERIC is in DK/NF.
- EAll of the above
143From a pragmatic standpoint, the only important rule of normalization is that the determinant of every functional dependency must be a candidate key.
- ARichtig
- BFalsch
144To represent a many-to-many relationship in the relational model, a(n) [blank_start]intersection[blank_end] table is used.
- Aintersection
145Which of the following is not true about surrogate keys?
- AThey have no meaning to the users.
- BThey are identifiers that are supplied by the system, not the users.
- CThey are nonunique within a table.
- DThe DBMS will not allow their values to be changed.
- EThey can be problematic when combining databases.
146What relationship pattern is illustrated in the following schema?
EMPLOYEE (EmployeeID, OfficePhone, Manager)
Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE- AAssociation relationship
- BIntersection relationship
- CRecursive relationship
- DStrong entity relationship
- ESupertype/subtype relationship
147All recursive relationships are 1:1.
- ARichtig
- BFalsch
148After a 1:1 relationship has been created between two tables in Microsoft Access, the Relationship Type of One-To-One appears:
- Ain the Relationship Type property of the primary key column in table Design View.
- Bin the Relationship Type property of the foreign key column in table Design View.
- Cin the table object in the Relationships window.
- Din the Show Table dialog box.
- Ein the Edit Relationships dialog box.
149By default, when Microsoft Access creates a relationship between two tables it creates a(n) [blank_start]1:N[blank_end] relationship.
- A1:N
150Microsoft Access does not create N:M relationships because:
- AMicrosoft Access creates databases based on database designs instead of data models.
- BMicrosoft Access creates databases based on data models instead of database designs.
- CMicrosoft Access cannot implement association relationships.
- DMicrosoft Access cannot implement supertype/subtype relationships.
- EMicrosoft Access cannot implement recursive relationships.
151Which of the following is the correct technique for representing a M:N relationship using the relational model?
- AAn intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation.
- BAn intersection relation is created with a surrogate key, which is placed in each of the parent entities.
- CAn intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation.
- DThe key from either relation is placed as a foreign key in the other relation.
- ENone of the above
152Given TABLE_A (Attribute1, Attribute2, Attribute3) and TABLE_B (Attribute4, Attribute5, Attribute6) shown in the figure below, which of the following would display the correct placement of foreign keys in the relational model?
- ATABLE_A (Attribute1, Attribute2, Attribute3)
TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1) - BTABLE _A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5)
TABLE _B (Attribute4, Attribute5, Attribute6)
TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5)
TABLE _B (Attribute4, Attribute5, Attribute6) - CTABLE _A (Attribute1, Attribute2, Attribute3, Attribute4)
TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1) - DTABLE _A (Attribute1, Attribute2, Attribute3)
TABLE _B (Attribute4, Attribute5, Attribute6) - ETABLE _A (Attribute1, Attribute2, Attribute3, Attribute6)
TABLE _B (Attribute4, Attribute5, Attribute6)
- ATABLE_A (Attribute1, Attribute2, Attribute3)
153As far as Microsoft Access is concerned, there are no N:M relationships.
- ARichtig
- BFalsch
154The key for an intersection table is always the combination of the keys of the parent entities.
- ARichtig
- BFalsch
155To represent a 1:N relationship in the relational model, the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.
- ARichtig
- BFalsch
156To represent a 1:N relationship in the relational model, the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.
- ARichtig
- BFalsch
157For a 1:1 relationship, the key of each table should be placed in the other table as the foreign key.
- ARichtig
- BFalsch
158Additional DBA responsibilities do not include [blank_start]editing ER diagrams[blank_end].
- Aediting ER diagrams
159When Microsoft Access 2013 compiles VBA code in a database, the resulting file is stored using a(n) [blank_start].accde[blank_end] file extension
- A.accde
160Microsoft Access 2019 can secure databases by using [blank_start]passwords[blank_end] to encrypt and decrypt the database files.
- Apasswords
161Breaking hardware, power outages, and human mistakes are all reasons that [blank_start]computers fail[blank_end].
- Acomputers fail
162The recovery method in which we undo the changes that erroneous or partially processed transactions have made in the database is called [blank_start]rollback[blank_end] recovery
- Arollback
163Transaction results are kept in a(n) [blank_start]log[blank_end], which contains records of the data changes in chronological order.
- Alog
164Serializable transactions are created by having a(n) [blank_start]growing[blank_end] phase, in which locks are obtained, and a(n) [blank_start]shrinking[blank_end] phase, in which locks are released.
- Agrowing
- Bshrinking
165Database administrators must make sure that [blank_start]security[blank_end] measures are in place and enforced so that only authorized users can take authorized actions at appropriate times.
- Asecurity
166One of the major tasks of the database administration is called [blank_start]concurrency[blank_end] control, which allows multiple users to access the database simultaneously.
- Aconcurrency
167When Microsoft Access 2013 creates a signed package with a digital signature, the database file will be a(n):
- A.accdb
- B.accdc
- C.accde
- D.mdb
- E.mdw
168When Microsoft Access 2019 secures a database with just a password, the database file will be a(n):
- A.accdb
- B.accdc
- C.accde
- D.mdb
- E.mdw
169Computer systems fail for which of the following reasons?
- AHardware breaks
- BElectrical power fails.
- CPrograms have bugs.
- DPeople make mistakes.
- EAll of the above
170Additional DBA responsibilities include:
- Aproblem and error reporting.
- Brequests of changes to existing systems.
- Ccontrolling database configuration.
- Dmaintaining appropriate documentation.
- EAll of the above
171A point of synchronization between the database and the transaction log is called a(n):
- Abefore-image
- Bafter-image
- Crecovery
- Dcheckpoint
- Enone of the above
172Which of the following is not true of database recovery through reprocessing?
- AReprocessing makes use of a database save.
- BReprocessing takes the same amount of time as did processing in the first place
- CReprocessing will always return the database to its exact previous state.
- DReprocessing requires a record of all transactions since the last time the database was saved.
- EAll of the above are true of reprocessing.
173What is the least restrictive isolation level that will prevent nonrepeatable reads?
- ARead Committed
- BSerializable
- CRead Uncommitted
- DAtomic Read
- ERepeatable Read
174What is the least restrictive isolation level that will prevent phantom read problems?
- ARead Committed
- BSerializable
- CRead Uncommitted
- DAtomic Read
- ERepeatable Read
175Ensuring that each SQL statement independently processes consistent rows is known as:
- Atransaction level consistency.
- Bindependent consistency.
- Cstatement level consistency.
- Dprocess level consistency.
- Eserializable consistency.
176An ACID transaction is one that is:
- Aatomic
- Bconsistent
- Cisolated
- Ddurable
- Eall of the above
177Which of the following is true about a shared lock?
- AIt is more restrictive than an implicit lock.
- BIt allows only two transactions to update a record simultaneously.
- CIt locks the item from all access.
- DIt allows reads to the locked item.
- EIt must use a two-phase locking scheme.
178Preventing multiple applications from obtaining copies of the same record when the record is about to be changed is called:
- Aserialized reading
- Blost updating
- Cconcurrent processing
- Dresource locking
- Eblock factoring
179What concurrent processing problem occurs when a transaction reads a changed record that has not been committed to the database?
- ANonrepeatable reads
- BPhantom reads
- CDirty reads
- DSerialized reads
- EUnlocked reads
180The purpose of concurrency control is to:
- Aensure that each form has a corresponding report.
- Bensure that ASPs do not duplicate JSPs.
- Censure that one user's work does not interfere with another's.
- Densure that stored procedures do not invoke triggers.
- Eensure that triggers do not invoke stored procedures.
181Which of the following is not a means of processing databases?
- AInternet applications using ASP
- BInternet applications using JSP
- CApplications invoking stored procedures
- DPrograms coded in C#
- EAll of the above are means of processing a database.
182The term DBA refers to the:
- Adatabase accessor
- Bdatabase auditor
- Cdata business auditor
- Ddatabase administrator
- Edata business administrator
183Microsoft Access 2019 databases can be secured by deploying databases packaged with digital signatures.
- ARichtig
- BFalsch
184Microsoft Access 2019 databases can be secured using trusted locations for database storage.
- ARichtig
- BFalsch
185Rollback requires the use of logs, but roll forward does not.
- ARichtig
- BFalsch
186In comparison to reprocessing, roll forward does not involve the application programs.
- ARichtig
- BFalsch
187In terms of database security, a user can be assigned many roles, and a role can be assigned to many users.
- ARichtig
- BFalsch
188Generally, the more restrictive the transaction isolation level, the less the throughput of database processing.
- ARichtig
- BFalsch
189Statement level consistency means that all statements within a transaction will access consistent rows across the lifetime of the entire transaction.
- ARichtig
- BFalsch
190With optimistic locking, locks are first issued, then the transaction is processed, and then the locks are released.
- ARichtig
- BFalsch
191Lock granularity refers to whether a lock is placed by the DBMS automatically or is placed by a command from the application program.
- ARichtig
- BFalsch
192A dirty read is a problem with concurrent processing when a transaction rereads data it has already read and finds modifications or deletions caused by another transaction.
- ARichtig
- BFalsch
193A transaction in which all steps must be completed successfully or none of them will be completed is called a durable transaction.
- ARichtig
- BFalsch
194The purpose of concurrency control is to ensure that one user's work does not inappropriately influence another user's work.
- ARichtig
- BFalsch
195Only large database systems have a need for database administration.
- ARichtig
- BFalsch
196Non-relational DBMSs associated with the NoSQL movement include:
- AKey-Value
- BDocument
- CColumn Family
- DGraph
- EAll of the above
197A data mart differs from a data warehouse in that:
- Ait has a smaller database.
- Bit deals with a particular component or functional area of the business.
- Cdata mart users do not have the data management expertise of data warehouse employees.
- DBoth A and B
- EAll of the above
198Data mining applications are used to accomplish which of the following tasks?
- APerform what-if analysis
- BMake predictions
- CFacilitate decision making
- DBoth A and B
- EAll of the above
199Business Intelligence (BI) systems obtain their data by which of the following means?
- ARead and process data from an operational database
- BProcess extracts from operational databases
- CProcess data purchased from data vendors
- DBoth A and B
- EAll of the above
200Virtualization is using hardware and software to simulate another software application.
- ARichtig
- BFalsch
Informationen
- Beschreibung
- Quiz am Final IT, erstellt von E I am 08/03/2021.
- Autor
- E I
- Sprache
- English
- Aufrufe
- 1
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz