Databases Interview Questions
Questions Answers Views Company eMail

How to define an anonymous procedure without variables?

560

How many data types are supported?

628

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

572

How to define default values for formal parameters?

607

What are the restrictions on external table columns?

555

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

574

How to loop through data rows in the implicit cursor?

551

How to create additional tablespaces for an new database?

583

How many categories of data types?

582

Can you assign multiple query result rows to a variable?

562

How to use fetch statement in a loop?

572

Can dml statements be used in pl/sql?

589

Can variables be used in sql statements?

559

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

658

How to process query result in pl/sql?

572


Un-Answered Questions { Databases }

What is mongodb atlas?

1


What's the information that can be stored inside a bit column?

555


What are the functions used to encrypt and decrypt the data present in mysql?

542


Why not phenix, the zelinka/otwinoski libraries, etc?

612


What are the different types of collation sensitivity?

567






Is record in oracle pl sql?

539


What problem one might face while writing log information to a data-base table in pl/sql?

567


How do I start microsoft access?

469


Why is there a performance difference between two similar queries where one uses union and the other uses union all?

520


What is data types in sql?

545


What is a heap table?

488


What is isnull() operator?

582


How does sql*loader handles newline characters in a record? : aql loader

594


What is SDL (Storage Definition Language)?

513


how many columns can be used for creating index? : Sql dba

528