Browse Article

Home » Articles tagged ‘oracle certification

Learn about Concurrency Protocol in Oracle Certification Courses in Pune

February 9, 2017 | Author: | Posted in Careers

Learn about Concurrency Protocol in Oracle Certification Courses in Pune If you consider multiprogramming environment where various transactions work together at the same time, it is vital to manage the concurrency of dealings. We have concurrency management methods to make sure atomicity, solitude, and serializability of contingency dealings. Concurrency management methods can be subdivided into …

Oracle 11g dba questions for freshers and experienced continued

February 8, 2017 | Author: | Posted in Careers

istinction between SGA and PGA. – SGA (System Global Area) is a storage place assigned during the set up of an instance. – SGA is assigned as 40% of RAM dimension by standard. – SGA dimension is managed by DB_CACHE_SIZE parameter described in initialization parameter file (init.ora details file or SPFILE). – PGA (Program or …

How to do the Oracle patch update?

December 31, 2016 | Author: | Posted in Careers

  How to do the Oracle patch update? Implementing the areas does not take that a lot of your energy,” said Nayak, a mature Oracle program DBA and part of the Oracle Programs Customers Team panel of administrators. “What requires up the most time is the research into choosing the best spot.” The misunderstandings over …

What Does DBA Expect in The Year 2016?

November 1, 2016 | Author: | Posted in Careers

  What does DBA expect in the year 2016? With changes in technological innovation come changes in responsibilities for IT experts, most especially for the DBA. Improved adopting of the reasoning, mobile and big data technological innovation, as well as the increasing approval of the Internet of Things, delivers changes in how programs and data …

What is Undo and Redo in DBA?

November 1, 2016 | Author: | Posted in Careers

What is Undo and Redo in DBA? Opposite is where Oracle records how to reverse a deal (one or more DMLs in a transaction) Redo is where Oracle records how to replay a transaction Undo and Upgrade are published to as the deal continues, not merely at the end of the transaction (imagine a deal …

Top 10 DBA Interview Questions

November 1, 2016 | Author: | Posted in Careers

Top 10 DBA interview questions If you are seriously enthusiastic about either beginning out in relation to becoming a SQL Server Data base Manager or perhaps wish to make a horizontal shift from an alternate IT self-discipline, this exposure can be quite frustrating. You may feel that it is somewhat of no win situation, as …

What are the Codd’s Rules?

October 15, 2016 | Author: | Posted in Careers

What are the Codd’s Rules? These guidelines can be applied on information source program that manages saved information using only its relational abilities. This is a basis concept, which acts as a base for all the other guidelines. Rule 1: Information Rule The information saved in a knowledge base, may it be customer information or meta-data, must …

What are the advantages and disadvantages of DBMS?

October 15, 2016 | Author: | Posted in Careers

What are the advantages and disadvantages of DBMS? A data base management system (DBMS) is an assortment of applications that controls the data base structure and controls accessibility to the information saved in the data base. In a sense, a data base appears like a very well-organized electronic processing cupboard in which powerful software, known …

What is Restoration and Concurrency in Database?

October 15, 2016 | Author: | Posted in Careers

What is Restoration and Concurrency in Database?   What is Restoration and Concurrency in database? Recovery and Concurrency in a DBMS are in the normal subject of deal control. Hence we shall start the conversation by analyzing the essential idea of a deal. Transaction A deal is a sensible device of labor. Consider the following …

Top 12 databases you need to know

October 15, 2016 | Author: | Posted in Computers & Technology

Top 12 databases you need to know There are different kinds of data source which are categorized according to their operate. The top 12 of these which you may come across are: 1.0 Relational Databases This is the most common of all the different types of databases. In this, the details in a relational databases …