Skip to main content

INF503 Week 5 New Quizess Lessons 14,16,17

                                                                        Lesson 14 Quiz 

Which normal form is based on the concepts of multivalued dependencies?

A)4NF


 

.BCNF boyce-codd normal form was proposed as a simpler form of ______

A)3NF



Which of the following normal forms is violated when a relation has undesirable multivalued dependencies and hence can be used to identify and decomposition such relations?

A)4NF

LESSON-16-QUIZ


Which of the following files keeps the records ordered by value of a particular field?

A)Sorted



Which of the following buffer replacement strategies works best for certain type of database, such as when a block that is used most recently is not neded until all the remaining blocks in the are processed? 

A)MRU




Which of the following file allocation techniques allocates file blocks to consecutive disk blocks?

A)Contiguous

What occurs when the hash field value of a record that is being inserted hashes to an address that already contains a different record?

A)Collision

Which RAIC level uses a single parity disk relying on the disk controller to figure out which disk has falied?

A)3


LESSON-17 QUIZ


Which type of ordered single-level index is specified on nonordering fields as additional access structures to improve performance of queries and fransactios?

A)Secondary
Each node in a tree, except for a special node called a ---------has one perent node and zero or more child nodes 

A)root


Which type of index facilitates querying on multiple keys and is used for relations that contain a large number of rows?

A)Bitmap





 14. LAB


1. 




2. 





3.



4. 



5.




6.





16. LAB

1. 



2. 



3.


4. 



5.




17. LAB

1.

CREATE INDEX upper_ix ON EMPLOYEE_REC (UPPER(Lname));



2. 

SELECT Fname, Lname
FROM EMPLOYEE_REC
WHERE UPPER(Lname)= "SMITH";








































































Labels:

Comments

Post a Comment

Popular posts from this blog

IS5203 Type 2 Post Assessment and Final Quiz

  Carlos has just created a new subnet for the finance department. He needs to be able to allow the employees in finance to retrieve files from the sales server, which is located in another subnet. Which of the following OSI model layers would it be necessary to categorize the device into? a. Layer 4 b. Layer 6 c. Layer 2 d. Layer 3 All of the cubicles in a company's office have cables that run up to the ceiling and across to an IDF. Inside the IDF, they connect directly to the latest generation switch available from the networking equipment vendor that they have chosen. Which of the following describes the physical topology most likely in use? a. mesh
Post a Comment
Read more

GE5103-2 Project Management [Aug 23 Syllabus]

    Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A)        True 2.    Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A)        Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A)        Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in the project? A) Alerting Governance board if 10 percent over schedule 5. Of the following options, which stand
Post a Comment
Read more

GE5163 Week8 ( Final Exam ) Quize's

  A process or product that is insensitive to normal variation is referred to as being Select one: a. in specification b. capable c. robust d. out of control Feedback Your answer is correct. A completed failure mode and effects analysis (FMEA) results in the following assessment rating.      Occurrence = 4      Severity = 8      Detection = 10 What is the risk priority number (RPN) for this FMEA? Select one: a. 42 b. 22 c. 320 d. 120 Feedback Your answer is correct. In a visual inspection situation, one of the best ways to minimize deterioration of the quality level is to: Select one: a. have a program of frequent eye exams. b. retrain the inspector frequently. c. add variety to the task. d. have a standard to compare against as an element of the operation. Feedback Your answer is correct. Which of the following elements is least necessary to a good corrective action feedback report? Select one: a. What caused the failure b. Who caused the failure c. What correction has been made d. Wh
Post a Comment
Read more