The Java JDK is installed directly from the Java download page at www.oracle.com.
Microsoft Access 2013 command buttons are created using the Command Button
Wizard.
In the MySQL Workbench, a 1:N non-identifying relationship between two tables that
already contain the needed primary and foreign keys is created using the Place a
Relationship Using Existing Columns button.
In the MySQL Table Editor, the abbreviation PK stands for partial key.
Microsoft Access 2013 switchboards use command buttons as part of the menu.
When an SQL SELECT statement is used to retrieve data from a view instance, the
maximum number of columns that can be specified in the SELECT is the same as the
number of columns in the table underlying the view.
To run an SQL script, click the Execute button on the Query Toolbar.
To add a table to a database design, click the Place a New Table button, move the
cursor to the diagram area and click the left mouse button.
Microsoft Access SQL supports and will correctly implement the numeric data type
with (m,n) notation.
ODBC stands for Open Database Connectivity.
Installing PHP using the Microsoft Installer provides sufficient PHP support for use
with Database Concepts 7th Edition.
Microsoft Access SQL commands are run within the SQL View of a Query window.
Microsoft Access 2013 databases cannot be secured by password encryption.
For a Web server running the Windows operating system, the most commonly used Web
server is IIS.
Data warehouses are populated with data prepared by Extract, Transform, and Load
(ETL) systems.
It is possible for an entity to have a relationship to itself.
Every table is a relation, but not every relation is a table.
In Microsoft Visio 2013, the Crow’s Foot Database Notation stencil objects include a
Recursive Relationship object.
To open a new Microsoft Access Query window, click the Query Design button on the
Create command tab.
The Microsoft Access 2013 application generator provides the ability to create and store
forms, reports, and queries.
Microsoft Access 2013 can be used to build a prototype database, which allows users to
validate the data model by demonstrating the consequences of data modeling decisions.
Maximum cardinality indicates whether or not an instance of one entity class must be
related to at least one instance of another entity class.
To run an SQL script, click the Execute button on the Query Toolbar.
For a workstation running the Windows operating system, the user file system
permissions Modify and Write must be granted to the Users group at the wwwroot
folder.
A database is self-describing because the user maintains a record of the database
structure outside the database itself.
To log into Oracle Database XE 11.2, use your personal account information.
One problem with storing duplicated data is the potential for inconsistent values.
Systems analysis and design is the process of creating and maintaining information
systems.
Every relation is a table, but not every table is a relation.
Databases are created in a DBMS during the implementation step.
Personal DBMS products, such as Microsoft Access, create a clear distinction between
the DBMS and the database application.
In Microsoft Visio 2013, the cardinalities of the relationshipare set using the Set Begin
Symbol and Set End Symbol commands.
Unlike SQL views, XML views are not limited to one multivalued path.
Microsoft Access 2013 uses the AutoNumber data type to create surrogate keys.
One way to prevent concurrent processing problems is to lock data that are retrieved for
update.
The SQL command CREATE VIEW is used to create view structures.
The basic idea of a join is to combine the contents of two or more relations into a new
relation.
In Microsoft Visio 2013, we can create database designs using:
A) Entity and Dynamic connector objects.
B) Entity and Relationship connector objects.
C) Category and Dynamic connector objects.
D) Category and Relationship connector objects.
E) We cannot create database designs in Microsoft Visio 2013.
________ provides the ability to sum, count, average and perform other simple
arithmetic operations on groups of data.
Which of the following is a reason that operational data are difficult to read?
A) Dirty data
B) Missing values
C) Non-integrated data
D) Both A and B
E) All of the above
Which of the following is not a standard data type used in SQL?
A) Text
B) Char
C) Varchar
D) Integer
E) Numeric
To place a table in a MySQL database design, start by clicking the:
A) Table button.
B) Entity button.
C) Place a New Table button.
D) Place a New Entity button.
E) None of the above
The IIS Web server is managed using the:
A) Microsoft Internet Information Service (IIS) Manager.
B) Microsoft SQL Server Management Studio.
C) Microsoft Visual Studio.
D) Microsoft IIS Workbench.
E) Microsoft Web Workbench.
What relationship pattern is illustrated in the following schema?
EMPLOYEE (EmployeeID, OfficePhone, Manager)
Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE
A) Association relationship
B) Intersection relationship
C) Recursive relationship
D) Strong entity relationship
E) Supertype/subtype relationship
SQL triggers are used for ________.
A) validity checking
B) providing default values
C) updating views
D) A and B
E) A, B, and C
In the MySQL Table Editor, the abbreviation for NOT NULL is:
A) PK
B) NN
C) UQ
D) BIN
E) AI
Business Intelligence (BI) ________ are used to filter data, sort data, group data and
make simple calculations based on the data.
Given 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?
A) UPDATE STUDENT SET Advisor = ‘Smith’;
B) MODIFY STUDENT SET Advisor = ‘Smith’;
C) MODIFY Advisor SET STUDENT = ‘Smith’;
D) UPDATE Advisor = ‘Smith’;
E) SET STUDENT Advisor = ‘Smith’;
The first step of the normalization process is to:
A) identify all the candidate keys of a relation.
B) identify all the foreign keys of a relation.
C) identify all the functional dependencies of a relation.
D) identify all the determinants of a relation.
E) split the relation into two or more new relations.
Which of the following SQL commands would be used to remove only the data from a
table named STUDENT while leaving the table structure intact?
A) DROP TABLE STUDENT;
B) DELETE TABLE STUDENT;
C) REMOVE TABLE STUDENT;
D) SELECT * FROM STUDENT THEN DROP;
E) DELETE FROM STUDENT;
Microsoft Access SQL commands are run in:
A) the SQL window.
B) the QBE window.
C) the Query View of an SQL window.
D) the Design View of a Query window.
E) the SQL View of a Query window.
The Microsoft Access 2013 report editor is a(n):
A) banded report editor.
B) wizard-based report editor.
C) ASCII report editor.
D) WYSIWYG report editor.
E) Web-based report editor.
Business Intelligence (BI) systems obtain their data by which of the following means?
A) Read and process data from an operational database
B) Process extracts from operational databases
C) Process data purchased from data vendors
D) Both A and B
E) All of the above
The first PHP element to be created is the:
A) Command object.
B) Connection.
C) Errors collection.
D) Parameters collection.
E) RecordSet object.
Given the tables
TABLE_A (Attribute1, Attribute2, Attribute3)
TABLE_B (Attribute4, Attribute5, Attribute6)
as shown in the figure below, which of the following would display the correct
placement of foreign keys in the relational model?
A) TABLE_A (Attribute1, Attribute2, Attribute3)
TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1)
B) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5)
TABLE _B (Attribute4, Attribute5, Attribute6)
C) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4)
TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1)
D) TABLE _A (Attribute1, Attribute2, Attribute3)
TABLE _B (Attribute4, Attribute5, Attribute6)
E) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute6)
TABLE _B (Attribute4, Attribute5, Attribute6)
We 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:
A) dirty data.
B) inconsistent data.
C) non-integrated data.
D) a “wrong format” problem.
E) a “too much data” problem.
Which type of lock assumes that no conflicts will occur?
A) Optimistic locks
B) Granular locks
C) Explicit locks
D) Shared locks
E) Open locks
Which of the following is not a function of the database application in a database
system?
A) Execute application logic
B) Control concurrency
C) Create and process forms
D) Create and transmit queries
E) Create and process reports
To create a new MySQL Workbench EER model, you can use:
A) the New Model button on the Home page.
B) the File | New Model command.
C) the Start new EER command.
D) A or B
E) All of the above
A new MySQL database is created using:
A) the new_database dialog box.
B) the Create Database command.
C) the new_schema dialog box.
D) the Create Schema command.
E) the New Object dialog box.
In the MySQL Workbench, a 1:N non-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.
The default Web page for the IIS Web server is:
A) startup.html.
B) startup.htm.
C) iistart.html.
D) iistart.htm.
E) index.html.
A document database may use either XML or JSON as the basis for storing data.
Whether or not an instance of one entity class must participate in a relationship with
another entity class is indicated by the:
A) degree.
B) recursive cardinality.
C) minimum cardinality.
D) maximum cardinality.
E) ordinality.
A relational database is:
A) a self-describing collection of related tables.
B) a collection of forms and reports that support a given purpose.
C) a library of queries and data files for querying.
D) a set of applications and the data sets for those applications.
E) a set of metadata.
Microsoft Access 2013 switchboards are built in a(n):
A) form window.
B) report window.
C) application window.
D) database design window.
E) All of the above
We have done an RFM analysis on our customer data. John Smith has a score of “5 1
1.” This means that John:
A) has ordered recently, and orders a lot when he orders.
B) hasn’t ordered recently, but orders a lot when he orders.
C) has ordered recently, but doesn’t order a lot when he orders.
D) hasn’t ordered recently, and doesn’t order a lot when he orders.
E) None of the above is correct.
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 Access, a relationship between two tables is created:
A) by entering the name of the foreign key in the appropriate table in Design View.
B) by entering the name of the primary key in the appropriate table in Design View.
C) by dragging the primary key column of one table onto the foreign key column of the
other table in the Relationships window.
D) by dragging the foreign key column of one table onto the primary key column of the
other table in the Relationships window.
E) by dragging the primary key column of one table onto the primary key column of the
other table in the Relationships window.
Which symbol is used in standard SQL as a wildcard to represent a series of one or
more unspecified characters?
A) % (percent sign)
B) ! (exclamation mark)
C) _ (underscore)
D) ? (question mark)
E) ; (semi-colon)
Users log into the Oracle Database XE 11.2 utility using the ________ account.
XML stands for ________.
Database designs are created during the ________ step.
Briefly describe the various tasks of the primary key.
The MySQL Workbench EER diagrams are actually ________ E-R diagrams.
Information systems are used to support ________.
The key that has been designated the ________ key of a relation functionally
determines all the other attributes in the relation.
According to the ODBC standard, a(n) ________ is a database and its associated
DBMS, operating system, and network platform.
When creating an OLAP report based on Access 2013 data, it is often a good idea to
create a(n) ________ query to organize the data needed for the OLAP report.
An important reason for using MySQL 5.6 Community Server Edition is that it has
________.
Describe how to create and run an SQL query in Oracle Database 11g Release 2
Express Edition.
Explain the process of using optimistic locking.
One of the major tasks of the database administration is called ________ control, which
allows multiple users to access the database simultaneously.
What is an XML Schema?
A new SQL Server database is created using the ________ dialog box.
What is a distributed database?
Explain how to create a relationship in Microsoft Access.
To control the placement of columns and rows in an Excel 2013 PivotTable, we use the
________.