Microsoft Access is a personal database that combines a DBMS with an application
generator.
A complex network is a collection of records and the 1:N relationships between them.
Unlike SQL views, XML views are not limited to one multivalued path.
Repeatable Read isolation is the most restrictive level of isolation.
A two-way linked list has links in both directions.
A MySQL data backup is accomplished by using the “Data Export” feature.
The MySQL Table Editor is accessible from the MySQL Workbench.
When viewing the SQL Server list of tables in a database, dbo means “domain base
object” and indicates a system table.
In addition to the basic command tabs, Microsoft Access 2013 also has additional
contextual command tabs.
MySQL concurrency options include four scopes for the transaction isolation level:
GLOBAL, LOCAL, SESSION and TRANSACTION.
The database application is responsible for concurrency control.
Persistent means that data should continue to exist in the database even if the object that
processes it is destroyed.
The goal of database security is to ensure that only authorized users can perform
authorized activities at authorized times.
A dynamic cursor saves primary key values when the cursor is opened and retrieves the
values for each row as the application program accesses it.
A static cursor processes a snapshot of the relation that was taken when the cursor was
opened.
A “composite object” cannot contain more than one multivalued attribute.
The third step in assessing table structure is to check the validity of presumed
referential integrity constraints.
If you have a table with a set of columns named “Child01”, “Child02” and “Child03”,
the table is likely to have the multivalued, multicolumn problem.
MySQL Workbench is the MySQL GUI database administration utility.
The NoSQL movement should really be called a NoRelational movement.
To obtain all columns, use an asterisk (*) wildcard character instead of listing all the
column names.
Rollforward is a method of database recovery that restores the database save and all
valid transactions since the save was reapplied.
Transaction level consistency means that all rows impacted by any actions in a
transaction are protected from change during the entire transaction.
MySQL users must be granted the right to have MySQL schema privileges before the
specific privileges themselves are granted.
One situation created by the multivalued, multicolumn problem is that the maximum
number of data values for an attribute is limited.
When creating an OLAP report based on SQL Server 2014 data, it is often a good idea
to create a view to organize the data needed for the OLAP report.
Oracle Database supports the ON UPDATE CASCADE constraint.
A surrogate key is a unique, system-supplied identifier used as the primary key of a
table.
Report modes include dynamic and static.
Metadata about the data’s source, format, assumptions, and constraints are kept in a data
warehouse metadata database.
ID-dependent entities are associated by a nonidentifying relationship.
Relationships between supertypes and subtypes are called IS-A relationships.
ADO is accessible from languages such as C++ and C#, but not Visual Basic or
scripting languages.
The SQL keyword CONSTRAINT can be used in conjunction with the SQL keywords
PRIMARY KEY and FOREIGN KEY.
The default transaction isolation level for SQL Server is Read Committed.
You are creating a BOAT table using existing data from multiple sources, and you find
that you have “power boat blue”, “boat, power, blue” and “blue power boat” as data
values for the same column. This is an example of the inconsistent values problem.
With Oracle Database, stored procedures cannot use a cursor variable, so another
method must be used to access a table on a row by row basis.
During the second step of assessing table structure, you are trying to determine
________.
A) relationships
B) candidate keys
C) updatability
D) efficiency
For a relationship to be considered a binary relationship it must satisfy which of the
following conditions?
A) It must involve exactly two entity classes.
B) It must have a maximum cardinality of 1:1.
C) It must have a maximum cardinality of 1:N.
D) Both A and B are correct
Which of the following statements would cause Oracle Database to include a new
column named C5, which is a two-digit whole number, to a table named T2?
A) UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2);
B) ALTER TABLE T2 ADD C5 NUMBER (2);
C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0);
D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0);
Measures that are taken to prevent one user’s work from inappropriately influencing
another user’s work are called ________.
A) concurrency control
B) checkpoint
C) database recovery
D) database logging
Because SQL statements are set-oriented, whereas programs are element-oriented, the
results of SQL statements used in programs are treated as ________.
A) tables
B) rows
C) files
D) pseudofiles
When making an SQL query, we are using SQL as a(n) ________.
A) DDL
B) DML
C) embedded language
D) SET
In the MySQL Table Editor, the abbreviation for AUTO_INCREMENT is ________.
A) PK
B) NN
C) UQ
D) AI
In Microsoft Visio 2013, for a Relationship object relationship that is one-mandatory on
the child side of the relationship, the correct setting in the Symbol menu is ________.
A) 1 and only 1
B) 1 or more
C) Zero or 1
D) Zero or more
A group identifier ________.
A) has more than one attribute
B) identifies a group of instances
C) identifies a group of attributes in an object
D) is the identifier for a group of semantic objects
A reporting system does not maintain a database of metadata.
A ________ data source can be shared among database users as long as they have the
same DBMS driver and privilege to access the database.
A) file
B) common
C) user
D) system
The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements as
long as some condition is true is ________.
A) DECLARE
B) BEGIN
C) IF…ELSE…END IF
D) LOOP
Regarding the interchangeability of subqueries and joins, ________.
A) a join can always be used as an alternative to a subquery, and a subquery can always
be used as an alternative to a join
B) a join can sometimes be used as an alternative to a subquery, and a subquery can
sometimes be used as an alternative to a join
C) a join can always be used as an alternative to a subquery, and a subquery can
sometimes be used as an alternative to a join
D) a join can sometimes be used as an alternative to a subquery, and a subquery can
always be used as an alternative to a join
The MySQL statement used to define a set of MySQL procedure statements is
________.
A) DECLARE
B) BEGIN
C) IF…THEN…ELSE…END IF
D) REPEAT
Which of the following is a tool for managing an existing Oracle Database database?
A) The Oracle Enterprise Manager Database Express
B) The Oracle SQL*Plus command utility program
C) The Oracle SQL Developer
D) The Oracle DBA Manager
In the following sample JSON data (presented in MongoDB syntax), the word
“addesses” is a ________.
{
_id: 555667777,
name: “Tierney, Doris”,
majors: [“Music”, “Spanish”],
addresses: [
{
street: “14510 NE 4th Street”,
city: “Bellevue”,
state: “WA”,
zip: “98005”
},
{
street: “335 Aloha Street”,
city: “Seattle”,
state: “WA”,
zip: “98109”
}
],
advisorID: “Advisor1”
}
A) value list
B) object identifier
C) field name
D) value
Which trigger type(s) does MySQL support?
A) BEFORE
B) AFTER
C) INSTEAD OF
D) Both A and B are correct
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
In IDEF1X, extended E-R model 1:N relationships are called ________.
A) nonidentifying connection relationships
B) identifying connection relationships
C) nonspecific relationships
D) category clusters
Which of the following statements is not true concerning the MySQL for Excel Add-In?
A) It must be installed into MySQL before importing from Excel can be performed.
B) The user must enter a password to connect to the MySQL instance.
C) The data must first be normalized before importing.
D) The user can modify some of the table characteristics before the actual data transfer.
A default value is the value the user enters into the row the first time the user enters
data.
Which of the following statements is not true about client-server architecture?
A) The client initiates a request.
B) The server is usually a tablet or smartphone.
C) The server usually runs the DBMS on it.
D) Most Web applications are supported by client-server.
In IDEF1X, a category cluster includes BLACK and WHITE, but does not show GREY,
which is also a possible category. This is an IDEF1X ________.
A) complete category cluster
B) incomplete category cluster
C) inherited category cluster
D) inconclusive category cluster
The XML Schema statement xmlns:xsd indicates that ________.
A) this XML Schema uses a labeled namespace calledxsd
B) this XML Schema is validated at www.xsd.com
C) this XML Schema is validated at www.xmlns.com using the xsd XML Schema
located there
D) this XML Schema is using a non-standard looping procedure, where xsd is the
variable name of the loop increment
A stored program that is attached to the database is called ________.
A) a view
B) embedded SQL
C) a trigger
D) a stored procedure
Based on the tables below, which of the following commands in ANSI SQL would
return only the name of the sales representative and the name of the customer for each
customer that has a balance greater than 400?
GENERAL SALES DATABASE:
SALESREP
CUSTOMER
A) SELECT *
FROM SALESREP, CUSTOMER
WHERE Balance > 400;
B) SELECT DISTINCT RepName, CustName
FROM SALESREP, CUSTOMER
WHERE Balance > 400;
C) SELECT *
FROM SALESREP, CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400;
D) SELECT RepName, CustName
FROM SALESREP, CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400;
Which of the following is not a type of trigger supported by SQL Server?
A) BEFORE
B) INSTEAD OF
C) CONCURRENT
D) Both A and C are correct
Which of the following is true about SQL Server Import and Export Wizard?
A) SQL Server Native Client should be selected as the destination.
B) The user can’t specify that the column names are in the first row.
C) There are no problems with modifying the default column attributes.
D) The user can specify the primary key to be set on the imported table.
For a workstation running the Windows operating system, the user file system
permissions Modify and Write must be granted to ________ at the wwwroot folder.
A) the ISUR_{WebServerName} User
B) the IAPP_{WebServerName} User
C) the WebUsers group
D) the Users group
In a minimum cardinality, minimums are generally stated as ________.
A) 0 or 1
B) 1 or N
C) M or N
D) one or many
Which of the following SQL statements is a correctly stated correlated subquery?
A) SELECT C1.CustName, C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT S1.SalesRepNo
FROM SALESREP S1
WHERE S1.RepName = ‘Smith’);
B) SELECT C1.CustName, C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT S1.SaleRepNo
FROM SALESREP S1
WHERE S1.RepName = ‘Smith’)
AND C1.SalesRepNo=S1.SalesRepNo);
C) SELECT C1.CustName, C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT S1.SaleRepNo
FROM SALESREP S1
WHERE S1.RepName = ‘Smith’)
AND C1.SalesRepNo<>S1.SalesRepNo);
D) SELECT C1.CustName, C1.SalesRepNo
FROM CUSTOMER C1
WHERE C1.SalesRepNo IN
(SELECT C2.SaleRepNo
FROM CUSTOMER C2
WHERE C1.SalesRepNo=C2.SalesRepNo);
AND C1.OrderNo<>C2.OrderNo);
OLE DB breaks the features and functions of a DBMS into what type of objects?
A) COM
B) JSP
C) MTS
D) ODBC
XML stands for ________.
A) Experimental Markup Language
B) Extendable Markup Language
C) Extensible Markup Language
D) Active X-control Markup Language
Explain the concept of semantic objects as being a sufficient description.
What is XML, and why is it significantly better than HTML?
Describe the database files that are automatically created when a new database is
created in SQL Server.
Give an example of how XML can be used with a DBMS.
Briefly explain the different SQL Server recovery models.
Distinguish between statement-level consistency and transaction-level consistency.
Explain the Oracle Database PL/SQL control-of-flow statements.
Why is operational data sometimes unusable for Business Intelligence (BI) use? Include
at least two examples.
Explain why semantic object attributes are called paired attributes.
Explain the steps in the process of putting a relation straight into Boyce-Codd Normal
Form (BCNF).
What is the NoSQL movement?
What is an association relationship and how does it differ from an N:M relationship?
What is a conformed dimension?
Explain the concept of an atomic transaction.
What symbols are used in IDEF1X diagrams to represent cardinalities?
How are entity classes drawn in UML-style E-R diagrams?
What is the multivalue, multicolumn problem, and why is it a problem? Include an
example.
What is a correlated subquery? Include an example.