True 2. Operations consist of the ongoing work needed to ensure that an organization continues to function effectively. True 3. A project manager needs to be concerned with achieving desired scope and quality (often called performance), subject to constraints of…
LESSON 18 1. Which search applies to any file, but all the other methods depend on having the appropriate access path on the attribute used in the selection condition? linear 2. In which of the following joins does the search…
1. While troubleshooting a recurring problem on your network, you want to examine the TCP messages being exchanged between a server and a client. Which tool should you use on the server? Wireshark 2. One of your coworkers downloaded several, very…
LESSON 22 1 .Deferred update is also known as the ______ NO-UNCO/REDO algorithm 2. For which of the following checkpoint actions does the fuzzy checkpointing technique come into use to overcome from the action? Suspend execution of…
Lesson 14 Quiz 1.Which normal form is based on the concepts of multivalued dependencies? 4NF 2..BCNF boyce-codd normal form was proposed as a simpler form of ______ 3NF 3.Which of the following normal forms is violated when a relation has…
7. LAB 7.1 SELECT DISTINCT Pnumber, PnameFROM PROJECTWHERE Pnumber IN(SELECT PnumberFROM PROJECT, EMPLOYEE_DEPARTMENT, EMPLOYEE_RECWHERE Dnum = Dnumber ANDMgr_ssn = Super_ssn AND Lname = ‘Zelaya’)ORPnumber IN(SELECT PnoFROM WORKS_ON, EMPLOYEE_RECWHERE Essn = Ssn AND Lname = ‘Smith’); 7.2 SELECT Lname, FnameFROM EMPLOYEE_RECWHERE Salary > (SELECT MAX (Salary)FROM EMPLOYEE_RECWHERE Dno = 5);7.3SELECT E.Lname AS Employee_name,S.Lname AS Supervisor_nameFROM (EMPLOYEE_REC AS E LEFT OUTER JOIN EMPLOYEE_REC AS SON E.Super_ssn = S.Ssn);7.4SELECT SUM…
Q1) which of the following conditions must be satisfied for a database to be called distributed? 1. Connection of database nodes over a computers network2. Logical interrelation of the connected databases Q2) .consider the following figureThe name attribute of student is a______.…
1(Q) Many service companies collect data via a follow-up survey of their customers. For example, to ascertain customer sentiment, Delta Air Lines sends an e-mail to customers immediately following a flight. Among other questions, Delta asks: How likely are you…
1. Who is responsible for identifying data to be stored in the database and for choosing appropriate structures to represent and store Data base designer 2. which of the following functions of database management system causes some data to be…
Q1) Loss of availability occurs when: A user or program cannot access objects who has legitimate right to those objects. Q2) Which of the following control measures is handled by creating user accounts and passwords to control the login processes…
