Top posts
-
Fixing Missing Rows error in transactional replication
Fixing Missing Rows error in transactional replication Fixing Missing Rows error in transactional replication: · Set up transactional replication http://sqlserverreplicationtroubleshooting.blogspot.com/2011/04/setting-up-transactional-replication-in.html...
-
Startup and Shutdown modes in oracle database
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...
-
Tech Mahindra PL/SQL Interview Questions
Tech Mahindra PL/SQL Interview Questions Introduce yourself Tell me your project What are the packages, functions, procedures you developed in your project what are their Functionality? Difference between loop and bulk collect which is the faster way...
-
Polaris PL/SQL Interview Questions
Polaris PL/SQL Interview Questions Tell me about yourself What is your front end How to pass data to java Diff b/w procedure and function Can we use all kind of function in function What is trigger and trigger types Do you know about analytical queries...
-
File oracle Control (Control Files)
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,...
-
Oracle Hints
Optimizer hints can be used with SQL statements to alter execution plans Hints let you make decisions usually made by the optimizer. As an application designer, you might know information about your data that the optimizer does not know. Hints provide...
-
Difference Between Cursor And Ref Cursor
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...
-
How to move the master db files in Sql server?
Moving the master Database To move the master database, follow these steps. From the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager. In the SQL Server Services...
-
SQL DB Security
SQL Server Database Security :--- ------------------------------------------------ Database roles (also referred to as database-level roles) are security roles that exist on a database level, as opposed to the server level. If you are familiar with any...
-
Memory issue in sql server
SQL Memory issue Memory Issues It can be external or internal. Physical – External - Physical RAM may be low and SQL Server detects and reduce the commit charge of the buffer pool. Internal –Responding to external memory pressure Changed memory settings...
-
SQL DMVs
SQL DMVs Top 15 SQL Dynamic management Views 1.sys.dm_db_index_physical_stats: This dynamic management function returns information regarding data and index information for data tables and views 2.sys.dm_exec_requests: This view shows information regarding...
-
Operating Modes in mirroring
What are the Operating Modes and explain them? a. High Availability:- High-availability mode, runs synchronously. Requires a Witness Server instance. The Principal server sends the log buffer to the mirror server, and then waits for a response from the...
-
What are the Authentication Modes in SQL Server?
Windows Authentication and Mixed mode Windows Authentication mode connects to an instance of SQL Server through a Windows NT 4.0 or Windows 2000 user account. Mixed mode (Windows Authentication and SQL Server Authentication) connect to an instance of...
-
FOR UPDATE in Oracle
What is the purpose of FOR UPDATE? Selecting in FOR UPDATE mode locks the result set of rows in update mode, which means that row cannot be updated or deleted until a commit or rollback is issued which will release the row(s). If you plan on updating...
-
CHAR datatype in oracle
CHAR datatype Char contain alphanumeric data. Length of Char datatype is between 1 and 255 characters. If you don't specify a length, a char column stores a single character by default. Char datatypes stores data in the Fixed-Length Format. Be aware,...
-
Sqlldr (SQL*Loader) example.
Question: I need an example of using the sqlldr (SQL*Loader) utility to load some data into my Oracle tables. Answer: The sqlldr utility has easy syntax, and here is a simple example in using SQL*Loader. Also see this sqlldr (SQL*Loader) example. Sqlldr...
-
Unix Related questions asked to an Oracle Database Administrator (DBA
1. How do you see how many instances are running? 2. How do you automate starting and shutting down of databases in Unix? 3. You have written a script to take backups. How do you make it run automatically every week? 4. What is OERR utility? 5. How do...
-
Backup Oracle Database using RMAN
How to Backup Oracle Database using RMAN (with Examples) Even if you are not an Oracle DBA, you’ll still encounter a situation where you may have to take a backup of an Oracle database. Using Oracle RMAN, you can take a hot backup for your database, which...
-
Explain Plan: Execution Paths and Hints
Explain Plan: Execution Paths and Hints USE_MERGE - two inputs are seperately sorted and merged. No sort is required if the table has indexes. waits until both the sorts are performed. Good when NO INDEXES are in the tables. When both are almost equal...
-
Oracle DBA Responsibilities
Oracle DBA Responsibilities (1) Creates and maintains all databases required for development, testing, education and production usage. (2) Performs the capacity planning required to create and maintain the databases. The DBA works closely with system...
-
What is Deadlock?
What is Deadlock? A deadlock occurs when users try to place exclusive locks on each other’s objects. Ex:- User1 places an exclusive lock on Table1 and then tries to place an exclusive lock on Table2. User2 already has an exclusive lock on table2, and...
-
Database Mirroring
What is Database Mirroring? What are the benefits of that? Database mirroring is an option to improve the availability of a databases which supports automatic fail over with no loss of data. Benefits:- Increases data protection Increases availability...
-
Why Use Dynamic SQL?
Why Use Dynamic SQL? You need dynamic SQL in the following situations: You want to execute a SQL data definition statement (such as CREATE), a data control statement (such as GRANT), or a session control statement (such as ALTER SESSION). Unlike INSERT,...
-
Using Dynamic SQL with Bulk SQL
Using Dynamic SQL with Bulk SQL Bulk binding lets Oracle bind a variable in a SQL statement to a collection of values. The collection type can be any PL/SQL collection type (index-by table, nested table, or varray). The collection elements must have a...
-
How Do Bulk Binds Improve Performance?
How Do Bulk Binds Improve Performance? The assigning of values to PL/SQL variables in SQL statements is called binding. PL/SQL binding operations fall into three categories: in-bind When a PL/SQL variable or host variable is stored in the database by...