Dbi202 exam - Study guides, Class notes & Summaries

DBI202 Final Exam |Questions with 100% Correct Answers

DBI202 (Full) Question and Answers 2024 | Exam Review

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 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 Questions and Answers Updated 2024 A CASE SQL statement is which of the following? Select one: A way to establish a loop in SQL A way to establish a data definition in SQL All of the above A way to establish an IF-THEN-ELSE in SQL - Answer-A way to establish an IF-THEN-ELSE in SQL A domain of PaymentMethod attributes in Invoice relation have 2 types: Cash, Transfer. Which statement is used to validate the data entries? Select one: ...CHECK PaymentMethod = ('Cash',...

dbi202 Exam Study Guide with Complete Solutions DBMS is a collection of .............. that enables user to create and maintain a database. - Answer-Program In a relational schema, each tuple is divided into fields called - Answer-Domains In an ER model, ................ is described in the database by storing its data. - Answer-Entity DFD stands for - Answer-Data Flow Diagram A top-to-bottom relationship among the items in a database is established by a - Answer- Hierarchical schema .....

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 [...

DBI202 Exam |Questions with 100% Correct Answers