Download PrepIQ Cambridge Certified SQL Associate Ultimate Exam and more Exams Technology in PDF only on Docsity!
SQL Associate Ultimate Exam
Question 1. Which business entity provides limited liability to owners while allowing pass-through taxation? A) Sole Proprietorship B) General Partnership C) Limited Liability Company (LLC) D) C-Corporation Answer: C Explanation: An LLC shields members from personal liability and its income is reported on members’ personal tax returns, providing pass-through taxation. Question 2. Under Hawaii Revised Statutes (HRS) 444-25.5, which disclosure must a contractor give to a homeowner before signing a contract? A) Contractor’s credit score B) Detailed payment schedule and lien waiver requirements C) Contractor’s political affiliation D) Estimated project duration only Answer: B Explanation: HRS 444-25.5 requires contractors to disclose payment terms, lien waiver provisions, and other contract details to protect homeowners. Question 3. In preparing a bid for a public project in Hawaii, which document is typically required to accompany the bid? A) A notarized personal guarantee B) A certified payroll report C) A bid bond or bid security D) A copy of the contractor’s driver’s license Answer: C Explanation: Public bids often require a bid bond to ensure the bidder will enter into a contract if awarded.
SQL Associate Ultimate Exam
Question 4. Which financial statement provides a snapshot of a company’s assets, liabilities, and equity at a specific point in time? A) Income Statement B) Statement of Cash Flows C) Balance Sheet D) Statement of Owner’s Equity Answer: C Explanation: The balance sheet reports assets, liabilities, and equity as of a particular date. Question 5. The Fair Labor Standards Act (FLSA) primarily governs which of the following? A) Workers’ compensation benefits B) Minimum wage, overtime, and child labor standards C) Unemployment insurance eligibility D) Occupational safety training requirements Answer: B Explanation: FLSA sets federal minimum wage, overtime pay, and child labor rules. Question 6. When filing a mechanic’s lien in Hawaii, the claimant must first provide the owner with which notice? A) Preliminary Notice of Intent to Lien (within 30 days of starting work) B) Final invoice C) Warranty certificate D) Insurance claim form Answer: A Explanation: Hawaii requires a preliminary notice to preserve lien rights before filing the lien. Question 7. OSHA 29 CFR 1926 Subpart P addresses which safety topic?
SQL Associate Ultimate Exam
B) To expand the pipe outward while pulling a new pipe segment behind it C) To inject resin into the existing pipe D) To seal the pipe ends during testing Answer: B Explanation: The bursting head fractures the existing pipe and expands the cavity for the replacement pipe. Question 11. Which of the following is a key advantage of continuous sliplining over segmental sliplining? A) Ability to repair pipes without any excavation B) Reduced need for grout in the annular space C) Faster installation for long pipe runs D) Compatibility with all pipe diameters without modification Answer: C Explanation: Continuous sliplining uses long liners, allowing faster installation over extended lengths. Question 12. In a hydrostatic pressure test, the test pressure is typically set at what factor of the pipe’s design pressure? A) 0.5 × design pressure B) 1.0 × design pressure C) 1.5 × design pressure D) 2.0 × design pressure Answer: C Explanation: Hydrostatic tests usually use 1.5 times the design pressure to verify pipe integrity. Question 13. When performing a CCTV inspection of a sewer pipe, which defect is most commonly identified as a cause of flow restriction? A) Color change of pipe interior B) Root intrusion
SQL Associate Ultimate Exam
C) Pipe material type D) Ambient temperature Answer: B Explanation: Roots entering the pipe are a frequent cause of blockage and are easily seen on CCTV footage. Question 14. Which material is most resistant to chemical corrosion and is commonly repaired using epoxy spray-on linings? A) Ductile Iron Pipe (DIP) B) Reinforced Concrete Pipe (RCP) C) Polyvinyl Chloride (PVC) D) High-Density Polyethylene (HDPE) Answer: B Explanation: Concrete is vulnerable to chemical attack; epoxy spray-on linings protect against corrosion. Question 15. According to OSHA, a trench classified as Type B soil requires which minimum protective system? A) No protection needed if depth < 5 ft B) Trench shield (sloping) or shoring C) Only a benching method D) Full underground utilities mapping only Answer: B Explanation: Type B soils are moderately stable and require a protective system such as shoring or shielding. Question 16. Which of the following best describes the role of the Responsible Managing Employee (RME) in Hawaii contracting? A) The owner of the company B) The employee who signs all contracts on behalf of the company
SQL Associate Ultimate Exam
C) Inform subcontractors of their pay schedule D) Record the contractor’s insurance policy numbers Answer: B Explanation: A notice of commencement informs parties of the project start date and protects lien rights. Question 20. Which of the following is a required element of a written change order? A) Contractor’s personal phone number B) Detailed description of the change, cost impact, and schedule impact C) Owner’s credit score D) List of all subcontractors on the original contract Answer: B Explanation: Change orders must clearly describe the scope change, cost, and schedule adjustments. Question 21. When calculating profit margin on a bid, the contractor should base the margin on: A) Total direct costs only B) Total estimated project cost (direct + overhead) C) Only labor costs D) The subcontractors’ profit margins Answer: B Explanation: Profit is applied to the sum of direct costs and overhead to ensure all expenses are covered. Question 22. Which of the following documents is NOT typically part of a contractor’s financial statement package? A) Balance Sheet B) Income Statement C) Statement of Cash Flows
SQL Associate Ultimate Exam
D. Architectural design drawings Answer: D Explanation: Financial statements consist of balance sheet, income statement, and cash flow; design drawings are not financial documents. Question 23. Under Hawaii law, a contractor must maintain workers’ compensation insurance that covers: A) Only full-time employees B) All employees, including part-time and temporary workers C) Only subcontractors D) Only owners of the company Answer: B Explanation: Workers’ compensation must cover all workers, regardless of employment status. Question 24. Which testing method uses a colored dye to locate leaks in a pressurized pipe system? A) Hydro-jet testing B) Acoustic emission testing C) Dye penetrant testing D) Ultrasonic thickness testing Answer: C Explanation: Dye penetrant testing introduces colored dye into the system; leaks are identified where dye emerges. Question 25. The “annular space” in sliplining refers to: A) The space between the host pipe and the inserted liner B) The internal voids within the liner material C) The clearance between the pipe and the surrounding soil D) The space inside a pipe coupler
SQL Associate Ultimate Exam
Answer: C Explanation: Architectural renderings are irrelevant to traffic control; the plan focuses on safety and vehicle flow. Question 29. When a contractor files a mechanic’s lien in Hawaii, the lien must be recorded within how many days after the last furnishing of labor or materials? A) 15 days B) 30 days C. 45 days D) 60 days Answer: B Explanation: Hawaii law requires lien recording within 30 days of the final work or material delivery. Question 30. Which OSHA record-keeping form is used to log work-related injuries and illnesses? A) OSHA 300 Log B) OSHA 301 Incident Report C) OSHA 302 Hazard Communication Sheet D) OSHA 303 Safety Inspection Form Answer: A Explanation: The OSHA 300 Log tracks recordable injuries and illnesses. Question 31. In a pipe-bursting project, the term “bursting force” refers to: A) The hydraulic pressure used to inflate the new pipe B) The axial force applied to the bursting head to fracture the existing pipe C) The torque required to rotate the bursting machine D. The weight of the equipment on the trench Answer: B
SQL Associate Ultimate Exam
Explanation: Bursting force is the axial thrust that breaks the old pipe and pushes the new pipe into place. Question 32. Which of the following is a primary reason to use polyethylene encasement on ductile iron pipe? A) To increase the pipe’s structural strength B) To provide corrosion protection and reduce water loss C. To improve the pipe’s flexibility for bends D. To enhance the pipe’s aesthetic appearance Answer: B Explanation: Polyethylene encasement acts as a barrier against corrosion and reduces infiltration. Question 33. A “conditional lien waiver” becomes effective under which condition? A) Upon the contractor’s signature only B) When the payer actually receives payment C. When the contractor files a lien D. Immediately after the waiver is mailed Answer: B Explanation: Conditional waivers are only effective once the payer has actually received the payment. Question 34. Which of the following best describes “root intrusion” as identified on a CCTV inspection? A) A crack larger than 1/4 inch B) A darkened area caused by mineral deposits C) A visible plant root extending into the pipe lumen D) A bulge caused by soil pressure Answer: C
SQL Associate Ultimate Exam
Question 38. Which of the following is a required element of a confined space entry permit? A) List of all employees’ birthdays B. Atmospheric testing results (oxygen, combustible gases, toxic gases) C. Contractor’s marketing brochure D. Blueprint of the entire project site Answer: B Explanation: Confined space permits must document atmospheric testing to ensure safe entry. Question 39. Which of the following best describes “pipe inversion” in CIPP? A) Pulling the liner through the pipe using a winch from the opposite end B) Flipping the pipe upside down to install the liner C) Using hydraulic pressure to push the liner forward D. Rotating the pipe to align with the liner Answer: A Explanation: Inversion involves pulling the resin-saturated liner into the pipe by turning it inside out. Question 40. For a contractor’s bid on a private residential project, which of the following is typically NOT required? A) Proof of liability insurance B. A performance bond C. A detailed scope of work and pricing breakdown D. A copy of the contractor’s driver’s license Answer: D Explanation: A driver’s license is not a standard requirement for residential bids.
SQL Associate Ultimate Exam
Question 41. Which of the following is an advantage of using spray-on epoxy lining over CIPP? A) Ability to repair pipes with severe deformation without removal B. Faster curing time in cold weather C. No need for a curing oven or steam D. Lower material cost in all cases Answer: C Explanation: Spray-on epoxy cures at ambient temperature, eliminating the need for a curing oven. Question 42. In a project’s cash-flow forecast, which of the following items is considered an inflow? A. Purchase of equipment B. Payment of subcontractor invoices C. Owner’s progress payment D. Payroll taxes Answer: C Explanation: Owner progress payments represent cash entering the contractor’s accounts. Question 43. Which OSHA standard addresses the requirement for personal protective equipment (PPE) on construction sites? A) 29 CFR 1926 Subpart E B. 29 CFR 1910 Subpart D C) 29 CFR 1926 Subpart H D. 29 CFR 1926 Subpart J Answer: C Explanation: Subpart H covers personal protective and life-saving equipment for construction.
SQL Associate Ultimate Exam
Question 47. Under the Hawaii Uniform Building Code, a contractor must obtain a building permit before: A. Purchasing tools and equipment B. Starting any excavation work that affects a public right-of-way C. Ordering materials for a project D. Conducting a site safety meeting Answer: B Explanation: Excavation affecting public rights-of-way requires a permit to ensure compliance with utility and safety regulations. Question 48. Which of the following is a primary function of a “manhole rehabilitation liner”? A) To replace the manhole cover with a larger one B. To restore structural integrity and prevent infiltration within the manhole shaft C. To increase the depth of the manhole for larger pipes D. To install a new lighting system inside the manhole Answer: B Explanation: Lining a manhole repairs cracks and seals the shaft, improving structural stability and preventing water ingress. Question 49. The “notice of completion” in Hawaii construction law is used to: A. Notify the public that a project has ended B. Trigger the statutory deadline for filing a mechanic’s lien C. Cancel all existing warranties D. Announce the contractor’s retirement Answer: B Explanation: The notice of completion starts the clock for lien claim periods. Question 50. Which of the following is a typical symptom of a failing HDPE pipe that may indicate the need for rehabilitation?
SQL Associate Ultimate Exam
A. Rust staining on the interior surface B. Sudden loss of pressure and water discoloration C. Audible knocking sounds during flow D. Excessive pipe expansion under load Answer: B Explanation: HDPE does not rust, but loss of pressure and discoloration can signal a breach or joint failure. Question 51. In a C-43A project, “static pipe bursting” differs from “pneumatic pipe bursting” primarily in: A. The type of pipe material that can be burst B. The use of hydraulic pressure versus air pressure to drive the bursting head C. The need for a trench versus trenchless method D. The requirement for a crew of at least three workers Answer: B Explanation: Static bursting uses hydraulic (liquid) pressure; pneumatic uses compressed air. Question 52. Which of the following is required for an employer to be exempt from the FLSA overtime provisions? A. The employee works primarily on a government contract B. The employee is classified as a “executive” and meets salary and duties tests C. The employee works less than 20 hours per week D. The employee is a seasonal farm worker Answer: B Explanation: The executive exemption requires meeting salary thresholds and managerial duties. Question 53. Which of the following best describes the purpose of a “pre-bid conference”?
SQL Associate Ultimate Exam
A. Bench the trench walls at a 45-degree angle B. Use a trench shield or shoring system C. Install a temporary concrete slab over the trench D. No protection is required if the trench is less than 10 ft long Answer: B Explanation: Type C soils are unstable; a shield or shoring system is required for safety. Question 57. In a C-43A repair, “spot repair” typically involves: A. Replacing the entire pipe segment with a new pipe B. Installing a short section of liner or mechanical seal at the location of damage C. Applying a full-length CIPP liner to the pipe D. Excavating the entire pipe for replacement Answer: B Explanation: Spot repairs address localized damage with a targeted liner or seal. Question 58. Which of the following best defines “gross profit” on a construction bid? A. Revenue minus direct costs only B. Revenue minus direct costs and overhead C. Revenue minus all expenses, including profit D. Revenue before any deductions Answer: A Explanation: Gross profit is calculated by subtracting direct costs from total revenue, before overhead and other expenses. Question 59. Which of the following is a primary reason to conduct a “risk assessment” before beginning a pipeline rehabilitation project? A. To determine the color of the pipe coating B. To identify potential safety hazards, environmental impacts, and cost overruns
SQL Associate Ultimate Exam
C. To select the subcontractor with the lowest bid D. To calculate the exact profit margin for the project Answer: B Explanation: Risk assessments evaluate safety, environmental, and financial risks to guide planning. Question 60. In a typical CIPP installation, what is the role of a “syringe” or “injection port”? A. To inject curing resin into the liner after inversion B. To pump water into the host pipe for cleaning C. To deliver air for pneumatic bursting D. To measure the pipe’s internal pressure Answer: A Explanation: The injection port introduces resin into the liner to saturate it before curing. Question 61. Which of the following is a required component of a contractor’s payroll tax filing in Hawaii? A. Federal income tax withholding only B. State General Excise Tax return only C. State Unemployment Insurance (SUI) contributions and withholding for state income tax D. Property tax statement Answer: C Explanation: Hawaii payroll tax filings include SUI and state income tax withholding. Question 62. When a contractor uses a “conditional lien waiver on progress payment,” the waiver becomes effective: A. When the contractor signs it, regardless of payment receipt B. When the payer actually receives the progress payment C. When the project is completed
