| Other Databases AllOther Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Define the following terms
i. Inverted List ii. Candidate Key iii. B-Tree
iv. Foreign Key
| | 1 |
| utility used to obtain inform regarding the optimizes
choice of access strategy for SQL stmts
A) LOAD
B) REORG
C) COPY
D) EXPLAIN
| Accenture | 1 |
| characters of DBMS
A) non redundant
B) data independence
C) increased security
D) all the above
| Accenture | 1 |
| WHAT IS OPM?(IN DETAILED) | L&T | 1 |
| what is primary key,unique key, foreign key? can u teach me
in simple language? | CMC | 14 |
| What are ACID Properties? | TCS | 1 |
| Write the major components of a Database Management System? | | 1 |
| Integrity constraints means..? how many and what are they? | AZTEC | 4 |
| What are the differences between Database Trigger and
Integrity constraints ? | Synergy | 2 |
| a __________ is a virtual table made up of subset of actual
table | | 1 |
| what is vlook up in ms excel and how does it used??? | | 1 |
| what is meant by Dynamic query? | Satyam | 2 |
| what is difference between delete and truncet ? | Fidelity | 6 |
| Which is the best sorting method if i have to sort the
students of Harvard University according to their first
name? | CybAge | 1 |
| plz suggest me the book for preparation of NIC exam. | NIC | 5 |
| Does aggregate and fact tables gets populated from
transactional data with only diffrence in there granularity?
Please clarify? | | 1 |
| 1.what are components of querystdio and report studio and
cognoss connection?
2. how to use prompts in query studio?
3.what is lock and un lock objects?
4.how to test the re[ports in query studio?
5.how to use brust option and when?
6.what is the performance testing?
7.condition explorer whaen your using?
8.in impromptu how do you create cascading prompt?
9.diff between section and group?
10.types filters where you are using group filters and
tabular filter?
11.tabular model, tabular references ,tabular set , tabular sql?
12.what is the use of multi[le packages?
13what types of problems arise when create a join?
14.how to provide package sequirety?
15.report server components?
16.how many kinds of quality subjects?
17.how do you specify the joins?
18.how would you maintain the relations in frame work manager?
19.what is usage of segments and how to provide it?
20.governer settings in frame work maneger?
21.how to create filter in frame work manager?
22diffrence between represention layer and physical layer?
23.how to create prompts in frame work manager?
24.what errors occured when verify the model?
25.how to publish package in net work or local system? | Wipro | 1 |
| WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS? | HP | 2 |
| Can we have a function Overloading with same number of
arguments but with different return types of function | CybAge | 7 |
| What are the three types of anomalies in database and
Explain? | | 2 |
| |
| For more Databases AllOther Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
