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...
Startup and Shutdown modes in oracle database The parameter file contains the information of parameters which controls the database The default space or location where the parameter file resides is ORACLE_HOME/dbs The satrtup mount means creating (SGA)System...
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...
#table refers to a local (visible to only the user who created it) temporary table. ##table refers to a global (visible to all users) temporary table. @variableName refers to a variable which can hold values depending on its type. Uses of Temporary Tables:...
Global Temporary Table: Global Temporary tables are visible to or available across all sessions. And all users. Global Temporary tables are created using the same syntax as a CREATE TABLE except the table name starts with "##" (two '#' signs). When the...
Temporary Table: Temporary tables are tables that are available only to the session that created them. These tables are automatically destroyed at the termination of the procedure or session that created them. Use of temporary tables in MS SQL Server...
