Databases Interview Questions
Questions Answers Views Company eMail

How to define an anonymous procedure without variables?

662

How many data types are supported?

733

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

679

How to define default values for formal parameters?

702

What are the restrictions on external table columns?

661

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

682

How to loop through data rows in the implicit cursor?

650

How to create additional tablespaces for an new database?

685

How many categories of data types?

681

Can you assign multiple query result rows to a variable?

674

How to use fetch statement in a loop?

693

Can dml statements be used in pl/sql?

706

Can variables be used in sql statements?

683

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

770

How to process query result in pl/sql?

677


Un-Answered Questions { Databases }

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

682


How can delete duplicate records in cte in sql server?

637


What is define in oracle?

695


If a table does not have a unique index, can a cursor be opened on it?

620


How do I start mysql database?

578






What are stored procedures in mysql?

695


What is a function in oracle pl sql?

666


How can you tell the difference between an index and a view?

623


How can be determining the size of the log files?

349


What are the different ddl commands in sql?

687


What is cursor in mysql?

582


what is dbms? : Sql dba

656


Is pl sql different from sql?

649


What is the use of i-am-a-dummy flag in mysql?

662


What is raid and sybase?

603