Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Databases Interview Questions
Questions Answers Views Company eMail

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 6522

What is the use of SCOPE_IDENTITY() function?

2 6566

After using set unused can we enable the column again to use? Please give me some answers....

Maveric,

1 4927

Can we rollback records deleted by a truncate statement?

CarrizalSoft Technologies, United Healthcare,

3 9042

How many types of indexes are there in SQL Server?

CarrizalSoft Technologies, United Healthcare,

6 12797

How many types of TRIGGERS are there in MS SQL Server?

CarrizalSoft Technologies, TCS, United Healthcare,

8 31736

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

United Healthcare,

1 6119

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

United Healthcare,

1 5879

Can we execute a stored procedure inside a trigger?

BirlaSoft, CarrizalSoft Technologies, United Healthcare,

6 25322

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

TCS, Wipro,

1 4684

What is the query optimization statistics?

1 2952

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 6757

Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris

1 3587

what is the difference between no rows returned and null returned?

2 5728

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

Cognizant, TCS,

12 16326


Un-Answered Questions { Databases }

What is oracle latest version?

1165


What are the source of constraints?

1006


Does view occupy space?

1005


Have you written applications to retrieve stored images in a table?

1081


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174


what is bcp? When does it used? : Sql dba

1051


Where can you add custom error messages to sql server?

1197


what is spatial nonclustered index

1050


Can one drop a column from a table?

1079


How to write a left outer join with the where clause in oracle?

1143


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2695


How many concurrent programs you have customized, can you name some of them?

23


List out the different types of locks available in sql server?

1041


what is dbms? : Sql dba

1053


what is the last version,the release date of that version and fix pack of ibm db2 udb?

2043