Exam (elaborations)
DBI 202 Exam Questions with 100% Correct Answers
- Course
- Institution
DBI 202 Exam Questions with 100% Correct Answers
[Show more]
Seller
Follow
Content preview
DBI 202 Exam Questions with 100% CorrectAnswers
Which of the following is not true about stored procedure?
a. Stored procedures can enhance security control (users can be granted Permission to execute
a stored procedure independently of underlyingTable permissions)
b. Stored procedures can replace stored functions to improve performance
c. Stored procedures can reduce/avoid network traffic
d. None of the others - ✔️✔️D
Choose the right statement
a. Transaction is a collection of one or more operations on the Database that must be executed
atomically. That is, either all Operations are performed or none of them is done.
b. In sql, each statement is a transaction by itself.
c. All of the others
d. Sql allows us to group several statements into a single transaction. - ✔️✔️C
Suppose a relation project(projectid, projectname, location, department,
Projectlo1(projectid, projectname, department) is an updatable view
Associated to project where location=1. Evaluate the following statement:
Insert into projectlo1 (projectid, projectname, department) values
(200,'erp1.0',1);
a. The query is executed, there is new tuple (200,'erp1.0',1) on Projectlo1, and new tuple
(200,'erp1.0',1,1) on project
, b. The query is executed, there is no new tuple on projectlo1, and new Tuple
(200,'erp1.0',null,1) on project
c. The query is executed, there is new tuple (200,'erp1.0',1) on Projectlo1, and new tuple
(200,'erp1.0',null,1) on project
d. The query is executed but nothing happened on project neither on Projectlo1 - ✔️✔️D
Suppose the theta join r3 :=r1?r2, where c is a condition that refers to
Attributes of r1 and r2. Which of the followings is correct?
a. Each tuple t1 of r1 connect with one tuple t2 of r2
b. Each tuple t1 of r1 connect with some those tuple t2 of r2 that satisfy c
c. Each tuple t1 of r1 connect with all those tuple t2 of r2 that satifsy c
d. None of the others - ✔️✔️B
Which of the following statement is not true:
a. Problems such as redundancy that occur when we try to cram too much
Into a single relation are called anomalies
b. If x is a key, then x is a super key
c. A relation can have only one key
d. A set of one or more attributes {a1, a2, ..., an} is a key for a relation r if these attributes
functionally determine all other attributes of the relation r and these attributes must be
minimal - ✔️✔️C
Which of the following is not a valid loop construct in psm?
a. Repeat until end repeat;
,b. Loop end loop;
c. While do end while;
d. None of the others - ✔️✔️D
Select the right statement
a. All of the others
b. A view is a virtual table
c. Not all views are updatable
d. With updatable views, the modification is translated into an equivalent modification on a
base table - ✔️✔️A
Which of the following isolation levels forbids the reading of dirty data?
a. Set transaction isolation level read uncommited;
b. Set transaction isolation level serializable;
c. Set transaction isolation level read committed;
d. Set transaction isolation level repeatable read; - ✔️✔️D
Which of the following isolation levels forbids the reading of dirty data?
a. Set transaction isolation level read uncommited;
b. Set transaction isolation level serializable;
c. Set transaction isolation level read committed;
d. Set transaction isolation level repeatable read; - ✔️✔️D
Which of the following datalog rules is safe?
, Choose at least one Answer:.
a. R(x,y,z) ? U(x,y) and t(y,z)
b. R(x,y,z) ? S(x) and u(x,y) and t(y,z)
c. R(x,y,z) ? S(x) and t(x,y) and y < z
d. R(x,y,z) ? U(x,y) and t(x,y) and y < z - ✔️✔️A,B
Which of the following is the correct definition of a procedure:
a. Create procedure () returns ;
b. All of the others
c. Create procedure () ;
d. Create procedure () returns return ; - ✔️✔️B
Which statement is true?
a. All xml documents must have a dtd
b. All of the others
c. All xml elements must be properly closed
d. All xml elements must be lower case - ✔️✔️C
Select the wrong statement
a. None of the others
b. An index can be created in a table to find data more quickly and Efficiently
c. A table can have only one index
d. The key for index can be any attribute or set of attributes, and Need not be the key of the
relation - ✔️✔️C
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Examcheatcode. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now