-
Write the pseudocode to format the data for the report in the generic case.
You are writing a report that needs to format data being extracted from the database on the screen. All data relates to a specific object, but there are a variable amount of tables, and each table has a variable amount of columns and a variable amount of rows. The goal is to produce a display which is user friendly from a typical browser screen. For example, consider a system for a gift wishlist....
-
Project to acquire a new data feed from a vendor and add it to a database to enhance coverage for a neglected market.
There is a new project to acquire a new data feed from a vendor and add it to a database to enhance coverage for a neglected market. The data feed consists of a daily set of 6 files, one primary file with one row per main object, 4 other files which relate to the main file, and a secondary object file which is loosely related to the first. The data is in plain text. What sort of information would...
-
What is the difference between a stored procedure and a view? why do we use views from SQL Server point of view? What are mutating triggers? How is the structure of a bit map index, clustered, Non clustered and B Tree What re mutating triggers? Can a stored procedure a record set? Can we use DTS on a client machine to schedule jobs and consolidate data to a sql tables? Can we have an update trigger within another update trigger?
vibha_kant
- May 15th, 2007
Clustered Index:A clustered index reorders the way data is physically stored in a disc. Thats why there can be only one clustered index on the table. The leaf nodes of the index contains the data page...
vibha_kant
- May 14th, 2007
Mutating triggers :I am not aware of mutating triggers in SQL Server. Per my knowledge only MySQL and Oracle throws this error. Coming back to the point, mutating trigger occurs when the table w...
-
-
-
-
-
SQL is used to store and retrieve data from a _____
yuvaraj.r
- Mar 6th, 2007
Normally we are reteriving datas internally in the tables of the database
-
-
-
-
-
What is a HASH INDEX and how does it compare to other indexes?
opbang
- Sep 23rd, 2006
A Hash index stores key value pairs based on a pseudo randomizing function called hash functionA B+- Tree is a balanced tree whose leaves contain a sequence of key pointer pairs.- Use a hash index for point queries only. Use a B- Tree if multipoint queries or range queries are used.
-
-
-
How do we normalize may to many relationship?
sri
- Oct 11th, 2006
We can normalize the many to many realationship, by creating a third table contaaining the primary keys of both the tables
sv_shali
- Feb 18th, 2006
By creating a third relation table containing only the primary keys of both master tables.
-
What are the different kind of indexes other than bitmap and normal index?
Sri
- Oct 11th, 2006
Other than those mentioned above the different indexes are1)ClusteredRequires the date to be sortedwe can create 1 clustered2)Non-Clustereddoesnt require the data to be sortedWe can create 249 non-clustered indexes
opbang
- Sep 23rd, 2006
Types of IndexesThere are different types of indexes that can be created on tables in a database, all of which serve the same goal?to improve database performance by expediting data retrieval. Indexes...
-
-
How to delete an Oracle Applications User?
ram vara prasad
- Mar 9th, 2006
tx paa, drop user user_name cascade; This command really works..
-
Which Data Dictionary holds information about Indexes and Constraints ?
Culver_lake
- Mar 19th, 2006
These answers are probably all correct---if it's SQLServer or Sybase. I don't think the DBMS was identified and for sure the data dictionary/relational catalog/system tables are not standard in naming...
rajnarayan yadav
- Jan 16th, 2006
Index information in : user_indexes Constraint information in : user_constraints and user_cons_columns
Database Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans