subject

Discuss the differences between a data definition language (ddl) and a data manipulation language (dml). what operations would you typically expect to be available in each language? describe the main characteristics of the database approach and the file-based approach. contrast the two different approaches. provide a definition for a physical database designer, data administrator and a database administrator. what role do they play for the database? what types of interactions would these users of the database have? what is concurrency control and why does a dbms need a concurrency control facility? what is a database transaction? give 2 examples of a transaction. what is meant by the term ‘client-server architecture’ and what are the advantages of this approach? what is a transaction processing monitor? what advantages does a tp monitor bring to an oltp environment? define logical data independence and physical database independence. how do they relate to the ansi-sparc database architecture. define cloud computing. name and define the two principal integrity rules for the relational model. describe the differences between a view and a base relation.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 09:00
Which best compares appointments and events in outlook 2010appointments have a subject man, and events do notappointments have a specific date or range of dates, and events do notappointments have a start and end time of day, and events do notappointments have a location option, and events do not
Answers: 2
question
Computers and Technology, 23.06.2019 15:30
The song about casey jones a railroad engineer who gives his life on the job would most likely gall under the folk song category of? a-work song b-nonsense song c-religious song d-ballad
Answers: 1
question
Computers and Technology, 23.06.2019 18:30
Where can page numbers appear? check all that apply. in the header inside tables in the footer at the bottom of columns at the top of columns
Answers: 1
question
Computers and Technology, 23.06.2019 21:30
Enzo’s balance sheet for the month of july is shown. enzo’s balance sheet (july 2013) assets liabilities cash $600 credit card $4,000 investments $500 student loan $2,500 house $120,000 mortgage $80,000 car $6,000 car loan $2,000 total $127,100 total $88,500 which expression finds enzo’s net worth?
Answers: 1
You know the right answer?
Discuss the differences between a data definition language (ddl) and a data manipulation language (d...
Questions
question
Mathematics, 23.10.2020 06:01
question
Mathematics, 23.10.2020 06:01
question
Mathematics, 23.10.2020 06:01