DBI202 EXAM TEST BANK 486 QUESTIONS WITH 100% CORRECT ANSWERS UPDATE
2 views 0 purchase
Course
DBI202
Institution
DBI202
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 (atom...
DBI202 EXAM TEST BANK 486
QUESTIONS WITH 100%
CORRECT ANSWERS 2024-2025
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 database must either complete in its entirety or have
no effect
whatsoever
B. 'Consistent' means that: Transactions must not violate any integrity constraints during
its execution - Answer ✔ B
In database design processes, data requirements are expressed through
(a) Schema Design
(b) ERD
(c) UML
(d) Table Design
A. (c) and (d)
B. (b) and (c)
C. (a) and (b) - Answer ✔ B
Consider the law. that holds for set relations:
(R natural join S) natural join T = R natural join (S natural join T). Does the above law
still hold for bag relations?
A. True
B. False - Answer ✔ A
Answer
,Compute the union of the ABC
123
423
456
253
126
and relation S(A.B.C):
ABC
253
254
456
123
Which of the following tuples DOES NOT appear in the result?
A. (1.2.3)
B. (4.5.6)
C. (1.5.4)
D. (4.2.3) - Answer ✔ C
Consider the law. that holds for set relations:
(R natural join S) natural join T = R natural join (S natural join T). Does the above law
still hold for bag relations?
A. True
B. False - Answer ✔ A
The ER model can:
[A]enable low level descriptions of data
[B]replace relational design
[C]enable detailed descriptions of data query processing
[D]be close to a users perception of the data - Answer ✔ D
The DBMS (Database Management System) is expected to:
[A]Allow users to query the data
[B]Support the storage of very large amounts of data
[C]Allow users to create new databases and specify their schemas
[D]All of the others - Answer ✔ D
What is an Entity Set?
A. It is a collection of entities of a particular entity type grouped together into an entity
set
B. It is a "thing" in the real world with an independent existence.
C. None ofthe others
D. It is a collection (set) of entities that have same attributes - Answer ✔ A
What is the degree of a Relation?
[A]None of the others
,[B]It Is the number of attributes of its relation schema
[C]It is the number of tuples of its relation schema - Answer ✔ B
SELECT name
FROM customers
WHERE name LIKE '%Gate';.
This query would yield an name for every customer whose name ends with "Gate".
Suppose that the name column has been Indexed.
Which of the following statements is correct?
[A]None of the others
[B]The database does not perform a full table scan when executing the above SELECT
statement
[C]The database must perform a full table scan when executing the above SELECT
statement - Answer ✔ C
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
[C]Data Definition Language
[D]None of the others - Answer ✔ C
Referential integrity Constraints control relationships between _.
[A]operations of an object
[B]tables in a database
[C]attributes in a table
[D]database instances - Answer ✔ B
Choose the right statement below to declare zero or one occurrence of an Element in
DTD.
[A]<"ELEMENT element-name (childname?)>
[B]<IELEMENT element-name (child-name+)>
[C]<'ELEMENT element-name (child-name*)>
[D]<IELEMENT element-name (child-name)> - Answer ✔ A
Given the relation Employee(SSN. FNAME. LNAME. SALARY). Select the right query
below
to find the employee(s) who has the lowest salary in the company
, [A]SELECT LNAME. FNAME. SALARY FROM Employee WHERE SALARY IN
(SELECT
MIN(SALARY) FROM Employee)
[B]SELECT LNAME. FNAME. SALARY FROM Employee WHERE SALARY >= ALL
(SELECT SALARY FROM Employee)
[C]SELECT LNAME. FNAME. SALARY FROM Employee WHERE SALARY < MAX
(SELECT SALARY FROM Employee)
[D]None of the others - Answer ✔ A
Given a relation R(A.B.C.D). Which of the followings is trivial?
[A]A->BCD
[B]A->->BCD
[C]A->AB
[D]A->->AB - Answer ✔ B
Which of the following is NOT a standard aggregation operator?
[A]SUM
[B]AVG
[C]GROUP
[D]COUNT - Answer ✔ C
Select the well-formed XML
[A]All of the others
[B]<? xml version = "1.0" ?>
<MovieData>
<Movie tiHe="StarWar*><Year>1997</Yearx/MovJe>
</MovieData>
[C]<? xml version - "1 0' ?>
<MovieData>
<Movie Me-'StarWaf*><Year>1997</Year></Movie>
</Movies>
[D]<? xml version = 1 0 7>
<MovieData>
<Movie trtle-"StarWar"><Year>1997</Movie></Year>
</MovieData> - Answer ✔ B
Which of the followings is true?
[A]The Entity Relationship (ER) model represents the structure of data graphically
[B]The ER model is a low level database design
IC]The ER model represents the operation on data
[D]All of the others - Answer ✔ A
In the three-tier architecture, the database tier's function is to
[A]All of the others.
[B]Execute the business logic of the organization operating the database.
[C]Manage the interactions with the user.
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 Scholarsstudyguide. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
