The certification test for Oracle 1Z0-042 requires sound knowledge of administrative tasks to manage the database. This test demands a thorough knowledge of various administrative tools available in Oracle 10g to manage a database in a very sophisticated manner. The candidate must have a solid understanding of how to back up a database to help in its recovery and one must be very well versed with the objectives specified for the test. Hands-on practice using the software itself can definitely help a candidate in qualifying the test. Practicing especially in the following areas can help raise the confidence level of a candidate:

  1. Know about the architecture of Oracle 10g.
  2. Install Oracle 10g.
  3. Know about various administrative tools to manage the database.
  4. Configure an Oracle network environment.
  5. Work with various database objects.
  6. Configure the Oracle shared server
  7. Implement the database security options.
  8. Manage undo data.
  9. Know the various techniques for database storage
  10. Continue reading

Q. What is the pre-requisite for taking the 1z0-042 test?

A. There is no prerequisite for the 1z0-042 test. The 1z0-042 (OCA) is the first step in the Oracle Database 10g certification track and also the first step towards a successful career as an Oracle professional. However, you must be well experienced with the SQL before you take the test. Even if you are new to the Oracle field, you can still pass the test with self-study or self-schooling. This will require a lot of dedication and practice, managing a database and newly added features in 10g.

Q. How can I register for the test?

A. Register yourself through the registered PearsonVUE testing center. After getting yourself registered for the test, you can contact the testing center to know the schedule (date and time) of your test. Oracle certifications can be taken only at authorized PearsonVUE centers world-wide. The test date may depend on your choice (and availability of slot) in your selected test center. You may choose to register yourself online at http://www.pearsonvue.com/oracle/
Continue reading

The Microsoft test 70-549-VB is designed to measure an individual’s ability to design and develop Enterprise applications by using the Microsoft .NET Framework. Before taking the 70-549-VB test, you should practice the following:

  1. Evaluate the technical feasibility of an application design concept and recommend the best technology.
  2. Create a proof-of-concept prototype, evaluate the risks associated with ASP.NET 2.0 technology, and validate that the proposed technology can be used in an Enterprise application.
  3. Evaluate the technical specifications for an application to ensure that the business requirements are met, and translate the functional specification into developer terminology, such as pseudo code and UML diagrams.
  4. Continue reading

Q. What is the 70-549 exam?

A. Microsoft’s 70-549 exam is designed to test your knowledge of the Enterprise application. The 70-549 exam measures your skills that include developing and designing Web applications, user interface, component, application framework, deploying and supporting an application, and testing and stabilizing an application.

Q. What are the prerequisites for the 70-549 exam?

A. Candidates for 70-549 exam work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET 2005. Candidates should have at least two years of experience developing Microsoft Windows, Web, or Enterprise-based applications.

An Enterprise Applications Developer can operate as a Microsoft Windows, Web, or Enterprise-based Application Developer and can develop middle-tier business logic components. Candidates should have at least three to five years of on-the-job experience committed to enterprise application development.
Continue reading

We designed 70-441 preparation kit to help you get certified effortlessly. PRO: SQL Server 2005 Designing Solutions exam PrepKit contains everything you need to pass the exam in first attempt. Before taking the 70-441 test, you should practice the following:

  1. Create databases and database objects through SQL Server Management Studio and SQL statements.
  2. Use different tools to optimize database and database objects.
  3. Understand the methods of creating reports.
  4. Understand the methods of creating integration packages.
  5. Understand the working of SQL Server Agent.
  6. Secure database and database objects.
  7. Continue reading

Q. What are the prerequisites of the 70-441 exam?

A. Before taking the 70-441 exam, you have to take the 70-431 exam.

Q. I am new to SQL Server. How should I start preparing for the exam?

A. To start preparing for the exam, you need to have the SQL Server 2005 Enterprise Edition. You should have Internet Explorer 6 Service Pack 1 and Internet Information Services.

Q. What are the objectives of the exam?

A. Visit the following link to view the objectives of the 70-441 exam: Objectives
Continue reading

Q: What are the prerequisites for taking the exam 70-300?

A: For taking this exam, candidates should have a minimum of two years of experience in designing and implementing business solutions using Microsoft .NET technology.

Q: What credit does it provide?

A: After passing the exam, you will achieve the Microsoft Certified Professional (MCP) status. You will also be eligible for the Microsoft Certified Solution Developer (MCSD) for Microsoft .NET certification.

Q: Which certification does it cover?

A: The exam 70-300 is a core requirement for the Microsoft Certified Solution Developer (MCSD) for Microsoft .NET certification. The MCSD for Microsoft .NET is the top-level certification for advanced developers who design and develop enterprise solutions by using Microsoft development tools and technologies. The certification uses the Microsoft .NET Framework 1.0 and Microsoft .NET Framework 1.1 version.
Continue reading

The Servlet Technology Model

  • The getWriter() method of the ServletResponse interface returns a PrintWriter object suitable for writing character data in the response.
  • The setValue() method of the Cookie class is used to assign a new value to a cookie after the cookie is created.
  • A cookie is created by the server on request from a client. It is stored on a client computer.
  • The getOutputStream() method returns a ServletOutputStream suitable for writing binary data in the response.
  • Either the Response.setContentType(String name, String value) or the HttpServletResponse.setHeader(String name, String value) is used to set the Content type.
  • The getWriter() method of the ServletResponse interface returns a PrintWriter object suitable for writing character data in the response.
  • The sendError() method of the HttpResponse interface sends an error response to the client using the specified status code and message.
  • The getRequestURL() method of the HttpServletRequest interface returns the URL associated with the request as a String.
  • The getCookies() method of the HttpServletRequest interface returns an array of cookie objects that a client sends with a request. However, if no cookies are sent, this method returns a null value.
  • A servlet has three life cycle methods. They are init(), service(), and destroy().
  • A servlet has no main() method. The container is responsible for managing the life-cycle of a servlet.
  • The servlet init parameters are read only once when the container initializes the servlet.
  • Before calling the init() method, a servlet class must be loaded and instantiated.
  • The element of the deployment descriptor declares the initialization parameters that are applicable for an entire Web application.
  • For each request, the Container creates a separate thread.
  • The init() and the destroy() methods are called only once in the life of a servlet.

The Structure and Deployment of Web Applications

  • Deploying a servlet in the deployment descriptor requires two main elements: and .
  • The WEB-INF directory contains files that should not be publicly available. This includes among others the web.xml file, the servlet class files, and the lib/JAR files.
  • The setContentType() method of the ServletResponse interface sets the content type of the response. The content type is also referred to as the MIME type.
  • The sub-element is present in two elements: and .
  • The element of a deployment descriptor is used to load a servlet file when the server starts instead of waiting for the first request. It is also used to specify the order in which the files are to be loaded.
  • The element of the deployment descriptor is used to configure a mapping between a mime type and an extension. It has two sub-elements, namely and .
  • A welcome file is returned when a user enters a partial link in a URL, i.e., the name of a directory but with no file inside it. If there is more than one welcome file, they are all entered within a single element.
  • The element defines a mapping between an error code/exception type and the location of the resource to display in response to the error.
  • A deployment descriptor is an XML document that defines a component’s deployment settings.
  • A deployment descriptor is an xml file known as web.xml located in the WEB-INF directory. It provides configuration and deployment information for the Web components that comprise a Web application.
  • The element is a sub-element of the element. It defines the user roles that are allowed to access the Web resources specified by the sub-elements.

The Web Container Model

  • To declare a filter in the deployment descriptor, the and the elements are mandatory, while the element is optional.
  • A filter life-cycle consists of three methods, namely init(), doFilter(), and destroy().
  • An object of the FilterChain interface is provided by the container to invoke the next filter in a chain of filters.
  • Every filter must implement the Filter interface.
  • The ServletContextListener interface has the two methods, namely ContextInitialized() and contextDestroyed.
  • The HttpContextAttributeListener interface has the following three methods:
    1. public void attributeAdded(ServletContextAttributeEvent event)
    2. public void attributeRemoved(ServletContextAttributeEvent event)
    3. public void attributeReplaced(ServletContextAttributeEvent event)
  • The requestInitialized() method of the ServletRequestListener interface takes a ServletRequestEvent object and notifies that the request is about to come into scope of the Web application.
  • The requestDestroyed() method of the ServletRequestListener interface takes a ServletRequestEvent object and notifies that the request is about to go out of scope of the Web application.
  • The HttpSessionBindingListener interface causes an object of the implementing class to be notified when it is added to or removed from a session. This interface has the following methods:
    1. public void valueBound(event)
    2. public void valueUnbound(event)

Session Management

  • The HttpSessionActivationListener interface notifies an attribute that the session is about to be activated or passivated.
  • The HttpSessionListener object is used to notify the class when a session is created or destroyed.
  • Invalidating a session unbinds all the attributes from the session. Hence, attributes no longer exist with the session, and trying to get an attribute from the session will result in an IllegalStateException.
  • The session binds the object by a call to the HttpSession.setAttribute() method and unbinds the object by a call to the HttpSession.removeAttribute() method.
  • Except for the HttpSessionActivationListener and the HttpSessionBindingListener, all other listeners must be configured in the deployment descriptor.
  • The getCreationTime() method throws an IllegalStateException if it is called on an invalidated session.
  • The getCookies() method of the HttpServletRequest interface is used to get the cookies from a client. This method returns an array of cookies.
  • URL rewriting can be used even if cookies are not supported by the browser.
  • The element of the deployment descriptor sets the session timeout. If the time specified for timeout is zero or negative, the session will never timeout.
  • The getSession() method of the HttpServletRequest interface returns the current session associated with the request, or creates a new session if no session exists.
  • The getCreationTime() method returns the time when the session was created. The time is measured in milliseconds since midnight January 1, 1970.
  • The getWriter() method of the ServletResponse interface returns a PrintWriter object suitable for writing character data in the response.
  • The setMaxInactiveInterval() method sets the maximum time in seconds before a session becomes invalid.
  • The encodeRedirectURL() method of the HttpServletResponse interface, returns a URL by including a session ID in it for use in the sendRedirect() method. If the encoding is not required, the URL is returned unchanged.

Web Application Security

  • If there is no auth-constraint, or if role-name is specified as * , all users are allowed access to the resource. If auth-constraint is empty, no user is allowed access to the resource.
  • The element specifies the resources that will be constrained.
  • The
    element can have any of three values as follows:
    1. NONE
    2. CONFIDENTIAL
    3. INTEGRAL
  • The element is used to specify the type of authentication and the type of security realm associated with the resource.
  • The element is a sub-element of the element and specifies the resources that will be constrained.

The JavaServer Pages (JSP) Technology Model

  • The import attribute of a page directive allows a user to import a specific package when a JSP is translated to a servlet. This is the only attribute in a page directive that can be used multiple times.
  • JSP directives serve as a message from a JSP page to the JSP container and control the processing of the entire page. They are used to set global values such as a class declaration, method implementation, output content type, etc.
  • A page directive allows a user to set the page-specific properties for a JSP.
  • The include directive inserts code of the included file into a JSP page at translation time, i.e., when the JSP page is compiled.
  • The variable directive is used to declare variables in a tag file.
  • The include directive inserts code of the included file into a JSP page at translation time, i.e., when the JSP page is compiled. This include mechanism is also known as static include.
  • The uri of the taglib directive matches the sub-element of the element in the deployment descriptor.
  • The page directive has an attribute called contentType that is used to set the MIME type, i.e., the content type of the response.
  • A tag directive is similar to a page directive and has all the attributes similar to a page directive plus an extra attribute called body-content. The body-content attribute can be scriptless, tagdependent, or empty.
  • An XML-based JSP document should be enclosed between the and tags.
  • The element is used to disable scripting through the deployment descriptor.
  • When a JSP page is translated to a servlet, the scriptlet code goes into the service() method.
  • A tag file must be placed in either of the following locations: Inside the META-INF/tags directory or its subdirectory within a JAR file installed in the WEB-INF/lib directory of the Web application or inside the WEB-INF/tags directory or its subdirectory.
  • A tag library is a collection of classes and meta information for using custom tags.

Building JSP Pages Using the Expression Language (EL)

  • Expression languages are always within curly braces, and prefixed with a dollar sign that is ${expression}.
  • The standard action enables the current JSP page to include a static or a dynamic resource at runtime. In contrast to the include directive, the include action is used for resources that change frequently. The resource to be included must be in the same context.
  • The param implicit object maps a request parameter name to a single value. If there are multiple values in a parameter, they are printed using the paramValues implicit object.
  • The getInitParameter() method returns the names of the servlet’s initialization parameters as an enumeration of String objects, or an empty enumeration if the servlet has no initialization parameters.
  • The dot operator is used in the expression language to retrieve a named property of either a bean or a Map.
  • When using the dot operator, the variableName can be a Java bean or a Map, and the propertyName can be a key or a bean property.
  • The indexing operator [] is used in the expression language to retrieve properties of a Java bean, a Map, an array, or a List. It can be used in all places where a dot operator is used.
  • A [] operator can accept a Map key, a bean property, a List, or an array index. It can accept an integer or any String that can be converted to an integer.
  • If the dot operator is used to access the bean property but the property does not exist, a runtime exception is thrown.
  • The ge operator checks whether the first operand is greater than or equal to the second operand. The gt operator checks whether the first operand is greater than the second operand. The div operator returns the result of the division of first operand by the second.
  • While performing EL arithmetic operations, the operands are converted to their primitive values.
  • Continue reading

Microsoft test 70-431 focuses on your ability to maintain and implement SQL Server 2005 computers. To successfully pass the test 70-431, you need to practice the following:

  1. Install and uninstall SQL Server 2005.
  2. Upgrade earlier versions of SQL Server.
  3. Configure SQL Server 2005 security.
  4. Create a trigger, identify recursive triggers, nested triggers, and transaction triggers.
  5. Create a function and identify deterministic and nondeterministic functions.
  6. Create and recompile stored procedures, and assign permissions to a role for a stored procedure.
  7. Create indexes.
  8. Configure linked servers by using SQL Server Management Studio.
  9. Implement and configure log shippings.

  10. Implement and prepare databases for database mirroring.
  11. Execute ad hoc queries for retrieving data from a database.
  12. Execute Data Manipulation Language statements such as Insert, Update, and Delete.
  13. Manage and create database snapshots.
  14. Retrieve and modify XML data and create XML indexes.
  15. Implement Service Broker and create message types, queues, contracts, and services.
  16. Monitor and resolve blocks and deadlocks and identify the cause of a block.
  17. Continue reading

This exam is meant for IT professionals who work in an enterprise environment that runs on Windows Vista, and who have worked on previous versions of Windows operating system. A candidate obtains MCITP (Microsoft Certified IT Professional) certification after passing this exam.
To pass this exam, a candidate must practice the following:

  1. Analyze working environment of an organization and choose a deployment method of Vista accordingly.
  2. Prepare a system for either a clean installation or an upgrade.
  3. Install Vista through custom image.
  4. Troubleshoot any post deployment issues.
  5. Configure and troubleshoot security for Windows Internet Explorer 7+.
  6. Troubleshoot Windows firewall and defender issues.
  7. Configure access to resources.
  8. Troubleshoot group policy settings.
  9. Continue reading