Top posts
-
What are the uses of MERGE in oracle
What are the uses of MERGE? MERGE is used to combine multiple DML statements into one. Syntax : merge into tablename using(query) on(join condition) when not matched then [insert/update/delete] command when matched then [insert/update/delete] command
-
autonomous transaction in oracle
Explain autonomous transaction. An autonomous transaction is an independent transaction of the main or parent transaction. It is not nested if it is started by another transaction. There are several situations to use autonomous transactions like event...
-
Can we uninstall/rollback a service packs from SQL Server 2005?
Can we uninstall/rollback a service packs from SQL Server 2005?
-
DIFF REPLACE &&TRANSLATE in Oracle.
REPLACE and TRANSLATE are character function in Oracle. Replace function Translate function Both function looks similar but there are some subtle difference. We can say Translate is an extended version of Replace.
-
SQLCODE and SQLERRM in oracle
What is the importance of SQLCODE and SQLERRM? SQLCODE returns the value of the number of error for the last encountered error whereas SQLERRM returns the message for the last error
-
DBMS_PARALLEL_EXECUTE
The DBMS_PARALLEL_EXECUTE package allows a workload associated with a base table to be broken down into smaller chunks which can be run in parallel
-
Why Use Materialized Views?
Ease Network Loads Create a Mass Deployment Environment Enable Data Subsetting Enable Disconnected Computing
-
Trigger Disadvantages
-->Not Compiled -->No SELECT Trigger Support -->Complete Trigger Failure -->Disabled Triggers -->No Version Control -->Update OF COLUMN -->No Support of SYS Table Triggers -->Mutating Triggers -->Hidden Behavior
-
What is RDBMS?
What is RDBMS? RDBMS stands for Relational Database Management System. It organizes data into related rows and columns. Features:- It stores data in tables. Tables have rows and column. These tables are created using SQL. And data from these tables are...
-
What is Hardening in mirroring
What is Hardening? As quickly as possible, the log buffer is written to the transaction log on disk, a process called hardening.
-
clustered index in oracle
A clustered index determines the order in which the rows of a table are stored on disk. If a table has a clustered index, then the rows of that table will be stored on disk in the same exact order as the clustered index. An example will help clarify what...
-
How to find members in Log in group in SQL Server
The following Query will display the members in a group EXEC xp_logininfo '
', 'members' example: EXEC xp_logininfo 'BUILTIN\Administrators', 'members' -
Error Handling in SQL SERVER
Error Handling Tips
-
What is ROWID?
What is ROWID? ROWID is a pseudo column attached to each row of a table. It is 18 characters long, blockno, rownumber are the components of ROWI
-
Explain the uses of Control File in oracle
Explain the uses of Control File. It is a binary file. It records the structure of the database. It includes locations of several log files, names and timestamps. They can be stored in different locations to help in retrieval of information if one file...
-
What is a database link?
What is a database link? Database link is a named path through which a remote database can be accessed.
-
Do you know about Resource Database?
Do you know about Resource Database? All sys objects are physically stored in resource database and logically available on every database. Resource database can faster the service packs or upgrades
-
second highest salary in each department
second highest salary in each department SELECT * FROM (SELECT emp.*, DENSE_RANK()OVER(PARTITION BY deptno ORDER BY sal DESC) secondhsal FROM emp )x WHERE x.second hsal=2 ;
-
TICKETING TOOLS...
TICKETING TOOLS...
-
What is Role-switching?
What is Role-switching? Inter changing of roles like principal and mirror are called role switching.
-
What is merge replication?
What is merge replication? This allows both publisher and subscriber to work independently, online or offline and merges the changes later. Here changes are track on both publisher and subscriber and then merged.
-
In which Recovery model we can use in Mirroring?
1In which Recovery model we can use in Mirroring? In mirroring the principal and mirror databases are used only full recovery model
-
merge replication
How does merge replication works? What are advantages and disadvantages of Merge replication? What is conflict resolution in Merge replication? What is a transactional replication?
-
What is Log buffer?
What is Log buffer? A log buffer is a special location in memory (RAM). SQL Server stores the changes in the database’s log buffer.
-
What is Hardening?
What is Hardening? As quickly as possible, the log buffer is written to the transaction log on disk, a process called hardening.