1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

Can u make a synonym for deptno=10 only from emp table.

TCS,

1 1942

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

SAPCO,

1095

All questions related to Control m monitoring tool

HCL, TY,

2007

what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

Arrow Electronics,

1 1869

how to do daily transactions with out sql* loader control file regesterd in apps?

Arrow Electronics,

1209

1) Does oracle have any table which contain all the exceptions and it's code internally?

CTS,

1270

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

CTS,

1136

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

Prodapt,

1128

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

CTS,

1372

display your age in months?

 2 3471

what is reindexing?

Tata Technologies,

1161

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

Aptroid,

1085

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

IBM,

1170

how to insert the records in particular position

 1 2111

what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?

OVGU,

1 1775

Un-Answered Questions { Databases }

What is pdo database?

477

What are the main differences between 11.x and 12.x versions of sybase?

455

How do you handle datasets larger than 50 gb?

140

Where are sql server user names and passwords stored in sql server?

516

Is sql dba a good career? : SQL DBA

521




How do I run mysql on a mac?

465

What is sql performance tuning?

484

What happens if time-only values are provided as date and time literals?

520

Give the various exception types.

530

Explain table queries and select queries. What are the main differences between the two?

429

how do u setup a replication site?

1482

What is a select query statement in ms sql server?

569

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2381

Why self join is used in sql?

480

What is the page protect in reports?

1

For More Un-Answered { Databases } Questions Click Here