Advanced Database Management Study Guide Questions https://quizplus.com/study-set/1337 16 Chapters 1194 Verified Questions
Advanced Database Management Study Guide Questions Course Introduction Advanced Database Management delves into the theoretical principles and practical applications of modern database systems. The course covers advanced topics such as query optimization, transaction management, distributed databases, data warehousing, and NoSQL systems. Students will explore techniques for ensuring data consistency, scalability, and availability in large and complex database environments. Through hands-on projects and case studies, participants will gain experience in database design, performance tuning, and the integration of emerging technologies to solve real-world data management challenges.
Recommended Textbook Database Systems Design Implementation and Management 13th Edition by Carlos Coronel
Available Study Resources on Quizplus 16 Chapters 1194 Verified Questions 1194 Flashcards Source URL: https://quizplus.com/study-set/1337
Page 2
Chapter 1: Database Systems Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26666
Sample Questions Q1) _____ exists when the same data are stored unnecessarily at different places. Answer: Data redundancy Q2) A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. A) query B) operating system C) database management system D) application Answer: D Q3) _____ exists when different and conflicting versions of the same data appear in different places. Answer: Data inconsistency Q4) The only way to access the data in a database is through the DBMS. A)True B)False Answer: True Q5) Raw data must be properly _____ for storage, processing and presentation. Answer: formatted Q6) The term _____ refers to scattered locations storing the same basic data. Answer: islands of information
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Data Models Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26667
Sample Questions Q1) Which of the following is true of NoSQL databases? A) They do not support distributed database architectures. B) They are not based on the relational model. C) They are geared toward transaction consistency rather than performance. D) They do not support very large amounts of sparse data. Answer: B Q2) The _____ model is the end users' view of the data environment. Answer: external Q3) The _____ data model is said to be a semantic data model. A) relational B) network C) object-oriented D) entity relationship Answer: C Q4) A(n) _____ represents a particular type of object in the real world. A) attribute B) entity C) relationship D) node Answer: B Page 4 To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: The Relational Database Model Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26668
Sample Questions Q1) Relational algebra defines the theoretical way of manipulating table contents using relational operators. A)True B)False Answer: True Q2) If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A). A)True B)False Answer: True Q3) The practical significance of taking the logical view of a database is that it serves as a reminder of the simple file concept of data storage. A)True B)False Answer: True Q4) The proper use of _____ keys is crucial to controlling data redundancy. Answer: foreign To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Entity Relationship Er Modeling Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26669
Sample Questions Q1) In implementation terms, an entity is existence-dependent if it has a mandatory primary key. A)True B)False Q2) A(n) _____ attribute need not be physically stored within the database. Q3) The Crow's Foot notation depicts the strong relationship with a(n) _____ line between the entities. Q4) Identifying the attributes of entities helps in the better understanding of _____ among entities. Q5) A person's Social Security number would be an example of a(n) _____ attribute. Q6) A weak entity must be _____-dependent. Q7) The Crow's Foot notation is less implementation-oriented than the Chen notation. A)True B)False Q8) Failure to understand the distinction between mandatory and optional _____ in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.
Page 6
Q9) When indicating cardinality, the first value represents the _____ number of associated entities.
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: Advanced Data Modeling Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26670
Sample Questions Q1) The default comparison condition for the subtype discriminator attribute is the _____ comparison. A) nonequality B) less than C) greater than D) equality Q2) One practical advantage of a(n) _____ key is that because it has no intrinsic meaning, values for it can be generated by the DBMS to ensure that unique values are always provided. Q3) Which of the following is a specialization hierarchy disjoint constraint scenario in case of partial completeness? A) Subtype discriminator can be null. B) Subtype discriminator cannot be null. C) Each supertype occurrence is a member of only one subtype. D) Each supertype occurrence is a member of at least one subtype. Q4) An entity cluster is considered "virtual" or "_____" in the sense that it is not actually an entity in the final ERD. Q5) _____ completeness means that not every supertype occurrence is a member of a subtype. 8 click on the resource link above. To view all questions and flashcards with Page answers,
Chapter 6: Normalization of Database Tables Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26671
Sample Questions Q1) When a table contains only one candidate key, _____ are considered to be equivalent. A) the 1NF and the 2NF B) the 3NF and the BCNF C) the 4NF and the 3NF D) the BCNF and the DKNF Q2) Since a partial dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF. A)True B)False Q3) Any attribute whose value determines other values within a row is known as a(n) _____. Q4) A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies. A)True B)False Q5) Denormalization produces a lower normal form. A)True B)False
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Introduction to Structured Query Language Sql Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26672
Sample Questions Q1) The _____ specification is used to avoid having duplicated values in a column. Q2) How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18? A) 8 B) 18 C) 26 D) 144 Q3) Oracle users can use the Access QBE (query by example) query generator. A)True B)False Q4) Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components. A)True B)False Q5) The _____ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables. Q6) The syntax of theEXCEPT statement in Oracle is _____. Q7) In the SQL environment, the word _____ both questions and actions. Pagecovers 10 To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Advanced Sql Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26673
Sample Questions Q1) You cannot have an invalid entry in the foreign key column; at the same time, you cannot delete a vendor row as long as a product row references that vendor. This isknown as _____. A) batch updating B) referential integrity C) authentication D) cross joining Q2) In an INSERT command, a user can indicate just the attributes that have required values by listing the _____ inside parentheses after the table name. Q3) The Oracle equivalent to an MS Access AutoNumber is a(n) _____. A) auto-number B) sequence C) TO_NUMBER function D) trigger Q4) In a 1:M relationship, a user must always create the table for the "_____" side first. Q5) A table can be deleted from the database by using the _____ command. Q6) How are triggers critical to proper database operation and management? Q7) What is a schema? How many schemas can be used in one database? Page 11 To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Database Design Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26674
Sample Questions Q1) The maintenance and evolution phase of the Database Life Cycle (DBLC) involves _____. A) defining objectives B) introducing changes C) testing the database D) installing the DBMS Q2) List and briefly describe the three types of system maintenance activities. Q3) Systems analysis establishes the need for an information system and its extent. A)True B)False Q4) Training principles and methodologies are planned during the _____ phase of the Systems Development Life Cycle (SDLC). A) maintenance B) implementation C) analysis D) detailed systems design Q5) The term _____ describes the strength of the relationships found among a module's entities. Q6) The proposed system is subject to limits known as _____, which are external to the system.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Transaction Management and Concurrency Control Available Study Resources on Quizplus for this Chatper 74 Verified Questions 74 Flashcards Source URL: https://quizplus.com/quiz/26675
Sample Questions Q1) A _____ lock will lock the entire diskpage. A) transaction-level B) table-level C) page-level D) row-level Q2) What rule applies to the two-phase locking protocol? A) Two transactions cannot have conflicting lock. B) No unlock operation can precede a lock operation in a different transaction. C) No data is affected until all locks are released. D) No data is affected until the transaction is in its locked position. Q3) _____ occurs when a transaction accesses data before and after one or more other transactions finish working with such data. A) Inconsistent retrieval B) The phenomena of uncommitted data C) Lost update problems D) Dirty read problems Q4) How does a shared/exclusive lock schema increase the lock manager's overhead? Q5) Most multiuser _____ automatically initiate and enforce locking procedures, where Page 13 all locking information is managed by the lock manager. To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Database Performance Tuning and Query Optimization Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26676
Sample Questions Q1) RAID systems use a single disk to create storage volumes. A)True B)False Q2) The B-tree index is used mainly in tables in which column values repeat a relatively small number of times. A)True B)False Q3) A(n) _____ is a logical grouping of several data files that store data with similar characteristics. A) procedure cache B) table space C) data cache D) listener Q4) The majority of primary memory resources will be allocated to the _____ cache. A) data B) SQL C) sort D) optimizer Page 14 Q5) List and describe some typical DBMS processes. Q6) _____ is evaluated based on client perspective.
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 12: Distributed Database Management Systems Available Study Resources on Quizplus for this Chatper 74 Verified Questions 74 Flashcards Source URL: https://quizplus.com/quiz/26677
Sample Questions Q1) Current distributed database management system (DDBMS) are subject to some problems, such as the complexity of management and control. A)True B)False Q2) The level of transparency supported by the distributed database management system remains the same for all systems. A)True B)False Q3) A user-friendly _____ is one advantage of a distributed database management system (DDBMS) . Q4) A distributed _____ can reference several different local or remote data processing sites. A) request B) site C) data location D) transaction Q5) In a distributed database management system (DDBMS), _____ occurs to determine the data location of local and remote fragments. Q6) A transaction processor is also known as the _____ processor. Page 16 To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Business Intelligence and Data Warehouses Available Study Resources on Quizplus for this Chatper 74 Verified Questions 74 Flashcards Source URL: https://quizplus.com/quiz/26678
Sample Questions Q1) _____ extends SQL so that it can differentiate between access requirements for data warehouse data and operational data. A) ROLAP B) OLAP C) DBMS D) BI Q2) A data warehouse designer must define common business dimensions that will be used by a data analyst to expand a search. A)True B)False Q3) What is the difference between decision support data and operational data from the point of view of data analyst? Q4) A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows. A) SQL view B) materialized view C) star schema D) data cube Q5) ______ is a method or process of government. 17 click on the resource link above. To view all questions and flashcards withPage answers,
Chapter 14: Big Data and Nosql Available Study Resources on Quizplus for this Chatper 75 Verified Questions 75 Flashcards Source URL: https://quizplus.com/quiz/26679
Sample Questions Q1) The ability to graphically presentdata in a way that makes it understandable is the concept of value. A)True B)False Q2) ______ is the Big Data 3 V that relates to the speed at which data is entering the system. Q3) A query in a graph database is called a ______. A) schema B) hierarchy C) traversal D) script Q4) Data collected or aggregated around a central topic or entity is said to be ______ aware. A) aggregate B) transversally C) feedback D) visually Q5) Adatabase model that attempts to provide ACID-compliant transactions across a highly distributed infrastructure is ______. 18 click on the resource link above. To view all questions and flashcards withPage answers,
Chapter 15: Database Connectivity and Web Technologies Available Study Resources on Quizplus for this Chatper 73 Verified Questions 73 Flashcards Source URL: https://quizplus.com/quiz/26680
Sample Questions Q1) _____ refer to a cloud computing-base data management service that provides relational data storage, access, and management to companies of all sizes without the typical high costs of in house hardware, software, infrastructure, and personnel. Q2) XML is derived from the _____, an international standard for the publication and distribution of highly complex technical documents. Q3) Every XML document has a _____. A) root element B) base tag C) schema D) DTD Q4) A(n) _____ provides limited additional semantic value to XML, such as data type support or data validation rules. Q5) The _____ is an advanced data definition language that is used to describe the structure of XML data documents. A) XHTML B) HTML schema C) DTD D) XML schema To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 16: Database Administration and Security Available Study Resources on Quizplus for this Chatper 74 Verified Questions 74 Flashcards Source URL: https://quizplus.com/quiz/26681
Sample Questions Q1) A full backup, or database dump, produces a complete copy of the entire database. A)True B)False Q2) The security, privacy, and integrity of data in a database are of minimal concern to DBAs who manage current DBMS installations. A)True B)False Q3) A security breach is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions. A)True B)False Q4) Each database has an associated_____ file that is read at instance startup, stores run-time configuration parameters, and is used to set the working environment for the database. Q5) The _____ aspect of introducing a DBMS in an organization deals with hardware and software changes in the organization. Q6) Describe the DBA's managerial role. To view all questions and flashcards with answers, click on the resource link above. Page 20