Microsoft Access is just a DBMS.
The IIS Web server is managed using the Microsoft Internet Information Service (IIS)
Manager.
With Oracle Database, data must be entered at the Oracle Database command prompt.
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 1:N
Non-identifying Relationship button.
Database designs are created during the component design step.
There is no good SQL command that can be used to change table names.
To refer to a set of values in a condition, the values are placed inside parentheses ( ) and
separated by commas.
You can use the Edit Table table editor to create an index in Oracle Database.
Processing rights may be implemented at the DBMS level.
In the database redesign process, two SQL tools are useful for testing whether or not
certain conditions or assumptions are valid: uncorrelated subqueries and EXISTS/NOT
EXISTS.
Facebook uses the Apache Software Foundation’s Cassandra NoSQL database.
The default Web page for the IIS Web server is index.html.
Only two tables can be queried by using a subquery.
Table names are edited in the MySQL EER Component Editor.
A missing value is called a null value.
The SQL built-in function COUNT computes the number of rows in a query.
MySQL databases are backed up using the MySQL Backup System.
When examining data values as a part of assessing table structure, you should try to
determine two types of dependencies: functional dependencies and multivalued
dependencies.
IDEF1X category entities are mutually exclusive within a cluster.
In Microsoft Visio 2013, we can create database designs using Entity and Dynamic
connector objects.
SQL includes a data definition language, a data manipulation language, and
SQL/Persistent stored modules.
One of the important properties of an attribute is whether or not it is required.
In UML, cardinalities are represented by an x .. y format.
A null value in a column may indicate that there is an appropriate value for that
attribute, and although the value is known, no one has entered the value into the
database.
If a server is using a Microsoft Windows operating system, it is usually running Internet
Information Server (IIS) as its Web server.
A data warehouse is a database system that has data for, programs for, and personnel
specialized in BI processing.
IDEFIX domains are numbered sets of values.
The Oracle Database Configuration Assistant is the easiest Oracle Database tool to use
when you are creating an Oracle database.
The MySQL Installer for Windows can be used to install the MySQL Workbench.
The term drill down refers to the capability of seeing the data in smaller and smaller
units.
The notation 1:N shows a relationship’s maximum cardinalities.
Database objects are displayed in the Object Explorer window in the MySQL
Workbench.
The SQL IS NULL keyword can be used to count the number of nulls in a column.
In SQL Server, locking behavior can be modified by providing locking hints in the
WITH parameter of the FROM clause in SELECT statements.
According to the ODBC standard, which of the following is not part of the specification
of a data source?
A) The associated DBMS
B) The database
C) The driver
D) The operating system
Star schemas have a ________ at the center of the star.
A) fact table
B) dimension table
C) map table
D) reduce table
The final step of using a PHP connection to a DBMS is to ________.
A) open the connection
B) test the connection
C) close the connection
D) process the query results
In UML, an attribute that is accessible only by methods of its entity class or of its
subclasses is said to be ________.
A) private
B) exclusive
C) protected
D) public
Suppose tables EMPLOYEE and CUSTOMER both store address information, and you
want to send a letter to all employees and customers of your company to make a major
announcement. Which SQL keyword would you most likely use here?
A) INTERSECT
B) UNION
C) UNION ALL
D) JOIN
XML documents that conform to their DTD are said to be ________.
A) type-valid
B) XML-valid
C) DTD-compliant
D) not-type-valid
What is the Database Configuration Assistant (DBCA)?
To represent a one-to-many relationship in a relational database design, ________.
A) the key of the child is placed as a foreign key into the parent
B) the key of the parent is placed as a foreign key into the child
C) an intersection table must be created
D) the key of the table on the “many” side is placed in the table on the “one” side
Which of the following is a function performed by the driver manager in ODBC?
A) Submit SQL statements to the data source
B) Determine the type of DBMS that processes a given ODBC data source
C) Load the appropriate ODBC driver into memory
D) Both B and C are correct
The MySQL Installer for Windows should be used to install MySQL Community
Edition components on computers running which operating system(s)?
A) Microsoft Windows
B) Unix
C) Linux
D) Both B and C are correct
To format a PivotTable in Microsoft Excel 2013, we use the ________.
A) Design command tab in the PivotTable Tools contextual command tab
B) Format command tab in the PivotTable Tools contextual command tab
C) Design command tab in the Report Tools contextual command tab
D) Format command tab in the Report Tools contextual command tab
Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate),
which of the following would find all employees whose name begins with the letter “S”
using Microsoft Access?
A) SELECT *
FROM EMPLOYEE
WHERE Name IN [‘S’];
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE ‘S’;
C) SELECT *
FROM EMPLOYEE
WHERE Name LIKE ‘S*’;
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE ‘S%’;
The SQL Server statement
SELECT *
FROM Table01
FOR XML RAW
tells SQL Server to place the data values from the columns in the table into XML
________.
A) elements
B) attributes
C) either elements or attributes, as chosen by SQL Server
D) either elements or attributes, as designated by the developer
In Windows, to use MySQL Workbench to create database designs, you must log into
MySQL using ________.
A) the Connect to Database dialog box
B) the Connect to MySQL Server dialog box
C) the MySQL | Connect to Server command
D) No login is required
A view may not be assigned to a(n) ________.
A) BEFORE trigger
B) INSTEAD OF trigger
C) CONCURRENT trigger
D) AFTER trigger
If you have a foreign key in a CUSTOMER table that references the primary key in a
SALESREP table, the ON DELETE CASCADE syntax means that ________.
A) when a CUSTOMER is deleted, that CUSTOMER’s SALESREP is also deleted
B) when a CUSTOMER is deleted, all SALESREPS are also deleted
C) when a SALESREP is deleted, all CUSTOMERs of that SALESREP are also deleted
D) when the SALESREP table is dropped, all CUSTOMERs must be deleted
A data source that is local to a single computer and can be used by the operating system
and any user on that computer is called a ________ data source.
A) file
B) user
C) shared
D) system
An SQL virtual table is called ________.
A) a CHECK constraint
B) a view
C) embedded SQL
D) a trigger
A form of multivalued dependency is found in ________.
A) the multivalued, multicolumn problem
B) the inconsistent values problem
C) the missing values problem
D) the general-purpose remarks column problem
XML stands for ________.
A) Experimental Markup Language
B) Extendable Markup Language
C) Extensible Markup Language
D) Active X-control Markup Language
The ________ processes ODBC requests and submits specific SQL statements to a
given type of data source.
A) driver manager
B) ADO
C) driver
D) source converter
The “M” in RFM analysis stands for ________.
A) money
B) mostly
C) modest
D) modern
Business Intelligence (BI) systems obtain their data by all of the following means
except ________.
A) read and process data from an operational database
B) triggers defined on the operational database
C) process data purchased from data vendors
D) process extracts from operational databases
An online drugstore such as Drugstore.com is an example of a(n) ________.
A) single-user database application
B) multiuser database application
C) e-commerce database application
D) enterprise resource planning system
Locks that are placed assuming that a conflict will not occur are called ________.
A) dynamic
B) shared
C) pessimistic
D) optimistic
Which of the following is not included in Michael Porter’s list of primary or operational
activities?
A) Procurement
B) Inbound logistics
C) Manufacturing operations
D) Outbound logistics
During the database redesign process, you discover that when you try to change a
DEPARTMENT name (the department’s primary key), the change is disallowed by the
DBMS due to your design of the EMPLOYEE table (which has a foreign key
referencing DEPARTMENT) You want the change to be allowed. In order to fix this,
you use what SQL syntax?
A) ON UPDATE CASCADE
B) ON DELETE CASCADE
C) ADD CONSTRAINT
D) FOREIGN KEY
Which of the following is not true of MUST constraint?
A) It may be needed in ternary relationships to enforce special business rules.
B) It can be expressed directly in a relational model.
C) It must be enforced by program code.
D) It requires that one entity be combined with another entity.
A dependency graph should include all of the following except ________.
A) tables
B) views
C) triggers
D) DEFAULT values
When dropping a nonkey column from a table, which of the following steps is (are)
included in the process? (The order of the steps listed below is not relevant, only the
steps themselves.)
A) Drop any column constraints from the table
B) Drop the column from the table
C) Drop any foreign keys constraints based on the column
D) Both A and B are correct