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 LATEST 2024 REAL EXAM QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) A GRADE $13.99
Add to cart
Quickly navigate to
Preview
  2.  
  3. DBI202
  4.  
  5. DBI202

Exam (elaborations)

DBI202 LATEST 2024 REAL EXAM QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) A GRADE
 0 purchase
  • Course
  • DBI202
  • Institution
  • DBI202

DBI202 LATEST 2024 REAL EXAM QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) A GRADE What is the hierarchical data model? - Answer A hierarchical data model is a data model in which the data is organized into a tree-like structure A person who is responsible for the structure or schema of the...

[Show more]

Preview 4 out of 43  pages

Document information

  • September 18, 2024
  • 43
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • dbi202
  • dbi202 latest 2024 real exam questions
  • what is the hierarchical data model

Written for

  • DBI202
  • DBI202

Seller

avatar-seller
Scholarsstudyguide

Reviews received

Content preview

DBI202 LATEST 2024 REAL EXAM
QUESTIONS AND CORRECT
ANSWERS (VERIFIED ANSWERS)
A GRADE
What is the hierarchical data model? - Answer ✔ A hierarchical data model is a data
model in which the data is organized into a tree-like structure

A person who is responsible for the structure or schema of the database is called: -
Answer ✔ a database administrator

A database administrator (DBA) is a person that is also known by the title: - Answer ✔
Database Coordinator or Database Programmer

A ___ is a notation for describing the structure of the data in a database, along with the
constraints on that data - Answer ✔ data model

Data Definition language (DDL) is used to ...... - Answer ✔ declare database schemas

Which is the subset of SQL commands used to manipulate Database structures,
including tables? - Answer ✔ DDL (Data Definition Language)

Which of the followings is part of data model? - Answer ✔ All of the others

"R(A,B,C,D)" is an example of: - Answer ✔ A schema

Which statement is used to remove a column named D from the relation R? - Answer ✔
ALTER TABLE R DROP COLUMN D;

What is a primary key? - Answer ✔

a. A primary key is the field(s) in a table that uniquely defines that table in a database -
Answer ✔ A primary key is the field(s) in a table that uniquely defines the row in the
table

,A ____ is a relation name, together with the attributes of that relation. - Answer ✔
schema

Which statement is used to add a column named D into the relation R? - Answer ✔
ALTER TABLE R ADD D [DataType];

Which one of the following is NOT a DML command? - Answer ✔ GRANT

What is another term for a row in a relational table? - Answer ✔ Tuple

The relational operator that adds all possible pairs of rows from two tables is known as
the .... - Answer ✔ product

What is a functional dependency? - Answer ✔ A functional dependency (A->B) occurs
when the attribute A uniquely determines B

Consider a relation with schema R(A, B, C, D) and FD's BC -> D, D -> A, A -> B. Which
of the following is the key of R? - Answer ✔ BC

Given the relation schema R(A,B,C) and functional dependencies F = {AB-> C, B->A, C-
>B}. Which attribute(s) is/are prime? - Answer ✔ B and C

DBMS is a collection of .............. that enables user to create and maintain a database. -
Answer ✔ Program

In a relational schema, each tuple is divided into fields called - Answer ✔ Domains

In an ER model, ................ is described in the database by storing its data. - Answer ✔
Entity

DFD stands for - Answer ✔ Data Flow Diagram

A top-to-bottom relationship among the items in a database is established by a - Answer
✔ Hierarchical schema

.................. table store information about database or about the system. - Answer ✔
System

..............defines the structure of a relation which consists of a fixed set of attribute-
domain pairs. - Answer ✔ Schema

.................. clause is an additional filter that is applied to the result. - Answer ✔ Having

A logical schema - Answer ✔ is a standard .. accessible parts.

,..................... is a full form of SQL. - Answer ✔ Structured query language

A relational database developer refers to a record as - Answer ✔ a tuple

.......... keyword is used to find the number of values in a column. - Answer ✔ COUNT

An advantage of the database management approach is - Answer ✔ data is integrated
and can be accessed by multiple programs

The collection of information stored in a database at a particular moment is called as ...
- Answer ✔ instance of the database

Data independence means - Answer ✔ (2ans) programs are not dependent on the
physical (logical) attributes of data

A ......... is used to define overall design of the database - Answer ✔ schema

Key to represent relationship between tables is called - Answer ✔ foreign key

Grant and revoke are ....... statements. - Answer ✔ DCL

DBMS helps achieve - Answer ✔ Data independence, Centralized control of data

.......... command can be used to modify a column in a table - Answer ✔ alter

The candidate key is that you choose to identify each row uniquely is called ................. -
Answer ✔ Primary Key

................. is used to determine whether of a table contains duplicate rows. - Answer ✔
Unique predicate

To eliminate duplicate rows .................. is used - Answer ✔ DISTINCT

State true or false - Answer ✔ i-true, ii-true

DCL stands for - Answer ✔ Data Control Language

........................ is the process of organizing data into related tables. - Answer ✔
Normalization

A ................... Does not have a distinguishing attribute if its own and mostly are
dependent entities, which are part of some another entity. - Answer ✔ Weak entity

, ................. is the complex search criteria in the where clause. - Answer ✔ Predicate

..................... is preferred method for enforcing data integrity - Answer ✔ Constraints

The number of tuples in a relation is called its ............. While the number of attributes in
a relation is called it's .................... - Answer ✔ Cardinality, Degree

The language that requires a user to specify the data to be retrieved without specifying
exactly how to get it is - Answer ✔ Non-Procedural DML

Which two files are used during operation of the DBMS? - Answer ✔ Data dictionary
and transaction log

The database schema is written in - Answer ✔ DDL

The way a particular application views the data from the database that the application
uses is a - Answer ✔ sub schema

The relational model feature is that there - Answer ✔ is much more data independence
than some other database models

Which one of the following statements is false? - Answer ✔ Data elements in the
database can be modified by changing the data dictionary.

Which of the following are the properties of entities? - Answer ✔ Attributes

Which database level is closest to the users? - Answer ✔ External

Which are the two ways in which entities can participate in a relationship? - Answer ✔
Total and partial

........ data type can store unstructured data - Answer ✔ RAW

1. State true or false. i) Select operator is not a unary operator. ii) Project operator
chooses subset of attributes or columns of a relation. - Answer ✔ i-False, ii-True

2. ............... database is used as template for all databases created. - Answer ✔ Model

3. One aspect that has to be dealt with by the integrity subsystem is to ensure that only
valid values can be assigned to each data items. This is referred to as - Answer ✔
Domain Integrity

4. ....................... operator is basically a join followed by a project on the attributes of
first relation. - Answer ✔ Semi-Join

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

Will I be stuck with a subscription?

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

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67479 documents were sold in the last 30 days

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

Start selling
$13.99
  • (0)
Add to cart
Added