DBI202 EXAM TEST BANK 486 QUESTIONS WITH 100% CORRECT ANSWERS UPDATE
2 vistas 0 veces vendidas
Grado
DBI202
Institución
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.
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable.
Así llegas a la conclusión rapidamente!
Preguntas frecuentes
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.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary 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 this summary for 11,71 €. You're not tied to anything after your purchase.