In a correlated subquery, the DBMS must run the lower SELECT statement as a process
that is nested within the upper SELECT statement.
In SQL Server, triggers can roll back the transaction that caused them to be fired.
To execute an SQL query, click the “Execute the selected portion of the script or
everything, if there is no selection” button.
With Oracle Database, you can change the default transaction isolation for all
transactions in a session by using the SET TRANSACTION ISOLATION LEVEL
statement.
Reprocessing is normally the most convenient method for recovery after a system
failure.
Read-only databases are often updated.
SQL views can be used to provide a level of insulation between data processed by
applications and the data actually stored in the database tables.
The continuous circular process of changes is known as the Systems Development Life
Cycle (SDLC).
A stored program that is stored within the database and compiled when used is called a
trigger.
The values in an SQL view are not always changeable through the view itself.
A data mart is a collection of data that addresses a particular component of functional
area of a business.
When examining data values as a part of assessing table structure, you should try to
determine three types of keys: the primary key, any candidate keys, and any foreign
keys.
Oracle Database does not require the use of Archive ReDo files for instance recovery.
Each Oracle Database tablespace has one or more datafiles associated with it.
In functional dependencies, the attribute whose value is known or given is referred to as
the determinant.
EXISTS and NOT EXISTS are actually just another form of correlated subqueries.
Although correlated subqueries are useful in database redesign, they cannot be used to
verify functional dependencies.
When you use the Microsoft SQL Server Management Studio to run and rerun a set of
SQL Server DBMS commands stored in a text file, the stored procedure must start with
CREATE PROCEDURE.
A relation is a table composed of columns and rows.
Multivalued dependencies show up under a different name as the multivalued,
multicolumn problem.
When the parent entity is required (M) in a relationship, every row of the child table
must have a valid, non-null value of the foreign key.
Attribute Y is functionally dependent on attribute X if the value of attribute X
determines the value of Y.
Semantic objects represent the user’s perceptions more closely than the E-R model.
To start working with MySQL Community Edition in Windows, use the command Start
| All Programs | MySQL | MySQL Workbench CE 6.2. (or the version number you have
installed).
With pessimistic locking, the assumption is made that a conflict will occur.
Normalization is an advantage for a read-only database.
In UML-style E-R diagrams, a weak entity is shown by placing a filled-in diamond on
the parent of the weak entity.
MySQL is configured using the MySQL Server Instance Configuration Wizard.
Recursive relationships only exist for one-to-one relationships.
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.
SQL Statements can be submitted to SQL Server from the Microsoft SQL Server
Management Studio.
Before installing theNetBeans IDE, we have to install ________.
A) the Java JRE
B) Microsoft IIS server
C) PHP
D) the PHP plugin
A combination of one or more columns used to identify particular rows in a relation is a
________.
A) record
B) field
C) key
D) tuple
Business Intelligence (BI) systems are information systems that help users analyze and
use data.
Which of the following is true about the functional dependency (A, B) → (C, D)?
A) A is the determinant of C.
B) A and B together are determined by C and D together.
C) A and B together determine D.
D) C and D together determine A.
In database systems, the DBMS enforces rules about which user can perform which
action when. The rules are known as ________.
A) referential integrity constraints
B) data modification control
C) data reading control
D) concurrency control
Which of the following would not be contained in a transaction log?
A) Before images
B) Type of operation
C) Time of the action
D) Permissions
A hash mark across the relationship line near an entity indicates ________.
A) a maximum cardinality of “zero”
B) a maximum cardinality of “one”
C) a minimum cardinality of “optional”
D) a minimum cardinality of “required”
Which of the following is not true of ADO?
A) ADO is a simple object model for OLE DB data consumers.
B) ADO can be used from VBScript and JavaScript.
C) ADO is harder to understand than OLE DB.
D) ADO can be called from languages such as Visual Basic.NET, Java and C#.
Which statement is not true about the relational model?
A) It was first proposed in 1970.
B) It was developed by E. F. Codd.
C) It was developed at Oracle.
D) It resulted in the DBMS product DB2.
In Microsoft Visio 2013, the cardinalities of the Relationship connector object end
points are formatted using ________.
A) the Set Begin Symbol command
B) the Set End Symbol command
C) the Set Non-primary Key Unique column
D) Both A and B are correct
The binary constraint must cover indicates that ________.
A) a specific binary relationship must be included in a ternary relationship
B) a binary relationship includes a set of value combinations that must all occur in a
ternary relationship
C) a table includes values that must occur in a binary relationship
D) a table includes values that must occur in a ternary relationship
For which of the following types of failure would Oracle Database use Offline ReDo
files as part of a recovery effort?
A) Instance failure
B) Application failure
C) Media failure
D) Logic failure
If a relation is in BCNF, and each multivalued dependency has been moved to a relation
of its own, then the first relation is in ________.
A) Third Normal Form
B) Boyce-Codd Normal Form
C) Fourth Normal Form
D) Domain/key normal form
An entity that holds specialized attributes that distinguish it from one or more other
similar entities is a ________.
A) supertype
B) subtype
C) discriminator
D) parent
RFM scores commonly range from ________, with ________ being the “high” or
“most desirable” (from the vendor’s point of view) score.
A) 0 to 5; 0
B) 0 to 5; 5
C) 1 to 5; 1
D) 1 to 5, 5
A composite attribute is an attribute that ________.
A) is multivalued
B) describes a characteristic of the relationship
C) consists of a group of attributes
D) is calculated at run-time
A BI reporting system ________.
A) creates meaningful information from disparate data sources.
B) delivers information to users on a timely basis.
C) uses statistical procedures to predict future events.
D) Both A and B are correct
In OLAP, the data item of interest is called a ________.
A) level
B) dimension
C) measure
D) member
In IDEF1X, the named set of values that an attribute can have is called a ________.
A) domain
B) base domain
C) type domain
D) domain cluster
Which of the following is true of clustered indexes?
A) They are normally slower than nonclustered indexes for retrieving data.
B) Only one is allowed per table.
C) They are normally slower than nonclustered indexes for updating data.
D) They do not have data in the bottom level.
A relation is in Boyce-Codd normal form (BCNF) if and only if it is in 3NF and
________.
A) all non-key attributes are determined by the entire primary key
B) there are no non-key attributes determined by another non-key attribute
C) every attribute is a candidate key
D) every determinant is a candidate key
The characteristics of an object are called ________.
A) classes
B) collections
C) methods
D) properties
Locks that are placed assuming that a conflict will occur are called ________.
A) explicit locks
B) implicit locks
C) optimistic locks
D) pessimistic locks
Recursive relationships can have all of the following maximum cardinalities except
________.
A) 1:1
B) 1:N
C) N:M
D) M:M
Microsoft Access includes ________.
A) a DBMS
B) an application generator
C) a Web server
D) Both A and B are correct
An attribute that determines which subtype should be used is a(n) ________.
A) supertype
B) subtype
C) discriminator
D) identifier
Document databases typically base their data structuring features on ________.
A) JSON
B) XML
C) relations
D) Both A and B are correct
A set of objects and the properties and methods that they expose are known as a(n)
________.
A) provider
B) interface
C) implementation
D) instantiation
Which method returns the next value in a sequence?
A) CountVal
B) Next
C) UpVal
D) NextVal
Which type of trigger is commonly used to update views?
A) BEFORE triggers
B) AFTER triggers
C) SELECT triggers
D) INSTEAD OF triggers
In Microsoft Visio 2013, for a Relationship object relationship that is one-optional 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
Which does the ODBC standard not define a means of doing?
A) Start transactions
B) Rollback transactions
C) Read a Microsoft Word document
D) Issue SQL commands
Which of the following is not a reason that operational data are difficult to read?
A) Dirty data
B) Large values
C) Non-integrated data
D) Missing values
An important method of a collection is a(n) ________, which can be used to pass
through or otherwise identify the items in the collection.
A) iterator
B) identifier
C) converter
D) transformer
Distinguish among the four types of JDBC drivers.
Explain the representation of a many-to-many strong entity relationship in a relational
database design.
What are the four components of a database system?
What is a reporting system?
Explain the importance of documenting changes in database structure.
What is a B-tree?
Why is the decomposition of the features and functions of a DBMS into different
objects an advantage for OLE DB?
What is the MySQL Command-Line Client?
What are objects, and how are they related to the object-oriented DBMS (OODBMS)?
What line symbols are used in IDEF1X diagrams to represent relationships?
What is a star schema?
Distinguish between the physical description and the semantic description of an
attribute domain.
What is a data warehouse?
Briefly explain the different types of files used by the Oracle Database recovery
facilities.
In Microsoft Visio 2013, how do we format line ends in data models to represent the
symbols used in the IE Crow’s Foot notation?
What is SQL?