Solving the problem of deleting the table
State the steps for “this message could not delete” from the particular tables?
Expert
This error is caused due to the delete query and when unique property is set to “no”.
Following given are the steps that must be followed in order to solve the problem.
1) Delete query must be opened and if it is not opening then press F4.
2) Clicking on the query properties underneath query designer will provide you the options.
3) In that options, you require to locate the unique records property and must set it to yes. These options are present in the query property sheet.
Illustrate the use and application of the DB Miner.
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
States the term Volatile temporary tables.
Write down a short note on the term concurrency transparency?
Illustrates the term data structure node class?
What is meant by the fact table?
What do you mean by the term Open Server in the Sybase?
What are to objectives of OLE DB?
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
Explain the stage variables?
18,76,764
1923609 Asked
3,689
Active Tutors
1436681
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!