ORACLE AND MSSQLSERVER

Deleting the duplicate records The usual need is to delete all but one such row. The first thing is to know the deciding factor -out of the duplicates, which one is to be retained? The next SQL retains the row with the minimum rowid: SQL> delete from...

Log shipping: Shipping the transnational log backups from one server (Primary) to another server (Secondary) SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or...

clustered index --------------- datapages store into leaf level nodes only one clustered index for table (data arrange physically only one way) good performance not allow duplicates If we create primary key on table on any key column then automatically...

1. What is the Oracle Architectural components ? Oracle Architectural components segregated in two parts - Physical & Logical layer. The physical layer consists of files that reside on the disk, the components of the logical layer map the data to these...

Indexes Indexes Indexes are optional structures associated with tables. Indexes can be created to increase the performance of data retrieval. Just as the index in a manual helps you quickly locate specific information, an Oracle index provides an access...

Q: What are the Oracle Background Processes? A: The Oracle Background Processes are programs or tasks that run on the Oracle background such as log writers, db writers, archives, checkpoint, etc. Q: Describe the V$BGPROCESS view. A: The V$BGPROCESS view...

What is module overloading? What are composite data types? What is the use of record. Why we use record. what is diifrence between where clause and having clause? What is collection? Difference b/w nested tables and varrays? what is a bad file? What are...

SMTP Server Details Hotmail SMTP server name: smtp.live.com Port number: 587 Gmail SMTP server name: smtp.gmail.com Port number: 587 Yahoo SMTP server name: smtp.mail.yahoo.com Port number : 25 AOL SMTP server name: smtp.aol.com Port number : 587 Database...

Maintenance Plan Wizard in SQL Server ----------------------------------------------------- SQL Server maintenance plan wizard is inbuilt feature which helps in creating automated maintenance jobs for database integrity checks, rebuild and reorganize...

You can execute the below query and find the fixed and user defined server roles. SELECT name, principal_id, type, type_desc, is_fixed_role, owning_principal_id FROM sys.server_principals WHERE type = 'R' There are eight types of fixed server roles in...