Saturday, 25 January 2020

100 Top C Programming Multiple Choice Questions and Answers

C Programming Multiple Choice Questions and Answers

1.  Who is father of C Language?
A.  Bjarne Stroustrup
B.  Dennis Ritchie
C.  James A. Gosling
D.  Dr. E.F. Codd
Answer : B

2.  C Language developed at _____?
A.  AT & T's Bell Laboratories of USA in 1972
B.  AT & T's Bell Laboratories of USA in 1970
C.  Sun Microsystems in 1973
D.  Cambridge University in 1972
Answer : A

3.  For 16-bit compiler allowable range for integer constants is ______ ?
A.  -3.4e38 to 3.4e38
B.  -32767 to 32768
C.  -32768 to 32767
D.  -32668 to 32667
Answer : C

4.  C programs are converted into machine language with the help of
A.  An Editor
B.  A compiler
C.  An operating system
D.  None of the above
Answer : B

5.  A C variable cannot start with
A.  An alphabet
B.  A number
C.  A special symbol other than underscore
D.  both (b) and (c)
Answer : D

6.  Which of the following is allowed in a C Arithmetic instruction
A.  []
B.  {}
C.  ()
D.  None of the above
Answer : C

7.  Which of the following shows the correct hierarchy of arithmetic operations in C
A.  / + * -
B.  * - / +
C.  + - / *
D.  * / + -
Answer : D

8.  What is an array?
A.  An array is a collection of variables that are of the dissimilar data type.
B.  An array is a collection of variables that are of the same data type.
C.  An array is not a collection of variables that are of the same data type.
D.  None of the above.
Answer : B

9.  What is right way to Initialization array?
A.  int num[6] = { 2, 4, 12, 5, 45, 5 } ;
B.  int n{} = { 2, 4, 12, 5, 45, 5 } ;
C.  int n{6} = { 2, 4, 12 } ;
D.  int n(6) = { 2, 4, 12, 5, 45, 5 } ;
Answer : A

10.  An array elements are always stored in _________ memory locations.
A.  Sequential
B.  Random
C.  Sequential and Random
D.  None of the above
Answer : A

11.  What is the right way to access value of structure variable book{ price, page }?
A.  printf("%d%d", book.price, book.page);
B.  printf("%d%d", price.book, page.book);
C.  printf("%d%d", price::book, page::book);
D.  printf("%d%d", price->book, page->book);
Answer : A

12.  perror( ) function used to ?
A.  Work same as printf()
B.  prints the error message specified by the compiler
C.  prints the garbage value assigned by the compiler
D.  None of the above
Answer : B

13.  Bitwise operators can operate upon?
A.  double and chars
B.  floats and doubles
C.  ints and floats
D.  ints and chars
Answer : D

14.  What is C Tokens?
A.  The smallest individual units of c program
B.  The basic element recognized by the compiler
C.  The largest individual units of program
D.  A & B Both
Answer : D

15.  What is Keywords?
A.  Keywords have some predefine meanings and these meanings can be changed.
B.  Keywords have some unknown meanings and these meanings cannot be changed.
C.  Keywords have some predefine meanings and these meanings cannot be changed.
D.  None of the above
Answer : C

16.  What is constant?
A.  Constants have fixed values that do not change during the execution of a program
B.  Constants have fixed values that change during the execution of a program
C.  Constants have unknown values that may be change during the execution of a program
D.  None of the above
Answer : A

17.  Which is the right way to declare constant in C?
A.  int constant var =10;
B.  int const var = 10;
C.  const int var = 10;
D.  B & C Both
Answer : D

18.  Which operators are known as Ternary Operator?
A.  ::, ?
B.  ?, :
C.  ?, ;;
D.  None of the above
Answer : B

19.  In switch statement, each case instance value must be _______?
A.  Constant
B.  Variable
C.  Special Symbol
D.  None of the above
Answer : A

20.  What is the work of break keyword?
A.  Halt execution of program
B.  Restart execution of program
C.  Exit from loop or switch statement
D.  None of the above
Answer : C

21.  What is function?
A.  Function is a block of statements that perform some specific task.
B.  Function is the fundamental modular unit. A function is usually designed to perform a specific task.
C.  Function is a block of code that performs a specific task. It has a name and it is reusable
D.  All the above
Answer : D

22.  Which one of the following sentences is true ?
A.  The body of a while loop is executed at least once.
B.  The body of a do ... while loop is executed at least once.
C.  The body of a do ... while loop is executed zero or more times.
D.  A for loop can never be used in place of a while loop.
Answer : B

23.  A binary tree with 27 nodes has _______ null branches.
A.  54
B.  27
C.  26
D.  None of the above
Answer : D

24.  Which one of the following is not a linear data structure?
A.  Array
B.  Binary Tree
C.  Queue
D.  Stack
Answer : B

25.  Recursive functions are executed in a?
A.  First In First Out Order
B.  Load Balancing
C.  Parallel Fashion
D.  Last In First Out Order
Answer : D

26.  Queue is a _____________ list.
A.  LIFO
B.  LILO
C.  FILO
D.  FIFO
Answer : D

27.  The statement print f ("%d", 10 ? 0 ? 5 : 1 : 12); will print?
A.  10
B.  0
C.  12
D.  1
Answer : D

28.  To represent hierarchical relationship between elements, which data structure is suitable?
A.  Priority
B.  Tree
C.  Dqueue
D.  All of the above
Answer : B

29.  Which of the following data structure is linear type?
A.  Strings
B.  Queue
C.  Lists
D.  All of the above
Answer : D

30.  The statement printf("%c", 100); will print?
A.  prints 100
B.  print garbage
C.  prints ASCII equivalent of 100
D.  None of the above
Answer : C

31.  The _______ memory allocation function modifies the previous allocated space.
A.  calloc
B.  free
C.  malloc
D.  realloc
Answer : D

32.  Number of binary trees formed with 5 nodes are
A.  30
B.  36
C.  108
D.  42
Answer : D

33.  The "C" language is
A.  Context free language
B.  Context sensitive language
C.  Regular language
D.  None of the above
Answer : A

34.  The worst case time complexity of AVL tree is better in comparison to binary search tree for
A.  Search and Insert Operations
B.  Search and Delete Operations
C.  Insert and Delete Operations
D.  Search, Insert and Delete Operations
Answer : D

35.  In which tree, for every node the height of its left subtree and right subtree differ almost by one?
A.  Binary search tree
B.  AVL tree
C.  Threaded Binary Tree
D.  Complete Binary Tree
Answer : B

36.  C is ______ Language?
A.  Low Level
B.  High Level
C.  Assembly Level
D.  Machine Level

37.  The Default Parameter Passing Mechanism is called as
A.  Call by Value
B.  Call by Reference
C.  Call by Address
D.  Call by Name
Answer : A

38.  What is Dequeue?
A.  Elements can be added from front
B.  Elements can be added to or removed from either the front or rear
C.  Elements can be added from rear
D.  None of the above
Answer : B

39.  In which linked list last node address is null?
A.  Doubly linked list
B.  Circular list
C.  Singly linked list
D.  None of the above
Answer : C

40.  Which is the correct syntax to declare constant pointer?
A.  int *const constPtr;
B.  *int constant constPtr;
C.  const int *constPtr;
D.  A and C both
Answer : D

1. What will be the output of the following arithmetic expression ?
5+3*2%10-8*6
a) -37
b) -42
c) -32
d) -28
Ans: a

2. What will be the output of the following statement ?
int a=10; printf("%d &i",a,10);
a) error
b) 10
c) 10 10
d) none of these
Ans: d

3. What will be the output of the following statement ?
printf("%X%x%ci%x",11,10,'s',12);
a) error
b) basc
c) Bas94c
d) none of these
Ans: b

4. What will be the output of the following statements ?
int a = 4, b = 7,c; c = a = = b; printf("%i",c);
a) 0
b) error
c) 1
d) garbage value
Ans: a

5. What will be the output of the following statements ?
int a = 5, b = 2, c = 10, i = a>b
void main()
{ printf("hello"); main(); }
a) 1
b) 2
c) infinite number of times
d) none of these
Ans: c

6. What will be output if you will compile and execute the following c code?
struct marks{
int p:3;
int c:3;
int m:2;
};
void main(){
struct marks s={2,-6,5};
printf("%d %d %d",s.p,s.c,s.m);
}
(a) 2 -6 5
(b) 2 -6 1
(c) 2 2 1
(d) Compiler error
(e) None of these
Ans: c

7. What will be the output of the following statements ?
int x[4] = {1,2,3}; printf("%d %d %D",x[3],x[2],x[1]);
a) 03%D
b) 000
c) 032
d) 321
Ans: c

8. What will be the output of the following statement ?
printf( 3 + "goodbye");
a) goodbye
b) odbye
c) bye
d) dbye
Ans: d

9. What will be the output of the following statements ?
long int a = scanf("%ld%ld",&a,&a); printf("%ld",a);
a) error
b) garbage value
c) 0
d) 2
Ans: b

10. What will be the output of the following program ?
#include
void main()
{ int a = 2;
switch(a)
{ case 1:
printf("goodbye"); break;
case 2:
continue;
case 3:
printf("bye");
}
}
a) error
b) goodbye
c) bye
d) byegoodbye
Ans: a

11. What will be the output of the following statements ?
int i = 1,j; j=i--- -2; printf("%d",j);
a) error
b) 2
c) 3
d) -3
Ans: c

12. What will be the output of following program ?
#include
main()
{
int x,y = 10;
x = y * NULL;
printf("%d",x);
}
a) error
b) 0
c) 10
d) garbage value
Ans: b

13. What will be the output of following statements ?
char x[ ] = "hello hi"; printf("%d%d",sizeof(*x),sizeof(x));
a) 88
b) 18
c) 29
d) 19
Ans: d

14. What will be the output of the following statements ?
int a=5,b=6,c=9,d; d=(ac?1:2):(c>b?6:8)); printf("%d",d);
a) 1
b) 2
c) 6
d) Error
Ans: d

15. What will be the output of the following statements ?
int i = 3;
printf("%d%d",i,i++);
a) 34
b) 43
c) 44
d) 33
Ans: b

16. What will be the output of the following program ?
#include
void main()
{
int a = 36, b = 9;
printf("%d",a>>a/b-2);
}
a) 9
b) 7
c) 5
d) none of these
Ans: a

17. int testarray[3][2][2] = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12};
What value does testarray[2][1][0] in the sample code above contain?
a) 11
b) 7
c) 5
d) 9
Ans: a

18. void main()
{
int a=10,b=20;
char x=1,y=0;
if(a,b,x,y)
{
printf("EXAM");
}
}
What is the output?
a) XAM is printed
b) exam is printed
c) Compiler Error
d) Nothing is printed
Ans: d

19. What is the output of the following code?
#include
void main()
{
int s=0;
while(s++
# define a 10
main()
{
printf("%d..",a);
foo();
printf("%d",a);
}
void foo()
{
#undef a
#define a 50
}
a) 10..10
b) 10..50
c) Error
d) 0
Ans: c

20. main()
{
struct
{
int i;
}xyz;
(*xyz)->i=10;
printf("%d",xyz.i);
}
What is the output of this program?
a) program will not compile
b) 10
c) god only knows
d) address of I
Ans: b

21.What will happen if in a C program you assign a value to an array element whose subscript exceeds the size of array?
A. The element will be set to 0.
B. The compiler would report an error.
C. The program may crash if some important data gets overwritten.
D. The array size would appropriately grow.
Ans:  C

22. What would be the output of the following program?
#include
main()
{
char str[]="S\065AB";
printf("\n%d", sizeof(str));
}
a) 7
b) 6
c) 5
d) error
Ans: b

23. What will be the value of `a` after the following code is executed
#define square(x) x*x
a = square(2+3)
a) 25
b) 13
c) 11
d) 10
Ans: c

24. #include
void func()
{
int x = 0;
static int y = 0;
x++; y++;
printf( "%d -- %d\n", x, y );
}
int main()
{
func();
func();
return 0;
}
What will the code above print when it is executed?
a)
1 -- 1
1 -- 1
b)
1 -- 1
2 -- 1
c)
1 -- 1
2 -- 2
d)
1 -- 1
1 -- 2
Ans: d

25. long factorial (long x)
{
????
return x * factorial(x - 1);
}
With what do you replace the ???? to make the function shown above return the correct answer?
a)
if (x == 0) return 0;
b)
return 1;
c)
if (x >= 2) return 2;
d)
if (x <= 1) return 1;
Ans: d

26. int y[4] = {6, 7, 8, 9};
int *ptr = y + 2; printf("%d\n", ptr[ 1 ] );
What is printed when the sample code above is executed?
a) 6
b) 7
c) 8
d) 9
Ans: d

27. int i = 4;
switch (i)
{
default: ;
case 3:
i += 5;
if ( i == 8)
{
i++;
if (i == 9) break;
i *= 2;
}
i -= 4;
break;

case 8:
i += 5;
break;
}
printf("i = %d\n", i);
What will the output of the sample code above be?
a) i = 5
b) i = 8
c) i = 9
d) i = 10
Ans: a


28. What will be output if you will compile and execute the following c code?
void main()
{
if(printf("cquestionbank"))
printf("I know c");
else
printf("I know c++");
}
(a) I know c
(b) I know c++
(c) cquestionbankI know c
(d) cquestionbankI know c++
(e) Compiler error
Answer: (c)

29.What will be output if you will compile and execute the following c code?
#define call(x) #x
void main(){
printf("%s",call(c/c++));
}
(a)c
(b)c++
(c)#c/c++
(d)c/c++
(e)Compiler error
Answer: (d)

30. What will be output if you will compile and execute the following c code?
#define message "union is\
power of c"
void main()
{
clrscr();
printf("%s",message);
getch();
}
(a) union is power of c
(b) union is power of c
(c) union is Power of c
(d) Compiler error
(e) None of these
Answer: (b)

31. What will be output if you will compile and execute the following c code?
void main(){
int a=25;
clrscr();
printf("%o %x",a,a);
getch();
}
(a) 25 25
(b) 025 0x25
(c) 12 42
(d) 31 19
(e) None of these
Answer: (d)

32. What will be output if you will compile and execute the following c code?
void main()
{
int i=0;
if(i==0){
i=((5,(i=3)),i=1);
printf("%d",i);
}
else
printf("equal");
}
(a) 5
(b) 3
(c) 1
(d) equal
(e) None of above
Answer: (c)

33.What will be output if you will compile and execute the following c code?
int extern x;
void main()
printf("%d",x);
x=2;
getch();
}
int x=23;
(a) 0
(b) 2
(c) 23
(d) Compiler error
(e) None of these
Answer: (c)

34.What will be output if you will compile and execute the following c code?
void main(){
int a,b;
a=1,3,15;
b=(2,4,6);
clrscr();
printf("%d ",a+b);
getch();
}
(a) 3
(b) 21
(c) 17
(d) 7
(e) Compiler error
Answer: (d)

35.What will be output if you will compile and execute the following c code?
void main(){
static main;
int x;
x=call(main);
clrscr();
printf("%d ",x);
getch();
}
int call(int address){
address++;
return address;
}
(a) 0
(b) 1
(c) Garbage value
(d) Compiler error
(e) None of these
Answer: (b)

36. What will be output if you will compile and execute the following c code?
#include "string.h"
void main(){
clrscr();
printf("%d %d",sizeof("string"),strlen("string"));
getch();
}
(a) 6 6
(b) 7 7
(c) 6 7
(d) 7 6
(e) None of these
Answer: (d)

37. Write c program which display mouse pointer and position of pointer.(In x coordinate, y coordinate)?
Answer:
#include”dos.h”
#include”stdio.h”
void main()
{
union REGS i,o;
int x,y,k;
//show mouse pointer
i.x.ax=1;
int86(0x33,&i,&o);
while(!kbhit()) //its value will false when we hit key in the key board
{
i.x.ax=3; //get mouse position
x=o.x.cx;
y=o.x.dx;
clrscr();
printf("(%d , %d)",x,y);
delay(250);
int86(0x33,&i,&o);
}
getch();
}

38.What will be output if you will compile and execute the following c code?
void main(){
int huge*p=(int huge*)0XC0563331;
int huge*q=(int huge*)0xC2551341;
*p=200;
printf("%d",*q);
}
(a)0
(b)Garbage value
(c)null
(d) 200
(e)Compiler error
Answer: (d)

39.What will be output if you will compile and execute the following c code?
struct marks{
int p:3;
int c:3;
int m:2;
};
void main(){
struct marks s={2,-6,5};
printf("%d %d %d",s.p,s.c,s.m);
}
(a) 2 -6 5
(b) 2 -6 1
(c) 2 2 1
(d) Compiler error
(e) None of these
Answer: (c)

40.What will be output if you will compile and execute the following c code?
void main(){
if(printf("cquestionbank"))
printf("I know c");
else
printf("I know c++");
}
(a) I know c
(b) I know c++
(c) cquestionbankI know c
(d) cquestionbankI know c++
(e) Compiler error
Answer: (c)

41.What will be output if you will compile and execute the following c code?
#define call(x) #x
void main(){
printf("%s",call(c/c++));
}
(a)c
(b)c++
(c)#c/c++
(d)c/c++
(e)Compiler error
Answer: (d)

42. What will be output if you will compile and execute the following c code?
#define message "union is\
power of c"
void main(){
clrscr();
printf("%s",message);
getch();
}
(a) union is power of c
(b) union ispower of c
(c) union is
Power of c
(d) Compiler error
(e) None of these
Answer: (b)

43. What will be output if you will compile and execute the following c code?
void main(){
int a=25;
clrscr();
printf("%o %x",a,a);
getch();
}
(a) 25 25
(b) 025 0x25
(c) 12 42
(d) 31 19
(e) None of these
Answer: (d)

44. What will be output if you will compile and execute the following c code?
void main(){
int i=0;
if(i==0){
i=((5,(i=3)),i=1);
printf("%d",i);
}
else
printf("equal");
}
(a) 5
(b) 3
(c) 1
(d) equal
(e) None of above
Answer: (c)

45.What will be output if you will compile and execute the following c code?
int extern x;
void main()
printf("%d",x);
x=2;
getch();
}
int x=23;
(a) 0
(b) 2
(c) 23
(d) Compiler error
(e) None of these
Answer: (c)

46.What will be output if you will compile and execute the following c code?
void main(){
int a,b;
a=1,3,15;
b=(2,4,6);
clrscr();
printf("%d ",a+b);
getch();
}
(a) 3
(b) 21
(c) 17
(d) 7
(e) Compiler error
Answer: (d)

47.What will be output if you will compile and execute the following c code?
void main(){
static main;
int x;
x=call(main);
clrscr();
printf("%d ",x);
getch();
}
int call(int address){
address++;
return address;
}
(a) 0
(b) 1
(c) Garbage value
(d) Compiler error
(e) None of these
Answer: (b)

48.What will be output if you will compile and execute the following c code?
#include "string.h"
void main(){
clrscr();
printf("%d %d",sizeof("string"),strlen("string"));
getch();
}
(a) 6 6
(b) 7 7
(c) 6 7
(d) 7 6
(e) None of these
Answer: (d)

49.What will be output if you will compile and execute the following c code?
void main(){
int huge*p=(int huge*)0XC0563331;
int huge*q=(int huge*)0xC2551341;
*p=200;
printf("%d",*q);
}
(a)0
(b)Garbage value
(c)null
(d) 200
(e)Compiler error
Answer: (d)

50.What will be output if you will compile and execute the following c code?
struct marks{
int p:3;
int c:3;
int m:2;
};
void main(){
struct marks s={2,-6,5};
printf("%d %d %d",s.p,s.c,s.m);
}
(a) 2 -6 5
(b) 2 -6 1
(c) 2 2 1
(d) Compiler error
(e) None of these
Answer: (c)

51.What will be output if you will compile and execute the following c code?
void main(){
if(printf("cquestionbank"))
printf("I know c");
else
printf("I know c++");
}
(a) I know c
(b) I know c++
(c) cquestionbankI know c
(d) cquestionbankI know c++
(e) Compiler error
Answer: (c)

52.What will be output if you will compile and execute the following c code?
#define call(x) #x
void main(){
printf("%s",call(c/c++));
}
(a)c
(b)c++
(c)#c/c++
(d)c/c++
(e)Compiler error
Answer: (d)

53. What will be output if you will compile and execute the following c code?
#define message "union is\
power of c"
void main(){
clrscr();
printf("%s",message);
getch();
}
(a) union is power of c
(b) union ispower of c
(c) union is
Power of c
(d) Compiler error
(e) None of these
Answer: (b)

54. What will be output if you will compile and execute the following c code?
void main(){
int a=25;
clrscr();
printf("%o %x",a,a);
getch();
}
(a) 25 25
(b) 025 0x25
(c) 12 42
(d) 31 19
(e) None of these
Answer: (d)

55.What will be output if you will compile and execute the following c code?
void main(){
int i=0;
if(i==0){
i=((5,(i=3)),i=1);
printf("%d",i);
}
else
printf("equal");
}
(a) 5
(b) 3
(c) 1
(d) equal
(e) None of above
Answer: (c)

56.What will be output if you will compile and execute the following c code?
int extern x;
void main()
printf("%d",x);
x=2;
getch();
}
int x=23;
(a) 0
(b) 2
(c) 23
(d) Compiler error
(e) None of these
Answer: (c)

57.What will be output if you will compile and execute the following c code?
void main(){
int a,b;
a=1,3,15;
b=(2,4,6);
clrscr();
printf("%d ",a+b);
getch();
}
(a) 3
(b) 21
(c) 17
(d) 7
(e) Compiler error
Answer: (d)

58.What will be output if you will compile and execute the following c code?
void main(){
static main;
int x;
x=call(main);
clrscr();
printf("%d ",x);
getch();
}
int call(int address){
address++;
return address;
}
(a) 0
(b) 1
(c) Garbage value
(d) Compiler error
(e) None of these
Answer: (b)

59.What will be output if you will compile and execute the following c code?
#include "string.h"
void main(){
clrscr();
printf("%d %d",sizeof("string"),strlen("string"));
getch();
}
(a) 6 6
(b) 7 7
(c) 6 7
(d) 7 6
(e) None of these
Answer: (d)

60.What will be output if you will compile and execute the following c code?
void main(){
int huge*p=(int huge*)0XC0563331;
int huge*q=(int huge*)0xC2551341;
*p=200;
printf("%d",*q);
}
(a)0
(b)Garbage value
(c)null
(d) 200
(e)Compiler error
Answer: (d)

20 Top Data Warehouse Multiple Choice Questions and Answers

Data Warehouse Multiple Choice Questions and Answers

1. Which of the following features usually applies to data in a data warehouse?
A.Data are often deleted
B.Most applications consist of transactions
C.Data are rarely deleted
D.Relatively few records are processed by applications
Ans: c

2. Which of the following statement is true?
A.The data warehouse consists of data marts and operational data
B.The data warehouse is used as a source for the operational data
C.The operational data are used as a source for the data warehouse
D.All of the above
Ans: c

3. The following is true of three-tier data warehouses:
A.Once created, the data marts will keep on being updated from the data warehouse at periodic times
B.Once created, the data marts will directly receive their new data from the operational databases
C.The data marts are different groups of tables in the data warehouse
D.A data mart becomes a data warehouse when it reaches a critical size
Ans: a

4. The following technology is not well-suited for data mining:
A.Expert system technology
B.Data visualization
C.Technology limited to specific data types such as numeric data types
D.Parallel architecture
Ans: c

5. What is true of the multidimensional model?
A.It typically requires less disk storage
B.It typically requires more disk storage
C.Typical business queries requiring aggregate functions take more time
D.Increasing the size of a dimension is difficult
Ans: b

6. The value at the intersection of the row labeled "India" and the column "Savings" in Table2 should be:
A.800,000
B.300,000
C.200,000
D.300,000
Ans: a

7. We want to add the following capabilities to Table2: show the data for 3 age groups (20-39, 40-60, over 60), 3 revenue groups (less than $10,000, $10,000-$30,000, over $30,000) and add a new type of account: Money market. The total number of measures will be:
A.4
B.More than 100
C.Between 10 and 30 (boundaries includeD.
D.Between 40 and 60 (boundaries includeD.
Ans: b

8. We want to add the following capability to Table2: for each type of account in each region, also show the dollar amount besides the number of customers. This adds to Table2:
A.Another dimension
B.Other column(s)
C.Other row(s)
D.Another measure for each cell
Ans: d

9. The most common source of change data in refreshing a data warehouse is:
A.Queryable change data
B.Cooperative change data
C.Logged change data
D.Snapshot change data
Ans: d

10. Which of the following statements is not true about refreshing a data warehouse:
A.It is a process of managing timing differences between the updating of data sources and the related data warehouse objects
B.Updates to dimension tables may occur at different times than the fact table
C.The data warehouse administrator has more control over the load time lag than the valid time lag
D.None of the above
Ans: d

11. A data warehouse is which of the following?
A. Can be updated by end users.
B. Contains numerous naming conventions and formats.
C. Organized around important subject areas.
D. Contains only current data.
Ans: C

12. An operational system is which of the following?
A. A system that is used to run the business in real time and is based on historical data.
B. A system that is used to run the business in real time and is based on current data.
C. A system that is used to support decision making and is based on current data.
D. A system that is used to support decision making and is based on historical data.
Ans: B

13. The generic two-level data warehouse architecture includes which of the following?
A. At least one data mart
B. Data that can extracted from numerous internal and external sources
C. Near real-time updates
D. All of the above.
Ans: B

14. The @active data warehouse architecture includes which of the following?
A. At least one data mart
B. Data that can extracted from numerous internal and external sources
C. Near real-time updates
D. All of the above.
Ans: D

15. Reconciled data is which of the following?
A. Data stored in the various operational systems throughout the organization.
B. Current data intended to be the single source for all decision support systems.
C. Data stored in one operational system in the organization.
D. Data that has been selected and formatted for end-user support applications.
Ans: B

16. Transient data is which of the following?
A. Data in which changes to existing records cause the previous version of the records to be eliminated
B. Data in which changes to existing records do not cause the previous version of the records to be eliminated
C. Data that are never altered or deleted once they have been added
D. Data that are never deleted once they have been added
Ans: A
 
17. The extract process is which of the following?
A. Capturing all of the data contained in various operational systems
B. Capturing a subset of the data contained in various operational systems
C. Capturing all of the data contained in various decision support systems
D. Capturing a subset of the data contained in various decision support systems
Ans: B
 
18. Data scrubbing is which of the following?
A. A process to reject data from the data warehouse and to create the necessary indexes
B. A process to load the data in the data warehouse and to create the necessary indexes
C. A process to upgrade the quality of data after it is moved into a data warehouse
D. A process to upgrade the quality of data before it is moved into a data warehouse
Ans: D

19. The load and index is which of the following?
A. A process to reject data from the data warehouse and to create the necessary indexes
B. A process to load the data in the data warehouse and to create the necessary indexes
C. A process to upgrade the quality of data after it is moved into a data warehouse
D. A process to upgrade the quality of data before it is moved into a data warehouse
Ans: B

20. Data transformation includes which of the following?
A. A process to change data from a detailed level to a summary level
B. A process to change data from a summary level to a detailed level
C. Joining data from one source into various sources of data
D. Separating data from one source into various sources of data
Ans: A

50 Top Siebel CRM Multiple Choice Questions and Answers

Siebel CRM Multiple Choice Questions and Answers

1. Which Siebel feature enables you to automatically apply a discount to a customer’ s order when the customer adds both a printer and replacement ink cartridges to their online shopping cart?
A. Siebel Workflow Policy Program
B. Action Sets
C. Siebel Assignment Manager
D. Rule Sets
Ans: B

2. You currently have a Siebel Operation step in a Workflow Process that updates SR priority from Low to High. You now want the Sub Process step to change the priority to Very High rather than High. How do you change this detail?
A. Double-click the Siebel Operation step in the Process Designer
B. Delete the step and replace it with a new Sub Process step
C. Right-click the Siebel Operation step in the Process Designer
D. Double-click the Sub Process step in the Process Designer
Ans: D

3. Which of the following is an Enterprise Component Group that should be enabled prior to running Siebel Workflow?
A. Workflow Process Batch Manager
B. Workflow Action Agent
C. Workflow Monitor Agent
D. Workflow Management
E. Workflow Process Manager
Ans: D

4. Which of the following is NOT an option with Siebel Workflow’ s Wait Step?
A. Pause a process for a specified amount of time
B. Pause a process until a specified runtime event occurs
C. Include a restart parameter in the process
D. Include a timeout parameter in the process
Ans: C

5. If an applet has five associated Rule Sets, and the first three rule sets will not return any data for the current user, but the last two rule sets will, how many rule sets are evaluated for this user?
A. 4
B. 3
C. 2
D. 5
Ans: A

6. How can you tell if your connectors in a Siebel Workflow process are successfully connecting the steps as you create the Workflow process? Choose two. A. The two ends of the connector will be white in color
B. By running the process using Process Simulator
C. By right-clicking the connector line
D. The two ends of the connector will be red in color
Ans: B,D

7. Which of the following describes .dx files?
A. Transaction files transferred between the Server and Mobile Client
B. Temporary files that are automatically purged upon application exit
C. Directory files used by Siebel to organize physical file directories
D. Log files used for troubleshooting EIM process errors
Ans: A

8. What is stored in the S_DOCK_TXN_LOG table in the Server Database?
A. Before and after images of data
B. A list of transactions performed while docked
C. All of the data that is changed during a remote session
D. Remote user information
Ans: A

9. In the first time set up of mobile users, what must you do before data can be loaded in the Mobile Client’ s local database?
A. Run the dev2prod.ksh script
B. Create the database schema for the local database
C. Copy the Siebel Database file to the mobile client
D. Copy the .cfg and .srf file from the server to the mobile client machine
Ans: B

10. Which server task creates the Docking\User directory on the Siebel Server for a new Mobile Client?
A. Transaction Router
B. Generate New Database
C. Synchronization Manager
D. Database Extract
Ans: D

11. What does the Transaction Merger server task do when it encounters a Duplicate Conflict? Choose two.
A. Merges the two records together into one record
B. Adds the duplicate record and sets a flag to indicate that duplicates exist
C. Does not add the duplicate record and logs the conflict in the remote status log
D. Notifies the mobile client of the duplicate
Ans: B,D

12. When does the Transaction Merger server task override the MRG: System Conflict Resolution system preference?
A. Never
B. When a Duplicate Conflict occurs
C. When an Update Conflict occurs
D. When a Delete Conflict occurs
Ans: D

13. What action is recommended if a mobile user is going to be unable to synchronize for an extended period of time (leave of absence, for example)?
A. Change the synchronization frequency
B. Modify the views assigned to the mobile client
C. Set a new effective end-date for the mobile client to deactivate it
D. Remove the mobile client’ s local database completely
Ans: C

14. When initially preparing your target environment for migration, which of the following tasks should you complete? Choose three.
A. Check out projects that were changed in development
B. Create user accounts
C. Install any required client software
D. Install database and server software
E. Copy the .srf file to server and clients
Ans: B,C,D

15. What is dataexp.exe used for when migrating environments?
A. To generate a data merge file that contains user and seed data
B. To create flat files containing data from non-EIM tables
C. To create flat files containing data from EIM tables
D. To generate a compressed copy of the source database
Ans: D

16. Which of the following must you do to reactivate a mobile client? Choose two.
A. Perform a database extract
B. Create the mobile client DOCKING sub-directory on the server
C. Add the server name to the DockConnString line of siebel.cfg
D. Remove the end date for the mobile client
Ans: A & D.

17. Which of the following tasks can you perform in the Catalog Manager?
A. Set permissions for Web Catalog items
B. Manage privileges and rights given to groups and users
C. Set authentication options
D. Manage Web groups and users
Ans: A

18. In workflow, using which of the following step you can invoke assignment manager
A. Business Service
B. Sub-Process
C. Siebel Operation
D. Decision Point
Ans: A

19. Which server component must be running for a siebel remote client to work:
A. Transaction Processor
B. Synchronization Manager
C. Transaction Router
D. Transaction Merger
Ans: B

20. You have a Workflow process that evaluates the age of Service Requests and updates the priority of Service Requests that are more than a week old. Which Siebel Workflow step type are you using to change the priority of the Service Request?
A. Siebel Update step
B. Siebel Operation step
C. Decision Point step
D. Sub Process step
Ans: B

21. The Expression Designer is used to define which of the following types of expressions?
A.Dynamic
B.Conditional
C.SQL
D.Rule
Ans: B,D

22. When an expression is validated, both the syntax and logic are checked.
A. True
B. False
Ans: b

23. At run-time, the system evaluates personalization expressions. Which of the following is NOT true of the evaluation results?
A.The view and applet displays because both view and applet expressions evaluate to True
B.The link to the view is not available even though the applet expression evaluates to True because the view expression evaluates to False
C.The view and applet displays even though the applet expression evaluates to False because the view expression evaluates to True
D.The link to the view is not available because both view and applet expressions evaluate to False
Ans: C

24. Personalization expressions override Responsibility in determining whether a user should see a view.
A. True
B. False
Ans: B

25. How are Personalization Expressions applied?
A.The Application administrator associates expressions with the appropriate Responsibility
B.A property is set on the appropriate view or applet
C.The Personalization administrator associates expressions with views and applets
Ans: C

26. Which of the following is NOT true of a rule set?
A.Consist of one or more rules which are evaluated in sequence
B.Defines an expression that is displayed in a salutation applet
C.Control the content of an applet based on personalization profile attributes, content attributes, and other factors
D.Defines an expression that acts as sort specification
Ans: D

27. Which of the following are actions that can be added to an action set? Pick THREE.
A.Invoke a method on a business service
B.Run a business service
C.Set a profile to a new value
D.Monitor an event
Ans: A,B,C

28. If an exclusion expression evaluates to True, that record is NOT included content, even if the inclusion expression evaluates to True.
A. True
B. False
Ans: A

29. Which of the following is NOT true of how rule sets are evaluated?
A.Evaluated in the specified sequence
B.Only evaluated if its conditional expression evaluates True and Start Date and End Date, if set, are appropriate
C.All rule sets are evaluated before determining content
Ans: C

30. Which of the following is true of Personal Salutations? Pick THREE
A.Appear at the top of the application home page
B.Scripted in rule sets
C.Salutation text can contain HTML tags to provide formatting
D.Can use only one rule per salutation
Ans: A,B,C

31. Siebel eConfigurator, ePricer, and eAdvisor are collectively known as what?
A. Siebel MidMarket Edition
B. Interactive Selling Suite
C. Siebel Employee Applications
D. Siebel Sales
Ans: B

32. Which entity represents a person external to your company?
A. Customer
B. Party
C. Contact
D. Person
Ans: C

33. Which entities always belong to a team? Choose three.
A. Activity
B. Opportunity
C. Contact 1
D. Account
E. Service Request
Ans: B,C,D

34. Which type of product is an internal application used by employees and partners?
A. Employee Application
B. Partner Application
C. Customer Application
D. Employee Partner Application
Ans: A

35. An Employee Application has the following characteristics? Choose two.
A. Used by employees only
B. Used by employees and partners
C. Internal application
D. Used by employees and customers
Ans: B,C

36. Marcel found out the area code of his contact, Céline, has changed from 912 to 440. Which of the following is the easiest way for him to change Céline’ s area code?
A. Find Céline’ s record in the My Contacts View, delete it, and create a new record
B. Find Céline’ s record in the My Contacts View, go to the detail applet, change the area code
C. Find Céline’ s record in the All Contacts Across Organizations View, delete her phone number from a primary list, and input the new one
D. Find Céline’ s record in the My Contacts View, delete her phone number from a primary list, and then input the new number
Ans: B

37. Which of the following objects is used to retrieve data from the database?
A. View
B. Business Object
C. Business Component
D. Database table
Ans: C

38. How many Business Components can a single list or form Applet reference?
A. Two (if using a toggle)
B. One
C. Unlimited
D. Eight
Ans: B

39. Complete this statement: A business object contains information about the _________
between business components.
A. Differences
B. Similarities
C. Shared properties
D. Relationships
Ans: D

40. Which of the following statements is true?
A.Form applet data comes from only one table
B.Form applet data may come from many tables and columns
C.Form applet data may come from many columns in a single table
D.Form applet data comes from only one column in a table
Ans: B

41.Complete the following statement. A set of related applets may be displayed in a __________.
A. Business object
B. View
C. Screen
D. Business component
Ans: B

42. Which applet type may simultaneously display more than one record?
A. List
B. Form
C. Child
D. Detail
Ans: A

43. On a Mobile Web Client using disconnected processing, how is HTML delivered to the browser?
A. The HTML is pulled from the Web cache on the Mobile Web Client
B. It is not possible for a disconnected client to receive Siebel HTML pages
C. The local Web Server with SWSE delivers the HTML to the browser
D. The Mobile Web Client must synchronize to receive the HTML from the Siebel Web Engine
Ans: C

46. What is the purpose of the Siebel Monitoring Account?
A. Used to monitor database capacity and alert DBA when approaching designated thresholds
B. Used to run Enterprise Server processes and components
C. Required to run Windows processes or start UNIX daemons
D. Required by Resonate Central Dispatch connection brokering software
Ans: D

47. Which of the following is NOT a valid task when installing and verifying the Enterprise and Siebel Servers?
A. Invoke the installation program and follow the installation steps
B. Run the install.ksh script
C. Verify that the Windows Service and Unix daemon process is started
D. Inspect the SESsetup.log file in the Siebel root directory
Ans: B

48. How might you verify repository data after installing the Database Server?
A. View the SESsetup.log file in the Siebel root directory
B. Verify that the Windows Service and Unix daemon process is started
C. Run the imprep.ksh script
D. Run a query to count the records in the S_VIEW table
Ans: D

49. What function does the Siebel Web Engine perform when it receives a URL with a Siebel
request?
A. Gathers templates and data and builds an HTML page
B. Displays the HTML page on the client’ s computer
C. Provides access to, and distributes load for Siebel Servers
D. Verifies that the client is using an acceptable browser
Ans: A

50. What happens when a user enters a URL for a Siebel application into a Web browser?
A. The Browser retrieves the appropriate templates and the Siebel Web Engine retrieves the data from the database to build the HTML page
B. The Siebel Web Engine recognizes the URL and passes it to the Web Server where the HTML page is built for the user
C. The Web Server retrieves the appropriate templates and the Siebel Web Engine retrieves the data from the database to build the HTML page
D. The Web Server recognizes the URL and passes it to the Siebel Web Engine where the HTML page is built for the user
Ans: D

51. Account is what kind of entity
A. Single Organization
B. Multiple Organization
C. Single User
D. Single Position
Ans: B

52. A potential client, partner and competitor is represented by which entity in Siebel
A. Contact
B. Account
C. Customer
D. Service Request
Ans: B

53. What are the different Business objects layers in Siebel, Choose 2
A. Business Object
B. Business Service
C. Business Component
D. Applet
Ans: A,C

54. In a view if you display an account form applet as the master and the opportunity list applet as the child then what is TRUE
A. Parent business component is used as Account
B. Child business component is used for Account
C. Parent business component is used as Opportunity
D. Child business component is used for Opportunity
Ans: A,D

55. Which of the following is TRUE in a view if there are two applets displayed one list and a detail.
A. It is based on two different views
B. It is based on two different Business Objects
C. It can use only one business component
D. It may use two business components
Ans: C

56. What does Rule set specify for an applet in personalization
A. Order condition
B. Search Specification
C. Set of Actions
D. Set of Events
Ans: B

57. What determines localization
A. Tools Language Mode
B. Siebel Tools
C. Regional Settings
D. OS regional settings
Ans: B

58. What does “GetAttribute(‘Me.Country’) = ‘USA’ tell us
A. Laptop being used is placed in USA
B. Laptops regional setting is set to USA
C. It checks for the address as ‘USA’
Ans: C

59. A Screen is a collection of
A. Applets
B. Business Components
C. Views
D. Business Objects
Ans: C

60. How does Siebel Remote Client connect
A. Through Gateway server
B. Through Domain Server
C. Through Enterprise Server
D. Directly
Ans: A