Telecom History/Events
Signed by FDR in 1934, this act established the FCC to regulate interstate and foreign communication.
The Communications Act
Provide 4 examples of SG&A costs
Marketing/advertising, rent, utilities, salaries/compensation, professional fees, operational expenses (software/IT) . Any non-production costs.
What technologies enable cable companies to provide high speed data over their existing cable infrastructure? Name the two key pieces.
Hybrid fiber coaxial cables and DOCSIS upgrades
This merger, completed in 2020, faced regulatory scrutiny over antitrust concerns but ultimately promised improved 5G coverage.
T-Mobile and Sprint
Name a mode of communication that is no longer in use (hint… it is alive).
Messanger Pigeon (last post closed in Calcutta in 2008)
What are the boundaries of the confidence interval based on?
The sample mean +/- the standard error * critical value
Type of fiber that is "unlit," provides maximum network infrastructure control for businesses.
Dark Fiber
What case was responsible for breaking up AT&T, and how many operating companies was it split into?
USA vs. AT&T, 7 Regional Operating Companies
In what year was 911 established as a national emergency number?
1968
From largest to most granular, list the different levels of census data starting from Nation
Nation, regions, divisions, states, counties, census tracts, block groups, and census blocks
Provide 2 pros and 1 con regarding fiber optic technology.
Pro: Low maintennce costs, low upgrade costs, potentially unlimited bandwidth speeds.
Con: very high upfront investment costs, difficult to find low competition fiber market that is not overbuilt.
Name 3 companies that have securitized a portion of their fiber network
MetroNet, Ziply, Allo, Frontier
Name the first president to have a telephone in the Oval Office
Herbert Hoover
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
A network that uses software rather than physical connections to route a customer’s traffic.
SD-WAN (Software Defined Wide Area Network)
Which cable/internet companies have stadiums named after them? Provide two examples
AT&T, Charter, and Lumen:
AT&T Stadium (Arlington, TX), Spectrum Arena (Charlotte, NC)
Lumen Field
Engineers from which company invented the modern fiber optic cable?
Corning, Inc. (Glass)
What is the difference between ST_intersects and ST_Intersection?
ST_Intersects checks if two geometries have any overlapping area (true/false), while ST_Intersection returns the geometry representing the overlapping area
What does HTTP stand for?
Hypertext Transfer Protocol
This firm is the largest privately owned FTTH provider, located primarily in the midwest. Its network is 100% fiber.
MetroNet (provides high speed internet & phone services through its fiber network)