1- “All users must have passwords” is an example of a ____. a- rule b- policy c-
ID: 3800872 • Letter: 1
Question
1- “All users must have passwords” is an example of a ____.
a- rule
b- policy
c- procedure
d- standard
______________________
2- _______ are executed when a specified condition occurs during insert/delete/update
a- Commands
b- Methods
c- Triggers
d- Log
______________________
3- 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
_____________________
4- _______ 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
_______________________________
5- _______is distinctive characteristic of Data warehouses.
a- Multiuser support
b- Accessibility
c- Transparency
d- All of the above
___________________________________
6- 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
________________________________
7- 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
________________________________
8- 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
_____________________________
9- 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
____________________________
10- 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
____________________________________
11- A transaction is a ____ unit of work that must be either entirely completed or aborted.
a- Timed
b- Practical
c- Logical
d- physical
__________________________________
12- Triggers follow a(n) ______________ model.
a- Aondition-Action-Event
b- Event-Condition-Action
c- Action-Condition-Event
d- Event-Action-Condition
___________________________________________
13- ________ 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
____________________
14- which of the following represents the aggregations with increasing level of details?
a- Drill-Down
b- Pivot
c- Slice
d- Sorting
_______________________
15- 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
___________________
16- The process of continuing to revise/adjust the physical database design called:
a- Tuning
b- Normalization
c- Denormalization
d- None of the above
____________________________
17- 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
__________________________________________
Explanation / Answer
1-b
2-c
3-b
4-c
5-d
6-b
7-d
8-c
9-a
10-c
11-a
12-a
13-d
14-d
15-d
16-a turing means corecting the data and adjusting it but normalization is just grouping and adjusting the data with efficiency ,denormalization means gouping the data with losing some data and writingth data and making them ito different copies
17-a
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.