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

Q. What are the prerequisites for the 70-444 test?

A. There are no prerequisites for the 70-444 test. However a candidate must be familiar with the creation and usage of SQL Server databases and database objects.

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

A. To start preparing for the test, 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 test?

A. Visit the following link to view the objectives of the 70-444 test:
Objectives
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

Q. What is the pre-requisite for taking the CompTIA Server+ (SK0-002) test?

A. There is no prerequisite for taking the SK0-002 test. Passing the SK0-002 test is required to achieve the Server+ certification as a Certified IT Technician.

Q. What certificate does it provide?

A. The SK0-002 test is a test required to achieve the Server+ certification.
Continue reading

The Microsoft test 70-621 is intended for candidates who have at least one year experience in the IT field. The candidates typically provide phone support at various levels in a wide range of environments. The test 70-621 measures a candidate’s ability to resolve issues concerning network connectivity, desktop operating systems, security, and applications. Their experience should also include addressing logon problems, performing password resets, and resolving most issues with desktop applications. Before taking the 70-621 test, you should practice the following:

  1. Create partitions in a hard disk and format partitions as FAT and NTFS file systems.
  2. Install Windows Vista on a computer. Installation includes:
    • Clean installation
    • Upgrade from previous versions of Windows.
    • Upgrade from one edition of Windows Vista to another edition.
    • Deploy from a custom image.
  3. Install and configure Windows Vista drivers.
  4. Configure Windows Aero.
  5. Configure Parental Controls.
  6. Continue reading

The EC-Council E-Commerce Architect exam (212-32) focuses on the standards, technologies, and practices for different models of e-business. The test covers the fundamental business concepts as they relate to E-Commerce, such as customer relationship management, e-procurement, security and staffing issues, planning, metric identification techniques for measuring the success of E-Commerce initiatives, marketing strategies on the World Wide Web, and information on E-Commerce software, hardware, and service providers. Before taking the 212-32 test, you should practice the following:

  • Use client/server technology to connect computers to one another.
  • Use different types of protocols for performing various activities on the Internet.
  • Read and know about the security issues and legal aspects of e-commerce.
  • Know about e-mail marketing of products.
  • Transfer text and binary files using popular Internet services.
  • Identify steps in the Web site planning and development process.
  • Create a Web page and add images to the Web page.
  • Continue reading

Q. What are the prerequisites for EC-Council E-Commerce Architect exam 212-32?

A. A candidate has to pass Certified e-Business Associate certification before appearing for E-Commerce Architect 212-32 exam.
Q. What are the objectives of the exam?

A. Visit the following link to view the objectives of 212-32 exam:
Objectives. You will have to fill up a form and select the exam, and then click the Get Exam Objective button.

Q. What is the exam fee?

A. The exam fee for 212-32 is approximately USD 125. The fee is to be paid at the time of registration through credit card, check, or voucher. After the payment has been made, a candidate can schedule his exam date and time.
Continue reading