Data Management Interview Questions 

I've been accepted into a Master's program (MSc in Information Technology) from a reputable UK program. I have no previous tech work experience but a strong background in finance and some law.

Here are the skills that the program is supposed to teach me:
- Java
-networks and security
-Databases : XHTML,XML,SQL
-UML
-Collections- ArrayList, Vector, iterators, comparators, generics
-Inheritance and interfaces, algebraic approach
-RMI
-ADTs and data structures

I realize that IT experience would affect marketability, but would these base skills position me well for a future in the industry? I'd want to eventually do project management or take on a managerial/finance role within a company...

Thank you!

I have a SP that basically copies data from one table to another.

Some of the data could be duplicates and so the SP detects any primary key violations, error 2627 and if detected uses a random number for the PK and tries the insert again.

This SP works fine when run manually from Management Studio but when scheduled as a job step, it fails. From investigation, it seems that the logic to handle PK violations is being processed but if there are more than around 16 PK violations in the batch copy, the job step fails at around the 17th violation insert and fails to process the rest of the step.

When this happens, as well as seeing the 2627 error logged in the message field of the job log history, it also records an error code 3621 in the SQL Message ID field of the log with Severity 14.

It is not a data issue as subsequent reruning of the job picks up where it failed previously and continues before failing again.

Does anyone know why this SP should fail as a job?

<<The Sr. QA Automation Engineer in this role will help Experian QA implement a robust, scalable, and reusable automation and performance framework.

Responsibilities:
• Analyze requirements specifications and identify specific test points within the software.
• Independently design and document detailed automation test cases to cover all levels of test
• Effectively employ automation to reduce testing cycles on repeated tasks.
• Generate/assemble test data to support test conduct
• Analyze defects identified and document in a problem report
• Interact with software developers to tune code and track all problem reports to closure

Skills:
Sound knowledge of software development lifecycle and QA processes
Knowledge of one or more industry tools and solutions that provide automated testing. (WinRunner,
QuickTest Pro, SilkTest, JUnit, eTest, Quality Center, SQA Robot, etc.)
Experience with multiple platforms (Windows, Solaris, Linux, HP UX, AIX), Web Servers (IIS and or iPlanet server), Application Servers, web technologies (Java, XML, WAP etc), web technology tools (Java, Java Scripting, Junit, Jmeter)
Knowledge of SQL and Databases (MS SQL or Oracle)
Excellent oral and written communication skills; including the ability to effectively convey issues and alternatives regardless of the audience level or circumstances, in writing or orally.
Adept at extracting information from written materials, and identifying the action to be taken
Effective organizational skills; ability to multi-task. Interact with software developers to tune code and track all problem reports to closure
Experienced with any programming or scripting language (VB, C, C++, Java, Perl, AWK, etc.)
Familiar with version control/configuration management systems and defect tracking software.


Requirements
Sound knowledge of software development lifecycle and QA processes
Knowledge of one or more industry tools and solutions that provide automated testing. (WinRunner,
QuickTest Pro, SilkTest, JUnit, eTest, Quality Center, SQA Robot, etc.)
Experience with multiple platforms (Windows, Solaris, Linux, HP UX, AIX), Web Servers (IIS and or iPlanet server), Application Servers, web technologies (Java, XML, WAP etc), web technology tools (Java, Java Scripting, Junit, Jmeter)
Knowledge of SQL and Databases (MS SQL or Oracle)
Excellent oral and written communication skills; including the ability to effectively convey issues and alternatives regardless of the audience level or circumstances, in writing or orally.
Adept at extracting information from written materials, and identifying the action to be taken
Effective organizational skills; ability to multi-task. Interact with software developers to tune code and track all problem reports to closure
Experienced with any programming or scripting language (VB, C, C++, Java, Perl, AWK, etc.)
Familiar with version control/configuration management systems and defect tracking software.
Do Whatever it Takes attitude
Advanced written and spoken English. Ability to communicate by phone, email, instant messaging and in-person. Position will communicate regularly with US based QA team as well as various developers and even potentially product / business users.
Experience with developing and supporting an automation system using keyword approach
Experience with one or multiple automation frameworks
Minimum 5years experience in Web based application testing
Smart, quick thinker, flexible.
Ability to learn and understand complex business rules
Experience writing and reviewing test plans/cases
Experience with both B2C and B2B software solutions.
Requires complete understanding software development and QA methodologies
Ability to be proactive and work independently with minimal supervision
Strong analytical skills are essential. Ability to make independent decisions based on experience and judgment.
Ability to multi-task assignments and manage self accordingly>>

1. Which of the following statements is correct about creating a database connection?
a. An application can have at most one database connection.
b. Connections can be created to different types of databases, such as Microsoft Access or SQL Server.
c. To create a connection, create an instance of the Connection control on a form.
d. There are two types of database connections - strongly typed connections and untyped connections.

2. Which of the following statements is correct of database connections?
a. Connection strings are identical from one database provider to another.
b. The Provider key is used to specify a database management system such as Microsoft Access.
c. To create a database connection, create an instance of the Connect class.
d. Once a connection has been created, it is always open while an application is running.


3. The Data Source key of the ConnectionString property of the OleDbConnection class defines:
a. the directory containing the database file and the name of the file.
b. the file containing the database.
c. the authentication information required by the provider.
d. the source code for the database.



4. ____ is a Microsoft technology for interfacing with data stores.
a. OLE DB c. XML
b. HTML d. COM



5. ADO was based on the ____ standard for interfacing with a data store.
a. XML c. .NET Framework
b. OLE DB d. JDBC


6. ADO.NET, released in 2002, is based on the ____.
a. ODBC protocol c. Microsoft .NET Framework
b. OLE DB standard d. XML format



7. A(n) ____ is a set of classes that provides the link between the dataset and the database.
a. DB2 c. data provider
b. dataset d. RDBMS

8. A(n) ____ is a separate memory resident representation of only that part of the database that an application needs.
a. RDBMS c. ADO object
b. dataset d. data provider



9. If an ADO.NET application updates (changes) the data in the dataset, the ____ writes the dataset back to the database.
a. data provider c. ADO.NET class
b. XML object d. ADO class



10. A ____ simply tells the application where the database is located and allows the user to log on to the database.
a. data connection c. data source
b. dataset d. data object


11. A ____ specifies exactly which parts of the database (which Tables, Columns, Views, Stored Procedures, and so on) are needed by the application.
a. data table c. data connection
b. data source d. DataRow



12. The ____ object is a memory resident cache (store) of data obtained from the underlying database just for this application.
a. DataSet c. TableCollection
b. DataCollection d. TableAdapterColle...

Could you please help me with the practice questions. Thank you.

1. Which of the following statements is correct about creating a database connection?
a. An application can have at most one database connection.
b. Connections can be created to different types of databases, such as Microsoft Access or SQL Server.
c. To create a connection, create an instance of the Connection control on a form.
d. There are two types of database connections - strongly typed connections and untyped connections.

2. Which of the following statements is correct of database connections?
a. Connection strings are identical from one database provider to another.
b. The Provider key is used to specify a database management system such as Microsoft Access.
c. To create a database connection, create an instance of the Connect class.
d. Once a connection has been created, it is always open while an application is running.


3. The Data Source key of the ConnectionString property of the OleDbConnection class defines:
a. the directory containing the database file and the name of the file.
b. the file containing the database.
c. the authentication information required by the provider.
d. the source code for the database.



4. ____ is a Microsoft technology for interfacing with data stores.
a. OLE DB c. XML
b. HTML d. COM



5. ADO was based on the ____ standard for interfacing with a data store.
a. XML c. .NET Framework
b. OLE DB d. JDBC


6. ADO.NET, released in 2002, is based on the ____.
a. ODBC protocol c. Microsoft .NET Framework
b. OLE DB standard d. XML format



7. A(n) ____ is a set of classes that provides the link between the dataset and the database.
a. DB2 c. data provider
b. dataset d. RDBMS

8. A(n) ____ is a separate memory resident representation of only that part of the database that an application needs.
a. RDBMS c. ADO object
b. dataset d. data provider



9. If an ADO.NET application updates (changes) the data in the dataset, the ____ writes the dataset back to the database.
a. data provider c. ADO.NET class
b. XML object d. ADO class



10. A ____ simply tells the application where the database is located and allows the user to log on to the database.
a. data connection c. data source
b. dataset d. data object


11. A ____ specifies exactly which parts of the database (which Tables, Columns, Views, Stored Procedures, and so on) are needed by the application.
a. data table c. data connection
b. data source d. DataRow



12. The ____ object is a memory resident cache (store) of data obtained from the underlying database just for this application.
a. DataSet c. TableCollection
b. DataCollection d. TableAdapterColle...

Hi i am creating a management system(web application) using javascript, asp.net and SQL database.

i had this 3 web form
- Add Data
- Update Data
- Select New member ( i want it to be a popup web page, after selecting a new using by clicking a button in the datagrid, it will save the user name in cookies and close the webform)

what is the best solution i can use to link them together?

i had try using hyperlink column but i do not know how to evaluate from the Select New memberweb form whether where the user came from(either Add or Update webform).

I had also try creating button in itemdatabound but i couldn't retrieve the data click by the user and save to cookies.

Please give me some advice. Thanks.

i need 2 make a project on any one of d topics viz:
hospital management
hotel management
call centre management
human resource management system.

database shud b sql. it shud b user friendly. nd integrated data wid xml data sources or text files in d application.
pls suggest me some site 4m where i can get it or if anybody have project on any of dese topics or related topics pls pls giv me. ASAP.
thank u..

We have an urgent requirement for our client. If someone could assist, it would be great. I'm giving the details below.

Title: Technical Manager/Lead
Location: Calabasas, CA
Duration: 6+ months
Salary: Open

Should have (Mandatory):-
Financial Project Management must have managed in the past couple of projects. (Consultants with Lead experience will also be considered)
Experience with Calypso investment system

Required Skills:-
Java, J2EE, Eclipse, XML, Swing, Oracle
Experience with JDBC, JMS, Jide, JMX, and RMI highly valued
Extensive knowledge of design patterns
Experience with n-tier deployment and data caching
Delivery experience on an actual J2EE project with integration with 3rd party applications
Knowledge and experience in Test-Driven Development
Knowledge and experience with Continuous Integration
Data modeling and SQL (Sybase preferred)
Interfacing via messaging (IBM MQ preferred)

Pramod
732-283-0499x216
bpramod@eprocorp.com

ABSTRACT


TITLE: DMT eMall

PROJECT DESCRIPTION:
The Website, DMTeMall – The Premier Site for Anything and Everything Electronic!!, The main sphere of DMT’s activity is to lease or wholesale or retail of computer peripherals and components with a big market share and presence in Hyderabad.DMT eMall provides very efficient way to consumers for E-Shopping the Electronic goods.
DMT eMall Site is a system developed for the online shopping i.e.
?Provides for sell, buy, Auction , Bid goods online .
?Help users find,display, compare, view, analyze electronics goods and act on information in a user friendly and timely way.
?Facilitates to meet user needs weather they are individuals or manufactures.
?Facilitating top quality services and solutions to its customers and clients
?The company’s productivity will be increased depending on two factors Revenue growth and cost saving.

The main objective of the website is to make the process of online shopping easy and user friendly.
LIST OF FEATURES:
1. Customer, Dealer, Administrator – are the type of users that can access this application
2. Customer can purchase online or directly from the dealer
3. Customer should have a login id to purchase online
4. Customer can search from the website for a particular product even though he is not having an ID.
5. Dealer can give a request for a stock
6. Dealer can update/return only his stock.
7. Dealer can view his stock reports /sales reports
8. Dealer can check his region customer’s requests.
9. Dealer can sell a product directly to customer and the same can update in the database. As well as he will send the product to the nearest locations as per the customer’s request.
10. Customer is not having any relation ship with main database. As well as dealer also.
11. Admin will create the main stock.
12. Admin can add/remove a Stock from main stock
13. Admin can add a new item to the main stock database.
14. Admin has to Log-in before to do any transaction.
15. Admin Has to create a dealer
16. Admin has to issue some stock to dealer which stock has to be update in to dealer database as well as need to decrease the same from main stock.
17.Admin can view the all reports like dealer’s stock report , dealer’s sales report, total customer’s , monthly sales by dealer wise, etc.,
18.Fraud Detection Tool
19.No Merchant account required
20.Prompt Payments,Short Payment cycles
21.Multiple Transaction services


SOFTWARE SPECIFICATION:
Operating System : Window’s XP.
Environment : C#.NET 2005, ASP.NET 2005
Database Support : SQL SERVER2000.
CONFIGURATION MANAGEMENT TOOL : VSS



Menu Features Categories:

Item Categories:
1.Cutomer can view different items
2.he can search products based on cost and quality

User Accounts:
1.Login Form
2.Registration Form
3.Change Password form


Administrator:
Admin control panel form( http://aspspider.org/bujjammalu/admin.dm... ---
Model)
Delete Dealer and Delete Customer form.
Display the existed stock items in data grid.

Dealer Issues:
Create new Dealer
Issue Stock to A Dealer
Check the Dealer's Stock
Total Number of Dealers

Customer Issues:
Issue Stock to Customer
Customer Issues (complaints/reviews)
Delete Customer


Other Issues:
Manage Product's
Orders from Customers
Orders from Dealers

Data Base:

1.Creating Master Database for Digital Media
2.Main stock Table
3.Dealer Stock Table
4.Registration Table
5.Main Stock Table
6.Dealer Stock Table (it will create individually for each and every dealer. To maintain the database flexibility)
7.Dropped Customers and Dealers Table.
8.Users Table
9.Payment Table
10.Customer Table.

1) A _ SYSTEM IS COMPOSED OF A SOFTWARE HARDWARE, PROCEDURES, AND PEOPLE.

A) SOFTWARE
B) COMPUTER
C) FILE
D) DATABASE

2) WHICH OF THE FOLLOWING IS NOT A DATA ANOMALLY?

A) MODIFICATION
B) INTERSECTION
C) DELETION
D) CORRECTION

3) WHICH OF THE FOLLOWING IS A LIMITATION OF THE FILE SYSTEM ENVIRONMENT?
A) SUPPORT SQL
B) ALLOWS ONLY OONE USER AT A TIME
C) SECURITY FEATURES ARE LIKELY TO BE INADEQUATE
D) DOES NOT ALLOW FOR THE DELETION OF DATA

4) A DBMS PERFORMS SEVERAL IMPORTANT FUNCTIONS THAT GUARANTEE THE INTEGRITY AND CONSISTENCY OF THE DATABASE. WHICH OF THOSE FUNCTIONS?

A) DATA INTEGRITY MANAGEMENT
B) DATA STORAGE MANAGEMENT
C) DATA REPORTS
D) SECURITY MANAGEMENT

5) THE HIERARCHIAL DATABASE MODEL IS BASED ON _

A) A TREE STRUCTURE
B) LACK OF A PARENT SEGMENT
C) LACK OF A CHILD SEGMENT
D) MATRIX

6) WHICH OF THE FOLLOWING REQUIRES THE MOST DETAIL IN THE INTERNAL MODEL?

A) NETWORK
B) RELATIONAL
C) SEMANTIC
D) ENTITY RELATIONSHIP

THANKS U

Content German Specialist

Database Management SQL

Managing via different internal software, hundreds of thousands different products coming from the various companies wishing to make refer their offers on the shopping.com site for the German version doorone.de.

Google.de

Using Google for different research, seeking info’s on products, via Google to supplement them with missing information. Exp; Images, EAN Number, Manufacturer Number, Product Description, etc…

Microsoft Excel

Via Excel checked that certain products are well sorted thanks to various data-processing rules.

I want to know the meaning of the following briefly:
SQL * REPORT,
SQL * FORM,
REPORT GENERATION IN THE ORACLE,
TUNNING OF THE DATABASE,
USER MANAGEMENT,
SYSTEM MANAGEMENT,
QUERY BY EXAMPLE,
DATA ADMINISTRATOR

please tell us within 10 hours

I cant see the Microsoft sql server data source in change data source window...How to add microsoft sql server data provider in visual studio 2005?

Hi guys, when i set up ASP.NET SQL in SQL Server 2005 i got this error.
You guys know y? Can you guys help me out ? Thx in advance

Setup failed.

Exception:
Unable to connect to SQL Server database.

--------------------------------------...
Details of failure
--------------------------------------...

System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.SqlClient.SqlInternalConnect... exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExc... stateObj)
at System.Data.SqlClient.TdsParser.Connect(... serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnect... serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnect... host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnect... owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnect... identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFacto... options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFac... owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPoo... owningObject)
at System.Data.ProviderBase.DbConnectionPoo... owningObject)
at System.Data.ProviderBase.DbConnectionPoo... owningObject)
at System.Data.ProviderBase.DbConnectionFac... owningConnection)
at System.Data.ProviderBase.DbConnectionClo... outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open...
at System.Web.Management.SqlServices.GetSql... server, String user, String password, Boolean trusted, String connectionString)
--- End of inner exception stack trace ---
at System.Web.Management.SqlServices.GetSql... server, String user, String password, Boolean trusted, String connectionString)
at System.Web.Management.SqlServices.SetupA... server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install)
at System.Web.Management.SqlServices.Instal... database, SqlFeatures features, String connectionString)
at System.Web.Management.ConfirmPanel.Execu...

I installed Visual C++ Express 2005 and MS SQL Server 2005 express. I was playing with the idea of creating a front end program and writing/reading to the MS SQL database. I created a new database using the SQL server management express and was looking to connect the database to my Visual C++ program. In the Visual C++ Express, I see there is a Database explorer in which I can connect to a database. I put in the correct .mdf filename, put when I press OK, I get the following message:
"Unable to open the physical file c:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test1.mdf
Operating system error 32 "32(The process cannot access the file because it is being used by another process.)"
An attempt to attach an auto-named database for file c:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test1.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on a UNC share"

Can someone help point me in the right direction with what I