- Samenvattingen en Aantekeningen
Op zoek naar een samenvatting over ? Op deze pagina vind je 10 samenvattingen over .
Alle 10 resultaten
Sorteer op:
-
Tentamen (uitwerkingen)
COSC 3380 EXAM 3 QUESTIONS WITH 100% CORRECT ANSWERS
-
---7maart 20262025/2026A+
- COSC 3380 EXAM 3 QUESTIONS WITH 100% CORRECT ANSWERS 
 
 
.How many zeros can appear in a single row of a bitmap index? - ANSWERS-Exactly one 
 
.Refer to the following scenario: 
-A table occupies 1,000 blocks. 
-FlightNumber is the primary key. 
-An index on FlightNumber occupies 100 blocks. 
-The WHERE clause specifies "FlightNumber = 3988." 
 
What is the minimum number of blocks necessary to process the SELECT? - ANSWERS-2 
 
.Sparse Index - ANSWERS-Index on either a uniq...
-
$11.99 Meer Info
IszackBd
-
Tentamen (uitwerkingen)
COSC 3380 FINAL EXAM QUESTIONS WITH VERIFIED ANSWERS
-
---9maart 20262025/2026A+
- COSC 3380 FINAL EXAM QUESTIONS WITH VERIFIED ANSWERS 
 
 
.Informal Guidelines (Measure of DB Quality) - ANSWERS--Making sure that the semantics of the attributes is clear in the schema 
-Reducing the redundant information in tuples 
-Reducing the NULL values in tuples 
-Disallowing the possibility of generating spurious tuples 
 
.Normalization - ANSWERS--analyzing schemas based on their FDs and primary keys 
-achieves 'desirable' properties: 
(1) minimizing redundancy 
(2) mini...
-
$11.99 Meer Info
IszackBd
-
Tentamen (uitwerkingen)
COSC 3380 FINAL EXAM QUESTIONS WITH 100% VERIFIED ANSWERS
-
---8maart 20262025/2026A+
- COSC 3380 FINAL EXAM QUESTIONS WITH 100% VERIFIED ANSWERS 
 
 
 
.An __________ is written in the log whenever an update is reversed during a rollback. - ANSWERS-undo 
 
.Whenever deadlock occurs, a cycle of dependent transactions always exists. - ANSWERS-True 
 
.With a hot backup, as a transaction executes against the primary database - ANSWERS-Log records are sent to the secondary database 
 
.Is the schedule 
T1:R(x), T2:W(x), T2: commit, T1: W(x), T1: commit, T3: R(x), T3: ...
-
$12.99 Meer Info
IszackBd
-
Tentamen (uitwerkingen)
COSC 3380 Exam 4
-
---19maart 20252024/2025A
- The COSC 3380 Exam 4 assesses students' understanding of advanced database management concepts, including relational databases, SQL optimization, indexing, transactions, concurrency control, and database security. Topics may also cover NoSQL databases, data warehousing, and distributed database systems. The exam evaluates students' ability to design, implement, and manage databases efficiently while ensuring data integrity and security.
-
$14.49 Meer Info
ThePlug
-
Tentamen (uitwerkingen)
COSC 3380 Exam 4 Questions with Correct Answers Latest Update 2025-2026 Graded A+
-
---10maart 20252024/2025A+
- COSC 3380 Exam 4 Questions with Correct Answers Latest Update Graded A+ 
How many SQL statements must be in one transaction? 
Exactly one 
At least one 
At least two - Answers At least one 
After a transaction commits, the transaction can be rolled back: 
Always 
Sometimes 
Never - Answers Never 
After a rollback, the database restarts a transaction: 
Always 
Sometimes 
Never - Answers Sometimes 
A transaction increases all employee salaries by 10%. Due to a system failure, increases for only h...
-
$10.79 Meer Info
TutorJosh
-
Tentamen (uitwerkingen)
COSC 3380 Exam 3 Questions and Answers Already Passed
-
---14maart 20252024/2025A+
- COSC 3380 Exam 3 Questions and Answers Already Passed 
Reading one gigabyte takes about one second. - Answers Flash memory 
Used to store petabytes (millions of gigabytes) of user data in the cloud. - Answers Magnetic disk 
Upgrading from 16 to 32 gigabytes costs an extra $400 for an Apple laptop computer. - Answers Main memory 
Approximately how many sectors are required to store one megabyte of data? 
Always 8,000 
Always 2,000 
Either 250 or 2,000 - Answers Either 250 or 2000 
The database a...
-
$10.79 Meer Info
TutorJosh
-
Tentamen (uitwerkingen)
COSC 3380 Exam 2 Questions with Correct Answers Graded A+ Latest Update 2025
-
---9maart 20252024/2025A+
- COSC 3380 Exam 2 Questions with Correct Answers Graded A+ Latest Update 2025 
Stored functions have no parameters - Answers False 
ID in Faculty is the PRIMARY KEY. Code in Department is the PRIMARY KEY 
If DepartmentView is a materialized view, against what tables is the query executed? - Answers DepartmentView 
Which statement correctly inserts Sales - Answers INSERT INTO Department 
VALUES(82, 'Sales', 6381) 
 
Feedback: the column names are omitted, so the values must be in the same or...
-
$10.69 Meer Info
TutorJosh
-
Tentamen (uitwerkingen)
COSC 3380 Exam 1 Questions and Answers Latest Update 2025-2026
-
---11maart 20252024/2025A+
- COSC 3380 Exam 1 Questions and Answers Latest Update 
Identification of entities, relationships, and attributes precedes documentation - Answers Usually 
Maria purchases an airline ticket, but a serer failure causes the ticket to become unavailable before the transaction completes. The database must reverse any partial changes. 
What transaction behavior would describe this situation? - Answers Transaction processed completely or not at all 
Data in a relational database can violate relational ...
-
$10.49 Meer Info
TutorJosh