Trinity - Oracle Interview Preparation Questions
Call
whatsapp
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
Cisco Training in Trivandrum, Trinity Technologies

No.1 Training Institute in Kerala

ORACLE QUESTIONS : PART 4

To obtain the structure of an Oracle table, the command to use is:

STRUCTURE [TableName].

DESCRIBE [TableName].

DESCRIBE STRUCTURE [TableName].

DESC TABLE [TableName].

SHOW ANSWER

After a table has been created, its structure can be modified using the SQL command:

UPDATE TABLE [

TableName

].

MODIFY TABLE [

TableName

].

ALTER TABLE [

TableName

].

CHANGE TABLE [

TableName

].

SHOW ANSWER

The SQL command to create a table is: 

MAKE TABLE.

ALTER TABLE.

DEFINE TABLE

CREATE TABLE.

SHOW ANSWER

The DROP TABLE statement:

deletes the table structure only.

deletes the table structure along with the table data.

works whether or not referential integrity
        constraints would be violated.

is not an SQL statement.

SHOW ANSWER
BACK | NEXT
TRINITY SOFTWARE SOLUTIONS,IInd floor, Radheyam Towers, Gandhari Amman Kovil Road, Pulimood, Trivandrum - 1
0471-2334855 | 2335855 | 9447387064 | 9847003556 info@trinitytechnology.in