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--