Sawaal
  • Home/
  • Certification Questions

Certification Questions

What are certifications?

Certification is the recognition of an individual to be qualified for a job or task. These Certification programs setup IT standards and play major role in developing a qualified workforce. Certifications can raise the technical standards.

Why certifications?

One can measure his/her abilities in their respective professional knowledge and present themselves through certificates. The certification programs assure technical proficiency of IT professionals by measuring their technical skills and knowledge in a specific IT support function or technology.

Who can do certifications?

Definitely who aim for professional growth in their respective functionality or technology can plan for Certifications. This can also tell how valuable certifications are to be potential employers. Any qualified and well experienced IT professional can step-up to take the certification.

How to do certifications?

When you decided to take the certification, well done! You have stepped up the professional ladder to upgrade your skills and knowledge. You can easily plan, work hard and grab a certification. Find some help from following steps.

  • Decide your certification – explore your skills and find a certification that matches your skill set.
  • Research the certification-evaluate the process of certification. Find details of validity, qualification for certification.
  • Evaluate your experience - asses your real experience with the material you gathered for certification and come up with a plan which areas to concentrate more.
  • Apply for certification – Get registered for your Exam.
  • Plan of study – you can study your well experienced areas yourself and can take trainings if required to boost your preparation. You can practice more through mock tests you find online, can keep discussing in forums and blogs.
  • Grab Certificate – finally, you can grab a certification with your positive attitude, hard work.
Popular Latest Rated
Q:

Data integrity constraints are used to

A) Ensure that duplicate records are not entered into the table B) Prevent users from changing the values stored in the table
C) Control who is allowed access to the data D) Improve the quality of data entered for a specific property like table column
 
Answer & Explanation Answer: D) Improve the quality of data entered for a specific property like table column

Explanation:

Integrity constraints are used to ensure accuracy and consistency of data in a relational database. Data integrity is handled in a relational database through the concept of referential integrity. Many types of integrity constraints play a role in referential integrity (RI).

 

Hence, Data integrity constraints are used to Improve the quality of data entered for a specific property i.e, table column.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer

0 3263
Q:

Who Creates The Project Charter?

A) Sponser B) Stake holder
C) Customer D) None
 
Answer & Explanation Answer: D) None

Explanation:

The project initiator or sponsor should be at a level that is appropriate to funding the project. They will either create the project charter or delegate that duty to the project manager.

Projects are authorized by someone external to the project such as a sponsor, PMO or portfolio steering committee.

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification
Job Role: Analyst , Project Manager

10 3259
Q:

You are installing Windows 2000 on a computer that already has another operating system installed on it. You choose to install Windows 2000 in a different folder than the previously installed operating system. What will Windows 2000 do?

A) Abort the installation process B) Delete the previously installed operating system
C) Display an error message indicating that windows 2000 cannot be installed in a different folder D) Cause the computer to dual boot between Windows 2000 and the previously installed operating system
 
Answer & Explanation Answer: D) Cause the computer to dual boot between Windows 2000 and the previously installed operating system

Explanation:

When windows 2000 is installed in the same folder as the other operating system, Windows 2000 will delete the previously installed operating system. When Windows 2000 is installed in a different folder than the other operating system, it will automatically configure the computer to dual boot between Windows 2000 and the previously installed operating system.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

1 3229
Q:

Multiple users can share a local temporary table

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

Multiple users can't share a local temporary table

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

0 3229
Q:

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?

A) Set up SQL Server replication to replicate the data from the Oracle server to the SQL Server computer. B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.
C) Set up a Microsoft ActiveX script that connects to the Oracle server and imports the financial information into a SQL Server temporary table. Create a view that joins the service contract information and the temporary table. D) Set up a Data Transformation Services (DTS) package that imports and transforms the data from the Oracle server to the SQL Server computer. Use SQL Server Agent to execute the DTS package throughout the day as needed.
 
Answer & Explanation Answer: B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.

Explanation:

SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements. Each distributed query can reference multiple linked servers and can perform either update or read operations against each individual linked server. A single distributed query can perform read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to query data in Oracle databases.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 3218
Q:

Which method should you use to group query filters together to form one AND statement?

A. Select the filters, then click the Group Filters button on the toolbar

B. Select the filters, right-click and select Group

C. Drag the queries together

D. Drag the query filters to the Group panel

Answer

Answer : C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

2 3218
Q:

Can’t update primary table’s primary key if row being modified has related rows in secondary table once referential integrity is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

0 3213
Q:

Count function in SQL returns the number of

A) groups B) values or rows
C) columns D) distinct values
 
Answer & Explanation Answer: B) values or rows

Explanation:

Count function in SQL returns the number of values or rows.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Database Administration , IT Trainer

3 3211