Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The DBMS that uses a table - based format for data storage is: Question 1 options: a ) Network DBMS b ) Hierarchical DBMS c
The DBMS that uses a tablebased format for data storage is:
Question options:
a
Network DBMS
b
Hierarchical DBMS
c
Relational DBMS
d
ObjectOriented DBMS
Question point
Which of the following DBMS types uses parentchild relationships of the data segments?
Question options:
a
Hierarchical DBMS
b
Network DBMS
c
Relational DBMS
d
ObjectOriented DBMS
Question point
Which type of DBMS is best for handling large amounts of unstructured data?
Question options:
a
Relational DBMS
b
Hierarchical DBMS
c
NoSQL DBMS
d
Network DBMS
Question point
In a threetier architecture, the application logic or process logic is located in the:
Question options:
a
Database Server
b
Client
c
Application Server
d
None of the above
Question point
In a twotier architecture, the presentation logic and application logic are combined at the:
Question options:
a
Client level
b
Server level
c
Both a and b
d
None of the above
Question point
In the architecture of a DBMS the user does not need to be aware of the physical storage details.
Question options:
a
tier
b
tier
c
tier
d
All of the above
Question point
Which type of DBMS allows inheritance, encapsulation, and polymorphism in its data model?
Question options:
a
Hierarchical DBMS
b
Network DBMS
c
Relational DBMS
d
ObjectOriented DBMS
Question point
Which DBMS type is designed to manage relationships between entities?
Question options:
a
Hierarchical DBMS
b
Network DBMS
c
Relational DBMS
d
ObjectOriented DBMS
Question point
In the relational model, data are structured into:
Question options:
a
Tables
b
Trees
c
Graphs
d
Networks
Question point
A tuple in a database refers to:
Question options:
a
A row
b
A column
c
A table
d
A database
Question point
The degree of a relation is the:
Question options:
a
Number of rows in the table
b
Number of tables in the database
c
Number of attributes in the table
d
Number of constraints on the table
Question point
A primary key in a database is a:
Question options:
a
Unique identifier of a record
b
Foreign key from another table
c
Column that allows null values
d
Table that links two other tables
Question point
A foreign key in a database is:
Question options:
a
A key that is unique in every row
b
A key that uniquely identifies a record in another table
c
A key that can be null
d
Both b and c
Question point
What is a relational schema?
Question options:
a
A description of the entire database
b
A description of a particular table in the database
c
A description of the network architecture
d
A description of a physical storage structure
Question point
In a relational database, what does the term 'domain' refer to
Question options:
a
The overall collection of databases in a system
b
A group of related tables in a database
c
The set of permissible values for a given attribute
d
The restrictions on a foreign key
Question point
What is an attribute in a relational database?
Question options:
a
A single column in a table
b
A constraint on a table
c
A type of database query
d
A type of database relationship
Question point
Which of the following types of integrity constraints ensures that a value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation?
Question options:
a
Domain constraint
b
Referential integrity constraint
c
Key constraint
d
None of the above
Question point
Which of the following integrity constraints ensure that every tuple in a relation has a unique identity?
Question options:
a
Domain constraint
b
Entity integrity constraint
c
Key constraint
d
Referential integrity constraint
Question point
Which of the following keys allows for duplicate values?
Question options:
a
Primary key
b
Super key
c
Candidate key
d
Foreign key
Question point
In the context of relational databases, what does a 'composite key' refer to
Question options:
a
A key formed by combining at least two or more columns
b
A key that cons
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started