Homework Sourse1 All users must have passwords is an example of a a rule b
1- “All users must have passwords” is an example of a ____.
a- rule
b- policy
c- procedure
d- standard
An algorithm for finding large itemsets is called fast find algorithm
True
False
Multi-dimensional schemas are specified by using dimension table and fact table
True
False
4- _______ are executed when a specified condition occurs during insert/delete/update
a- Commands
b- Methods
c- Triggers
d- Log
5- Triggers which Execute once for the SQL statement are
a- Row level triggers
b- Statement level triggers
c- Both a & b
d- None of above
6- _______ is handled by creating user accounts and passwords to control login process by the DBMS.
a- Mandatory
b- Discretionary
c- access control
d- flow control
7- _______is distinctive characteristic of Data warehouses.
a- Multiuser support
b- Accessibility
c- Transparency
d- All of the above
8- A schedule S is ................... if it is equivalent to some serial schedule of the same n transactions
a- Serial
b- Serializable
c- Result equivalent
d- non of the above
In Database Recovery, Redo means Restore all AFIMs on to disk
True
False
tamp is a unique identifier created by the DBMS to identify a transaction
True
False
Normalization is to improve the performance of frequently occurring queries and transactions
True
False
The information stored in the ____ is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program’s abnormal termination, or a system failure such as a network discrepancy or a disk crash.
a- data dictionary
b- transaction log
c- metadata
d- rollback manager
CARTESIAN PRODUCT of relations R and S include all possible combinations of records from R and S. The attribute of the result include all attributes of R and S.
True
False
14- This signals that the transaction has ended unsuccessfully, so that any changes or effects that the transaction may have applied to the database must be undone.
a- Rollback
b- Commit
c- Abort
d- Redo
15- A _______ is a sequence of records, where each record is a collection of data values (or data items).
a- File
b- Blocking factor
c- Field length
d- Field type
16- This occurs when two transactions that access the same database items have their operations interleaved in a way that makes the value of some database item incorrect.
a- Incorrect Summary Problem
b- Lost Update
c- Temporary Update
d- Filthy Update
17- A transaction is a ____ unit of work that must be either entirely completed or aborted.
a- Timed
b- Practical
c- Logical
d- physical
Account creation- This action creates a new account and password for a user or a group of users to enable access to the DBMS
True
False
In a deductive database, speciation consists of facts and rules.
True
False
20- Triggers follow a(n) ______________ model.
a- Aondition-Action-Event
b- Event-Condition-Action
c- Action-Condition-Event
d- Event-Action-Condition
21- ________ deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an authorized user, that the data are used only for an authorized purpose.
a- Integrity
b- Availability
c- Compliance
d- Confidentiality
22- which of the following represents the aggregations with increasing level of details?
a- Drill-Down
b- Pivot
c- Slice
d- Sorting
23- They are huge projects requiring massive investment of time and resources
a- Data Mart
b- Virtual data warehouses
c- Enterprise-wide data warehouses
d- DSS
24- The process of continuing to revise/adjust the physical database design called:
a- Tuning
b- Normalization
c- Denormalization
d- None of the above
e- None of the above
Hashing techniques are adapted to allow the dynamic growth and shrinking of the number of file records
True
False
26- The first step in query processing is ___.
a- scan the query
b- use heuristic optimization
c- compute the cost of the operations
d- determine the execution plan
27- If the selection condition involves an equality comparison on a key attribute on which the file is ordered, Linear search is the best option to use
a- True
b- False
Solution
An algorithm for finding large itemsets is called fast find algorithm
True
False
Ans:False
An algorithm for finding large itemsets is called Apriori algorithm
=============================================================================
4- _______ are executed when a specified condition occurs during insert/delete/update
a- Commands
b- Methods
c- Triggers
d- Log
Ans:C Triggers.They will start on action of insert ,delete and update
===============================================================================
5- Triggers which Execute once for the SQL statement are
a- Row level triggers
b- Statement level triggers
c- Both a & b
d- None of above
B statement trigger is fired once on behalf of the triggering statement
===============================================================================
7- _______is distinctive characteristic of Data warehouses.
a- Multiuser support
b- Accessibility
c- Transparency
d- All of the above
Ans d- All of the above
===============================================================================
8- A schedule S is ................... if it is equivalent to some serial schedule of the same n transactions
a- Serial
b- Serializable
c- Result equivalent
d- non of the above
Ans:b schedule S of n transactions is a serialisable schedule if it is equivalent to some serial schedule of the same n transactions.
==============================================================================
21- ________ deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an authorized user, that the data are used only for an authorized purpose.
a- Integrity
b- Availability
c- Compliance
d- Confidentiality
Ans:a
Integrity
=================================================================================
Normalization is to improve the performance of frequently occurring queries and transactions
True
False
Ans:True Normalization means aggregation of redudant data so that queries can execute fast.
