Certification Questions

Q:

What are the different types of SQL statements ?

Answer

SQL statements are broadly classified into three. They are


1. DDL – Data Definition Language


DDL is used to define the structure that holds the data. For example, Create, Alter, Drop and Truncate table.


2. DML – Data Manipulation Language


DML is used for manipulation of the data itself. Typical operations are Insert, Delete, Update and retrieving the data from the table. The Select statement is considered as a limited version of the DML, since it can't change the data in the database. But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function.


3. DCL – Data Control Language


DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc. Example - Grant, Revoke access permission to the user to access data in the database.

Report Error

View answer Workspace Report Error Discuss

4 2659
Q:

Payroll schema consists of a sequence of functions. Which of these functions is used to import Absence infotype data?

A. PAB.

B. PIT.

C. P0015.

D. RAB.

Answer

Answer : D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP HR

0 2648
Q:

 when you create asset master records this data is automatically adopted from the asset class you specify

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

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Subject: SAP FI

1 2648
Q:

If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what?

A) committed read B) repeatable read
C) share read D) indexed read
 
Answer & Explanation Answer: B) repeatable read

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

1 2641
Q:

Project Procurement Management - Processes

Describe the Inputs, Tools and Techniques , Outputs included in the Plan Contracting?

Answer

I. Inputs



  • Procurement management plan

  • Contract statement of work

  • Make-or-buy decisions

  • Project management plan


                 - Risk register


                 - Risk related contractual agreements


                 - Resource requirements


                 - Project schedule


                 - Activity cost estimate


                 - Cost baseline


II. Tools and Techniques



  • Standard forms

  • Expert judgment


III. Outputs



  • Procurement documents

  • Evaluation criteria

  • Contract statement of work (updates)

Report Error

View answer Workspace Report Error Discuss

0 2638
Q:

Which of the following is part of the IEEE 802.3u standard?

A) 100Base2 B) 10Base5
C) 100Base-TX D) 1000Base-T
 
Answer & Explanation Answer: C) 100Base-TX

Explanation:

IEEE 802.3u is Fast Ethernet at 100Mbps and covers 100Base-TX, 100BaseT4, and 100Base-FX.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 2632
Q:

Identify the four main types of roadmaps reviewed.

A. Download roadmap
B. Global template roadmap
C. Upgrade roadmap
D. Solution management roadmap
E. Implementation roadmap
F. Solution roadmap

Answer

Answer : B , C , D , E

Report Error

View answer Workspace Report Error Discuss

0 2626
Q:

What does CSMA/CD stand for?

A) Carrier Sense Multiple Action with Collision Detection. B) Carrier Sense Multiple Access with Collisionless Delivery
C) Carrier Sense Multiple Action with Collision Detonation D) Carrier Sense Multiple Access with Collision Detection
 
Answer & Explanation Answer: D) Carrier Sense Multiple Access with Collision Detection

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: CCENT

1 2620