DBI202 LATEST 2024 REAL EXAM QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) A GRADE
2 views 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...
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
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 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.
