علم البيانات | DS2 Quizes – Telegram
علم البيانات | DS2 Quizes
968 subscribers
96 photos
2 videos
14 files
110 links
"قناة علمية متخصصة في مجال علم البيانات، قناة خاصة بالاختبارات MCQ ."
القناة العامة: @Computer_DS_1
النقاشات: @Computer_DS1
قناة الاختبارات: @Computer_DS_2
بوت التواصل والمشاركات : @DS_Combot
Download Telegram
The key for a separate relation created from a Multivalued Attribute is the combination of the entitys Primary Key and the:
Anonymous Quiz
20%
Foreign Key
60%
Primary Key of the Superclass
10%
New Surrogate Key
10%
Attribute value itself
Section 8: أسئلة من الاختبار النصفي

#أساسيات_قواعد_البيانات
#databases_fundamentals

#علم_البيانات الدفـعـ(1)ــة
Loading the initial database contents on a secondary storage medium is a phase of:
Anonymous Quiz
9%
Defining a database
36%
Manipulating a database
9%
Sharing a database
45%
Constructing a database
A special null value is used to represent values that are:
Anonymous Quiz
0%
Equal to zero (0)
83%
Not applicable or unknown
8%
Always invalid input
8%
Temporarily deleted
Which of the following is NOT one of the three main types of Explicit schema-based constraints in the Relational Model?
Anonymous Quiz
36%
Entity integrity constraints
18%
Key constraints
36%
Domain constraints
9%
Referential integrity
All the following are types of recent database applications EXCEPT:
Anonymous Quiz
0%
Data Warehouse
0%
Mobile database
30%
Multimedia database
70%
Numeric and textual database
Which of the following describes properties used to describe an entity?
Anonymous Quiz
33%
Relationship
8%
Entity
58%
Attributes
0%
Tuple
Which term is the informal name for a Tuple in the Relational Model?
Anonymous Quiz
8%
Relation
33%
Key
33%
Row
25%
Attribute
In the E-R Diagram notation, an attribute that can be calculated from other stored attributes (like Age from Date of Birth) is represented as a:
Anonymous Quiz
8%
Single oval
42%
Dashed oval
25%
Double oval
25%
Oval with an underline
Which constraint specifies that every entity in the entity set must participate in the relationship at least once?
Anonymous Quiz
30%
Partial Participation
20%
Cardinality Ratio
40%
Referential Constraint
10%
Total Participation
The constraint that links two relations via a Foreign Key is:
Anonymous Quiz
20%
Entity Integrity Constraint
0%
Domain Constraint
20%
Key Constraint
60%
Referential Integrity Constraint
Which integrity constraint in the Relational Model prohibits the Primary Key from having a NULL value?
Anonymous Quiz
18%
Domain Constraint
27%
Referential Integrity Constraint
36%
Key Constraint
18%
Entity Integrity Constraint
The Key Attribute in an E-R Diagram should be underlined. (True/False)
Anonymous Quiz
40%
False
60%
True
In the E-R Model, the Primary Key of a Weak Entity is formed by combining its Partial Key with the:
Anonymous Quiz
31%
Foreign Key to the Superclass
8%
Partial Key alone
31%
Primary Key of the Owner Entity
31%
Primary Key of the Schema
Which phase involves specifying the data types, structures, and constraints to be stored in the database?
Anonymous Quiz
38%
Sharing a database
8%
Manipulating a database
15%
Constructing a database
38%
Defining a database
Which type of attribute is composed of several meaningful sub-parts (e.g., Address broken down into Street, City, and Zip)?
Anonymous Quiz
15%
Derived Attribute
23%
Multivalued Attribute
62%
Composite Attribute
0%
Simple Attribute
The ability to change the conceptual schema without requiring changes to the external views or application programs is called:
Anonymous Quiz
27%
Physical Data Independence
27%
Storage Independence
13%
Functional Independence
33%
Logical Data Independence
Sharing of data and multi-user transaction processing is NOT allowing a set of concurrent users to retrieve from and update the database. (True/False)
Anonymous Quiz
41%
True
59%
False
Which DBMS role is typically responsible for managing backup, recovery, and access authorization?
Anonymous Quiz
5%
Sophisticated End User
11%
Application Programmer
16%
Systems Analyst
68%
Database Administrator (DBA)
The term Relation in the Relational Model corresponds to the informal term:
Anonymous Quiz
19%
Attribute
15%
Row
27%
Key
38%
Table
The entire collection of data definitions and denoscriptions stored by the DBMS is referred to as the:
Anonymous Quiz
25%
Data Model
42%
Application Program
13%
Data Instance
21%
DBMS Catalog
🥰1