Blog

Make sure your workspace and you are visible at all times. Your phone should remain face down for the duration of the exam. When you have finished the exam, use your phone to scan your exam into Gradescope.Note the following:failure to mark the pages in Gradescope to correspond to your questions may result in a deduction of points from the exam overall.failure to maintain the proper workspace environment may result in a grade of zero for the exam.Using the exam:you can zoom the document by pressing the plus button to zoom in or the minus to zoom outyou can also zoom in on the entire browser window: use “pinch and zoom” if you have a trackpad. If using a mouse, hold “ctrl” and use the scroll wheel on the mouse.

Exam 2 Questions

 For a training set of size N with M attributes, each tree is grown by selecting N cases at random with replacement, what is this process called?

In the above chart, fill in the values of fW(X) for each sample.

Which of the following is NOT the necessary component of a form-based authentication web application?

Assume permitting access to a proxy using the HTTP CONNECT method, an attacker can  

The following query is executed: select name, salary + 5000 as revised_salary from instructor; For an instructor whose salary is NULL, what value appears in the revised_salary column?

Section schema: section (course_id, sec_id, semester, year, building, room_number, time_slot_id)  Which relational algebra expression lists courses taught in Fall 2017 but not in Spring 2018?

A relation Instructor(ID, name, dept_name, salary) is stored in a university database. Which relational algebra expression retrieves the names of instructors in the ‘Computer Science’ department who earn more than $80,000?

A company notices that its database queries are running slowly even though no schema changes were made. Upon investigation, it turns out that the data files are intact, but the indices became corrupted, and the system takes longer to locate records. Which database system component is most responsible for handling and optimizing these operations?