Questions from Database Management

Q: Explain how to combine queries using the UNION clause.

Explain how to combine queries using the UNION clause.

Q: Explain some possible purposes of creating a view using SQL. In

Explain some possible purposes of creating a view using SQL. In particular, explain how a view can be used to reinforce data security.

Q: Define each of the following terms: a. application partitioning

Define each of the following terms: a. application partitioning b. application program interface (API) c. client/server system d. middleware e. three-tier architecture f. locking g. versioning h. dead...

Q: Match each of the following terms with the most appropriate definition:

Match each of the following terms with the most appropriate definition: - client server system - application program interface (API) - fat client - database server - middleware - three-tier architectu...

Q: List several major advantages of the client/server architecture compared with

List several major advantages of the client/server architecture compared with other computing approaches.

Q: Contrast the following terms: a. two-tier architecture

Contrast the following terms: a. two-tier architecture; three-tier architecture b. fat client; thin client c. optimistic concurrency control; pessimistic concurrency control d. deadlock prevention; de...

Q: Describe the advantages and disadvantages of three-tier architectures.

Describe the advantages and disadvantages of three-tier architectures.

Q: What is database-oriented middleware? What does it consist of

What is database-oriented middleware? What does it consist of?

Q: What are the six common steps needed to access databases from a

What are the six common steps needed to access databases from a typical program?

Q: What are the advantages of PHP? Discuss the drawbacks of PHP

What are the advantages of PHP? Discuss the drawbacks of PHP and JSP. What is the role of MVC in overcoming these drawbacks?