Technical Questions / Interviews
Hi, One question I was asked was pretty lame…would I know what CAT5 cable is and how can I be sure it was correct? Also, I was asked “If the user reported a problem with their computer, would I asked them to check the cables before I made a trip to the desk/office to check [...]
View Answer
| June 2, 2008 3:42 PM
Interview questionaire, IT careers
Hi, One question I was asked was pretty lame…would I know what CAT5 cable is and how can I be sure it was correct? Also, I was asked “If the user reported a problem with their computer, would I asked them to check the cables before I made a trip to the desk/office to check [...]
View Answer
| June 2, 2008 3:42 PM
Interview questionaire, IT careers
DB2 Transaction in C#.Net
You’ll need o setup and configure MS DTC on the workstations, as well as configure IBM’s Distributed Transaction Coordinator on the DB2 server.
View Answer
| May 31, 2008 10:20 PM
.NET, .NET Data Provider, C#, DB2
You’ll need o setup and configure MS DTC on the workstations, as well as configure IBM’s Distributed Transaction Coordinator on the DB2 server.
View Answer
| May 31, 2008 10:20 PM
.NET, .NET Data Provider, C#, DB2
Data Modeling Tools for relational database & dimensional data mart
You don’t need any specific tool to do a data mart compared to an OLTP database. Toad will work just fine. Many people including myself prefer to use Visio to do this. This gives you a second option.
View Answer
| May 31, 2008 9:41 PM
Data mart, Data Model Diagram, Data modeling, Oracle, Oracle Data Mart, Relational databases, Snowflake Schema, Toad Data Modeler
You don’t need any specific tool to do a data mart compared to an OLTP database. Toad will work just fine. Many people including myself prefer to use Visio to do this. This gives you a second option.
View Answer
| May 31, 2008 9:41 PM
Data mart, Data Model Diagram, Data modeling, Oracle, Oracle Data Mart, Relational databases, Snowflake Schema, Toad Data Modeler
Planning to move data on new databse server?
Moving your database shouldn’t be all that hard. It sounds like you are planning on moving the application from the current server to a third server which makes it easier to do. 1. Install SQL 2000 on the new server. You will want to patch it to the same patch level that the current server [...]
View Answer
| May 31, 2008 8:51 PM
Application Server, Database servers, SQL Server 2000
Moving your database shouldn’t be all that hard. It sounds like you are planning on moving the application from the current server to a third server which makes it easier to do. 1. Install SQL 2000 on the new server. You will want to patch it to the same patch level that the current server [...]
View Answer
| May 31, 2008 8:51 PM
Application Server, Database servers, SQL Server 2000
how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003
You will want to reduce the amount of data that you need to transfer to the smallest amount of data possible. This way you are transferring the smallest amount of data possible. The easiest way to do this would be to query the remote system for the highest value that it has then transfer the [...]
View Answer
| May 30, 2008 8:56 PM
SQL Server 2005, SSIS, Update remote database
You will want to reduce the amount of data that you need to transfer to the smallest amount of data possible. This way you are transferring the smallest amount of data possible. The easiest way to do this would be to query the remote system for the highest value that it has then transfer the [...]
View Answer
| May 30, 2008 8:56 PM
SQL Server 2005, SSIS, Update remote database
set up file not installed in other system
Hello Bipansahoo, did you add all necessary files to the Package and Deployment Wizard? Normally if you are using OCX,DLL or any ohter additional files, I stringly suggest you providing the most updated version of these files. Anyway does the message say you which files are outdated? Bye
View Answer
| May 30, 2008 7:04 AM
Microsoft Access, Package and Deployment wizard, VB, Visual Basic 6
Hello Bipansahoo, did you add all necessary files to the Package and Deployment Wizard? Normally if you are using OCX,DLL or any ohter additional files, I stringly suggest you providing the most updated version of these files. Anyway does the message say you which files are outdated? Bye
View Answer
| May 30, 2008 7:04 AM
Microsoft Access, Package and Deployment wizard, VB, Visual Basic 6
How Can i restrict the user to insert next record
Hello, you can accomplish to this in two ways: 1) If the db is on a SQL server you can set this field to be <i>NoNull</i> so no null values are allowed. 2) You can do it via code by checking if the length of the field is major than 0 or not (e.g. <i>If [...]
View Answer
| May 29, 2008 4:01 PM
Access 2000, Microsoft Access, VBA, Visual Basic for Applications
Hello, you can accomplish to this in two ways: 1) If the db is on a SQL server you can set this field to be <i>NoNull</i> so no null values are allowed. 2) You can do it via code by checking if the length of the field is major than 0 or not (e.g. <i>If [...]
View Answer
| May 29, 2008 4:01 PM
Access 2000, Microsoft Access, VBA, Visual Basic for Applications
Limiting characters in memo field
Hello OldDog, this cannot be done on a memo field but only to test fields. You may consider using some VBA code to check the length before insert/update (E.g. <i>If Len(text) > 123 then….</i>) Bye
View Answer
| May 29, 2008 9:03 AM
Microsoft Access
Hello OldDog, this cannot be done on a memo field but only to test fields. You may consider using some VBA code to check the length before insert/update (E.g. <i>If Len(text) > 123 then….</i>) Bye
View Answer
| May 29, 2008 9:03 AM
Microsoft Access
Grouping in a report
Hello Kemosabe everything depends on which report engine yuo are using; some engines have conditions/options that easily allow this. Please be more specific.
View Answer
| May 29, 2008 8:58 AM
Database reporting
Hello Kemosabe everything depends on which report engine yuo are using; some engines have conditions/options that easily allow this. Please be more specific.
View Answer
| May 29, 2008 8:58 AM
Database reporting
Restricting the user to insert next record
Hello, I guess you want to do this with some programming like VB, ASP or whatever, may you please specify which language? Bye
View Answer
| May 29, 2008 8:53 AM
Database, Database programming, Datasheet View, Form validations
Hello, I guess you want to do this with some programming like VB, ASP or whatever, may you please specify which language? Bye
View Answer
| May 29, 2008 8:53 AM
Database, Database programming, Datasheet View, Form validations
IT as a career
There are a lot of areas to consider in IT. There are a lot of other folks asking the same question on this board. Try using the search on this site for careers and learning new skills. Then, if you have additional questions, come back and ask those and we will be glad to assist. [...]
View Answer
| May 29, 2008 1:50 AM
IT, IT careers
There are a lot of areas to consider in IT. There are a lot of other folks asking the same question on this board. Try using the search on this site for careers and learning new skills. Then, if you have additional questions, come back and ask those and we will be glad to assist. [...]
View Answer
| May 29, 2008 1:50 AM
IT, IT careers
Embedded SQL in SQLRPGLE using JOIN on multiple files
I have done this before with JOIN on multiple files with no problems. Just make sure the data structure you fetch into is defined to match the fields on your SELECT. All fields will be defined in the same data structure. This makes it kind of hard to just define the data structure externally to [...]
View Answer
| May 28, 2008 8:26 PM
DB2 Universal Database, RPG ILE
I have done this before with JOIN on multiple files with no problems. Just make sure the data structure you fetch into is defined to match the fields on your SELECT. All fields will be defined in the same data structure. This makes it kind of hard to just define the data structure externally to [...]
View Answer
| May 28, 2008 8:26 PM
DB2 Universal Database, RPG ILE
Best authentication method
You can install ssl cert and arrange merchant accounts with your financial institute or setup paypal accounts which are very secure
View Answer
| May 28, 2008 6:29 PM
Access control, Application security, Biometrics, Browsers, Database, Digital certificates, Encryption, Exchange, filtering, Identity & Access Management, Instant Messaging, provisioning, Secure Coding, Security tokens, Servers, Single sign-on, SSL/TLS, Web security
You can install ssl cert and arrange merchant accounts with your financial institute or setup paypal accounts which are very secure
View Answer
| May 28, 2008 6:29 PM
Access control, Application security, Biometrics, Browsers, Database, Digital certificates, Encryption, Exchange, filtering, Identity & Access Management, Instant Messaging, provisioning, Secure Coding, Security tokens, Servers, Single sign-on, SSL/TLS, Web security
How can I change the collation name of a specific database?
The collation of a user database can be changed via the ALTER DATABASE command. <pre>alter database MyDatabase collate Latin1_General_BIN</pre> You can see the list of available collations <a href=”http://msdn.microsoft.com/en-us/library/ms180175.aspx”>here</a> or by running the following SQL Command. <pre>select * from sys.fn_helpcollations()</pre>
View Answer
| May 28, 2008 8:28 AM
Collation, Database collation
The collation of a user database can be changed via the ALTER DATABASE command. <pre>alter database MyDatabase collate Latin1_General_BIN</pre> You can see the list of available collations <a href=”http://msdn.microsoft.com/en-us/library/ms180175.aspx”>here</a> or by running the following SQL Command. <pre>select * from sys.fn_helpcollations()</pre>
View Answer
| May 28, 2008 8:28 AM
Collation, Database collation
AS400 in Future?
Try to make your skills as portable across operating systems and devices as possible. It’s the ideas that you should use to promote yourself. Be flexible and not afraid of change. Embrace it and let it lead you into the challenges and rewards of a brighter future.
View Answer
| May 28, 2008 4:36 AM
AS/400, IT careers, Mainframe
Try to make your skills as portable across operating systems and devices as possible. It’s the ideas that you should use to promote yourself. Be flexible and not afraid of change. Embrace it and let it lead you into the challenges and rewards of a brighter future.
View Answer
| May 28, 2008 4:36 AM
AS/400, IT careers, Mainframe
Procedures for a new area.
It depends on the level of detail required and the audience for the policy. ISO will provide indepth administration and technical criteria related to a policy ….ie…provides details from start to finish on what is the purpose of the policy, scope, and tools used to monitor that the policy is in effect. COBIT will provide [...]
View Answer
| May 28, 2008 4:05 AM
Access control, Application security, backdoors, Biometrics, Browsers, Cabling, Compliance, configuration, CRM, Current threats, Database, DataCenter, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network management software, Network security, Networking, Outsourcing, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Switches, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
It depends on the level of detail required and the audience for the policy. ISO will provide indepth administration and technical criteria related to a policy ….ie…provides details from start to finish on what is the purpose of the policy, scope, and tools used to monitor that the policy is in effect. COBIT will provide [...]
View Answer
| May 28, 2008 4:05 AM
Access control, Application security, backdoors, Biometrics, Browsers, Cabling, Compliance, configuration, CRM, Current threats, Database, DataCenter, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network management software, Network security, Networking, Outsourcing, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Switches, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Database Newbie
For database information <a href=”http://www.searchsqlserver.com”>searchsqlserver.com</a> is a good one. You can also check out the <a href=”http://itknowledgeexchange.techtarget.com/sql-server/”>SQL Server with mrDenny</a> blog You’ll need to learn about creating Web Methods in ASP.NET which will be how your app talks to the database. Here’s a nice little article on <a href=”http://msdn.microsoft.com/en-us/magazine/cc302021.aspx”>Web Methods</a>.
View Answer
| May 27, 2008 11:56 PM
Database, Database security, SQL Server, SQL Server 2005, SQL Server 2008, VB.NET 2008, Visual Basic .NET
For database information <a href=”http://www.searchsqlserver.com”>searchsqlserver.com</a> is a good one. You can also check out the <a href=”http://itknowledgeexchange.techtarget.com/sql-server/”>SQL Server with mrDenny</a> blog You’ll need to learn about creating Web Methods in ASP.NET which will be how your app talks to the database. Here’s a nice little article on <a href=”http://msdn.microsoft.com/en-us/magazine/cc302021.aspx”>Web Methods</a>.
View Answer
| May 27, 2008 11:56 PM
Database, Database security, SQL Server, SQL Server 2005, SQL Server 2008, VB.NET 2008, Visual Basic .NET
Getting Into IT – Clueless
I was where you are in all this 5 years ago. I had a natural ability with computers but I needed more than that to start working professionally of course. The best way in my opinion is to start with a basic computer certification course, like an MCP in windows xp desktop, or if you [...]
View Answer
| May 27, 2008 7:29 PM
Career development, Certifications, IT careers, MCSE
I was where you are in all this 5 years ago. I had a natural ability with computers but I needed more than that to start working professionally of course. The best way in my opinion is to start with a basic computer certification course, like an MCP in windows xp desktop, or if you [...]
View Answer
| May 27, 2008 7:29 PM
Career development, Certifications, IT careers, MCSE
MS Access IIF
Hello Keg, if I understood well your answer, your query shoule look like this: <pre> SELECT (SELECT SUM(COST) FROM MY TABLE WHERE [TASK TYPE]= ‘STEEL’) AS STEEL_COST FROM MY TABLE</pre> Regards.
View Answer
| May 27, 2008 7:30 AM
IIF function, Microsoft Access
Hello Keg, if I understood well your answer, your query shoule look like this: <pre> SELECT (SELECT SUM(COST) FROM MY TABLE WHERE [TASK TYPE]= ‘STEEL’) AS STEEL_COST FROM MY TABLE</pre> Regards.
View Answer
| May 27, 2008 7:30 AM
IIF function, Microsoft Access
Whats a good tool/software to import (excel, csv) into IBM DB2
Hello Geyes, <a href=”https://www.regsoft.net/regsoft/vieworderpage.php3?productid=79982″>this tool costs only 20€</a> so i’d say it is not too much. Bye
View Answer
| May 26, 2008 9:54 AM
CSV, import DB2, Microsoft Excel
Hello Geyes, <a href=”https://www.regsoft.net/regsoft/vieworderpage.php3?productid=79982″>this tool costs only 20€</a> so i’d say it is not too much. Bye
View Answer
| May 26, 2008 9:54 AM
CSV, import DB2, Microsoft Excel
