Logo 
Search:

Interview FAQs

Submit Interview FAQ
Home » Interview FAQsRSS Feeds
Oracle
Comments: 0

Provide syntax to truncate a table

TRUNCATE TABLE ;
Posted By:Shruti Sharma      Posted On: Dec 17

Oracle
Comments: 0

Name of serial’s name which has been started two year ago.

SQL>select serialname from serial_master where to_char(timeinindia ,'DD-MON-YYYY hh:mi:ss a.m.') <= '05-aug-2000 12:59:59'

SERIALNAME
----------
Kundali
Kmg
Ksbkbthi
Posted By:Shruti Sharma      Posted On: Dec 15

Oracle
Comments: 0

How to create table?

SQL> create table serial_master 2 (serialno varchar2(3) primary key,serialname varchar2(10) check (serialname like 'K%'), director varchar2(10), timeinindia date);
Posted By:Shruti Sharma      Posted On: Dec 15

Oracle
Comments: 0

How to insert records into tables?

SQL> insert into serial_master (serialno,serialname,director,timeinindia)values('C4','Knkkh','Hemal',to_date('28-Jul-2002 12:59:59 p.m.','DD-MON-YYYY hh:mi:ss p.m.'));
Posted By:Shruti Sharma      Posted On: Dec 15

Oracle
Comments: 0

How to select records?

SQL> select serialno, serialname, director, to_char (timeinindia,'dd-mon-yyyy hh:mi:ss a.m.') from serial_master;
Posted By:Shruti Sharma      Posted On: Dec 15

C++ Programming
Comments: 0

Which of the following can be used to identify the objects in object-oriented design?

Options

a) Textual analysis
b) Data flow diagram
c) Both a and b
d) None of the above

Answer : c) Both a and b
Posted By:Shruti Sharma      Posted On: Dec 15

  13  14  15  16  17  18  19  20  21  22  23