DBI202-Final total, DBI202 (Full) Practice Questions with Guaranteed Pass Solutions.

DBI202-Final total, DBI202 (Full) Practice
Questions with Guaranteed Pass
Solutions.
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.

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



Choose a right answer

[A]When a privilege is granted, it cannot be revoked

[B]Privileges cannot be granted on a view

[C]An authorization ID may be granted privileges from others or may grve its

privileges to others

[D]All of the others - Answer C



Which of the followings is part of data model?

[A]Operations on the data

[B]Constraints on the data

[C] All of the others |

[D]Structure of the data - Answer C



Exception handler in PSM is defined as follows:

DECLARE <where to go next> HANDLER FOR condition list> <statement>

The <where to go next> clause can be:

[A]UNDO

[B]EXIT

[C]All of the others

[D]CONTINUE - Answer C



In SQL language, the command/statement that let you add an attribute to a relation

is_

[A]Alter

[B]None of the others

[C]Insert

, [D]Update - Answer A



Choose the right statement

[A]All of the others.

[B]The syntax to remove a trigger is. DROP TRIGGER<trigger_name>

[C]Use ALTER TRIGGER to change the definition of a trigger

[D]You can remove a trigger by dropping it or by dropping the trigger table. - Answer A



Consider the Dalalog rule H(xy) <- Sfx. y) AND x > 2 AND y < 6. Relation S(x y) has 3 tuples

(2.3). (3.5). and (4.6). What is about H?

[A]H has a tuple (2.3)

[B]H has 3 tuples (2.3) and (3.5) and (4.6)

[C]H has 2 tuples (2.3) and (3.5)

[D]*H has a tuple (3.5) - Answer D



Select the valid query to declare the foreign key presC# of the relation Studiolname. address.

presC#) that references the cert of the relation MovieExeclname. address. cert#. netWorth):

[A]All of the others.

[B]CREATE TABLE Studio (name CHAR(30) PRIMARY KEY. address VARCHAR(256). presC#

INT FOREIGN KEY):

[C]CREATE TABLE Studio (name CHAR(30) PRIMARY KEY. address VARCHAR(256). presC#

INT UNIQUE KEY REFERENCES MovieExec):

[D]CREATE TABLE Studio (name CHAR(30) PRIMARY KEY. address VARCHAR(256). presC#

INT REFERENCES Movie Exec (cert#)); - Answer D



Choose the right statement

[A]XML Schema allows us to declare simple types, such as integer or float and even complex
types

[B]All of the others

[C]XML schema provides us the ability to declare keys and foreign keys.

[D]XML Schema is an alternative way to provide a schema for XML documents. - Answer B



The relational operator that yields all possible pairs of rows from two tables is known as a _

[A]Union

[B]Selection