Dbi202 exam Study guides, Class notes & Summaries

DBI202 EXAM QUESTIONS WITH ALL CORRECT ANSWERS (NEWEST VERSION) Which of the following is considered disadvantage of triggers? A. Triggers run every time the database fields are Inserted/updated/deleted, so it adds overhead to system. B. Triggers execute invisible to client application. It is called by the database server automatically, not by the client application or user. C. All of the others D. Unlike stored procedure, parameters cannot be used with triggers. - Answer b The deg...

DBI202 EXAM TEST BANK 486 QUESTIONS WITH 100% CORRECT ANSWERS UPDATE What SQL keyword can be used to return data from two non-related tables as a combined set of rows? A. DISTINCT ALL B. DISTINCT C. UNION ALL D. COMBINED - Answer C A database transaction, by definition, must be ACID (atomic, consistent isolated and durable). What does 'Consistent" mean? A. 'Consistent' means that: Transactions provide an "all-or-nothing" proposition, stating that each work-unit performed in a d...

DBI202 EXAM NEWEST 2024 ACTUAL EXAM TEST BANK COMPLETE QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) ALREADY GRADED A+ What is the goal of decomposition when designing a database? - Answer-The goal of decomposition is to replace a relation by several relations that do not exhibit anomalies When drawing an ERD:(a)Entity sets and their attributes should reflect reality(b)Redundancy is not important, so we can ignore it(c) Avoid introducing more elements into the design than is absolutely ...

DBI202 EXAM LATEST VERSION QUESTIONS WITH CORRECT ANSWERS (GRADED A+) Then, identify which of the following tuples is/are in the natural joinR|>< - Answer-S. You may assume each output tuple has schema (A.B.C.D)|(3.4.6.8) and (12.4.6) Consider the following statement "When drawing ERD. you should avoid introducing more elements into your design than necessary" That above statement describes which principle? - Answer-Simplicity Count Principle Compute the join of R and S with the...

DBI202 FINAL EXAM REAL EXAM QUESTIONS AND CORRECT ANSWERS (NEWEST VERSION) Which of the followings is false about weak entity set? Choose one answer. a. Every many - one relationship from a weak entity set need be supporting b. The key for a weak entity set includes the keys for all supporting entity sets c. A weak entity set has one or more relationships to other (supporting) entity sets d. Do not construct a relation for any supporting relationship - Answer b. The key for a we...

DBI202 LATEST 2024 REAL EXAM QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) A GRADE What is the hierarchical data model? - Answer A hierarchical data model is a data model in which the data is organized into a tree-like structure A person who is responsible for the structure or schema of the database is called: - Answer a database administrator A database administrator (DBA) is a person that is also known by the title: - Answer Database Coordinator or Database Programmer A ___ is ...

DBI202 PRACTICE EXAM QUESTIONS AND ANSWERS ALL CORRECT Which of the following is considered disadvantage of triggers? a. Triggers run every time the database fields are Inserted/updated/deleted, so it adds overhead to system. b. Triggers execute invisible to client application. It is called by the database server automatically, not by the client application or user. c. All of the others d. Unlike stored procedure, parameters cannot be used with triggers. - Answer B The degree...

DBI202 ACTUAL EXAM QUESTIONS WITH ALL CORRECT ANSWERS UPDATED When performing union, intersection, or difference operations on relations R and S, they must be type compatible. That is, ______ Select one: a. The domain of corresponding attributes of R and S must be compatible b. The names of attributes of R and S must be the same c. R and S must have the same number of attributes d. R and S must have the same number of attributes and the domain of corresponding attributes of R and S must b...

DBI202 (Full) Question and Answers 2024 | Exam Review