Wednesday, April 28, 2010
UPTU EVEN SEM. EXAM SCHEDULE_2010

Monday, April 26, 2010
Software Quality Assurance, questions asked by interviwers......
- What and where are the policy statements that dictate quality assurance in your project?
- What are the functions of the Quality Assurance Group (QAG)?
- How are the quality assurance activities planned ?
- What is a non-conformance report (NCR)?
- When a non-conformance is noted during these "reviews", what happens next?
- What is is External Quality Assurance (EQA) and Final Inspection (FI)?
- Is the quality assurance group (for the QAG) audited? Who does these audits?
- How frequently is your project audited? How do you know the result of these audits?
- What is an internal quality audit? What happens during this audit?

Software Project Planning, question asked by interviwers.......
- What is the project management structure in your project? Is a PL assigned to the project?
- How do you know that a particular individual is the project leader (or) how do you know that you are the Project Leader?
- What and where are the policy statements for software project planning?
- Explain the various activities you do (as a PL) when the project is started up.
- How do you know what you need to deliver or do in your project?
- How do you create the Software Project Management Plan (SPMP)?
- What training have you undergone in project planning?
- How do you ensure that your project plan is available for others to see? Where will you find the plans of other projects executed (in the past or currently) in the center?
- How did you choose the appropriate lifecycle for your project?
- What are the documents that you will refer to create the plan?
- How do you estimate the effort for your project? Where is the estimation procedure documented?
- What procedures do you follow to arrive at the project schedule?
- Where and how are the risks associated with your project identified and documented?
- When you come in to the office, how do you know what you have to do during the day?
- How do you report the status of your project?
- How are the team members kept informed about the current status of the project?
- How do the audits cover planning activities?
- How does the senior management review your project's progress?
- How do you track the technical activities in your project? How is the status of the project communicated to the team?
- How do you track the size or changes to size of the work products in your project?
- When do revise your project plan? When do you know you have to revise your project plan? Where is the plan revision frequency documented?
- How do you ensure that you and all the other team members in your project have the required technical skills to execute the project?
- How do you assign tasks to your team members? ?
- What is the document that should be consulted to know about your project, the activities you do, your schedules and milestones?

Requirements Management, question asked by interviwers....
- What is your project about? What stage or phase is it currently in? What is your current role in your project?
- Explain how you manage requirements in your project?
- Where and how do you document your requirements?
- What and where are the policy statements for requirement management?
- How do you ensure that you base your software plans, work items and products on the requirement?
- If during some stage down the life cycle, the initial requirements change, what will you do? How will you handle any changes in the requirements?
- Who reviews the requirements and the changes to the requirements?
- Explain the contract review process followed in your project?
- When requirements change, how do you handle the changes it may lead to project progress and schedule?
- How do you handle any risk that might arise due to changes in requirements?
- How do you ensure that you are consistently meeting the requirements during various stages in the life cycle of the software product?
- How do internal quality audits cover requirements management activities in the project?
- Who is responsible for managing the requirements in your project?
- What will you do if you find that you cannot meet the requirements?
- While doing HLD/LLD/Coding/Testing, how do you know that a specific HLD/LLD component, program code unit, or test case relates to a particular requirement?

Database Questions asked by interviewers.....
- What are the different types of joins?
- Explain normalization with examples.
- What cursor type do you use to retrieve multiple recordsets?
- Diffrence between a "where" clause and a "having" clause
- What is the difference between "procedure" and "function"?
- How will you copy the structure of a table without copying the data?
- How to find out the database name from SQL*PLUS command prompt?
- Tadeoffs with having indexes
- Talk about "Exception Handling" in PL/SQL?
- What is the diference between "NULL in C" and "NULL in Oracle?"
- What is Pro*C? What is OCI?
- Give some examples of Analytical functions.
- What is the difference between "translate" and "replace"?
- What is DYNAMIC SQL method 4?
- How to remove duplicate records from a table?
- What is the use of ANALYZing the tables?
- How to run SQL script from a Unix Shell?
- What is a "transaction"? Why are they necessary?
- Explain Normalizationa dn Denormalization with examples.
- When do you get contraint violtaion? What are the types of constraints?
- How to convert RAW datatype into TEXT?
- Difference - Primary Key and Aggregate Key
- How functional dependency is related to database table design?
- What is a "trigger"?
- Why can a "group by" or "order by" clause be expensive to process?
- What are "HINTS"? What is "index covering" of a query?
- What is a VIEW? How to get script for a view?
- What are the Large object types suported by Oracle?
- What is SQL*Loader?
- Difference between "VARCHAR" and "VARCHAR2" datatypes.
- What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.
- Difference between "ORACLE" and "MICROSOFT ACCESS" databases.
- How to create a database link ?

The World of WWW, questions asked by interviewers
- What is HTTP? Explain its working?
- What is DNS?
- Why do I need a domain name like 'OneSmartClick.Com'?
- What happens when I type in some url and press enter?
- How does CGI work? Can I use 'C' language to write a CGI?
- Working of Proxy Server, Cookies, types of cookies?
- What is Firewall?
- How to redirect to another page?
- Some questions on web servers.
- What is DOM?
- Connection Pooling in IIS 3.0 and 4.0
- What is Code Base, Style Sheets?
- Need for CSS
- DHTML: Difference between FontSize and Font Size?
- Layers in TCP/IP
- Some sites work with "http://sitename.com" but for some sites we need to specify "www" - like "http://www.sitename.com". Why?
- Explain "URL Encoding",HTML "entity", GET method, POST method
- If we force XML for web design, the browzer size will reduce. How?
- How does DTD work?
- Difference between ASP and DHTML?
- How to create virtual directory in IIS?
- Can I host muliple sites on same machine?
- Administration of IIS.
- Some questions on ODBC and internet.
- XML and propritory databbases.
- Working of ping, telnet, gopher.
- Some questions about cross-browzer compatibility.

Operating Systems questions asked by interviewrs.......!!!!!!!
- What is MUTEX ?
- What isthe difference between a 'thread' and a 'process'?
- What is INODE?
- Explain the working of Virtual Memory.
- How does Windows NT supports Multitasking?
- Explain the Unix Kernel.
- What is Concurrency? Expain with example Deadlock and Starvation.
- What are your solution strategies for "Dining Philosophers Problem" ?
- Explain Memory Partitioning, Paging, Segmentation.
- Explain Scheduling.
- Operating System Security.
- What is Semaphore?
- Explain the following file systems : NTFS, Macintosh(HPFS), FAT .
- What are the different process states?
- What is Marshalling?
- Define and explain COM?
- What is Marshalling?
- Difference - Loading and Linking ?

Subscribe to:
Posts (Atom)