Databases Interview Questions
Questions Answers Views Company eMail

How to define an anonymous procedure without variables?

764

How many data types are supported?

826

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

798

How to define default values for formal parameters?

797

What are the restrictions on external table columns?

807

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

809

How to loop through data rows in the implicit cursor?

822

How to create additional tablespaces for an new database?

797

How many categories of data types?

766

Can you assign multiple query result rows to a variable?

763

How to use fetch statement in a loop?

793

Can dml statements be used in pl/sql?

804

Can variables be used in sql statements?

783

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

875

How to process query result in pl/sql?

816


Un-Answered Questions { Databases }

What are the disadvantages of microsoft access?

613


What is sql collation?

858


Why transaction is important?

751


How do users use Report Builder with SQL Server data sources?

129


What is restrict in sql?

786


how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

763


What is ELT? Or What is the difference between ODI and other ETL Tools?

508


What is a sql trace file?

769


What is the use of “join” in sql server?

806


What is conditional split?

758


Name the buffer in which all the commands that are typed in are stored

592


How to unzip a file in ssis?

766


What are the restrictions applicable while creating views?

734


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

747


Explain a join between tables?

775