adspace




Databases Interview Questions
Questions Answers Views Company eMail

How to define an anonymous procedure without variables?

1 1235

How many data types are supported?

1 1170

How to connect to the server with user account: sys?

1 1092

How to define default values for formal parameters?

1 1116

What are the restrictions on external table columns?

1 1140

What privilege is needed for a user to insert rows to tables in another schema?

1 1089

How to loop through data rows in the implicit cursor?

1 1149

How to create additional tablespaces for an new database?

1 1104

How many categories of data types?

1 1068

Can you assign multiple query result rows to a variable?

1 1062

How to use fetch statement in a loop?

1 1093

Can dml statements be used in pl/sql?

1 1152

Can variables be used in sql statements?

1 1110

How to revise and re-run the last sql command?

1 1250

How to process query result in pl/sql?

1 1224


Un-Answered Questions { Databases }

How can I check that whether automatic statistic update is enabled or not?

1111


i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1861


what is dbms? : Sql dba

1061


Is there some bulk load or other way to import a lot of data fast?

931


How to start an oracle instance?

1103


What is your daily office routine?

2345


What is the difference between upgrade and migration in sql server?

1183


Can we do dml on views?

1035


What is an indexed view?

1021


Which statement is used in a select query for partial matching?

1241


Can sql servers link to other servers like oracle?

915


Do we need to rebuild index after truncate?

1137


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1196


Explain “row_number()” in sql server with an example?

1076


Is primary key clustered index?

1018