Exam (elaborations)
DBI-202 Exam |Questions with 100% Correct Answers
- Course
- Institution
DBI-202 Exam |Questions with 100% Correct Answers
[Show more]
Content preview
DBI-202 Exam |Questions with 100%Correct Answers
A SOL environment is the framework under which data may exist and SQL operations on
data may be executed - ✔ ✔ All of the others
Schema-altering commands are known as......commands. - ✔ ✔ Data Definition Language
Referential integrity Constraints control relationships between _. - ✔ ✔ tables in a database
Choose the right statement below to declare zero or one occurrence of an Element in DTD. -
✔ ✔ <"ELEMENT element-name (child-name?)>
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 - ✔ ✔ SELECT LNAME.
FNAME. SALARY FROM Employee WHERE SALARY IN (SELECT MIN(SALARY) FROM Employee)
Given a relation R(A.B.C.D). Which of the followings is trivial? - ✔ ✔ A->->BCD
Which of the following is NOT a standard aggregation operator? - ✔ ✔ GROUP
Select the well-formed XML - ✔ ✔ <? xml version = "1.0" ?>_<MovieData>_<Movie
tiHe="StarWar*><Year>1997</Yearx/MovJe>_</MovieData>
Which of the followings is true? - ✔ ✔ The Entity Relationship (ER) model represents
the structure of data graphically
,In the three-tier architecture, the database tier's function is to - ✔ ✔ Execute queries that
are requested from the application tier.
Choose a right answer - ✔ ✔ An authorization ID may be granted privileges from others or
may grve its privileges to others
Which of the followings is part of data model? - ✔ ✔ All of the others
Structure of the dataException 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 - ✔ ✔
All of the others
In SQL language, the command/statement that let you add an attribute to a relation is -
✔ ✔ Alter
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? - ✔ ✔ H has a tuple (3.5)
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): -
✔ ✔ CREATE TABLE Studio (name CHAR(30) PRIMARY KEY. address VARCHAR(256). presC#
INT REFERENCES Movie Exec (cert#));
The relational operator that yields all possible pairs of rows from two tables is known as -
✔ ✔ Product
Consider a relation with schema R(A, B, CD) and FD's BC-> D, D-> A, A-> B. Which of the
following is the key of R? - ✔ ✔ BC
,The ER Diagram uses three principle element types: - ✔ ✔ Entity sets. Attributes,
and Relationships
In PSM. the difference between 3 stored procedure and a function is that - ✔ ✔ All of the others
Selecl Ihe right syntax for HAVING clause in SOL - ✔ ✔ SELECT <list of attributes>_FROM <list
of tables>_WHERE <conditions on tuples>_GROUP BY <list of attributes>_HAVING <conditions
on groups>
Select the right answer. - ✔ ✔ All of the others
Given relations R(A.B) and S(B.C.D). The result of natural join of the relations R and S has -
✔ ✔ Attributes A B. C. D
Given relation U(A, B, C) that has 2 tuples (1,2,3) and (4,5,6), and relation V(B(C, D) that has
2 tuples (2,3,10) and (2,3,11). Choose the right answer below; - ✔ ✔ The outer join of U and
V is the relation R(A. B. C. D) that has 3 tuples (1.2.3.10) .(1.2.3.11) and (4.5.6. NULL).
Definition language (DDL) is used to - ✔ ✔ declare database schemas
The result of (UNKNOWN OR TRUE) is - ✔ ✔ TRUE
In Java Database Connectivity (JDBC). before we can execute SQL statements), we need to -
✔ ✔ Establish a connection to the database and create statement(s).
Choose the right answer - ✔ ✔ All of the others
Which of following is never used as a data model' - ✔ ✔ None of the others
, Select the right answer - ✔ ✔ All of other
Select the right statement to declare MovieStar to be a relation whose tuples are of type
StarType. Note; StarType is a user-defined type that has its definition as follows;_CREATE TYPE
StarType AS (_nameCHAR(30)._address CHAR(IOO) }; - ✔ ✔ CREATE TABLE MovieStar OF
StarType Q;
Suppose an updatable view ParamountMovies is associated with Movies relation. Choose
a nght answer - ✔ ✔ Drop Movies relation also delete the view ParamountMovies
The most useful index on a relation is an index on its key. This is because - ✔ ✔ The
search operation based on the primary key is commonly used.
Which of the following statements is true? - ✔ ✔ 4NF implies BCNF and BCNF implies 3NF
The binary relationship between classes in UML is called - ✔ ✔ Association
Choose the right statement - ✔ ✔ All of the others
Which of the following statements is true? - ✔ ✔ All of the others
Given the relation Movies(title, year, length, genre. studioName). Select the right query to
create a View with the titles and studio names of all movies that were produced in 1980 - ✔ ✔
CREATE VIEW OldMovies AS SELECT title. studioName FROM Movies WHERE year=1980
Given the relation Employee(SSN. FNAME. LNAME. SALARY. DepartmentNo). Select the right
query below to count the number of employees in each department - ✔ ✔ SELECT
DepartmentNo. COUNT(*) FROM Employee GROUP BY DepartmentNo
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 Examsplug. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now