علم البيانات | DS2 Quizes – Telegram
علم البيانات | DS2 Quizes
966 subscribers
96 photos
2 videos
14 files
110 links
"قناة علمية متخصصة في مجال علم البيانات، قناة خاصة بالاختبارات MCQ ."
القناة العامة: @Computer_DS_1
النقاشات: @Computer_DS1
قناة الاختبارات: @Computer_DS_2
بوت التواصل والمشاركات : @DS_Combot
Download Telegram
Which of the following is NOT a main characteristic of the Database Approach?
Anonymous Quiz
25%
Self-describing nature via a Catalog
9%
Support for multiple views
7%
Data Sharing
58%
High Program-Data Dependence
The ability of the DBMS to execute multiple user transactions at the same time is primarily handled by:
Anonymous Quiz
2%
Recovery Management
42%
Concurrency Control
50%
Data Definition Language (DDL)
6%
Data Modeling
Which schema in the three-schema architecture uses a Physical Data Model to describe storage details?
Anonymous Quiz
18%
External Schema
27%
Internal Schema
40%
Conceptual Schema
15%
Logical Schema
1
The entire collection of data definitions stored in the DBMS is called the:
Anonymous Quiz
27%
Data Model
19%
Data Instance
37%
DBMS Catalog
17%
Data Dictionary
Which type of end user typically interacts with the system using tools like SQL or a data analysis package?
Anonymous Quiz
20%
Parametric End Users
50%
Sophisticated End Users
18%
Casual End Users
13%
Standalone Users
The lowest level of the three-schema architecture is the:
Anonymous Quiz
25%
Conceptual level
30%
External level
37%
Internal level
9%
Logical level
The term that describes the execution of multiple processes on a single CPU by switching between them is:
Anonymous Quiz
27%
Parallel processing
18%
Recovery processing
25%
Interleaved processing
30%
Transaction processing
The process of defining a set of constraints that the database must satisfy is part of the overall process of:
Anonymous Quiz
23%
Transaction Management
44%
Defining the Database
23%
Data Retrieval
11%
Application Development
The set of processes responsible for ensuring data is restored to a consistent state after a system failure is called:
Anonymous Quiz
19%
Integrity Enforcement
24%
Security Management
48%
Recovery Management
10%
Query Processing
1
The difference between the stored data and the data denoscription is that the latter is stored in the:
Anonymous Quiz
19%
Database Files
53%
DBMS Catalog
21%
External Views
8%
Application Programs
The property that allows the DBA to change the internal storage structure without requiring changes to the application programs is called:
Anonymous Quiz
31%
Physical Data Independence
35%
Logical Data Independence
4%
Data Redundancy
31%
Conceptual Independence
Which database user category primarily uses pre-written, highly structured application programs (transactions)?
Anonymous Quiz
22%
Database Designers
19%
Systems Analysts
41%
Parametric End Users
19%
Sophisticated End Users
A major disadvantage of the traditional File Processing Approach is the:
Anonymous Quiz
19%
Data Abstraction
8%
Controlled Access
19%
Data Sharing
54%
Program-Data Dependence
In the three-schema architecture, the schema that describes the entire database structure for the community of users is the:
Anonymous Quiz
13%
Storage Schema
21%
External Schema
54%
Conceptual Schema
13%
Internal Schema
The property of separating the data denoscription from the application programs is known as:
Anonymous Quiz
0%
Data Isolation
20%
Data Sharing
65%
Data Abstraction
15%
Data Integrity
Logical Data Independence refers to the ability to change the conceptual schema without altering the:
Anonymous Quiz
73%
External Views/Application Programs
14%
Internal Schema
5%
Physical Storage Files
9%
System Catalog
Which of the following is an essential advantage of the Database Approach over the File System Approach?
Anonymous Quiz
78%
Enforcement of Integrity Constraints
6%
Increased Storage Costs
11%
Higher System Complexity
6%
No Need for a DBA
Which DBMS role is typically responsible for authorizing access and granting privileges to users?
Anonymous Quiz
94%
Database Administrator (DBA)
0%
Application Programmer
6%
Sophisticated End User
0%
Systems Analyst
Which of the following is NOT a main characteristic of the Database Approach?
Anonymous Quiz
6%
Data Sharing
44%
Self-describing nature via a Catalog
6%
Support for multiple views
44%
High Program-Data Dependence