-
-
-
-
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...
-
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....
-
-
-
-
-
-
-
-
VBScript to output contents of SQL Table
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: SQL Server Name: DBServerDatabase Name: DBNameSQL User Login: SQLUserSQL User Password: SQLPasswordSQL Table: dbo.Exam (2 fields: FirstName, LastName)
-
-
-
Difference between user and end-user
Types of users with their duties using suitable examples
-
Reasons of developing Object Oriented Database Management System
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 example each.
-
Microsoft and Oracle's XML Technology
Differentiate between Microsoft and Oracle's XML technology support for database.
-
Basic Architecture of Data Warehouse
Show the basic architecture of Data Warehouse and briefly describe its components.
-
Database Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans