40 likes | 53 Views
Enjoy your success in Microsoft Certification Exams with our Database Fundamentals Exam Customization and Configuration Exam Dumps!!! 98-364 Dumps with Questions and their Answers for Database Fundamentals Exam Customization and Configuration Practice Test software is a success leading way towards your Microsoft 98-364 Exam. All the 98-364 solved Questions are tested and approved by professional experts to assure 100% success in Database Fundamentals Exam Customization and Configuration exam. Visit us for more information on https://www.troytec.com/exam/98-364-exams
E N D
98-364 Database Fundam entals Exam : 98-364 Demo Edition © 2015 - 2016Troy Tec, LTD All Rights Reserved 1 http://www.troytec.com
98-364 QUESTION: 1 The terms "bitmap," "b-tree," and "hash" refer to which type of database structure? A. View B. Function C. Index D. Stored procedure E. Trigger Answer: C QUESTION: 2 One reason to add an index is to: A. Decrease storage space. B. Increase database security. C. Improve performance of select statements. D. Improve performance of insert statements. Answer: C QUESTION: 3 You have a table that contains the following data. You break the table into the following two tables. 2 http://www.troytec.com
98-364 This process is referred to as: A. defragmentation B. normalization C. fragmentation D. denormalization Answer: B QUESTION: 4 You have a table that contains the following data. Which database term is used to describe the relationship between ProductID and Product Category? A. Cohort B. Relationally dependent C. Deterministic D. Functionally dependent E. Compositional Answer: D QUESTION: 5 Which key uniquely identifies a row in a table? A. foreiqn B. primary C. local D. superkey 3 http://www.troytec.com
98-364 Answer: B 4 http://www.troytec.com