Answered step by step
Verified Expert Solution
Link Copied!

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 table-based format for data storage is:
Question 1 options:
a)
Network DBMS
b)
Hierarchical DBMS
c)
Relational DBMS
d)
Object-Oriented DBMS
Question 2(1 point)
Which of the following DBMS types uses parent-child relationships of the data segments?
Question 2 options:
a)
Hierarchical DBMS
b)
Network DBMS
c)
Relational DBMS
d)
Object-Oriented DBMS
Question 3(1 point)
Which type of DBMS is best for handling large amounts of unstructured data?
Question 3 options:
a)
Relational DBMS
b)
Hierarchical DBMS
c)
NoSQL DBMS
d)
Network DBMS
Question 4(1 point)
In a three-tier architecture, the application logic (or process logic) is located in the:
Question 4 options:
a)
Database Server
b)
Client
c)
Application Server
d)
None of the above
Question 5(1 point)
In a two-tier architecture, the presentation logic and application logic are combined at the:
Question 5 options:
a)
Client level
b)
Server level
c)
Both a) and b)
d)
None of the above
Question 6(1 point)
In the ____ architecture of a DBMS, the user does not need to be aware of the physical storage details.
Question 6 options:
a)
1-tier
b)
2-tier
c)
3-tier
d)
All of the above
Question 7(1 point)
Which type of DBMS allows inheritance, encapsulation, and polymorphism in its data model?
Question 7 options:
a)
Hierarchical DBMS
b)
Network DBMS
c)
Relational DBMS
d)
Object-Oriented DBMS
Question 8(1 point)
Which DBMS type is designed to manage relationships between entities?
Question 8 options:
a)
Hierarchical DBMS
b)
Network DBMS
c)
Relational DBMS
d)
Object-Oriented DBMS
Question 9(1 point)
In the relational model, data are structured into:
Question 9 options:
a)
Tables
b)
Trees
c)
Graphs
d)
Networks
Question 10(1 point)
A tuple in a database refers to:
Question 10 options:
a)
A row
b)
A column
c)
A table
d)
A database
Question 11(1 point)
The degree of a relation is the:
Question 11 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 12(1 point)
A primary key in a database is a:
Question 12 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 13(1 point)
A foreign key in a database is:
Question 13 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 14(1 point)
What is a relational schema?
Question 14 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 15(1 point)
In a relational database, what does the term 'domain' refer to?
Question 15 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 16(1 point)
What is an attribute in a relational database?
Question 16 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 17(1 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 17 options:
a)
Domain constraint
b)
Referential integrity constraint
c)
Key constraint
d)
None of the above
Question 18(1 point)
Which of the following integrity constraints ensure that every tuple in a relation has a unique identity?
Question 18 options:
a)
Domain constraint
b)
Entity integrity constraint
c)
Key constraint
d)
Referential integrity constraint
Question 19(1 point)
Which of the following keys allows for duplicate values?
Question 19 options:
a)
Primary key
b)
Super key
c)
Candidate key
d)
Foreign key
Question 20(1 point)
In the context of relational databases, what does a 'composite key' refer to?
Question 20 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M. Kroenke, David J. Auer

7th edition

133544621, 133544626, 0-13-354462-1, 978-0133544626

More Books

Students also viewed these Databases questions