Is it possible to Enable or Disable a Database trigger ?
With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
Define transaction and transaction isolation levels?
Explain the term generalization.
Explain armstrong rules? How they are complete and/or sound?
I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?
In DBMS, what are the two integrity rules used?
Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?
what is the difference between delete and truncate?
Define cursor.
What is an entity-relationship model?
State at least four kinds of indexing?
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?