Top posts
-
What are different execution methods of executables?
What are different execution methods of executables? FlexRpt The execution file is wrnitten using the FlexReport API. FlexSql The execution file is written using the FlexSql API. Host The execution file is a host script. Oracle Reports The execution file...
-
FIRST_VALUE and LAST_VALUE function
The general syntax is: FIRST_VALUE(
) OVER ( ) The FIRST_VALUE analytic function picks the first record from the partition after doing the ORDER BY. The is computed on the columns of this first record and results are... -
What are the advantage & disadvantage of package
What are the advantage & disadvantage of package A package is a group of PL/SQL types, objects, and stored procedures and functions. The specification part of a package declares the public types, variables, constants, and subprograms that are visible...
-
PL/SQL - restrictions on calling Functions from SQL Expressions
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...
-
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...
-
Setting up transactional Replication in SQL Server
Setting up transactional Replication in SQL Server PULL Replication Setup on 3 database servers. Where Publisher, Distributor and Subscriber all are in different servers 1) To set up distributor · Go to distributor server · Click on replication folder...
-
Autonomous Transaction in oracle
Autonomous Transaction in oracle An autonomous transaction is an independent transaction started by another transaction called as main transaction. It let you allow to execute various DML statements, commit and rollback without commiting or rolling back...
-
SQL Server Agent roles?
What are the differences in the SQL Server Agent roles? SQLAgentUserRole Ability to manage Jobs that they own SQLAgentReaderRole All of the SQLAgentUserRole rights The ability to review multiserver jobs, their configurations and histor SQLAgentOperatorRole...
-
what permissions to require to create a job in sql server?
what permissions to require to create a job in sql server To configure a user to create or execute Microsoft SQL Server Agent jobs, you must first add an existing SQL Server login or msdb role to one of the following SQL Server Agent fixed database roles...
-
Partitioning Types in Oracle
RANGE partitioning. This type of partitioning assigns rows to partitions based on column values falling within a given range. CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', separated...
-
Database in Suspect In sql server
SQL Database in Suspect Mode What are the reasons for the database to be in suspect state? 1) Data and Log files missing 2) Corruption of pages in the Data files. 3) Issues that are caused during Recovery/Restoring process 4) Disk level failures 5) SNA...
-
exceptions in collctions in oracle
COLLECTION_IS_NULL you try to operate on an atomically null collection. NO_DATA_FOUND a subscript designates an element that was deleted, or a nonexistent element of an associative array. SUBSCRIPT_BEYOND_COUNT a subscript exceeds the number of elements...
-
Difference Between Cursor And Ref Cursor in Oracle
Difference Between Cursor And Ref Cursor In this post I am trying to detail out the differences between Cursor and Ref Cursors. I am sure, this question has been asked in many interviews to many of us and it also has its own technical weightage. Lets...
-
SQL SErver Error 2098, 8344
SQL Error 2098, 8344 To understand the error you can transcribe the error message 0x2098 in a more readable. - You can use the tools: Error Code lookuphttp://www.microsoft.com/downloads/details.aspx?familyid=be596899-7bb8-4208-b7fc-09e02a13696c&displaylang=en...
-
SUBSTR, Instr in oracle
The Instr function is used to find the position of a string in another string. Optionally you can provide position m to start searching for the string and the occurrence n of the string. By default m and n are 1 which means to start the search at the...
-
What is a SQL Server transaction log file?
What is a SQL Server transaction log file? A SQL Server transaction log file is an integral part of every SQL Server database. Along with the data file, which has an MDF extension, the transaction log file with a LDF extension, makes a SQL Server database....
-
slow Running Queries in SQL
Troubleshooting slow Running Queries in SQL 1) Whenever slow running query comes in to picture we will follow the following technique. We need to identify if this issue is at h/w or s/w level Most of the times the issue will be with SQL Server (s/w level)...
-
sql server interview questions
What is TUF File in log shipping ? TUF file stands for Transaction Undo File inWhat is TUF File in log shipping ? TUF file stands for Transaction Undo File in SQL Server, .TUF file is the Transaction Undo File, which is created when performing log shipping...
-
HOW To modify a synchronization schedule for a pull subscription in Management Studio
HOW To modify a synchronization schedule for a pull subscription in Management Studio Connect to the Subscriber in Management Studio, and then expand the server node. Expand the SQL Server Agent folder, and then expand the Jobs folder. Right-click the...
-
HOW To modify a synchronization schedule for a push subscription in Replication Monitor
HOW To modify a synchronization schedule for a push subscription in Replication Monitor Expand a Publisher group in the left pane of Replication Monitor, expand a Publisher, and then click a publication. Click the All Subscriptions tab. Right-click a...
-
HOW To specify synchronization schedules REPLICATION?
HOW To specify synchronization schedules REPLICATION? On the Synchronization Schedule page of the New Subscription Wizard, select one of the following values from the Agent Schedule drop-down list for each subscription you are creating: Run continuously...
-
Log Reader Agent
Log Reader Agent - The Log Reader Agent is used with transactional replication. It moves transactions marked for replication from the transaction log on the Publisher to the distribution database. Each database published using transactional replication...
-
Explain about Principal, Mirror and Witness Servers?
Explain about Principal, Mirror and Witness Servers? 1) Principal Server:- One Server serves the database to client is called Principal server and it having original data. Can have only one Principal Server and it has to be on a separate server. 2) Mirror...
-
point in time recovery performed independent of a server
How is a point in time recovery performed independent of a server down situation? It depends on which backup types are issued. In this example let's assume that full, differential and transaction log backups are issued. Restore the most recent full backup...
-
SQL Constraints
SQL Constraints SQL constraints are used to specify rules for the data in a table. If there is any violation between the constraint and the data action, the action is aborted by the constraint. Constraints can be specified when the table is created (inside...