Answer Posted / mohan

can some one help me with a exam new pattern

how can I pass ccna in first try in one month

2228

---

Explain why fet is known as voltage control device?

937

---

oracle 1st round What are the different types of joins? Explain normalization with examples. What cursor type do you use to retrieve multiple recordsets? Diffrence between a "where" clause and a "having" clause What is the difference between "procedure" and "function"? How will you copy the structure of a table without copying the data? How to find out the database name from SQL*PLUS command prompt? Tadeoffs with having indexes Talk about "Exception Handling" in PL/SQL? What is the diference between "NULL in C" and "NULL in Oracle?" What is Pro*C? What is OCI? Give some examples of Analytical functions. What is the difference between "translate" and "replace"? What is DYNAMIC SQL method 4? How to remove duplicate records from a table? What is the use of ANALYZing the tables? How to run SQL script from a Unix Shell? What is a "transaction"? Why are they necessary? Explain Normalizationa dn Denormalization with examples. When do you get contraint violtaion? What are the types of constraints? How to convert RAW datatype into TEXT? Difference - Primary Key and Aggregate Key How functional dependency is related to database table design? What is a "trigger"? Why can a "group by" or "order by" clause be expensive to process? What are "HINTS"? What is "index covering" of a query? What is a VIEW? How to get script for a view? What are the Large object types suported by Oracle? What is SQL*Loader? Difference between "VARCHAR" and "VARCHAR2" datatypes. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table. Difference between "ORACLE" and "MICROSOFT ACCESS" databases. How to create a database link ? PL/SQL interview questions... Normalize many to many relationships Difference - Equijoin and union What is TEMP table space in Oracle, what is rollback segment How do we find row chaining? Pattern matching operators Features in oracle 9i and 10g Why truncating table is faster than delete copy commit syntax Convert Zulu time zone to US Eastern time zone Difference - union and union all Difference - Group by, Order by clause Which Ranking functions are available? Difference - Decode, NVL, NVL2 Tradeoffs of using partitioned tables How can we call stored procedure in SQL query What are the restrictions on calling PL/SQL from SQL Why EXISTS is preferable to distinct Give 2 examples of avoiding unnecessary parsing.

3632

---

In micro controller individual pin output current is 1.6ma .Normally to blink a led we need minium 10-12 ma. But if we connect led to the micro controller pins without additional device it blinks. How it is possible

2010

---

What is the purpose of the package around a microprocessor silicon die?

929

---

What happens to the residual resistivity of metals

1006

---

Consider a fixed subnet partition of a class B network number that will accommodate at least 76 networks. How many hosts can be on each network? Also mention how you calculated that.

2157

---

How WDM works in wireless system...as we say that it works in optical and signals transmitted in this are light signals...??

1810

---

i want to know fire safety factory purpose .. does fire mauual call point requires hooter or mcp has inbuilt siren...???

1943

---

Explain in detail the thevenin`s theorem

984

---

What are the different turn on methods of scr?

997

---

In ics the substrate is not employed as collector. Explain why?

1045

---

Hai Frds, i want to join in testing tools course, pls sugest good institute. And pls tel about Mind Q institute & phone num of Nareswar Roa sir plss, ple mail me plssssss

1808

---

What electron gun assembly is provided in crt?

990

---

What are the advantages of bjt?

962

---