1. What are the restrictions on calling Functions from SQL Expressions? To be callable from SQL expressions, a user-defined PL/SQL function must meet certain requirements. • Parameters to a PL/SQL function called from a SQL statement must use positional...
Module Overloading Two or more modules can, under certain conditions, have the same name with different parameter lists. Such modules are said to be overloaded. The code in these overloaded programs can be very similar or can be completely different....
SSIS 1: What is SSIS? How it is related with SQL Server. SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server....
The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track...
How to launch 5 diff application from 5 child process What is the use of man command? Print numbers in the reverse order How to write program to print descending order What is the method by which we find the list of users logged on a server using telnet...
Unix Interview Questions And Answers How are devices represented in UNIX? All devices are represented by files called special files that are located in/dev directory. Thus, device files and other files are named and accessed in the same way. A 'regular...
Unix Interview questions Explain difference between IPC mechanisms? What type of scheduling is used in Unix? What is stty used for? How would you remove a semaphore / shared memory whose owner processes have died? Explain the unix file system? Give examples...
aggregate functions, analytic functions return aggregate results, but analytics do not group the result set. Instead, they return the group value multiple times with each record, allowing further analysis. Analytic queries also generally run faster and...
File oracle Control (Control Files) ORACLE CONTROL FILE (CONTROL FILES). What is a file Control Files. The control file is one of the most important files (this is not the only way!!), It contains valuable information on the database. Its format is binary,...
Multiplexer Control Files Oracle (control-files) Multiplexer Oracle control files. How to add control files in Oracle. How to multiplex the control files with a spile. How to add a control file with a PFILE. It is strongly recommended to multiplex control...
