INF503 WEEK-4 LESSON (10,11&12) LAB
LESSON 10 QUIZ 1. Which statement in the SQL standard can be used to invoke a stored prored-either from an interface or from embedded SQL or SQLJ ? call 2. Which of the following approaches does not suffer from…
INF503 WEEK-2 LESSON (4,5&6) LAB
LEESON 4 QUIZ 1.Which of the following notations indicates a specialization/generalization with the disjoint…
GE5103 Week 1 (1.3 test & 2-assignment)
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…
INF503 WEEK-6 LESSON (18,20&21) LAB
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…
IS 5203 WEEK 8 ( all solutions)
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…
INF503 WEEK-7 LESSON (22,23) LAB
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…
INF503 Week 5 New Quizzes Lessons 14,16,17
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…
INF503 Week 3 (7.8 lab)
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…
INF503-POST ASSEGNEMENT ( FINAL WEEK )
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______.…
BA6933 WEEK-1 ASST-(1,2,3)
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…