Sequences are most often used to provide values for surrogate keys.
Oracle Database XE 11.2 uses Application Express to create new workspaces.
For a column to be defined as the primary key using table constraints, the column must
have been given the property NULL.
The Oracle DBMS supports the SQL BEFORE trigger.
Unified Modeling Language (UML) has quickly replaced the E-R Model as the most
popular technique for creating data models.
When creating an OLAP report based on Access 2013 data, it is often a good idea to
create a view equivalent query to organize the data needed for the OLAP report.
An important reason for using MySQL Community Server 5.6 is that it has full SQL
capabilities.
SQL query results are displayed in a tabbed results window.
When used to represent a relationship, the primary key must have the same name as the
corresponding foreign key.
A new SQL Server database is created using the New Database dialog box.
Information systems must be both developed and used to help businesses reach their
goals and objectives.
In the general division of labor between database applications and the DBMS, the
application program formats the results of a query into a report.
Lock granularity refers to whether a lock is placed by the DBMS automatically or is
placed by a command from the application program.
In Microsoft Access, foreign keys are designated by using the Foreign Key button in the
toolbar.
SQL views can be used to display the results of computed columns.
Relational database tables are commonly combined, queried, and processed using
Structured Query Language (SQL).
In SQL, multiple conditions in the WHERE clause can be combined by using the SQL
AND keyword.
Database designs are created during the component design step.
The technique for representing E-R relationships in the relational model is dependent
on the minimum cardinality.
Business Intelligence (BI) systems obtain data in three different ways.
Microsoft Visio 2013 is a component of Microsoft Office 2013.
Data from a maximum of three tables can be combined through the use of subqueries in
SQL.
In comparison to reprocessing, rollforward does not involve the application programs.
The first step in representing entities using the relational model is to determine which
identifier will be used as the key.
In Microsoft Visio 2013, the arrow end of the Relationship connectorobject points to the
table containing the foreign key.
Report delivery is more difficult for data mining than it is for reporting systems.
XML Web Services is a means for protecting and hiding elements of program
functionality that otherwise would be available for misuse over the Web.
In the general division of labor between database applications and the DBMS, the
processing of forms is considered a DBMS task.
Database security is easy to achieve since all security is handled by the DBMS, which
is a single point of entry into the database.
XML Schema is a synonym for Document Type Declaration (DTD).
Application programs are responsible for creating, maintaining, and supporting
database backup and recovery systems.
When Microsoft Access 2013 uses user-level security with an Access 2003 file, the
database is stored in a(n) *.accdb file.
Basic Web pages are created using Hypertext Markup Language (HTML).
Microsoft Access is a personal database system, and a personal database system is
characterized by:
A) the DBMS removing the metadata from the database.
B) the DBMS product taking the role of the DBMS and the database application
generator.
C) the database being stored inside the DBMS.
D) the DBMS product being limited to a maximum of ten tables in any given database.
E) the DBMS not supporting indexes.
Which of the following cannot be done using the CONSTRAINT phrase?
A) Create a single attribute primary key.
B) Define a foreign key.
C) Establish a referential integrity constraint.
D) All of the above can be done using the CONSTRAINT phrase.
E) None of the above can be done using the CONSTRAINT phrase.
Data is composed of:
A) facts.
B) numbers.
C) information.
D) A and B
E) A, B and C
A report generated by a reporting system is delivered to the appropriate users via an
electronic display customized for each user. This system uses which of the following
media?
A) Paper
B) Web portal
C) Digital dashboard
D) E-mail
E) None of the above
In Microsoft Access, the relationship between two tables is not actually created until:
A) the OK button in the Create Relationships dialog box is clicked.
B) the Create button in the Create Relationships dialog box is clicked.
C) the OK button in the Edit Relationships dialog box is clicked.
D) the Create button in the Edit Relationships dialog box is clicked.
E) the Join button in the Edit Relationships dialog box is clicked.
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 crow’s foot style E-R diagrams, a crow’s foot mark on the relationship line near an
entity indicates:
A) a minimum cardinality of zero.
B) a minimum cardinality of one.
C) a maximum cardinality of one.
D) a maximum cardinality of many.
E) Both B and C
Computer systems fail for which of the following reasons?
A) Hardware breaks.
B) Electrical power fails.
C) Programs have bugs.
D) People make mistakes.
E) All of the above
XML documents that conform to their DTD are said to be ________.
A) DTD-valid
B) XML-valid
C) DTD-compliant
D) not-type-valid
E) type-valid
Stored procedures have the advantage of ________.
A) greater security
B) decreased network traffic
C) SQL optimized by the DBMS compiler
D) code sharing
E) All of the above
Which of the following would not be contained in a use case?
A) Inputs provided to the system to perform a task
B) A description of a task the user wants to perform
C) A prototype of the system performing a given task
D) Outputs generated by the system in performing a given task
E) All of the above would be contained in a use case.
SQL query results are displayed:
A) in a tabbed results window.
B) in a tabbed Results1 window.
C) in a tabbed Document window.
D) in a tabbed Messages window.
E) in a tabbed Finished window.
If the computer hosting the Web server is running a Windows operating system, the
Web server is probably:
A) Apache.
B) Tomcat.
C) Internet Information Services (IIS).
D) Internet Interpreter Server (IIS).
E) Information Interpreter Server (IIS).
Microsoft Access:
A) supports standard SQL view statements.
B) only supports SQL view statements as QBE constructions.
C) can store a view equivalent Access query.
D) can store a view equivalent Access query but does not provide a means to use it.
E) cannot store any database object that is equivalent to an SQL view.
Which of the following data types used in SQL would define a fixed-length text field of
10 characters?
A) text(10)
B) char(10)
C) varchar(10)
D) fixed(10)
E) length(10)
PHP was most recently ranked as the ________ most popular programming language.
A) 3rd
B) 4th
C) 5th
D) 6th
E) 7th
When Microsoft Access 2013 uses user-level security with an Access 2003 file, the
database is stored in a(n):
A) *.accdb file.
B) *.accdc file.
C) *.accde file.
D) *.mdb file.
E) *.mdw file.
Which of the following is not true about document type declarations for XML
documents?
A) They are not required.
B) They are required for type-valid documents.
C) They cannot be contained inside the XML document.
D) Storing the DTD externally allows many documents to be validated against the same
DTD.
E) The DTD can be extended by the developer with any elements he or she wants to
include.
XML stands for ________.
A) Experimental Markup Language
B) Extendable Markup Language
C) Extensible Markup Language
D) Active X-control Markup Language
E) Active X-control Management Language
Given only the following excerpt of an E-R model:
Which of the following is known to be true?
A) A single instance of ENTITY A must be related to one instance of ENTITY B.
B) Many instances of ENTITY A may be related to one instance of ENTITY B.
C) ENTITY B has a degree of many.
D) ENTITY B is a weak entity.
E) Both A and C are true.
The CAP Theorem defines three properties of distributed database systems, which are:
A) consistency, always-on, properties.
B) competency, always-on, properties.
C) consistency, availability, partition tolerance.
D) competency, availability, partition tolerance.
E) consistency, availability, properties.
In order 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) Both A and B are used together.
E) None of the above is correct – no login is required.
DBMS objects are displayed:
A) in the Navigator Pane.
B) in the Object Browser.
C) in the tabbed database window.
D) in the tabbed document window.
E) in the command tab.
The term drill down means the user wants to:
A) summarize data.
B) get older data.
C) sort data.
D) get more details.
E) aggregate data.
SOAP originally stood for ________.
A) Simple Operational Application Protocol
B) Standard Operational Application Protocol
C) Simple Object Application Protocol
D) Simple Object Access Protocol
E) Standard Object Access Protocol
Data models are created during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
The MySQL Workbench can be used to create:
A) data models.
B) data designs.
C) database models.
D) database designs.
E) database diagrams.
The default cardinality for elements in an XML Schema is ________.
A) 0.1
B) 1.1
C) 1.N
D) N.1
E) M.N
When transforming an E-R data model into a relational database design, the key of the
parent entity should be placed as part of the primary key into the child entity ________.
A) when the child entity is ID-dependent
B) when the child entity is non-ID-dependent
C) when the child entity has a 1:1 relationship with the parent entity
D) when the child entity has a 1:N relationship with the parent entity
E) when the child entity has a recursive relationship with the parent entity
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
E) XML Schema can validate XML documents
A relational database stores data in the form of:
A) lists.
B) forms.
C) columns.
D) tables.
E) spreadsheets.
XML allows a programmer to:
A) define elements.
B) use only predefined elements.
C) use only “shrink-warped,” purchased programs.
D) Both A and B
E) All of the above
A(n) ________ is a collection of data that addresses a particular component or
functional area of a business.
SQL query results are displayed in a tabbed ________ window.
The unique keys that are not chosen to be the primary key are called ________ keys.
What is denormalization and why can it be desirable?
What are the elements of a graph database?
Define and briefly describe the function of ODBC.
Since an SQL view is essentially a stored query, Microsoft Access ________ can be
used to implement SQL view equivalents.
The SQL command ________ is used to create a virtual table.
Explain sequences and their relationship to surrogate keys.
SQL views can be used to display the results of ________.
Distinguish between the HAVING clause and the WHERE clause.
Write the schema to represent the entities below, including tables, the proper placement
of the foreign key, and referential integrity constraint.
A new MySQL Server database is known as a new ________.
What is XML, and why is it useful?
In Microsoft Visio 2013, how do we create database designs?
The Oracle Database ODBC Client is installed ________ when Oracle Database
Express Edition 11g Release 2 is installed.
Microsoft Access 2013 switchboards build command buttons by using the ________.
________ can be used to build prototype databases.