Placement Papers - TCS Database Questions

GeekInterview.com > Placement Papers > TCS > Placement Papers

Go To First | Previous Question |

Placement Papers | Question 23 of 23

TCS Database Questions

1. What are the different types of joins?
2. Explain normalization with examples.
3. What cursor type do you use to retrieve multiple
record sets?
4. Difference between a "where" clause and a "having"
clause
5. What is the difference between "procedure" and
"function"?
6. How will you copy the structure of a table without
copying the data?
7. How to find out the database name from SQL*PLUS
command prompt?
8. Tradeoffs with having indexes
9. Talk about "Exception Handling" in PL/SQL?
10. What is the difference between "NULL in C" and
"NULL in Oracle?"
11. What is Pro*C? What is OCI?
12. Give some examples of Analytical functions.
13. What is the difference between "translate" and
"replace"?
14. What is DYNAMIC SQL method 4?
15. How to remove duplicate records from a table?
16. What is the use of Analyzing the tables?
17. How to run SQL script from a Unix Shell?
18. What is a "transaction"? Why are they necessary?
19. Explain Normalization dn De normalization with
examples.
20. When do you get constraint violation? What are the
types of constraints?
21. How to convert RAW data type into TEXT?
22. Difference - Primary Key and Aggregate Key
23. How functional dependency is related to database
table design?
24. What is a "trigger"?
25. Why can a "group by" or "order by" clause be
expensive to process?
26. What are "HINTS"? What is "index covering" of a
query?
27. What is a VIEW? How to get script for a view?
28. What are the Large object types supported by
Oracle?
29. What is SQL*Loader?
30. Difference between "VARCHAR" and "VARCHAR2"
data types.
31. What is the difference among "dropping a table",
"truncating a table" and "deleting all records" from a
table.
32. Difference between "ORACLE" and "MICROSOFT ACCESS"
databases.
33. How to create a database link ?

Total Answers and Comments: 3

Last Update: May 24, 2008 Asked by: sowjanya

Sponsored Links

Best Rated Answer

—

Submitted by: arif_h_j

there are 5 ways to normalize the database in order to make complex data structure into simpler form.

1NF- removing duplicate groups and multivalued entries
2NF-removing functional dependencies and create
foreign key to relate with primary key

3NF- removing transivity
4NF-removing multivalued dependencies
5NF- PJNF - join dependency

Above answer was rated as good by the following members:
jones.ir

April 15, 2008 05:59:55

sreeswaroop

Member Since: April 2008 Contribution: 1

RE: TCS Database Questions

sorry

Is this answer useful? Yes | No

May 24, 2008 05:14:28

arif_h_j

Member Since: May 2008 Contribution: 2

RE: TCS Database Questions

there are 5 ways to normalize the database in order to make complex data structure into simpler form.

1NF- removing duplicate groups and multivalued entries
2NF-removing functional dependencies and create foreign key to relate with primary key

3NF- removing transivity
4NF-removing multivalued dependencies
5NF- PJNF - join dependency

Is this answer useful? Yes | No

May 24, 2008 05:18:16

arif_h_j

Member Since: May 2008 Contribution: 2

RE: TCS Database Questions

there are 5 ways to normalize the database in order to make complex data structure into simpler form.

1NF- removing duplicate groups and multivalued entries

2NF-removing functional dependencies and create
foreign key to relate with primary key

3NF- removing transivity

4NF-removing multivalued dependencies

5NF- PJNF - join dependency

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top