Currently I am taking database management system and my teacher wants my to fill
ID: 3679892 • Letter: C
Question
Currently I am taking database management system and my teacher wants my to fill in these fill in the blank questions.
1.A single piece of data is a _______________________.
2.______________________________invented the first punched card.
3.Name one challenge with storing data today.
4.Software to manage data is called __________________________.
5.Herman Hollerith founded ______________________________.
6.DDL is known as ______________________________________.
7.A basic SQL statement has the following 3 parts _______________, _____________________ and __________________________.
8.In the like clause, what matches any group of characters of any length? _________________
9.T or F, Or comes before And?
10. The where-clause limits the number of ______________ that are selected from the database.
11.Three typical cardinalities are ________________________, _______________________________, and _______________________________
12.Intersection data is the same as this type of entity _________________________.
13.A relationship of one entity to occurrences of the same type of entity is called _______________________________.
14.A ________________________________ involves 3 different entity types.
15.Modality is _____________________________________________.
16.Four operations that can be performed on stored data are ______________________________ , _______________________________, _______________________________, _______________________________
17.The ability to tie pieces of related data together is called ____________________________.
18.In general data redundancy is good for a system. T or F. ______________
19.Name three data control issues.
20.Hierarchical databases are known as ______________________ approaches to database.
Explanation / Answer
1)ans:
field
2)ans:
Semen Korsakov && Herman Hollerith
3)ans:
now a days is different kinds(extrnsions like pdf,jpg,tables,images,videos) and managing storing data
4)ans:
data management software or also called as data extraction software.
5)ans:
punched card
6)ans:
Data Definition Language
7)ans:
basic sql statement syntax is starting with sql keywords(select,insert,update,delte..) and table name and the statement is end with semicolon;
the Basic Select statement has three parts has Select,From,Where
8)ans:
pattern
9)ans:
F
10)ans:
rows(records)
11)ans:
one to one,one to many,many to many
12)ans:
intersection entity type
13)ans:
unary relationship
14)ans:
A Relationship Type
15)ans:
when a relationship is optional then the value of the modality is zero. when mandatory then the modality is one.
16)ans:
select,delete,update,drop
17)ans:
grouping
18)ans:
F
19)ans:
Backup,recovery,concurrency,security
20)ans:
navigational approach
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.