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 2782
Q:

Project Management - Introduction

What is program Management?

Answer

A program is a group of related projects managed in a coordinated way to obtain benefits and  control  not available from managing them individually. Programs may include elements of related work outside of the scope of the discrete projects in the program.


For example:


A New car model program can be broken up into projects  for the design and upgrades of each major component (transmission, engine, interior, exterior) while the ongoing manufacturing occurs on the assembly line

Report Error

View answer Workspace Report Error Discuss

0 2772
Q:

Which of the following is a result of route aggregation?

A) Smaller routing tables B) More complete routing tables
C) Increased memory usage D) Increased CPU usage
 
Answer & Explanation Answer: A) Smaller routing tables

Explanation:

Route aggregation results in smaller routing tables.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 2771
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 2757
Q:

What is the difference between a Local and a Global temporary table?

Answer

Local :


Only available to the current Db connection for current user and are cleared when connection is closed.


Multiple users can’t share a local temporary table.


 


Global:


Available to any connection once created. They are cleared when the last connection is closed.


Can be shared by multiple user sessions

Report Error

View answer Workspace Report Error Discuss

1 2755
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 2754
Q:

If you have a keyword with a low CTR, what can you expect?

Answer

A lower Quality Score on the Search Network.

Report Error

View answer Workspace Report Error Discuss

0 2753
Q:

Project Life Cycle - Characteristic of Project Phases

What is a deliverable?

Answer

A deliverable is a measurable, verifiable work product such as a specification, feasibility study report, detailed design document, or working prototype.

Report Error

View answer Workspace Report Error Discuss

0 2747