100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
DBI202 Exam Practice Questions and Answers Updated 2024 $12.49   Add to cart
Quickly navigate to
Preview
  2.  
  3. 2024/2025
  4.  
  5. 2024/2025

Exam (elaborations)

DBI202 Exam Practice Questions and Answers Updated 2024
 0 view  0 purchase
  • Course
  • 2024/2025
  • Institution
  • 2024/2025

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

[Show more]

Preview 4 out of 200  pages

Document information

  • October 16, 2024
  • 200
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • dbi202 exam practice questions and answers updated

Written for

  • 2024/2025
  • 2024/2025

Seller

avatar-seller
Emillect

Content preview

EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024




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


[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

Page 1/200

,EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024


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



Page 2/200

,EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024


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



Page 3/200

, EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024


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


[D]Execute queries that are requested from the application tier. - Answer✔✔-D


Choose a right answer



Page 4/200

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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 Emillect. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $12.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

77254 documents were sold in the last 30 days

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

Start selling
$12.49
  • (0)
  Add to cart