Provided by www.YuvaJobs.com - ABB  Placement Paper 11 Sepember 2011 


 Major portion was from high level concepts of RDBMS and DBA. 5-6 questions from C, 5-6 from Unix, 2-3 about binary-decimal and 2-3 from OS and Networking.

1. Which directory contains info about user accounts in UNIX
a-/usr
b-/usr/src
c-/home
d-/root

2. What does EXP command do?
a) create backup
b) recovery
c)
d)none

3. Lowest layer of UNIX
a) Hardware
b) Kernel
c) Shell
d) None

4. What does whoami command do?---(ans)current user.

5. Which command is used for help on a particular command in  UNIX?---(ans)man command

6. What file does the ODBC look for to load drivers?
a) odbc.ini
b) odbc.dll
c) odbcdvr.ini
d) none

7. printf("f=%o",f)--output?

8. How do we write comments in sql;

9. Function of ipconfig,

10. What is the extension of oracle reports---optiond like RPF,RDf,REP etc;

11. OS is a _______? ans-system software

12. Windows is ____________?single user/multitasking OS.

13. Linking can happen at wich time?
a) compile,
b) load,
c) run;
d) all

14. Questions on report generation in oracle.

15. #define a 10
void main()
{
#define a 50;
printf("%d",a);
}

16. In hierarchial model-hash function used to find wat?-
a) primary key,
b) root,
c) child;
d) none

17. Hierarichal model given by IBM

18. Which model has top down approach----ans:hierarchical model

19. printf("\nsb");
printf("\bri");
printf("\rha");
output-_____?
ans:hai

20. define_editor="emacs" in sql*plus means??
ans-- emacs become default editor

21. In wich type we need to take arr size greater than the input lenght:
a)int
b)char
c)float
d)double
 
22. Int a[100];
a[1]=3;
a[999]=4;
value of a[50]???

23.Some program on post,pre increment in C
 
24. A ques on outer join

25. A dbms query to insert values in only 2 columns of a table hacin 3 columns

26. 1 gigabyte=1073741824;

27. Atomic units of databse are _____________?---indivisible;


28. You are running a query against a relational database.

Referring to the scenario above, what clause or command do you use in the query to help avoid a costly tablescan?

Choice 1
GROUP BY clause
Choice 2
INDEX command
Choice 3
HAVING clause
Choice 4
FROM clause
Choice 5
WHERE clause [/quote]

29. For performance, you denormalize your database design and create some redundant columns.

Referring to the scenario above, what RDBMS construct can you use to automatically prevent the repeated columns from getting out of sync?

Choice 1
Cursors
Choice 2
Constraints
Choice 3
Views
Choice 4
Stored procedures
Choice 5
Trigger

30. Which one of the following capabilities do you expect to see in a majority of RDBMS extensions to ANSI SQL-92?

Choice 1
Encryption key management
Choice 2
Graphical User Interface Widgets
Choice 3
Thread creation, execution, & coordination
Choice 4
Network socket creation/operation
Choice 5
If/Then, for, do/while statements


31. Which of these is data dictionary software package::
1. DB/DC dictionary
2. MS ACCESS
3. TOTAL
4. metadata

32. What is Demorgans law?

33. C bitwise left shift RHS operator?? ans--