Answer Posted / ravi satyadarshi

//1st of all create a directory to store ur external table
CREATE DIRECORY EMP_DIR AS '/FLAT_FILES' ;


// now write the following line of code to create an
external table at that directory

CREATE TABLE OLDEMP(ENO NUMBER,ENAME CHAR(20),DOB DATE,)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY EMP_DIR
ACCESS PARAMETERS
(RECORDS DELIMITED BY NEWLINE
BADFILE 'BAD_EMP')
LOGFILE 'LOG_EMP'
FIELDS TERMINATED BY ','
(ENO CHAR , ENAME CHAR DOB CHAR DATE_FORMAT
DATE MASK "DD-MON-YYYY"
)
)
LOCATION ('EMP1.TXT')
)
PARALLEL 5
REJECT LIMIT 200;

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

974

---

Explain the cube operator?

981

---

How to replace not in with not exist?

2058

---

What is a database development?

946

---

Explain about the hierarchical model of the database?

1091

---

How would you design a database for an online site, which would average a million hits a day?

987

---

Explain about the database management systems.

954

---

Explain about relational operator join?

1019

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2402

---

What is the physical representation for a many-to-many relationship?

1055

---

How to read and create .LDC data files which are used by linguatic dictionary.

2517

---

Which data type cannot be used as a parameter in a udf?

956

---

Explain about normal forms?

1032

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

983

---

How to generate OIDS

2228

---