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 ...
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 ...
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. ...
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 : data objects in a database are of the objects that are used for storing data that are of type (tables,indexes....) ...
Latest Answer : yes what is the different between schema and database ...
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
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. The main object is a person and different categories of items are stored in separate tables (movies
Show the basic architecture of Data Warehouse and briefly describe its components.
