Latest Answer : It is the property of the database to utilize the additional resources such as the memory and processors to meet the increased demand. By scaling performance is increased to a greater extend ...
Latest Answer : HI, In simple words databse is generic and database server is specific to computers. Database is collection of data in a defined manner.Database sever is software that helps us to operate on the databaseRegards,PRASAD ...
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. ...
Latest Answer : This may be considered as the mapping of the data and data relations into an indefinitely large linear address space. This specifies some or all of the data structures necessary to support the data and data relations declared in the conceptual schema. ...
Latest Answer : no up to 3nf it is not sufficient to normilize...coz 3nf contains redundancy problem....that can be removed by BCNF...so up to BCNF it is sufficient..... ...
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
What are latches in Oracle 9i Database? Can you name the latches.How do you resolve contention on latches.
Provide VBScript code that that outputs the contents of a SQL table into a CSV formatted file called Output.csv. Your code must include the connection string and must use the following SQL criteria:
What are the reasons of developing Object Oriented Database management system? Describe the various features of Object Oriented programming languages that are being supported by SQL with the help of an
