databases - 2024 ACF Fall - Buzzpoints App

Question

Microsoft Access is a frequently used piece of enterprise software that manages these systems. For 10 points each:

[10e] Name these systems, whose “relational” type should obey ACID (“acid”) properties and store large amounts of organized information in rows and columns.

ANSWER: databases

[10m] The JOIN, SELECT, and WHERE keywords are used to query relational databases with this language. Programmers argue over whether or not this language’s name should be pronounced as a three-letter initialism.

ANSWER: SQL (“S-Q-L” or “sequel”) [or Structured Query Language]

[10h] This property is the first of the four ACID properties, and states that a database transaction must either completely finish or not occur. More generally, this property describes operations that cannot be interrupted.

ANSWER: atomicity

Back to bonuses

Summary


2024 ACF Fall at Cornell	fall	Y	9	17.78	78%	78%	22%
2024 ACF Fall at Ohio State	fall	Y	8	16.25	88%	63%	13%
2024 ACF Fall at Washington	fall	Y	6	18.33	83%	83%	17%
2024 ACF Fall at Georgia	fall	Y	12	18.33	83%	92%	8%
2024 ACF Fall at North Carolina	fall	Y	9	11.11	33%	67%	11%
2024 ACF Fall at Claremont Colleges	fall	Y	5	24.00	100%	100%	40%
2024 ACF Fall at Rutgers	fall	Y	9	15.56	44%	67%	44%
2024 ACF Fall at Illinois	fall	Y	9	16.67	56%	100%	11%

Data


Syracuse	Binghamton A	10	10	10	30
RIT C	Binghamton C	0	10	0	10
U of Rochester A	Cornell B	10	10	10	30
Cornell D	Cornell E	10	10	0	20
Cornell G	U of Rochester B	10	0	0	10
Cornell A	ESF	0	0	0	0
Cornell F	Penn State	10	10	0	20
Binghamton B	RIT A	10	10	0	20
Cornell C	RIT B	10	10	0	20
West Virginia A (UG)	CWRU A (UG)	10	10	0	20
Miami A (UG)	CWRU B (DII)	10	0	0	10
Jefferson County Scholars (DII)	Michigan C	0	0	0	0
Michigan B (UG)	Michigan A (UG)	10	10	10	30
Michigan State A	Michigan State B	10	10	0	20
CWRU C (UG)	Ohio State A (UG)	10	0	0	10
Miami B (UG)	Ohio State B (DII)	10	10	0	20
Michigan D (UG)	West Virginia B (UG)	10	10	0	20
Alberta	UW Gluttony	0	10	0	10
UW Lust	Arizona State A	10	10	0	20
UW Envy	Arizona State B	10	10	10	30
Boise State	UBC A	10	0	0	10
UBC B	UW Sloth	10	10	0	20
UW Chastity	UW Pride	10	10	0	20
Auburn A	Tennessee A	0	0	0	0
Clemson A	Tennessee B	10	10	0	20
Georgia A	Clemson B	10	10	0	20
Georgia Tech B	Emory A	10	10	0	20
Vanderbilt A	Emory Oxford	10	10	0	20
Alabama A	Furman	10	10	0	20
Georgia Tech A	South Carolina A	10	10	0	20
Georgia Tech C	Auburn B	10	10	0	20
Georgia Tech E	Georgia Tech D	10	10	0	20
Mississippi State A	South Carolina B	10	10	10	30
Belmont	Southern	10	10	0	20
Vanderbilt B	Auburn C	0	10	0	10
James Madison A	Liberty B	0	0	0	0
James Madison B	Appalachian State A	0	10	0	10
Liberty A	Duke A	10	10	10	30
Liberty C	William & Mary	0	0	0	0
UNC D	NC State	0	10	0	10
Virginia Tech A	Tusculum	0	10	0	10
VCU	UNC B	10	0	0	10
UNC C	UNC A	0	10	0	10
Virginia Tech B	Duke B	10	10	0	20
UCLA C	Claremont B	10	10	0	20
Claremont C	UCLA D	10	10	0	20
UCLA E	UCLA B	10	10	10	30
UCSD	Claremont A	10	10	10	30
USC	UCLA A	10	10	0	20
Columbia A (UG)	Columbia J (DII)	0	10	0	10
Maryland A (DII)	Fordham A	10	10	0	20
Lehigh A (UG)	Rutgers B	10	0	10	20
Lehigh A (UG)	Rutgers B	10	0	10	20
Lehigh A (UG)	Lehigh B (DII)	0	0	10	10
Lehigh A (UG)	Lehigh B (DII)	0	0	10	10
Lehigh A (UG)	Rutgers B	10	10	10	30
Lehigh A (UG)	Rutgers B	10	10	10	30
Lehigh A (UG)	Lehigh B (DII)	0	10	10	20
Lehigh A (UG)	Lehigh B (DII)	0	10	10	20
Bard A (UG)	Maryland B (DII)	0	0	0	0
Columbia B	NYU A (UG)	10	10	10	30
Rowan A (DII)	NYU B	0	0	0	0
Penn B (DII)	Penn A (DII)	10	10	10	30
Lehigh B (DII)	Princeton A (UG)	0	10	0	10
Purdue B	Chicago B	10	10	0	20
Illinois A	Northwestern A	0	10	0	10
Illinois B	Indiana	10	10	0	20
Illinois D	Illinois C	10	10	0	20
Iowa A	Chicago A	0	10	0	10
WashU B	Iowa B	0	10	0	10
Notre Dame A	Notre Dame C	0	10	0	10
Purdue A	Notre Dame B	10	10	10	30
Purdue C	WashU A	10	10	0	20