Microsoft Access uses the same pure N:M relationships that occur in data modeling.
Users log into SQL Server 2014 Express using the Connect to Server dialog box.
An important reason for using SQL Server 2014 Express is that it has full SQL
capabilities.
When using Oracle Database, a sequence is an object that generates a sequential series
of unique numbers.
An advantage of keeping data in lists is that if you add a new row of data to the list, you
will never have null values occurring for any data item in the row.
Relationships that are 1:1 do not require referential integrity constraints.
An important reason for using Oracle Database Express Edition 11g Release 2 is that it
has full SQL capabilities.
The CurrVal method provides the current value in a sequence.
To represent a M:N relationship in the relational model, an intersection relation is
created to represent the relationship itself.
When 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.
SQL Server 2014 Express requires that the .NET Framework version 2.0 be installed.
When developing a database system, the database is constructed during the
implementation phase.
As far as Microsoft Access is concerned, there are no N:M relationships.
Operational databases contain a fact table.
One definition of information is knowledge derived from data.
As far as Microsoft Access is concerned, there are no 1:N relationships.
In a snowflake table, each dimension table is normalized.
Most organizations create and use their own database management system (DBMS)
products.
The CAP theorem defines the three properties, one of which is partition tolerance.
The SQL command SELECT is used to retrieve data from view instances.
With optimistic locking, locks are first issued, then the transaction is processed, and
then the locks are released.
XML Schemas consist of elements, attributes, and properties.
A common default Web page name recognized by most Web servers is FirstPage.html.
A new MySQL database is created using the New Database dialog box.
While the relational model for databases appears to hold much promise, few
commercial databases have implemented it.
The IIS Web server is managed using the Microsoft Internet Information Service (IIS)
Manager.
SQL statements used to construct views cannot contain the WHERE clause.
Given 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).
Data is facts and numbers.
An 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.
To 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.
In Microsoft Access, relationships between tables are created in the Relationships
window.
Business Intelligence (BI) systems support operational activities.
Business Intelligence (BI) reporting systems can do which of the following operations?
A) Filter data
B) Group data
C) Modify data
D) Both A and B
E) All of the above
RFM analysis analyzes and ranks customers based on:
A) their purchasing patterns.
B) their income status.
C) their residential location.
D) Both A and B
E) All of the above
In the MySQL Workbench, a 1:N identifying relationship between two tables that
already contain the needed primary and foreign keys is created using:
A) the 1:N Identifying Relationship button.
B) the 1:N Non-identifying Relationship button.
C) the N:M Identifying Relationship button.
D) the Place a Relationship Using Existing Columns button.
E) None of the above is correct.
SQL views contain their own data.
Microsoft SQL Server is an example of a:
A) database.
B) database management system.
C) data manipulation system.
D) table.
E) list manager.
Database designs are created during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL
statements would be used to add new student data to the STUDENT table?
A) INSERT DATA STUDENT SET StudentID=123, Name=’Jones’, Advisor=’Smith’;
B) INSERT INTO STUDENT VALUES (123, ‘Jones’, ‘Smith’);
C) INSERT INTO STUDENT (New Student Data) VALUES (123, ‘Jones’, ‘Smith’);
D) INPUT DATA STUDENT SET StudentID=123, Name=’ Jones’, Advisor=’Smith’;
E) INPUT INTO STUDENT (123, ‘Jones’, ‘Smith’);
SQL query results are displayed:
A) in a tabbed Resultset window.
B) in a tabbed Results window.
C) in a tabbed Document window.
D) in a tabbed Messages window.
E) in a tabbed Finished window.
SQL stands for:
A) Standard Query Language.
B) Structural Question Language.
C) Structured Query Language.
D) Standard Question Language.
E) Structured Question Language.
In the MySQL Workbench, a 1:N identifying relationship between two tables that do
not contain the needed primary and foreign keys is created using:
A) the 1:N Identifying Relationship button.
B) the 1:N Non-identifying Relationship button.
C) the N:M Identifying Relationship button.
D) the Place a Relationship Using Existing Columns button.
E) None of the above is correct.
Which of the following is a function of the database application in a database system?
A) Create and transmit queries
B) Update database data
C) Maintain database structures
D) Create tables
E) Backup and restore data
Which method returns the next value in a sequence?
A) CountVal
B) Next
C) UpVal
D) NextVal
E) Append
Microsoft SQL Server 2014 Express Advanced includes:
A) SQL Server 2014 Management Studio.
B) SQL Server 2014 Reporting Services.
C) Windows Installer 4.5.
D) Both A and B
E) All of the above
Which of the following functional dependency diagrams accurately represents the
following situation:
– A campus has many buildings.
– Each building has a unique name.
– Each building has many rooms.
– All rooms in any given building are numbered sequentially starting at “101.”
– Each room has a certain capacity, although many rooms in the same building or
different buildings may have the same capacity.
– Each room is assigned to a single department.
– A department may have many rooms in one or more buildings, each with the same or
different capacities.
A) BuildingName → (RoomNumber, Capacity, Department)
B) RoomNumber → (BuildingName, Department, Capacity)
C) (Department, Capacity) → (BuildingName, RoomNumber)
D) (BuildingName, Capacity) → (Department, RoomNumber)
E) (BuildingName, RoomNumber) → (Capacity, Department)
Which of the following is not true about a relation?
A) A relation is a two-dimensional table.
B) The cells of a relation must hold a single value.
C) A relation may have duplicate column names.
D) A relation may not have duplicate rows.
E) The order of the rows of a relation is insignificant.
________ provides the ability to sum, count, average and perform other simple
arithmetic operations on groups of data.
Dimensional databases are used to track historical data and therefore must have a:
A) time dimension.
B) customer dimension.
C) sales dimension.
D) Either A or B
E) Both A and B
SQL statements can be run individually or as part of a related group of SQL statements
known as a:
A) Result.
B) Resultset.
C) Script.
D) Scriptset.
E) Commandset.
In Microsoft Visio 2013, when the Entity object is placed in a diagram, it is labeled as
a(n):
A) entity.
B) table.
C) relationship.
D) dynamic connector.
E) category.
Which of the following is a common unsupervised data mining technique?
A) Cluster analysis
B) Regression analysis
C) RFM analysis
D) Both A and B
E) All of the above
In SQL Server, the starting value of a surrogate key is called the:
A) Identity.
B) Identity Increment.
C) Identity Start.
D) Identity Seed.
E) Identity Property.
When distributed databases break the database into sections and store the sections on
different servers, this is known as:
A) replication.
B) partitioning.
C) disbursing.
D) distributed two-phase locking.
E) None of the above
In the normalization process, if you find a candidate key that is not a primary key then
you should:
A) place the columns of the functional dependency in a new relation.
B) make the determinant of the functional dependency the primary key of the new
relation.
C) leave a copy of the determinant as a foreign key in the original relation.
D) All of the above
E) None of the above
ODBC stands for:
A) Open Database Compatibility.
B) Open Database Connectivity.
C) Open-source Database Compatibility.
D) Open-source Database Connectivity.
E) None of the above
Which of the following would be a reason to denormalize a relation?
A) Relax security
B) Lack of design time
C) End user preference
D) Improve performance
E) None of the above
Given only the following excerpt of an E-R model:
If one instance of ENTITY B must be related to one and only one instance of ENTITY
A, and one instance of ENTITY A may be related to many instances of ENTITY B,
which of the following should be written on the end of the relationship line next to
ENTITY B in the figure above?
A)
B)
C)
D)
E) None of the above is correct.
In the normalization process, if you find a candidate key that is not a determinant then
you should:
A) place the columns of the functional dependency in a new relation.
B) make the determinant of the functional dependency the primary key of the new
relation.
C) leave a copy of the determinant as a foreign key in the original relation.
D) All of the above
E) None of the above
Market basket analysis is:
A) a data mart specific technique.
B) a reporting technique.
C) an RFM application.
D) an OLAP application.
E) a data mining technique.
Refer to the table above. What is the confidence of Drug B being purchased given that
Drug A has been purchased?
A) .200
B) .250
C) .333
D) .400
E) .500
The representation of the content, relationships, and constraints of the data needed to
support the system requirements is the:
A) relation design.
B) implementation.
C) data model.
D) data view.
E) application program.
The MySQL GUI tool is replaced by:
A) MySQL Query Browser.
B) MySQL Administrator.
C) My SQL Workbench.
D) Both A and B
E) All of the above
Which of the following is an account name for which you are asked to enter a password
for the Oracle Database XE 11.2 utility?
A) SYSTEM
B) EXTERNAL
C) INTERNAL
D) A and B
E) A, B and C
A 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:
A) normalization.
B) a referential integrity constraint.
C) a key matching constraint.
D) a functional dependency.
E) synchronization.
To create a 1:1 relationship between two tables in Microsoft Access:
A) the Indexed property of the foreign key column must be set to No.
B) the Indexed property of the foreign key column must be set to Yes (Duplicates OK).
C) the Indexed property of the foreign key column must be set to Yes (No Duplicates).
D) the Data Type of the foreign key column must be set to AutoNumber.
E) the Smart Tag property of the foreign key column must be set to Foreign Key.
Database objects are displayed in the ________ window in the SQL Developer.
In Microsoft Access, the Relationships window is accessed by using the ________
button on the Database tools command tab.
What are SQL Built-in Functions?
What are SQL triggers and how are they used?
For a(n) ________ weak entity, it is necessary to add the key of the parent entity to the
weak entity’s relation so that this added attribute becomes part of the weak entity’s key.
The Microsoft Access application generator adds the ability to create and store
________, ________, and ________.
To run an SQL script, click the ________ button.
In addition to downloading MySQL Community Server and the MySQL Workbench, it
is recommended that the ________ also be downloaded.
What is the CAP theorem, and what does it show?
Every DBMS product has a(n) ________ that allows DBMS functions to be executed
from application program code.
To format an Excel 2013 PivotTable report, we use the ________ command tab.
What is an association relationship, and how does it differ from an N:M relationship?
Business Intelligence (BI) systems fall into two broad categories: ________ and
________.
The term for the enormous datasets generated by Web 2.0 applications is ________.
How are 1:1, 1:N and N:M relationships handled in Microsoft Access?
The classic systems analysis methodology is called the ________.
What is normalization?
A business process is a set of activities that transforms ________ into ________.
Microsoft Access does not create N:M relationships because Microsoft Access creates
databases based on ________.