1 Replies - 944 Views - Last Post: 14 August 2010 - 09:29 AM

#1 Kairi   User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 107
  • Joined: 02-October 09

query management and sql database management

Posted 14 August 2010 - 09:12 AM

Ok these are two seperate questions coz i didn't wanna make two new topics on this.

and i hope someone can help me with a answer since my autumn exam is in 3 days time.

Question 1

Describe the features of the Oracle SQL *Plus database management tool (6 marks)

Question 2
What is query management and what does it involve? (5 marks)

I'm sorry to bother ya all but if anyone can at least help me answer these questions nicely and keep the answer separate lol i will be ever grateful.

I don't have much time to do a full search up since i need to learn the answers as well lol
Thanks alot guys and whoever gives me a good answer will get a thanks of post

Is This A Good Question/Topic? 0
  • +

Replies To: query management and sql database management

#2 Martyr2   User is offline

  • Programming Theoretician
  • member icon

Reputation: 5207
  • View blog
  • Posts: 13,955
  • Joined: 18-April 07

Re: query management and sql database management

Posted 14 August 2010 - 09:29 AM

Answers to question 1 can be found at the following links...

SQL Plus Release Notes, Section 5 new features
SQL Plus Documentation

As for your second question... query management is all about managing queries in that you track and update queries to be as efficient as possible as well as who can access those queries and what they can access.

Examples might be...

1) Restricting insert/update queries to only senior management between the hours of 9-5.
2) Constructing query views of data so that the VP of sales can see the total liabilities and revenues world-wide while the director of North American sales can see only sales figures for locations in North America.
3) Changing a query to use an inner join rather than a nested select to increase efficiency.
4) Changing a query to make use of new indexes on various tables.
5) Creating or changing queries to construct or update reports.

Just a few examples. :)
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1