Give two examples of how you might determine the structure of the table DEPT?
Use the describe command or use the dbms_metadata.get_ddl package.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Give examples for Micro controller? 10.11.08
Z80, Intel MSC51 &96, Motorola are the best examples of Microcontroller. Z80, Intel MSC51 &96, Motorola are the best examples of Microcontroller....Give examples of degenerated dimensions ? 22.09.08
Degenerated Dimension is a dimension key without corresponding dimension. Example: In the PointOfSale Transaction Fact table, we have: Date...Give two examples of referential integrity constraints? 14.05.08
A primary key and a foreign key....What is a pseudo column. Give some examples 11.05.08
It is a column that is not an actual column in the table. eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL. Suppose customer table is there having di...How to declare select-option as a parameter? 26.03.07
SELECT-OPTIONS: specify are displayed on the selection screen for the user to enter values. Parameters: dname like dept-dname. Select-options: dname for dep...What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table. 16.11.06
Drop Table - will remove the existence of the table from the database along with its data and structure and all the constraints. The table will be no longer ava...What are the difference between DDL, DML and DCL commands? 22.08.06
DDL (Data Definition Language) statements are used to define the database structure or schema. Some examples: 1. CREATE - to create objects in the database...Give examples for Micro controller? 26.03.06
Z80, Intel MSC51 &96, Motorola are the best examples of Microcontroller....What does level of Granularity of a fact table signify? 17.03.06
Granularity The first step in designing a fact table is to determine the granularity of the fact table. By granularity, we mean the lowest level of information...What command is used to create a table by copying the structure of another table? 09.03.06
CREATE TABLE .. AS SELECT command Explanation : To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the f...