Top posts
-
Database Mail Architecture in SQL SERVER
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...
-
Oracle 11g Architecture
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...
-
SQL SERVER DBA_ SQL SERVER ARCHITECTURE
SQL Server Architecture SQL Server architecture is mainly divided into different components i.e. SNI Protocol Layer, Relational Engine, Storage Engine, Buffer Pool. Majorly classified as two main engines: Relational Engine and the Storage engine. SNI...
-
What is the difference between FUNCTION, PROCEDURE AND PACKAGE in PL/SQL?
What is the difference between FUNCTION, PROCEDURE AND PACKAGE in PL/SQL? Function: The main purpose of a PL/SQL function is generally to compute and return a single value. A function has a return type in its specification and must return a value specified...
-
SQL SERVER Error 4064
SQL Error 4064 Issue Description : Each user has a default database. When you connect to computer that is running Microsoft SQL Server, and you do not specify a login database, the default database is used. However, if the default database is unavailable...
-
SQL SERVER Log shipping:
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...
-
Resource governor
Resource Governor 1. What is Resource governor? A: Resource Governor is a feature which can manage SQL Server Workload and System Resource Consumption. We can limit the amount of CPU and memory consumption by limiting /governing /throttling on the SQL...
-
SQL Server 2014 Upgrade Advisor Prerequisites, Download and Installation
SQL Server 2014 Upgrade Advisor Prerequisites, Download and Installation What is SQL Server Upgrade Advisor? Microsoft has provided a free tool to analyse existing SQL Server Instance, database, its components, features and configurations and generates...
-
PL/SQL - invoke the Functions in SQL Expressions
1. How to invoke the Functions in SQL Expressions? We invoke the SQL functions when activates are too complex, too awkward, or unavailable with SQL. By invoking functions we can increase efficiency when used in the WHERE clause to filter data, as opposed...
-
Unix Interview Questions And Answers-2
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
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...
-
Analytic Functions vs Aggregate Functions
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...
-
Global Temporary Table in sql server
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 Tables in sql server
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...
-
Uses of Temporary Tables in Sql server
#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:...
-
Multiplexer Control Files Oracle (control-files)
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...
-
What is normalization ?
Defination : Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies...
-
SQL*Loader : bad file vs discard file
SQL*Loader : bad file vs discard file What is the difference between the bad file and the discard file in SQL*Loader. The bad file and discard files both contain rejected rows, but they are rejected for different reasons: Bad file: The bad file contains...
-
How to print the even and odd numbers from 1 to 10?
How to print the even and odd numbers from 1 to 10? BEGIN FOR i IN 1..10 LOOP IF mod(i,2) = 0 THEN dbms_output.put_line(i||' is an even number'); END IF; END LOOP; FOR i IN 1..10 LOOP IF mod(i,2)!= 0 THEN dbms_output.put_line(i||' is an odd number');...
-
How to return multiple values from a function in Oracle PL/SQL?
How to return multiple values from a function in Oracle PL/SQL? Generally we write functions for computing some value. Function can return only one value, though it’s definition may contains more than one return statements. This article explains us how...
-
What is Difference between Translate andReplace functions in ORACLE?
Replace used for String where as Translate used for Character. Replace Replaces entire string at a time where as Translate Replaces character one-to-one basis Replace Function replaces single character with multiple characters where as Translate Function...
-
operations cannot be performed on the master database:
Adding files or filegroups. Changing collation. The default collation is the server collation. Changing the database owner. master is owned by sa. Creating a full-text catalog or full-text index. Creating triggers on system tables in the database. Dropping...
-
SQL SERVER SQL backup Error
Error 3154 and 3013 How to fix the SQL backup Error 3154 and 3013? Today we have faced below error msg while restoring sql backup file from drive . Msg 3154, Level 16, State 4, Line 1 The backup set holds a backup of a database other than the existing...
-
MSSQL Server Management Studio with Windows Authentication but unable to connect with SQL Server Authentication.
Issue : I am able to connect to MSSQL Server Management Studio with Windows Authentication but unable to connect with SQL Server Authentication. The 'sa' login details are correct but still getting the following error message. Login failed for user 'sa'....
-
How to recover a database from suspect mode ?
How to recover a database from suspect mode ? Step 1: Open SQL Server Management Studio and connect to the SQL Server. Make sure that your current database is set to master Step 2: Clear the suspect mode of the database using sp_resetstatus DatabaseName....