Description : What is the difference between deleting and truncating of tables?
Last Answer : Deleting a table will not remove the rows from the table but entry is there in the database dictionary and it can be retrieved But truncating a table deletes it completely and it cannot be retrieved.
Description : The various file operation are: a. Crating a file b. Writing a file c. Reading a file d. Repositioning within a file e. Deleting a file truncating a file f. All of these
Last Answer : f. All of these
Description : Deleting the Duplicate rows in the table
Last Answer : We can delete the duplicate rows in the table by using the Rowid
Description : Deleting a page removes information about all the fields in that page ? a. True. b. False?
Last Answer : a. True.
Description : What are the built-ins used for Creating and deleting groups?
Last Answer : CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)
Description : What is the use of TABLES option in EXP command ?
Last Answer : List of tables should be exported.ze)
Description : A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Last Answer : Disable the foreign key constraint to the parent, drop the table, re- create the table, enable the foreign key constraint.
Description : Give the two types of tables involved in producing a star schema and the type of data they hold.
Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.
Description : What are mutating tables
Last Answer : When a table is in state of transition it is said to be mutating. eg :: If a row has been deleted then the table is said to be mutating and no operations can be done on the table except select.
Description : What is in all those X$ tables? (for DBA
Last Answer : The following list attempts to describe some x$ tables. The list may not be complete or accurate, but represents an attempt to figure out what information they contain. One should generally not ... Fixed Table. It can predict the potential loss of decreasing the number of database buffers. The
Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.
Description : What are two virtual tables available during database trigger execution ?
Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.
Description : Name the tables where characteristics of Package, procedure and functions are stored ?
Last Answer : User_objects, User_Source and User_error.
Description : How will you estimate the space required by a non- clustered tables?
Last Answer : Calculate the total header size Calculate the available dataspace per data block Calculate the combined column lengths of the average row Calculate the total average row size. Calculate the average number rows ... add 10 % additional space to calculate the initial extent size for a working table.
Description : What are the dictionary tables used to monitor a database space?
Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.
Description : What are the dictionary tables used to monitor a database spaces ?
Description : How does one get the view definition of fixed views/tables?
Last Answer : Query v$fixed_view_definition. Example: SELECT * FROM v$fixed_view_definition WHERE view_name='V$SESSION';
Description : Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii
Last Answer : a) i& ii b) ii & iii
Description : Tables derived from the ERD
Last Answer : a) Are totally unnormalised b) Are always in 1NF c) Can be further denormalised d) May have multi-valued attributes (b) Are always in 1NF
Description : How do you move tables from one tablespace to another tablespace?
Last Answer : There are several methods to do this; 1) export the table, drop the table, create the table definition in the new tablespace, and then import the data (imp ignore=y). 2) Create ... table and rename the temporary table as the original: DROP TABLE real_table; RENAME temp_name TO real_table;
Description : Can you make collection of Statistics for tables automatically?
Last Answer : YES. Oracle databse has default, scheduled job "gather_stats_job" that analyses stats on a daily basis during the maintenance window time. There are two scheduled activities related to ... GATHER_STATS_JOB'); Oracle collects optimizer statistics for SQL via the default of autostats_target = auto.
Description : Name the seven types of Oracle tables
Last Answer : Heap Organized Tables, Index Organized Tables, Index Clustered Tables, Hash Clustered Tables, Nested Tables, Global Temporary Tables, Object Tables.
Description : I need to know the way to save a 450mb .txt file into my Kindle with 170mb of free space without deleting other files.
Last Answer : Defrag your disc. (Assuming your Kindle has such a thing, which I know nothing about.) Just a shot in the dark here…
Description : Do you think when Facebook has a problem deleting a status it's because of key words?
Last Answer : I don't delete things I wrote. I may edit them but not delete them. Sometimes if someone writes something stupid on one of my posts, I'll delete it, for example, a friend's mentally ill brother will ... I may delete it. I never have a problem but as I said, these occasions are few and far between.
Description : How can I move an in-text citation (Chicago Style) without deleting my footnote?
Last Answer : What happens if you leave it in place in both places and then delete the extraneous one?
Description : Mods, how long do you wait for me to edit my question before deleting it altogether?
Last Answer : answer:Once a question is returned to a user for editing, the mods are unable to do anything else with it. It will stay under that user's control until they either edit it or abandon it. Once a users ... this takes may vary depending on if a mod is around at the time of the re-submission or not.
Description : Mac question about deleting files?
Last Answer : answer:(I found this on the Finder Help menu and copied it for you. Don't take this as truth or gospel, however. But it may be worth exploring.) ************ If there's no ... Empty Trash securely. The Finder menu now contains tow options for emptying the Trash; Empty Trash and Secure Empty Trash.
Description : Is it a good thing or a bad thing for the senders of email to know that the receipients are deleting without reading?
Last Answer : I don’t believe they could see the email was being deleted without being read. I think they were guessing. There’s no way you can tell if someone deleted it without reading it.
Description : How do I clear my contacts storage on galaxy prevail without deleting my personal contacts?
Last Answer : answer:Try copying your contacts to the SD card. Go to you Boost customer service person, if your nor sure how to do it.
Description : Can I regain Garage Band (MAC) after deleting it?
Last Answer : All of those programs should be on the install CDs that came with your computer. I just checked, and they are all on my own install discs. If you aren't sure, try popping the disk into your ... There's no need to delete these programs if they aren't weighing your computer down in the first place.
Description : Is there a program that merges folders together, deleting the same items?
Last Answer : In Windows 7, I just drag the folders together and it will merge them while asking how I want to handle duplicates. I would imagine that OS X would have the same thing.
Description : Deleting Emails from Gmail?
Last Answer : answer:He @temporary5, welcome to Fluther! The first workaround that comes to mind: 1) Archive all your labeled messages 2) Your inbox will contain only un-labeled messages But I don't know ... a search operator for unlabeled messages http://support.google.com/mail/bin/answer.py?hl=en&answer=7190
Description : I am thinking of deleting a couple of my OPs. Do people save their answers generally?
Last Answer : Hi Flo please excuse me for not understanding the question. When you say OPs , do you mean original posts? If so, do you mean on Fluther or on some other site? And I'm really lost when it ... the details. It might help (me) if there was a hypothetical example or even a specific one. Thanks friend!
Description : Deleting Sprites from frame (Xcode for iPhone)
Last Answer : Do you actually understand the Objective-C language? or are you just copying code from other people and trying to “wing it?” because “SpaceJunk = delete” makes no sense… or was that supposed to be psudocode?
Description : Is there a way to disable deleting certain websites from Firefox's history?
Last Answer : I know in internet explorer you can get the history by hitting control + shift + H… idk if it’s the same for firefox. whatcha lookin at that you don’t want seen? hmmm? =]
Description : Deleting a pic on fluther?
Last Answer : This is broken for now. It is a known problem and they are working on it.
Description : Ok I'll bite: Why are some of you deleting your account and starting over?
Last Answer : Thanks @markyy! I was wondering the same thing…kept thinking I was missing something
Description : No active partition after deleting 2 OS?
Last Answer : You might want to try a Gparted LiveCD It’s like partition magic but runs in linux. I had luck with it before when partition magic didn’t do the trick.
Description : How can I download a different browser without deleting my current one?
Last Answer : Just choose for it not to be the “default” browser when it installs. That is something you can always go back and change, anyway. Nothing “gets rid” of anything, it just puts itself first in line to be used. Does that make sense?
Description : Anybody else having trouble deleting email?
Last Answer : sorry but my iphone just completely frose on me about 2 weeks ago and now it wont turn off/on or charge or anything
Description : Is there a way of deleting more than one "Comments for You" at a time?
Last Answer : I have this problem as well, and it is especially difficult on the iphone since Edge is so slow. Hopefully Bandrerik the ask-public God will offer this feature soon. I almost always want to either remove ... long to go back into my questions area every time. Maybe I should repost this in the forum
Description : Can you delete specific entries from york history on a MacBook without deleting all of the history?
Last Answer : answer:In Safari, go to the Bookmarks menu, and choose Show all Bookmarks, then on the left-hand column click on the History button; you should be able to then click on specific sites and delete ... the triangle next to the folder you wish to search (today, yesterday, etc.). Hope that helps!
Description : How can i stop emails from deleting in yahoo.mail when i delete from my iphone ?
Last Answer : Configure it as a regular POP account instead of IMAP or ‘Yahoo’ account. To do that, you have to select ‘Other’ when you create a new account, instead of ‘Yahoo’ and then select the POP option (it’ll give you IMAP, POP and Exchange as options)
Description : Is iTunes deleting apps off of your iPhone after update 2.02?
Last Answer : Check your iPhone application settings, it happened to me after I updated to 2.0.1.
Description : You have to remove one country from existence and by removing a certaing country you are deleting its history, what country would that be and why?
Last Answer : Sudan.