Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Accenture DB2 Interview Questions
Questions Answers Views Company eMail

What is sqlcode -811?

 7 61227

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 5841

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 17334

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 7603

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 10977




which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 7046

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 8679

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

 4 15494

How to get Top 10 Salaries from a Table

 11 19570

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

 8 10859

what is the differences between spufi and qmf and which is better?

 4 7641

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

 1 2280

My SQL is not performing well. Describe how will you fine tune it?

 1 4533

Post New Accenture DB2 Interview Questions




Accenture DB2 Interview Questions


Un-Answered Questions

List some of the test types that are supported by selenium.

73

Tell us about your family background.

118

in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?

112

What causes java.io exceptions in the log file of weblogic server?

76

Explain Hive Thrift server?

65




Which package is always imported by default?

89

What does hiv results?

39

What is the purpose of struts.xml in struct2?

63

Can a constructor be declared private? If yes then in which scenario?

370

Explain indirection?

94

What is the name of solid solution of carbon in alpha iron and delta iron ?

106

Should excess cash be place in long term investments?

1111

What are conversions and interfaces?

75

What is h:datatable tag in jsf (javaserver faces)?

5

What is liquidity adjustment facility?

88