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


Databases Interview Questions
Questions Answers Views Company eMail

Repair mdf file

 2 2869

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

 1307

sql database suspect We have a sql database that is showing as suspect. How can we recover?

 1413

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

Miracle Software,

1434

This message is received in response to the query SELECT * FROM JA_Party. I would like to know what am I doing wrong. ERROR: relation "ja_party" does not exist LINE 1: SELECT * FROM JA_Party ^ ********** Error ********** ERROR: relation "ja_party" does not exist SQL state: 42P01 Character: 15

 1 1926

What are the common bugs found while migrating to MySQL db to Postgre?

 1 2070

What is inverted file ?

 977

What can be used in PostgreSQL to send messages to the front-end, and optionally terminate the current query being processed?

 1 2107

How is the statistics in PostgreSQL updated?

 1 2582

What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?

 908

What is the Maximum size for a table in PostgreSQL?

 958

PostgreSql Disadvantages

AFDD,

1488

What are the character types that are available in postgresql?

 948

What does GEQO stands for in PostgreSQL?

 1039

What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?

 1031

Un-Answered Questions { Databases }

What is a storage engine?

571

How many rows can you have in an access table?

458

Give syntax for SQL and ORACLE joins.

644

Do you need a commit after ddl statements?

289

What are the different tcl commands in sql?

628




What does this statement do @@rowcount?

562

How to create nested stored procedure?

548

What is schema in teaching?

412

How do I start and stop sql server?

556

What is sql rowcount?

568

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

508

Is left join inner or outer by default?

536

Explain the first normal form(1nf)?

567

Define msdb database?

604

How do you know the version of your mysql server?

568

For More Un-Answered { Databases } Questions Click Here