soloscript.com
Home | Contact Us | Log In | Help
HOME New Listing Script NEW LISTING Most Popular Script MOST POPULAR High Rated Script HIGHEST RATED Script SCRIPTS Add Script ADD SCRIPT Download Tutorial DOWNLOADS Forums FORUM
TUTORIALS
   ASP.Net & C#
   ASP
   Perl and PHP
   Java Scripts
   C and C++
   Ajax Tutorials
   J2ee, J2Me, Java
   Python & Ruby Rail
   Crystal Report
   Sap
   CGI
   XML
   Cold Fusion & CFML
   HTML, DHTML & CSS
   Dreamweaver
   FLASH
   Photoshop/Web Designing
   Tools & Utilities
   Oracle/D2K
   Sql Server
   MySql
   Domain Name Registration
   Remotely Hosting
   Web/Server Application
   Hotel Marketing
   Internet and Law
   Search Engine Optimization/SEO
   E-Commerce
   Interview Questions
   Site Map

Previous < 1 2 3 4 5 6 > Next
Oracle / D2K 2
 How do you view version information in Oracle?

SQL> select banner from $version;
   
 How do you return the top-N results of a query in Oracle?

SELECT TOP N * FROM TABLE
OR
SELECT TOP N% * FROM TABLE
 
 What is Q Database link.

It is a schema object in one database enables you to access objects on another database.Other database can be any one not necessary that it should be oracle.

when you create public using PUBLIC, it is available to all users if you do not use public it will become private.
 
 Why is a UNION ALL faster than a UNION?

UNION ALL faster than a UNION because for union operation server needs to remove the duplicate values but for union all its not. Thats why the UNOIN ALL is fater than UNION Operation. It is recommended that if you know that the union set operation never returns duplicate values than you must use UNION ALL instead of UNION.
 
 What is Full Backup ?
A full backup is an operating system backup of all data files, on-line redo log  files  and  control  file  that  constitute  ORACLE  database  and the parameter. 
Latest Answer : The first choice to be made is whether a backup should be of the entire database, or just a part of it.A full backup is the is a backup of all Datafiles, control files and the spfile. Remember that as all multiplexed copies of the control files are identical, ..
 
 Can Full Backup be performed when the database is open ?
No. 
Latest Answer : NO, we can't. cuz Full Backup means consistent backup and we can take this backup only when our database is close. ...
 
What is Partial Backup ?

A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down. Latest Answer : A partial backup is an operating system backup of part of a database. The backup of an individual tablespace's datafiles or the backup of a control file are examples of partial backups. Partial backups are useful only when the database is in ARCHIVELOG ...
 
 What is the difference between media recovery & crash recovery..?

The basic diff between the media and crash recovery is that , media recovery is performed by the user or dba with the helps of backups while the crash recovery is performed by the oracle itself by using his sman background process. ...
   

Previous < 1 2 3 4 5 6 > Next
  Copyright 2000-2006 © SoloScript.com, All rights reserved.