This test requires a thorough knowledge of administrative tasks for managing the database for optimal performance. The candidate appearing in this test should have a sound knowledge of various tools available in Oracle9i for managing different issues in the database. This includes identifying contentions and resolving them through the tools. For this purpose, one should practice the following to a good extent:

  1. Identifying tuning areas through querying the available views.
  2. Gathering statistics through available tools, such as STATSPACK.
  3. Using the available GUI tools, such as Instance Manager to resolve contentions.
  4. Continue reading

One should have a good knowledge about RDBMS concepts, SQL, and PL/SQL before taking the 1Z0-001 (Introduction to Oracle: SQL and PL/SQL) test, as this test focuses on one’s capability to design relational databases and write various types of SQL and PL/SQL statements to interact with databases. Practicing the following things will help a candidate to perform well in the test:

  1. Create tables and link them using different types of constraints.
  2. Create views, synonyms, and indexes.
  3. Use the SELECT statement to retrieve rows from tables and views.
  4. Insert, update, and delete rows from tables.
  5. Use the WHERE and ORDER BY clauses to restrict and sort rows retrieved by SELECT statements.
  6. Continue reading

The CompTIA test 220-604 (A+ Depot Technician) is meant for individuals who work or intend to work in an environment with limited customer interaction where hardware related activities are emphasized. This test measures an individual’s ability to install, configure, and troubleshoot hardware on a computer. Before taking the 220-604 test, you should practice the following:

  1. Identify the name of different parts in a computer and their functions and characteristics.
  2. Install the motherboard in the computer case.
  3. Identify the components on the motherboard, such as hard disk controller, floppy disk controller, CMOS chip, expansion slots, etc.
  4. Install and remove memory modules on the motherboard.
  5. Install add-on cards, such as display card, sound card, internal modem, etc., on the motherboard.
  6. Install device drivers for add-on cards installed on the motherboard.
  7. Continue reading

The CX310-035 (Sun Certified Programmer for Java 2 Platform 1.4) test checks your ability to use the basic syntax and structure of the Java programming language. This test requires you to have a good understanding of the Java language and the capability to write code for well-defined design applications. For this purpose, along with studying books and taking various practice tests, you should also practice with Java. While practicing with Java, you can learn a lot of things that are of great importance from the test point of view. The test asks all sorts of tricky questions that you might not consider in the real world. Practicing the following things with Java will make you confident enough of scoring well in the test:

  1. Write code that declares, constructs, and initializes arrays of any base type using any of the permitted forms both for declaration and for initialization.
  2. Write code using if and switch statements.
  3. Write code using all forms of loops including labeled and unlabeled, using break and continue statements.
  4. Write code that makes proper use of exceptions and exception handling clauses (try, catch, finally).
  5. Write code that makes proper use of assertions.
  6. Write code that explicitly makes objects eligible for garbage collection.
  7. Write code to invoke overridden or overloaded methods and parental or overloaded constructors.
  8. Continue reading

The CX310-066 (Sun Certified Programmer for the Java Platform, Standard Edition 6 Upgrade Exam) checks your real ability as a programmer. In fact, it is totally scenario based rather than knowledge based. The prerequisite for the test is that you must have successfully completed the previous version of the Sun Certified Programmer for the Java 2 Platform exam. This test requires you to have a good understanding of the Java language and the capability to write code for well-defined design applications. For this purpose, along with studying books and taking various practice tests, you should also practice with Java. There will be less number of direct questions, and more questions of ‘find the output’ type. Drag-n-Drop questions will test your hold on your knowledge in writing code. A good number of questions will be based on new topics added to the language in J2SE 5 and J2SE 6 versions. These topics are as follows: generics, autoboxing/unboxing, covariant return, variable length arguments, static import, enums, Console class, NavigableSet, NavigableMap, and for-each loop. Although not many direct questions will be there in the test, practicing them will help clear your fundamentals. You should practice the following things with Java to be confident enough to score well in the test:

  1. Write code that declares, constructs, and initializes arrays of any base type using any of the permitted forms, both for declaration and for initialization.
  2. Write code using the if and switch statements.
  3. Continue reading

The Microsoft test 70-444 measures your ability to optimize, manage, and administer SQL Server databases. The test is designed to check your ability to use the SQL Server services and objects. It requires you to have a good knowledge of the SQL Server objects and troubleshooting issues related to SQL Server. Before taking the 70-444 test, you should practice the following:

  1. Use System Monitor.
  2. Manage counters and performance logs.
  3. Use SQL Server Profiler.
  4. Use Dynamic Management Views.
  5. Create and maintain statistics.
  6. Maintain transaction logs.
  7. Use Query Editor.
  8. Analyze queries using Graphical Execution Plan.
  9. Create and manage a trace.
  10. Trigger events and notification processes.
  11. Use different tools and services of SQL Server to diagnose database problems.
  12. Understand Failover Clustering.
  13. Understand Database Mirroring.
  14. Restore system databases.
  15. Continue reading

A+ 220-603 tests the candidate’s ability in troubleshooting and interacting with customers remotely via the telephone or e-mail. The updated CompTIA A+ credential requires two tests. CompTIA A+ Essentials plus CompTIA A+ 220-603 Exam credential validates hardware and software, with added elements of security and soft skills, as well as safety and environmental issues. Before taking the 220-603 test, a candidate should practice the following:

  1. Install add-on cards such as display card, sound card, internal modem, etc., on the motherboard.
  2. Install device drivers for add-on cards installed on the motherboard.
  3. Connect power supply connectors to motherboard, hard disk drive, floppy drive, etc.
  4. Create partitions on the hard disk drive and format partitions.
  5. Install operating systems.
  6. Identify system resource conflicts such as IRQ conflict and I/O address conflict between devices.
  7. Configure important settings such as boot sequence, date and time, floppy disk drive parameters, hard disk drive parameters, etc., in BIOS.
  8. Identify various types of communication ports such as serial port, parallel port, USB port, IEEE 1394 port, etc.
  9. Continue reading

The 1Z0-147 (Oracle9i: Program with PL/SQL) test focuses on a candidate’s ability to develop applications by using the PL/SQL. It requires the candidate to have a good command over PL/SQL. One should be capable of understanding the requirements of an application and program accordingly. Before appearing for the test, one must be well familiar with the objectives declared for the test. Along with going through books and taking practice tests, a candidate should also do a lot of hands-on work on programming. Practicing the following things can help a candidate clearly understand the concepts of PL/SQL programming and pass the test confidently:

  1. Define and execute PL/SQL blocks.
  2. Use %TYPE attribute to define the datatypes of variables.
  3. Insert, update, delete, and query data from tables with the help of PL/SQL programs.
  4. Practice defining and raising exceptions in PL/SQL programs.
  5. Create and execute procedures.
  6. Create and execute functions.
  7. Invoke functions in SQL expressions.
  8. Create packages.
  9. Continue reading

The CompTIA test SK0-002 is intended to certify users who should have at least 18 to 24 months hands-on experience of installing, configuring, diagnosing, and troubleshooting computers. Server+ certifies technical knowledge in areas such as RAID, SCSI, and multiple CPUs, as well as capabilities with server issues, including disaster recovery. Before taking the SK0-002 test, you should practice the following:

  1. Identify the name of several parts in a computer and their purposes and characteristics.
  2. Install the motherboard in the computer case.
  3. Identify several components on the motherboard such as hard disk controller, floppy disk controller, CMOS chip, expansion slots, etc.
  4. Install and remove memory modules on the motherboard.
  5. Install add-on cards such as display card, sound card, internal modem, etc., on the motherboard.
  6. Install external devices such as keyboards, monitors, subsystems, and modem racks.
  7. Install UPSs according to requirements.
  8. Continue reading

The CompTIA test SK0-002 is intended to certify users who should have at least 18 to 24 months hands-on experience of installing, configuring, diagnosing, and troubleshooting computers. Server+ certifies technical knowledge in areas such as RAID, SCSI, and multiple CPUs, as well as capabilities with server issues, including disaster recovery. Before taking the SK0-002 test, you should practice the following:

  1. Identify the name of several parts in a computer and their purposes and characteristics.
  2. Install the motherboard in the computer case.
  3. Identify several components on the motherboard such as hard disk controller, floppy disk controller, CMOS chip, expansion slots, etc.
  4. Install and remove memory modules on the motherboard.
  5. Install add-on cards such as display card, sound card, internal modem, etc., on the motherboard.
  6. Install external devices such as keyboards, monitors, subsystems, and modem racks.
  7. Install UPSs according to requirements.
  8. Continue reading