 Related Questions Latest Answer : For Indexes you can use :DBA_INDEXESALL_INDEXESUSER_INDEXESFor Constraint you can use :DBA_CONSTRAINTSALL_CONSTRAINTSUSER_CONSTRAINTSFor index upon which table and which column you can query on:DBA_CONS_COLUMNSALL_CONS_COLUMNSUSER_CONS_COLUMNS ... Read Answers (1) | Asked by : Arti Gupta Latest Answer : 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 or contents.For instance in DB2 it's SYSIBM.SYSINDEXES ... Read Answers (5) | Asked by : vcppvenkat 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? Latest Answer : 1) Transaction database is designed for a specific application.Datawarehouse is designed to integrate data from multiple datasource.2) Transaction focuses on the details, Datawarehouse focuses on high level aggregates.3) Transaction database is volatile. ... Read Answers (8) | Asked by : Mojtaba Kamalian I need to export data in Mainframe DB2 tables on to my PC as IXF files. Are there any commands I can I need to export data in Mainframe DB2 tables on to my PC as IXF files. Are there any commands I can use from QMF or SPUFI or any other Mainframe source to do this? Latest Answer : 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 ... Latest Answer : 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 ... Latest Answer : data objects in a database are of the objects that are used for storing data that are of type (tables,indexes....) ... Read Answers (1) | Asked by : surya prasad Latest Answer : yes what is the different between schema and database ... Read Answers (3) | Asked by : amarjit singh 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 you expect to see in the feed specification from the vendor? List at least eight. Give the reason View Question | Asked by : Ming
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
