Databases Interview Questions
Questions Answers Views Company eMail

How to define an anonymous procedure without variables?

553

How many data types are supported?

624

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

568

How to define default values for formal parameters?

598

What are the restrictions on external table columns?

552

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

568

How to loop through data rows in the implicit cursor?

545

How to create additional tablespaces for an new database?

575

How many categories of data types?

578

Can you assign multiple query result rows to a variable?

553

How to use fetch statement in a loop?

561

Can dml statements be used in pl/sql?

581

Can variables be used in sql statements?

556

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

654

How to process query result in pl/sql?

566


Un-Answered Questions { Databases }

What is database users in dbms?

509


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

553


Why do we use views instead of tables?

502


What are commonly used mssql functions in php?

566


What is RMS Migrations

1966






What are the ddl commands?

541


Explain trigger and its types?

618


How do I edit a stored procedure in sql server?

514


What is Database Management System?

641


What is wal in postgresql?

443


Is oracle faster than sql server?

557


Describe why operational and informational systems are separate.

473


What is use of except clause? How does it differ from not in clause?

560


What you can use regular expression for in mysql? Support your answer with an example?

487


What are its different types of dbms?

542