UTA INSY 3304 EXAM QUESTIONS AND ANSWERS
LATEST UPDATE (ALREADY GRADED A+)
Create the databases
Requires the creation of special storage-related constructs to house the end-user tables
Load or convert the data
Requires aggregating data from multiple sources
Full backup/dump
All database objects are backed up in their entirety
Differential backup
Only modified/updated objects since last full backup are backed up
Transaction log backup
Only the transaction log operations that are not reflected in a previous backup are backed up
Software
Software-induced failures may be traceable to the operating system, the DBMS software, application
program, or viruses and other malware
Hardware
Hardware-induced failures may include memory chip errors, disk crashes, bad disk sectors, and disk-full
errors.
Programming exemptions
Application program or end users may roll back transactions when certain conditions are defined.
Programming exemptions can also be caused by malicious or improperly tested code that can be
exploited by hackers.
Transactions
The system detects deadlocks and aborts one of the transactions
External factors
Backups are especially important when a system suffers completely destruction from fire, earthquake,
flood, or other natural disaster
Minimum data rule
All that is needed is there, and all that is there is needed
LATEST UPDATE (ALREADY GRADED A+)
Create the databases
Requires the creation of special storage-related constructs to house the end-user tables
Load or convert the data
Requires aggregating data from multiple sources
Full backup/dump
All database objects are backed up in their entirety
Differential backup
Only modified/updated objects since last full backup are backed up
Transaction log backup
Only the transaction log operations that are not reflected in a previous backup are backed up
Software
Software-induced failures may be traceable to the operating system, the DBMS software, application
program, or viruses and other malware
Hardware
Hardware-induced failures may include memory chip errors, disk crashes, bad disk sectors, and disk-full
errors.
Programming exemptions
Application program or end users may roll back transactions when certain conditions are defined.
Programming exemptions can also be caused by malicious or improperly tested code that can be
exploited by hackers.
Transactions
The system detects deadlocks and aborts one of the transactions
External factors
Backups are especially important when a system suffers completely destruction from fire, earthquake,
flood, or other natural disaster
Minimum data rule
All that is needed is there, and all that is there is needed
