Studied by 0 people
Looks like no one added any tags here yet for you.
A database language enables the user to perform complex queries designed to transform the raw data into useful information.
True
SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.
False
The ANSI SQL standards are also accepted by the ISO.
True
Data type selection is usually dictated by the nature of the data and by the intended use.
True
Only numeric data types can be added and subtracted in SQL.
False
Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.
True
The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.
False
You cannot insert a row containing a null attribute value using SQL.
False
All SQL commands must be issued on a single line.
False
SQL requires the use of the ADD command to enter data into a table.
False
Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.
True
If you have not yet used the COMMIT command to store the changes permanently in the database, you can restore the database to its previous condition with the ROLLBACK command.
True
You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.
True
Mathematical operators cannot be used to place restrictions on character-based attributes.
False
String comparisons are made from left to right.
True
A relational join operation merges rows from two tables.
True
The SELECT statement uses the attribute list to indicate what columns to project in the result set
True
Numeric functions take one numeric parameter and return one value.
True
String manipulation functions are rarely used in programming
False
A view is a virtual table based on a SELECT query.
True
In Oracle, the _____ function converts a date to a character string.
TO_CHAR()
3 multiple choice options
_____ is a string function that returns the number of characters in a string value.
LENGTH
3 multiple choice options
When using the Oracle TO_NUMBER function to convert a character string into a number, _____ represents a digit.
9
1 multiple choice option
The _____ data type is considered compatible with VARCHAR(35).
CHAR(15)
3 multiple choice options
The Oracle equivalent to an MS Access AutoNumber is a(n) _____.
sequence
3 multiple choice options
Most real-world database transactions are formed by only one database request.
False
Although the DBMS is designed to recover a database to a previous consistent state when an interruption prevents the completion of a required set of transactions, the transactions themselves are defined by the end user or programmer and must be semantically correct.
True
A scheduler facilitates data isolation to ensure that two transactions do not update the same data element at the same time.
True
Transaction is a ____ unit of work that must be either entirely completed or aborted
logical
3 multiple choice options
A consistent database state is ___
one in which all data integrity constraints are satisfied
3 multiple choice options
_____ requires that all operations of a transaction be completed.
Atomicity
3 multiple choice options
_____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
Isolation
3 multiple choice options
A single- user database system automatically ensures_____ of the database, because only one transaction is executed at a time.
serializability and Isolation
3 multiple choice options
The ANSI ha define standard that govern SQL database transactions. Transaction support is provided by two SQL statements____ and ROLLBACK.
UPDATE
3 multiple choice options
One of the three most common data integrity and consistency problem is ___.
lost updates
3 multiple choice options
_____ occurs when a transaction accesses data before and after one or more other transactions finish working with such data.
Inconsistent retrievals
1 multiple choice option
As long as two transactions, T1 and T2, access ____ data, there is no conflict, and the order of execution is irrelevant to the final outcome.
unrelated
3 multiple choice options
___ are required to prevent another transaction form reading inconsistent data
Locks
3 multiple choice options
The ___ manager is responsible for assigning and policing the locks used by transactions.
lock
3 multiple choice options
Lock_____ indicates the level of lock use.
granularity
3 multiple choice options
Business intelligence (BI) architecture is composed of data, people, processes, technology, and the management of such components.
True
A data store is used by data analysts to create queries that access the database.
False
Master data management's main goal is to provide a partial and segmented definition of all data within an organization.
False
Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in a table.
True
Multidimensional data analysis techniques include advanced computational functions.
True
Operational data and decision support data serve the same purpose.
False
_____ are in charge of presenting data to the end user in a variety of ways.
Data visualization tools
3 multiple choice options
From a data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and _____.
dimensionality
3 multiple choice options
Operational data are commonly stored in many tables, and the stored data represent information about a given _____ only.
transaction
3 multiple choice options
_____ extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.
ROLAP
3 multiple choice options
In the context of the data-information-decision cycle, decisions made by high-level managers trigger actions in an organization's:
lower levels.
3 multiple choice options
At the level of middle management, the database must be able to _____.
provide the data necessary for tactical decisions and planning
3 multiple choice options
When introducing a database into an organization, the database approach creates a more controlled and structured information flow and thus affects people, functions, and interactions. This leads to a(n) _____ impact of the new database system.
cultural
3 multiple choice options
The person responsible for the control of the centralized and shared database is the database _____.
administrator
3 multiple choice options
Database administration operations are commonly defined and divided according to the phases of the _____.
DBLC
3 multiple choice options
A data administrator is also known as a(n) _____.
information resource manager
3 multiple choice options
The _____ administrator is responsible for strategic planning.
data
3 multiple choice options
Coordinating, monitoring, and allocating database administration resources is included in a DBA's _____ role.
managerial
3 multiple choice options
_____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity.
Standards
3 multiple choice options
"All users must have passwords" is an example of a _____.
policy
3 multiple choice options
"A password must have a minimum of five characters" is an example of a _____.
standard
3 multiple choice options
Instructions to create a password are an example of a _____.
procedure
3 multiple choice options
In the context of data backup and recovery, the activities of a _____ includes the DBA operations that are classified as disaster management.
database security officer
3 multiple choice options
Which of the following is a reason why a DBMS's daily operations must be clearly documented?
Documentation of the daily operations help pinpoint causes and solutions of database problems.
3 multiple choice options
A(n) _____ plan is a set of instructions generated at application compilation time that predetermines how the application will connect to and communicate with the database at run time.
access
3 multiple choice options
Most SQL implementations yield case-insensitive searches.
False
Numeric function;s take one numeric parameter and return one value
True
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.
True
The SQL aggregate function that gives the number of rows containing non null values for a given column is
COUNT
The COUNT function is deigned to tally the number of non null values of an attribute and is often used in conjunction with the DISTINCT clause
True
The COMMIT command does not perminantly save all changes. In Order to do that, you must use SAVE
False
If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a ____ clause
JOIN ON
You cannot insert a row containing a null attribute value using SQL.
False
Comparison operators cannot be used to place restrictions on character based attributes
False
A database language enables the user to perform complex designed to transform the raw data into useful information
True
Oracle users can use the Access QBE (query by example) query generator.
False
All SQL commands must be issued on a single line.
False
An alias cannot be used when a table is required to be joined to itself in a recursive query
False
The _ command defines a default value for a column when no value is given
DEFAULT
String comparisons are made from left to right
True
Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines with space between the SQL command and the commands components
True
You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output
True
An _ query specifies which data should,d be retrieved and how it should be filtered aggregated and displayed
SELECT
Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.
True
The conditional LIKE must be used in conjunction with wildcard characters.
True
When using _____ join, only rows from the tables that match on common value are returned
inner
Which is a feature of a correlated sub query
The outer subquery initiates the process of execution in a subquery
The _____ command restricts the selection of grouped rows based on a condition
HAVING
The syntax for a left outer join is ___
SELECT Column list FROM table 1 LEFT [OUTTER] JOIN Table 2 ON join condition
Date procedures are often more softwear specific than other SQL procedures
True
The ANSI SQL standards are also accepted by the ISO
true
SQL allows the use of logical restrictions on its inquiries such as OR AND and NOT
True
SQL is considered difficult to learn; it's command set has a vocabulary of more than 30l words
False
An ___ is an alternate name given to a column or table in any SQL Statement
Alias
In subquery terminology, the first query in the SQL statement is known as the _____ query.
outer
When using the Oracle TO_DATE function, the code _____ represents a three-letter month name.
MON
What type of command does this SQL statement use? SELECT P_code, P_ DESCRIPT.....
"Old style" join
Which comparison operator indicates a value is not equal
<>
The special operator used to check whether a subquery returns any rows is
EXISTS
____ is a string function that returns the number of characters in a string value
LENGTH
