Databases Interview Questions
Questions Answers Views Company eMail

What is hot add cpu in sql server 2008?

510

Define cross join in sql server joins?

579

Explain about system stored procedure?

586

Explain syntax for viewing trigger?

529

How to create a store procedure with encryption?

513

Explain the difference between primary keys and foreign keys?

503

What is ms sql server index?

553

What are clustered and non-clustered index?

541

Explain the categories of stored procedure?

510

Define full outer join in sql server joins?

493

What are the events recorded in a transaction log?

494

What are the disadvantages of indexes?

522

Explain datetime2 data type in sal server 2008?

540

Explain about system database?

570

Write a sql query to convert all character to uppercase after hypen.

951


Un-Answered Questions { Databases }

what is an extent ? : Sql dba

575


Mention what are the main components of an oracle rac system?

1


How to use copy and concatenate commands in SQL?

590


What is reference section?

487


Explain the term entity set in dbms?

592






How to return top 5 rows in oracle?

530


How to change postgresql root user password?

452


Can we use joins in subquery?

525


What is the difference between stored procedure and view?

522


Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

520


What is 3nf normalization form?

552


How do I remove duplicates in two columns?

500


Can an access database be used online?

464


How do I connect to a postgresql database remotely?

418


Explain the features of oracle?

588