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 Claremont Colleges	fall	Y	5	24.00	100%	100%	40%
2024 ACF Fall at Cornell	fall	Y	9	17.78	78%	78%	22%
2024 ACF Fall at Illinois	fall	Y	9	16.67	56%	100%	11%
2024 ACF Fall at Rutgers	fall	Y	8	16.25	50%	75%	38%
2024 ACF Fall at Ohio State	fall	Y	7	15.71	86%	57%	14%
2024 ACF Fall at Washington	fall	Y	6	18.33	83%	83%	17%
2024 ACF Fall at Georgia	fall	Y	11	17.27	82%	91%	0%
2024 ACF Fall at North Carolina	fall	Y	9	11.11	33%	67%	11%

Data


UCLA C	Claremont B	10	10	0	20
Claremont C	UCLA D	10	10	0	20
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
UCLA E	UCLA B	10	10	10	30
UCSD	Claremont A	10	10	10	30
USC	UCLA A	10	10	0	20
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
Columbia A	Columbia J	0	10	0	10
Maryland A	Fordham A	10	10	0	20
Lehigh A	Rutgers B	10	10	10	30
Bard A	Maryland B	0	0	0	0
West Virginia A	CWRU A	10	10	0	20
Miami A	CWRU B	10	0	0	10
Jefferson County Scholars	Michigan C	0	0	0	0
Michigan B	Michigan A	10	10	10	30
Michigan State A	Michigan State B	10	10	0	20
CWRU C	Ohio State A	10	0	0	10
Michigan D	West Virginia B	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
Columbia B	NYU A	10	10	10	30
Rowan A	NYU B	0	0	0	0
Penn B	Penn A	10	10	10	30
Lehigh B	Princeton A	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
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
Belmont	Southern	10	10	0	20
Vanderbilt B	Auburn C	0	10	0	10