Computers and Technology, 17.09.2019 20:00 andreal7915

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.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 23.06.2019 00:20, kathlynskare06

Ihave been given the number of guns per 100, and the total firearm-related deaths per 100,000. i have to find the actual number of guns per country and actual number of gun-related deaths. if somebody could show me how to do 1 question, i can finish the rest, i am just confused. tia

Answers: 3

continue

Computers and Technology, 23.06.2019 14:00, allison9746

Need ! will choose brainliest! discuss the role of abstraction in the history of computer software.

Answers: 1

continue

Computers and Technology, 23.06.2019 15:00, lopez7512

What is the total resistance in a circuit that contains three 60 ohm resistors connected in a series? a. 20 ohms b. 120 ohms c. 60 ohms d. 180 ohms

Answers: 2

continue

Computers and Technology, 23.06.2019 18:00, yedida

File account. java (see previous exercise) contains a definition for a simple bank account class with methods to withdraw, deposit, get the balance and account number, and return a string representation. note that the constructor for this class creates a random account number. save this class to your directory and study it to see how it works. then write the following additional code: 1. suppose the bank wants to keep track of how many accounts exist. a. declare a private static integer variable numaccounts to hold this value. like all instance and static variables, it will be initialized (to 0, since itâ€™s an int) automatically. b. add code to the constructor to increment this variable every time an account is created. c. add a static method getnumaccounts that returns the total number of accounts. think about why this method should be static - its information is not related to any particular account. d. file testaccounts1.java contains a simple program that creates the specified number of bank accounts then uses the getnumaccounts method to find how many accounts were created. save it to your directory, then use it to test your modified account class.

Answers: 3

continue

You know the right answer?

Discuss the differences between a data definition language (ddl) and a data manipulation language (d...