DBI202-final Exam Questions with 100% Correct Answers

DBI202-final Exam Questions with 100% Correct
Answers
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.

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

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

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

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

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

B

Which of the following is NOT a standard aggregation operator?

[A]SUM

[B]AVG

[C]GROUP

[D]COUNT

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>

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

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.

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

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