Software Applications Programming Errors and solutions.

This is SQL Command chart we read it from starting of any computer diploma which include oracle and SQL. DDL is data definition language,DML is data manipulation language ,DCL is data control language and TCL is Transaction control. TCL Include Set transaction also. DML Include Merge,call ,explain plan,and lock table command too. DDL include comment also.

Below is some details or example what is the use of 'CACHE' ,'NO CACHE' option in sequence 1.Suppose cache is 10 so it will store the next 10 values in advance and that time it some issue happenes with database .we will lose that stored values 2.Values will be fetched from memory by pre-generating them to reduce I/O 3.Cache in sequence specifies that how many values will be stored in memory for faster access,It's default value is 20.

Difference between view and Materialized view  (i) View will not store any data,whereas Materialized View will store data. (ii)View is used for security purpose and Materialized View for performance. (iii) view is not accessible if base table is dropped, whereas in Materialized View it can still be accessible. (iv) Can perform DML operation directly on view but it Materialized View its not possible. Define Long Column LONG columns cannot be in the SELECT clause when using the UNION set operators. There are some restrictions for long columns like.  (i) It cannot appear in where clause. (ii) Indexes cannot be created on them. (iii) It cannot appear in Group by,order by, or connect by clauses or with the distinct operator in select statements.

If you are facing following error which Database space error on Sql server for ERP. "The database reported (session 2 (-AOS-)): Database space problem - 'AX2009_Test' is out of space" Then you can do following to resolve this error. 1. Clean unwanted file from c drive or other drive where database stored. 2. Shrinking database log and data files can also help to free some space. 3. If you database size growing fast then increase hard drive volume or move database to other drive. 4. Clean log files which is bigger size. 5. Use disk cleanup tool. 6. You can Shrink other database which is not related to ERP.

To get SQL Database Backup Restore History you can execute below code using msdb database. This table resides in msdb database. SELECT [rs].[destination_db], [rs].[restore_date], [bs].[backup_start_date], [bs].[backup_finish_date], [bs].[database_name] as [source_db], [bmf].[physical_device_name] as [backup_file_used_for_restore] FROM msdb.restorehistory rs INNER JOIN msdb.backupset bs ON [rs].[backup_set_id] = [bs].[backup_set_id] INNER JOIN msdb.backupmediafamily bmf ON [bs].[media_set_id] = [bmf].[media_set_id] ORDER BY [rs].[restore_date] DESC

Problem : I have faced one issue which was access denied type error . I am able to take Backup manually but when I am trying to set it through maintenance job then its show below Error. Executing the query "EXECUTE testDB.dbo.xp_create_subdir N'D:\DBBackup..." failed with the following error: "xp_create_subdir() returned error 5, 'Access is denied.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Solution :.I resolved above error by providing full right for user everyone to folder DBBackup.  To give rights to folder you can follow steps as below. 1.Select folder Properties and select the Tab Security 2.Now click Add buton then click on Advanced button. 3.Then click Find Now and select Everyone then click ok.

Problem Getting Error during setting SQL Maintenance plan wizard setting. " Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)" Solution : This type of error comes due to t the unregistered COM in dts.dll which is located in in command line change directory and path of dll file is  C:\Program Files\Microsoft SQL Server\100\DTS\Bin You can run the following from the command line to resolve this error: REGSVR32.EXE dts.dll Then you need to disconnect from management studio and reconnect, it again then set SQL Maintenance plan wizard again it should work. I hope this will solve to come out from your troubleshooting.

Mostly we face space issue in C drive . How to handle disk space issue on C drive? Following are the steps you can use to free some space in c drive. 1. Go to event viewer and clean all logs. 2. Use disk cleanup properties on c drive to clean unwanted logs. 3. Clean CBS log file at C:\Windows\Logs\CBS folder. 4. Go to %userprofile%\desktop folder and transfer all files to other drives. 5. Set virtual memory to other drive instead of more on c drive. 6. Uninstall unwanted program from control panel ->Program and features. 7. Clean temporary folder from internet explorer. 8. You can use ccleaner software to clean logs. 9. Empty Recycle bin folder. 10. Find duplicate files and delete it.

1)Btree index:when ever we are requesting data using btree indexes columns using where clause then oracle server searching for indexes in database,if btree indexes columns are available in database then oracle server automatically creates btree structure,through btree structure only oracle server retrieve data very fast from data base . 2)Bitmap index:when ever we are using bitmap index then oracle server automatically creates bitmap table,it is mostly used in data-ware house applications.bitmap index is high performance compare to btree index because bitmap index internally creates bitmap table. 3)By default indexes are btree indexes. When ever we are creating the primary key ,unique key constraints automatically btree indexes are created. If you want to create bitmap index then explicitly you have to mention the bitmap keyword at the time of creation of index. Bitmap index mostly created on lo cardinality columns.the table having wide range values.

An Embedded system is any computer system hidden inside a product other than a computer.  You will encounter a number of difficulties when you writer embedded-system software in addition to those you encounter when you write applications. Throughput — Your system may need to handle a lot of data in a short period of time. Response — Your system may to react to events quickly. Testability — Setting up equipment to teat embedded software can be difficult. Debug ability — Without a screen or a keyboard, finding out what the software is doing wrong is a trouble some problem. Reliability —Embedded systems must be able to handle any situation without human intervention. Memory Space —Memory is limited on embedded systems, and you must make the software and the data fit into whatever memory exists. Program installation —You will need special tools to get your software into embedded systems. Power Consumption —Portable systems must run on battery power, and the software in these sys

Platform Independence of .NET Platform Its lang independent as long as that language's compiler targets the managed environment.. i.e, code written in C#.net or VB.Net or any other .Net compliant language will result in the same IL. certainly .net doesn't compile in UNIX. No compilers til date i suppose.. Heard that something similar exists to compile .net in Linux tho'.. Platform Independent does not mean O S independence in .NET terms. It means you can build a managed code and be assured it works on 32 - bit m/c, 64 bit m/c etc. Of course, at present it only supports Windows as O S, but Microsoft has left open the UNIX ( or any other O S for that matter) implementation of .NET run time. Lot of open source projects are going on in this regard. Advantages of asp with c sharp over asp with vb.net ultimately both copies in to MSIL, it depends on what application designing and what is the background of the developers who work for. C# more structured and fully OOP e

Question: What is bulk-collect and any restrictions in bulk-collect ? what is the use of limit clause in bulk-collect ? Answer: With bulk collect we can move all the resultant set in bulk to b processed in PL/SQL engine which kindles high efficiency but at the cost of memory ,thus the resultant set is moved in batches by giving how many records to be moved in one batch by specifying it in limit clause. Actually bulk collect performance is very high,because when ever resource table having large amount of data to fetch data using cursors that is degrade performance of the application,to improve performance of the application then we are using bulk collect,limit is an optional clause using in cursor fetch statement with bulk collect clause. Bulk collect reduces the context switching between the SQL and PL/SQL engines .. thereby increasing performance.. we can reduce the context switch to one but in case of very large data set. it's must that you use limit clause to manage t