Blog

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?

Suppose you have two relations:Instructor(ID, name, dept_name, salary)Department(dept_name, building, budget) Which relational algebra operation retrieves each instructor’s name along with the building of their department?