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


Databases Interview Questions
Questions Answers Views Company eMail

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

Accenture,

6 13683

1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

Wipro,

1819

1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?

3i Infotech,

2 5154

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

BeBo Technologies,

8 14294

what is main def between plsql/table and array?

Oracle,

1 3071

Define the term DML, DDL and DTL?

 1 30136

How to count the no of records of a table without using COUNT function?

TCS, Tesco,

11 24966

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

JDA,

4 7172

Creating Tables Using SELECT

 1 2640

How can I create a table from another table without copying any values from the old table?

 3 4624

CREATE a table from another table

 2 4126

Get Current System Date Time

 2 3819

What is a SQL Server Temporary Table?

Wipro,

1 5491

Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.

 1 2729

what is the difference between delete,drop and truncate

Honeywell, Zomato,

2 5233

Un-Answered Questions { Databases }

What is Restricted Mode of Instance Startup in Oracle?

683

explain normalization concept? : Sql dba

592

Can we use where clause in union?

599

List the different index configurations possible for a table?

516

How do I create a mysql username and password?

500




How many aggregate functions are available there in sql?

530

How to get help at the sql prompt?

645

Is postgresql case sensitive?

434

How to download microsoft sql server 2005 express edition?

580

How to delete a trigger in mysql?

492

What are the two different parts of the pl/sql packages?

568

How to connect Azure federated root database and apply federation in entity framework?

87

How Switch (select or use) to a database.

541

What is mysqli_result?

509

What are the different editions of oracle?

593

For More Un-Answered { Databases } Questions Click Here