What is the significance of having storage clause ?

What is the significance of having storage clause ?
by

1 Answer

Answer :

We can plan the storage for a table as how much initial extents are
required, how much can be extended next, how much % should leave
free for managing row updations etc.,
by

Related questions

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Which parameter in Storage clause will reduce no. of rows per block?

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

When do you use WHERE clause and when do you use HAVING clause?

Description : When do you use WHERE clause and when do you use HAVING clause?

Last Answer : HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

Discuss the significance of having clause with group by statement with suitable example. -Technology

Description : Discuss the significance of having clause with group by statement with suitable example. -Technology

Last Answer : Sometimes we do not want to see the whole output produced by a statement with Group By clause. We want to see the output only for those groups which satisfy some condition. It means we want ... the total amount of all type of transactions, it will only display the total of credit transactions only.

Can you use select in FROM clause of SQL select ?

Description : Can you use select in FROM clause of SQL select ?

Last Answer : Yes.

How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

What WHERE CURRENT OF clause does in a cursor?

Description : What WHERE CURRENT OF clause does in a cursor?

Last Answer : LOOP SELECT num_credits INTO v_numcredits FROM classes WHERE dept=123 and course=101; UPDATE students FHKO;;;;;;;;;SET current_credits=current_credits+v_numcredits WHERE CURRENT OF X;

Explain the usage of WHERE CURRENT OF clause in cursors ?

Description : Explain the usage of WHERE CURRENT OF clause in cursors ?

Last Answer : WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers

What is a property clause?

Description : What is a property clause?

Last Answer : A property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on it. An object based on a property can inherit the setting of any property in the clause that makes sense for that object.

Can a property clause itself be based on a property clause?

Description : Can a property clause itself be based on a property clause?

Last Answer : Yes

Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER The above is a) Not an error b) Error - the string in single quotes ‘NORTH’ and ‘SOUTH’ c) Error - the string should be in double quotes d) Error - ORDER BY clause

Description : Select NORTH', CUSTOMER From CUST_DTLS Where REGION = N' Order By CUSTOMER Union Select EAST', CUSTOMER From CUST_DTLS Where REGION = E' Order By CUSTOMER The above is a) Not an error b) Error - ... ' and SOUTH' c) Error - the string should be in double quotes d) Error - ORDER BY clause

Last Answer : d) Error - ORDER BY clause

What is the significance of PAGE 0 in forms 3.0 ?

Description : What is the significance of PAGE 0 in forms 3.0 ?

Last Answer : Hide the fields for internal calculation.

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Physical Storage of the Data

Description : Physical Storage of the Data

Last Answer : The finest level of granularity of the data base are the data blocks. Data Block :: One Data Block correspond to specific number of physical database space Extent :: Extent is the number of ... Index has index segment that stores data c) Roll Back Segment :: Temporarily store 'undo' information

What is Data Storage - Definition Language?

Description : What is Data Storage - Definition Language?

Last Answer : The storage structures and access methods used by database system are specified by a set of definition in a special type of DDL called data storage-definition language.

What is SDL (Storage Definition Language)?

Description : What is SDL (Storage Definition Language)?

Last Answer : This language is to specify the internal schema. This language may specify the mapping between two schemas

……………..specifies a search condition for a group or an aggregate. A) GROUP BY Clause B) HAVING Clause C) FROM Clause D) WHERE Clause

Description : ……………..specifies a search condition for a group or an aggregate. A) GROUP BY Clause B) HAVING Clause C) FROM Clause D) WHERE Clause

Last Answer : B) HAVING Clause

……………… clause is an additional filter that is applied to the result. A) Select B) Group-by C) Having D) Order by

Description : ……………… clause is an additional filter that is applied to the result. A) Select B) Group-by C) Having D) Order by

Last Answer : C) Having

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

What are the advantages of having a Package ?

Description : What are the advantages of having a Package ?

Last Answer : Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)

What is advantage of having disk shadowing/ Mirroring ?

Description : What is advantage of having disk shadowing/ Mirroring ?

Last Answer : Shadow set of disks save as a backup in the event of disk failure. In most Operating System if any disk failure occurs it automatically switchover to place of failed disk. Improved performance because most OS ... instead of the main set of files. This reduces I/O load on the main set of disks.

What are disadvantages of having raw devices ?

Description : What are disadvantages of having raw devices ?

Last Answer : We should depend on export/import utility for backup/recovery (fully reliable) The tar command cannot be used for physical file backup, instead we can use dd command which is less flexible and has limited recoveries.

A Column is having many repeated values which type of index you should create on this column, if you have to?

Description : A Column is having many repeated values which type of index you should create on this column, if you have to?

Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.

A table is having few rows, should you create indexes on this table

Description : A table is having few rows, should you create indexes on this table

Last Answer : Small tables do not require indexes; if a query is taking too long, then the table might have grown from small to large. You can create an index on any column; however, if the ... , creating an index on the column does not increase performance and the index takes up resources unnecessarily.

Mitochondria - what might be the significance of having such a complex membranous structure?

Description : Given that mitochondria do not have the same aggressive autolytic capacity as lysosomes, what might be the significance of having such a complex membranous structure? After all, the ... reticulum and the plasma membrane could potentially support those enzymes found in mitochondrial membranes.

Last Answer : In fact, bacteria do not have mitochondria, but some types do have membranous intrusions into the cytoplasm called mesosomes. These are similar in function to the inner membrane of ... advantage) control of the various metabolic processes that are now distributed between distinct compartments. 

How do I get around a non-compete clause?

Description : How do I get around a non-compete clause?

Last Answer : When you signed the non-compete clause, did it specify a length of time?

In grammar, what is a matrix clause?

Description : In grammar, what is a matrix clause?

Last Answer : answer:A matrix clause is a clause that surrounds an embedded clause. It is typically-but not always-the main clause of a sentence. Example: Jim's old car, which was never any good in the first place, ... is a matrix clause. which was never any good in the first place is an embedded clause.

Can you guys tell me what the 72 hour real estate clause means to us in this situation?

Description : Can you guys tell me what the 72 hour real estate clause means to us in this situation?

Last Answer : From the time of notice of the other offer on that other house you have 72 hours to execute the offer you made on the other house that was accepted with this 72 hour contingency clause in your offer. ... in that time period the seller is free to accept this other offer if they choose to do so.

Is this a grammatical error? What type of clause is this?

Description : Is this a grammatical error? What type of clause is this?

Last Answer : All three sentences need to begin with Whilst or While. Plus, it will be tedious if the author uses the same sentence structure constantly. Generally, one wants to mix sentences of different ... (unless the sentences are so long and convoluted that they're difficult and painful to follow).

Do you think it's okay to teach your kids that Santa Clause/ Easter bunny/ tooth fairy exists?

Description : Do you think it's okay to teach your kids that Santa Clause/ Easter bunny/ tooth fairy exists?

Last Answer : Myth and magic are fun for kids.

Is an apology still an apology if there is a but you clause in it?

Description : Is an apology still an apology if there is a but you clause in it?

Last Answer : I think I need more context to formulate an answer. It could swing both ways. More times than not, I wouldn’t think they’re not being sincere, but that’s just my opinion.

I need some advice about my daughter and her belief of Santa Clause. Please help me?

Description : I need some advice about my daughter and her belief of Santa Clause. Please help me?

Last Answer : I'm amazed she made it to 10 years old before she started questioning. I think my oldest son was 8. He had a younger brother and sister at the time, who did still believe in Santa. I told ... t believe in Santa Claus would get no presents from him under the tree each of my children were told this

an adjectival clause always includes a/an -General Knowledge

Description : an adjectival clause always includes a/an -General Knowledge

Last Answer : An adjectival clause always includes a relative pronoun.

which of the following is a complex sentence that contains a dependent adverbial clause? -General Knowledge

Description : which of the following is a complex sentence that contains a dependent adverbial clause? -General Knowledge

Last Answer : A complex sentence that contains a dependent adverbial clause is: Mark expects the photo to arrive when the letter arrives.

which of the following sentences has a relative clause? -General Knowledge

Description : which of the following sentences has a relative clause? -General Knowledge

Last Answer : The following sentence has a relative clause: The audience applauded the ambassador, who spoke for one-half hour.

the establishment clause would prevent -General Knowledge

Description : the establishment clause would prevent -General Knowledge

Last Answer : the mayor's office from displaying a cross.

identify the sentence that contains a noun clause in italics -General Knowledge

Description : identify the sentence that contains a noun clause in italics -General Knowledge

Last Answer : The sentence that contains a noun clause is: What Betty wants is to harvest the corn.

in this sentence what word begins the subordinate clause -General Knowledge

Description : in this sentence what word begins the subordinate clause -General Knowledge

Last Answer : Dolly must clean up her room before she goes out. In this sentence, the word 'before' begins the subordinate clause.

What is the difference between the order by and group by clause when used along with the select statement. -Technology

Description : What is the difference between the order by and group by clause when used along with the select statement. -Technology

Last Answer : The order by clause is used to show the contents of a table/relation in a sorted manner with respect to the column mentioned after the order by clause. The contents of the column can be arranged in ... a given column and then apply an aggregate function eg max(), min() etc on the entire group.

A single clause standing alone is called asentence.A. compoundB. simpleO C. complexO D. incomplete?

Description : A single clause standing alone is called asentence.A. compoundB. simpleO C. complexO D. incomplete?

Last Answer : B. simple

Whenever there is a bluegrass festival adjective or adverb clause?

Description : Whenever there is a bluegrass festival adjective or adverb clause?

Last Answer : adjective

Which of congresses powers is implied through the necessary and proper clause?

Description : Which of congresses powers is implied through the necessary and proper clause?

Last Answer : The power to restrict child labor

Choose the group of words that is not an independent clause?

Description : Choose the group of words that is not an independent clause?

Last Answer : Experiencing unemployment during the depression.

Who wrote the Santa Clause Movies?

Description : Who wrote the Santa Clause Movies?

Last Answer : Leo Benvenuti and Steve Rudnick co-wrote all 3 Santa Clause movies. They also co-wrote Space Jam and the Will Ferrell movie Kicking and Screaming

What is the dance that Tim Allen does during the montage before his second ********* Eve in the Santa Clause?

Description : What is the dance that Tim Allen does during the montage before his second Christmas Eve in the Santa Clause?

Last Answer : It was improvised and done in one take. The Director kept it because it was so good.

What is the difference between a clause and phrase?

Description : What is the difference between a clause and phrase?

Last Answer : Phrases and clauses are both groups of two or more words that convey ideas. However, there is an easy way to tell if you're using a phrase or a clause. The main difference is that clauses have both a subject and a predicate; phrases do not. Phrases are part of clauses.

How old is Santa clause?

Description : How old is Santa clause?

Last Answer : 90billion years

what is a independent clause?

Description : what is a independent clause?

Last Answer : A sentence with two main ideas joined by " and " or " but ", forexample, has two independent clauses.Tom is short but his father and mother are tall.

What job is the noun clause doing in this sentenceBrad's one worry, that he would use up his inheritance, never came true.?

Description : What job is the noun clause doing in this sentenceBrad's one worry, that he would use up his inheritance, never came true.?

Last Answer : appositive A+

What is Adverb Clause ?

Description : What is Adverb Clause ?

Last Answer : A subordinate clause that acts as an adverb in a sentence and modifies a verb, or an adjective-clause , or another adverb clause is called an adverb clause .