Some of these questions require a few words. Others require a few sentences. You will have
Question:
Some of these questions require a few words. Others require a few sentences.
You will have to do some research in order to answer these questions because we have not studied most of this.
Look at more than one site before writing your answer.
Be sure you are reading about Oracle as opposed to SQL Server.
1.What is the advantage of specifying WITH GRANT option in the GRANT command?
2.When would you use CASCADE CONSTRAINTS? Why would you use it?
3.Discover what needs to be backed up and write a sentence or two about each.
4.What happens if the constraint name is left out of a constraint clause?
Is this bad or good? Why?
5.An Oracle database is a collection of related operating system files that Oracle uses
to store and manage a set of related information. Name the three primary types of files in an Oracle database.
6.What two ways can be used to designate comments in SQL?
7.Is it a good idea to set up each user with the authorities and privileges needed? Why or why not?
8.What is an index? Give a definition and discuss pros and cons of using indexes.
9.What is a stored procedure? Why are they useful?
10.List the four components of an Entity Relationship Diagram.
Briefly explain each component and/or give an example.
11.Since many-to-many relationships must be resolved, explain how to resolve them.
Use the example that a dog can do many tricks and a trick can be performed by many dogs.
Define the table that will let you know which dog can do which trick.
12.You have coded a WHERE clause condition with two string data values (literals or fields).
What must you do to be certain that you have retrieved every possible match?
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young