100% de satisfacción garantizada Inmediatamente disponible después del pago Tanto en línea como en PDF No estas atado a nada
logo-home
DBI202 EXAM TEST BANK 486 QUESTIONS WITH 100% CORRECT ANSWERS UPDATE 11,71 €   Añadir al carrito

Examen

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

[Mostrar más]

Vista previa 4 fuera de 91  páginas

  • 18 de septiembre de 2024
  • 91
  • 2024/2025
  • Examen
  • Preguntas y respuestas
  • DBI202
  • DBI202
avatar-seller
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

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

45,681 summaries were sold in the last 30 days

Founded in 2010, the go-to place to buy summaries for 14 years now

Empieza a vender
11,71 €
  • (0)
  Añadir