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...

Sript performs the same function as the one above but it displays failure date, job name, step id, step name and error message. SELECT DISTINCT CAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11)) AS 'Failure Date', SUBSTRING(T2.name,1,40)...

Bulk Exceptions Using BULK COLLECT in PL/SQL blocks and procedures can dramatically speed array processing, but it can, if the DBA isn't prepared, 'hide' any errors that occur in the bulk processing list. A 'plain vanilla' EXCEPTION handler may not report...

The Transact SQL language allow you to use various system stored procedures like: sp_tables, sp_table_privileges, sp_stored_procedures, sp_cursor, sp_executesql, sp_rename, sp_lock, sp_execute, sp_help. Sp_addextendedproperty Sp_columns Sp_column_privileges...