The IDEF1X default cardinality of a nonidentifying connection relationship is
one-to-one, with a mandatory parent and an optional child.
Paradox is the only major survivor of the “bloodbath of PC DBMS products.”
Relations in BCNF have no modification anomalies in regard to functional
dependencies.
A checkpoint is a point of synchronization between the database and the transaction log.
Object identifiers may or may not be unique.
A data constraint is a limitation on data values.
The MySQL LOOP statement is used to repeat a set of SQL statements as long as some
condition is true.
In Microsoft Visio 2013, clicking the File command tab opens the Backstage view.
SQL views can be used to hide columns.
The SQL Server statement SELECT …FOR XML RAW tells SQL Server to place the
data values from the columns in the table into XML elements.
In the MySQL Table Editor, the abbreviation NN stands for NOT NULL.
A foreign key is one or more columns in one relation that also is the primary key in
another table.
Operational databases contain a fact table.
Stored procedures have the advantage of greater security, decreased network traffic,
SQL optimized by the DBMS compiler, and code sharing.
In SQL Server, insert and update triggers store new values in a pseudotable named
inserted.
To represent an N:M relationship in a relational database design, a table is created to
represent the relationship itself.
The classic systems analysis methodology is called the Analysis Development Life
Cycle (ADLC).
A report that is sent to users only upon the user’s request is called on-demand report.
Report management systems include the ability to create associated user accounts and
groups.
ID-dependent entities are a common type of weak entity.
A nested SELECT statement (one that appears within the WHERE clause of another
SQL statement) is called a subquery and must be enclosed in parentheses.
Reports that rely on the most current data when they are prepared are called dynamic
reports.
When designing or normalizing relations, each relation should have only one theme.
Only open source products may be used in conjunction with JDBC.
An SQL virtual table is called a view.
Database design is important, and fortunately it is simple to do.
Users should create a MySQL Workspace folder to hold documents created with the
MySQL Workbench.
MySQL Workbench is the MySQL GUI application development utility.
SQL Server 2014 provides two ways to create tablesgraphically and through SQL code.
XML stands for Extensible Markup Language.
Microsoft Access 2013 uses the Microsoft Office Fluent User Interface.
A database save is used to mark the end of a transaction.
JDBC-ODBC bridge drivers resolve inconsistencies between Java and C/C++ to allow
Java access to ODBC data sources.
SQL triggers use the ANSI SQL keywords BEFORE, INSTEAD OF, and AFTER.
DTD stands for Document Type Declaration.
A SELECT statement used in a WHERE clause is called a subquery.
NetBeans is a development environment that can be used for PHP program
development.
A multiple-tier ODBC driver may reformat an SQL request, but it does not actually
process the SQL statement.
The principal difference between an entity and a table is that you can express a
relationship between entities without using foreign keys.
For the M-O (parent mandatory, child optional) case, what action(s) should be taken to
ensure minimum cardinality is maintained?
A) Define referential integrity constraint from child to parent
B) Make foreign key NOT NULL
C) Will require trigger or other application code
D) Both A and B are correct
People are hired (if necessary) and trained during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
In an SQL query, which SQL keyword is used to link two conditions that both must be
true for the rows to be selected?
A) AND
B) EXISTS
C) OR
D) IN
In UML notation, the relationship line in a relationship with an non-ID-dependent weak
entity is labeled as ________.
A) <persistent>
B) <identifying>
C) <nonidentifying>
D) There is no label used.
In the UML-style entity class ORDERS shown above, “SumOfOrders” is ________.
A) an entity attribute
B) a method
C) a constraint
D) a class attribute
Microsoft Access is a good tool for forms and reports because ________.
A) the form and report generators do not exist within Access itself
B) Access forms and reports are very simplistic
C) Access wizards make it easy to create the forms and reports
D) Access has a version of Microsoft PowerPoint built into it to allow easy creation of
PowerPoint slide shows
In database systems, the DBMS enforces rules about which data can be written in
certain columns. The rules are known as ________.
A) data insertion control
B) data modification control
C) concurrency control
D) referential integrity constraints
An example of a document database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
XML documents that are not-type-valid can still be ________.
A) DTD-valid
B) XML-valid
C) DTD-compliant
D) proper XML documents
An important improvement of XML Schema over DTDs is that ________.
A) XML Schema can be stored external to the document
B) XML Schema support XQL queries
C) XML Schema are XML documents
D) XML Schema are not required
Business Intelligence (BI) systems fall into which of the following categories?
A) Processing
B) Reporting
C) Data mining
D) Both B and C are correct
Changing cardinalities ________.
A) never occurs in database redesign
B) rarely occurs in database redesign
C) commonly occurs in database redesign
D) always occurs in database redesign
XML documents that conform to an XML Schema are validated against that schema.
Which of the following is true of JDBC?
A) Programs must be written in Java.
B) JDBC only works with open-source products.
C) JDBC is only available for Unix-like operating systems, such as Linux.
D) JDBC is actually a DBMS.
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
Which of the following would indicate a minimum cardinality of 1 and a maximum
cardinality of many in UML notation?
A) 1:N
B) 1 .. N
C) 1 .. *
D) 1:*
The SQL command used to create a virtual table is ________.
A) CREATE VTABLE
B) CREATE VIEW
C) VTABLE
D) VIEW
Because SQL statements are table-oriented, whereas programs are element-oriented, the
results of SQL statements used in programs are accessed using ________.
A) standard programming tools
B) custom written programming tools
C) an SQL cursor
D) an SQL trigger
A series of actions to be taken on the database such that either all actions are completed
successfully, or none of them can be completed, is known as a ________.
A) checkpoint
B) log
C) lock
D) transaction
If the table PRODUCT has a column PRICE that has the data type Numeric (8,2), the
value 12345 will be displayed by the DBMS as ________.
A) 123.45
B) 12345
C) 12345.00
D) 123450.00
A relation is also known as a(n) ________.
A) table
B) tuple
C) relationship
D) attribute
In PHP, any programming language statements that are to be processed on the server
must be enclosed in ________.
A) <!– and –!>
B) [php and php]
C) (php and php)
D) <?php and ?>
For database/XML applications, a good rule to follow is that elements are used to carry
data and attributes are used to carry metadata.
A for-use-by pattern must involve what kind of entity?
A) Strong entity
B) Supertype entity
C) Weak entity with one identifying relationship
D) Weak entity with two identifying relationships
Which of the following is not true about XSLT?
A) It requires the use of CSS.
B) It is a transformation language.
C) It can materialize XML documents into HTML.
D) It is a declarative language.
When creating tables, Oracle Database automatically converts the SQL standard data
type “int” into ________.
A) number (38,0)
B) integer (32)
C) number (5,0)
D) integer (16)
A relation is in fourth normal form if it is in BCNF and it has no ________.
A) transitive dependencies
B) multivalued dependencies
C) partial dependencies
D) deletion dependencies
An ad-hoc query is ________.
A) a question about the data that requires a program to be written
B) a question that can be answered from the database using SQL
C) a question that can be answered only by combining several SQL queries
D) never useful in Business Intelligence scenarios
An ADO.NET Data Provider is a(n) ________ that provides ADO.NET services.
A) class library
B) windows application
C) Web application
D) XML service
Complex networks can be represented by reducing them to simple networks, and then
representing the simple networks using ________.
A) indexes or linked lists
B) linked lists or sequential lists
C) sequential lists or indexes
D) trees