1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

How to build data dictionary view an new database?

 522

How to get a create statement for an existing table?

 564

How to pass parameters to procedures?

 544

How to use "in" parameter properly?

 608

How to run create database statement again?

 613

How to run queries on external tables?

 560

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

 559

How to rename a column in an existing table?

 609

How to view existing locks on the database?

 539

How much memory your 10g xe server is using?

 576

How to recover a dropped index?

 1 906

How to assign values to data fields in record variables?

 574

How to create a new table by selecting rows from another table?

 544

How to create tables for odbc connection testing?

 485

What is a named program unit?

 572

Un-Answered Questions { Databases }

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

2054

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

549

What are the general rules on data consistency?

576

What is the difference between access and excel?

412

What database block size should I use?

396




Explain what is “asynchronous” communication in sql server service broker?

487

how you can list all the tables in a database?

518

What do you mean by mainframe connect tool in sybase?

446

Difference between aggregate functions of sql?

645

How many tables can you join in sql?

522

What is sqlca in db2?

523

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

597

Should database table names be capitalized?

540

What are the advantages of partitioning?

634

Why we need sql server?

546

For More Un-Answered { Databases } Questions Click Here