A wooden log having weight of 60 kg. If d circumference increased 2 times and height decreased by ½ then what will be d weight? Very easy prob. Take ∏ (d/2)2h =30 Then find the value of ∏d2h/2
Descripción: A strategic analysis of infosys covering Indian IT sector in details
.................................................................. 3 THE D ATABASE O BJECTS ................................................................ ATABASE BJECT AMING ULES ................................ ................................ .................................................4 D O N R ........................................................................................4 D ATATYPES................................................................ TH E DATA DATA DEFINITION COMMA COMMANDS
........................... .......... ...... 8 FOR TABLES ............................... .............................
CREATING A TABLE ................................ ...........................................................................................................8 ................................................................. 9 CONSTRAINTS ON TABLES................................................................ .........................................................................................................12 D ROPPING A TABLE ................................ .........................................................................................................13 ALTERING LTERING A TABLE ................................ ...............................................................................14 SAMPLE TABLES ................................................................
.............................. ..............................................................15 ............................................................15 QUERYING THE TABLES TABLES............................ ..................................
..............................................................................15 CONDITIONAL RETRIEVAL OF ROWS ................................ ..............................................................................17 SQL FUNCTIONS................................................................ G ROUP (OR AGGREGATE ) FUNCTIONS ................................ ...........................................................................17 ..........................................................................20 SINGLE ROW ( OR SCALAR) FUNCTIONS................................ ...............................................................................27 JOINS TO Q UERY MULTIPLE TABLES................................ ..............................................................................29 SET O PERATORS ................................................................ N ESTED Q UERIES ................................ ............................................................................................................30 ............................................................ ........33 ..... 33 DATA MAN MAN IPULATION COMMAND COMMAND S ............................... ..............................................................
................................................................33 33 THE INSERT COMMAND ................................................................ THE DELETE COMMAND ................................................................ ...............................................................33 33 THE UPDATE COMMAND ................................................................ ...............................................................33 33 ...................................................35 TH E TRANSA TRANSACTION CTION CONTROL COMMAND COMMAND S ............................... .....................................................35
...............................................................35 35 THE COMMIT COMMAND ................................................................ ..........................................................................................35 35 THE ROLLBACK COMMAND ................................ ............................................................ .........................37 .....................37 WORKING WITH WITH OTH ER SCHE MA OBJECTS OBJECTS ............................................................ SEQUENCES................................................................ ............................................................................... ....... ............... .......37 37 ............................................................................................................... ....... ............... .........38 38 SYNONYMS ................................ ...............................................................................................................................39 39 VIEWS................................ ...........................................................................................................................41 41 INDEXES................................ CLUSTERS ................................................................ .........................................................................................42 42