Searching for "select"

Q:

Selecting and managing marketing channels :

How are the channel members managed and motivated, once they are selected?

Answer

These days channel members are being accepted by companies as their partners. The intermediaries are even being asked to integrate their business with the companies which results in lesser costs, greater efficiency and improved customer service. Corporates like Airtel are adopting PRM (Partner relationship management) software to give that added advantage to their supply chain. They organise rewards and recognition programs for their channel partners and also organise proper channels though which partners can vent any of their grievances relating to payments, violation of codes etc.

Report Error

View answer Workspace Report Error Discuss

Q:

Selecting and managing marketing channels :

On what criteria can channel members be evaluated for their proper selection?

Answer

The SCPCA method can be used to evaluate channel members.


a) Sales (S): How much sales each channel member can give within a cetain time frame


b) Cost(C): How much cost would be incurred for each channel?


c) Profitability(P): Which channel can give better profitability to the company?


d) Control(C): Whether company can have better control over its channel members or not.


e) Adaptability (A): Whether the channel alternatives are flexible enough to any changes or not. The channel meeting the objectives of the company is selected

Report Error

View answer Workspace Report Error Discuss

Q:

How to declare select-option as a parameter?

Answer


SELECT-OPTIONS: specify or displayed on the selection screen for the user to enter values.




Parameters    : dname like dept-dname.
Select-options: dname for dept-dname.


Report Error

View answer Workspace Report Error Discuss

Subject: ABAP

Q:

Write a c program for selection sort.

Answer

include<stdio.h>
int main(){

  int s,i,j,temp,a[20];

  printf("Enter total elements: ");
  scanf("%d",&s);

  printf("Enter %d elements: ",s);
  for(i=0;i<s;i++)
      scanf("%d",&a[i]);

  for(i=0;i<s;i++){
      for(j=i+1;j<s;j++){
           if(a[i]>a[j]){
               temp=a[i];
              a[i]=a[j];
              a[j]=temp;
           }
      }
  }

  printf("After sorting is: ");
  for(i=0;i<s;i++)
      printf(" %d",a[i]);

  return 0;
}

Output:
Enter total elements: 5
Enter 5 elements: 4 5 0 21 7
The array after sorting is:  0 4 5 7 21

Report Error

View answer Workspace Report Error Discuss

Subject: Programming

Q:

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

A) Equi-join B) Natural join
C) Outer join D) Cartesian join
 
Answer & Explanation Answer: D) Cartesian join

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

A) ONLY B) DISTINCT
C) UNIQUE D) SINGLE
 
Answer & Explanation Answer: B) DISTINCT

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. You use the ADO.NET Entity Framework to model entities. You write the following code segment. (Line numbers are included for reference only.)


01AdventureWorksEntities context = New AdventureWorksEntities
02
03var q = from c in context.Customers
04where c.City == "London"
05orderby c.CompanyName
06select c;


You need to ensure that the application meets the following requirements: "Compares the current values of unmodified properties with values returned from the data source". Marks the property as modified when the properties are not the same. Which code segment should you insert at line 02?

A) context.MergeOption = MergeOption.AppendOnly; B) context.MergeOption = MergeOption.PreserveChanges;
C) context.MergeOption = MergeOption.OverwriteChanges; D) context.MergeOption = MergeOption.NoTracking;
 
Answer & Explanation Answer: B) context.MergeOption = MergeOption.PreserveChanges;

Explanation:
Report Error

View Answer Report Error Discuss

Q:

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. The application connects to a Microsoft SQL Server 2008 database. The database includes a table named dbo.


Documents that contains a column with large binary dat a. You are creating the Data Access Layer (DAL). You add the following code segment to query the dbo.Documents table. (Line numbers are included for reference only.)


01public void LoadDocuments(DbConnection cnx)
02{
03var cmd = cnx.CreateCommand();
04cmd.CommandText = "SELECT * FROM dbo.Documents";
05...
06cnx.Open();
07
08ReadDocument(reader); }


You need to ensure that data can be read as a stream. Which code segment should you insert at line 07?

A) var reader = cmd.ExecuteReader(CommandBehavior.Default); B) var reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly);
C) var reader = cmd.ExecuteReader(CommandBehavior.KeyInfo); D) var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
 
Answer & Explanation Answer: D) var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);

Explanation:
Report Error

View Answer Report Error Discuss