Dbi202 practice exam - Study guides, Class notes & Summaries

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 Practice Exam Questions and Answers Updated 2024 What do machine instructions not cause a transfer of control? A. Instructions related IO accesses B. Branching C. All of others D. Arithmetic instructions - Answer-A. Instructions related IO accesses In the context of reduced instruction set computing(RISC) architecture to pass a called function,____ A. Memory locations B. Registers C. Immediate values D. All of the others - Answer-B. Registers 1, in the context addressing mode...

DBI202 Exam Practice Questions and Answers Updated 2024 Which of the following statement is belong to DML? Select one: a. CREATE b. INSERT c. GRANT d. ALTER - Answer-b Suppose a relation R(A,B) and S(B,C) are bags. R has 2 tuples (1,3), (2,4) and S has 3 tuples (1,2), (1,2) and (4,5). The theta join R ⋈ R.B>S.B S has __________ tuples Select one: a. 2 b. 3 c. 6 d. 4 - Answer-d Choose a right statement about high level design. EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT....

DBI202 Exam Practice Questions and Answers Which of following feature is NOT responsibility of Database Management System? A. Allow users to create new databases and specify their schemas B. Give users the ability to query the data C. Support the storage of very large amounts of data D. Manage user accounts of computer on which DBMS is running - Answer-d Which of following statement is correct? A. Every relation must have only one primary key B. Primary key has only one attribute C. Tw...

DBI202 Exam Practice Questions and Answers Updated 2024 Which statement is true? a. Xml documents must have a root tag b. All of the others c. Xml tags are case sensitive d. Xml elements must be properly nested - Answer-B In a typical olap application, there is a central relation or collection Of data, called ______ a. The fact table b. All of the others c. The dimension table d. The star table - Answer-A There is a way of describing xml data, how? EMILLECT 2024/2025 ACADEMIC YEAR ...

DBI202 Exam Practice Questions and Answers Updated 2024 Choose a right answer. A. A SOL environment is the framework under which data may exist and SQL operations on data may be executed [B] All of the others [C] Within a SQL environment are two special kinds of processes: SQL clients and SQL servers. [D] A SQL environment is a DBMS running at some installation. - Answer-B Schema-altering commands are known as......commands. [A]Data Manipulation Language [B]Data Controlling Language [...