HITEQUEST
technical interviews for high-tech professionals

 =QA Software Questions= 


   
 
 

 

 

   
 
SQL Servers
  • What is a major difference between SQL Server 6.5 and 7.0 platform wise?

    •   SQL Server 6.5 runs only on Windows NT Server. SQL Server 7.0 runs on Windows NT Server, workstation and Windows 95/98.
  • Is SQL Server implemented as a service or an application?

    •   It is implemented as a service on Windows NT server and workstation and as an application on Windows 95/98.
  • What is the difference in Login Security Modes between v6.5 and 7.0?

    •   7.0 doesn't have Standard Mode, only Windows NT Integrated mode and Mixed mode that consists of both Windows NT Integrated and SQL Server authentication modes.
  • What is a traditional Network Library for SQL Servers?

    •   Named Pipes
  • What is a default TCP/IP socket assigned for SQL Server?
      1433
  • If you encounter this kind of an error message, what you need to look into to solve this problem? "[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL Server not found."
      1.Check if MS SQL Server service is running on the computer you are trying to log into
    2.Check on Client Configuration utility. Client and Server have to in sync.
  • What are the two options the DBA has to assign a password to sa?
      a) to use SQL statement
    Use master
    Exec sp_password NULL,
    b) to use Query Analyzer utility
  • What is new philosophy for database devises for SQL Server 7.0?
      There are no devises anymore in SQL Server 7.0. It is file system now.
  • When you create a database how is it stored?
      It is stored in two separate files: one file contains the data, system tables, other database objects, the other file stores the transaction log.
  • Let's assume you have data that resides on SQL Server 6.5. You have to move it SQL Server 7.0. How are you going to do it?
      You have to use transfer command.

     
    DirectConnect

     
  • Have you ever tested 3 tier applications?
  • Do you know anything about DirectConnect software? Who is a vendor of the software?
      Sybase.
  • What platform does it run on?
      UNIX.
  • How did you use it? What kind of tools have you used to test connection?
      SQL Server or Sybase client tools.
  • How to set up a permission for 3 tier application?
      Contact System Administrator.
  • What UNIX command do you use to connect to UNIX server?
      FTP Server Name
  • Do you know how to configure DB2 side of the application?
      Set up an application ID, create RACF group with tables attached to this group, attach the ID to this RACF group.

     
    Web Application

     
  • What kind of LAN types do you know?
      Ethernet networks and token ring networks.
  • What is the difference between them?
      With Ethernet, any devices on the network can send data in a packet to any location on the network at any time. With Token Ring, data is transmitted in 'tokens' from computer to computer in a ring or star configuration.
     
    Steve Dalton from ExchangeTechnology:  "This is such a common mistake that people make about TR I didn't want it to propagated further!"
    Token ring is the IEEE 802.5 standard that connects computers together in a closed ring. Devices on the ring cannot transmit data until permission is received from the network in the form of an electronic 'token'. The token is a short message that can be passed around the network when the owner is finished. At any time, one node owns the token and is free to send messages. As with Ethernet the messages are packetized. The packet = start_flag + address + header + message + checksum + stop_flag. The message packets circulate around the ring until the addressed recipient receives them. When the sender is finished sending the full message (normally many packets),he sends the token.
    An Ethernet message is sent in packets too. The sending protocol goes like this:
    1. wait until you see no activity on the network .
    2. begin sending your message pocket.
    3. while sending, check simultaneously for interference (another node wants to send data).
    4. as long as all clear, continue sending your message.
    5. if you detect interference abort your transmission, wait a random length of time and try again.

    Token ring speed is 4/16 Mbit/sec , Ethernet - 10/100 Mbit/sec
    For more info see http://www.flgnetworking.com/usefuli4.html
  • What protocol both networks use? What it stands for?
      TCP/IP. Transmission Control Protocol/ Internet Protocol.
  • How many bits IP Address consist of?
      An IP Address is a 32-bit number.
  • How many layers of TCP/IP protocol combined of?
      Five. (Application, Transport, Internet, Data link, Physical)
  • How to define testing of network layers?
      Reviewing with your developers to identify the layers of the Network layered architecture, your Web client and Web server application interact with. Determine the hardware and software configuration dependencies for the application under test.
  • How to test proper TCP/IP configuration Windows machine?
      To run command on:
    Windows NT: IPCONFIG/ALL
    Windows 95: WINIPCFG
    Ping or ping
  • What is a component-based Architecture? How to approach testing of a component based application?
    � Define how many and what kind of components your application has.
    � Identify how server-side components are distributed
    � Identify How server-side software components interact with each other
    � Identify how Web-To- Database connectivity is implemented
    � Identify how processing load is distributed between client and server to prepare for load stress and performance testing
    � Prepare for compatibility and reliability testing
  • How to maintain Browser settings?
      Go to Control Panel, Internet Option.
  • What kind of testing considerations you have to have in mind for Security Testing?
      In client/server system, every component carries its own security weaknesses.
    The primary components which need to be tested are:
    � application software
    � the database
    � servers
    � the client workstations
    � the network

Main menu