What are the different Oracle versions?

Posted on July 10, 2020August 27, 2020 by Ankush Verma

Introduction: Oracle is a Relational Database Management System (RDBMS) available in various versions. In this article I am going to tell you various Oracle versions and features. Oracle RDBMS is providing all the features to perform online transaction processing and data where housing. Every new oracle version comes with new features. Any software is not a final product. There is always a scope for improvements. That’s why there is a need to understand the Oracle versions ...

How long does it take to learn SQL in 2020?”

Posted on July 8, 2020August 29, 2020 by Ankush Verma

Introduction Look at the title it is “How long does it take to learn SQL in 2020?” It could be only “How long does it take to learn SQL ? Why 2020 is attached to make it How long does it take to learn SQL in 2020?” ? In this modern era of online learning methodology, there are several websites providing online SQL engine where you can experience more interactive way of learning and practicing. Few online ways available for learning are Smarter way of learning Video Le...

Find the Fibonacci Series in python and Factorial of a Number in python

Posted on July 7, 2020July 11, 2020 by Ankush Verma

Fibonacci Series in python Fibonacci Series in python-In this article, we're going to start talking about finding the Fibonacci series in python and the factorial of a number in Python. So to begin with the Fibonacci numbers is a fairly classically studied sequence of natural numbers. The 0th element of the sequence is 0. The first element is 1. And from thereon, each element is the sum of the previous two. So 0 and 1 is 1. 1 + 1 is 2. 1 + 2 is 3. 2 + 3 is 5. And the sequence continues, 8...

20 Best Online Jobs from home –No investment (Earn 50,000 per month)

Posted on July 6, 2020July 13, 2020 by Ankush Verma

Online jobs from home Online jobs from home is not a new term but after the lockdown period imposed by COVID-19, most of the people are looking for online jobs work from home. Nowadays people are preferring work from home. There are various ways to earn money by online jobs. You can earn up to 50000 INR per month without any investment. You just have to arrange a laptop and internet connection. Now I am going to tell you 20 best onli...

What is TRP full form?

Posted on July 3, 2020July 5, 2020 by Ankush Verma

1. TRP full form TRP full form-All the Television Viewers must have heard this term that is Television Rating Point (TRP). But very few know about this term. you will be knowing all about the TRP such as What is TRP?How TRP is calculated?What is the Role of TRP in making money? Very few people know the full form of TRP. It’s full form is Television Rating point. In this modern era of business world, every factor which affects business directly or indirectly, is deeply analyzed for f...

Python Flask framework and Django framework

Posted on July 3, 2020July 3, 2020 by Ankush Verma

What is Flask framework and Django framework: If you are interested in web development using Python then Python flask framework and Django framework is a good choice because both the Framework provides an efficient and elegant way to develop your web application. There is a very popular approach that is used to develop the websites known as model view controller that is MVC architecture. This approach of web development provides many benefits such as your website will be easy to ...

Python strings |lowercase in python|comparison operators

Posted on July 2, 2020July 2, 2020 by Ankush Verma

This article reveals the power of python language to deal with strings, to perform various operations on strings such as how to get strings to be all lowercase in python, and how many characters does a string has in python, and comparison operators. Apart from all that few mathematical functions will also be discussed such as how to compute the absolute value etc. String processing and text analysis are playing vital role in the field of Media and communicationEmotion detection SystemT...

Database Developer Skills and Salary

Posted on June 30, 2020June 30, 2020 by Ankush Verma

Database Developer For any organization, the database is developed and maintained by a professional known as a database developer. A database developer can become a key person of any organization by providing his /her services related to database management and database security. That’s why it is a good carrier option. A database developer is a good job profile in terms of earning handsome amount of money and job security. But this job profile comprises great sense of responsibiliti...

How long does it take to learn coding?

Posted on June 28, 2020July 11, 2020 by Ankush Verma

If you want to build a carrier in the field of computer, there are several options such as Network AdministrationDatabase AdministrationHardwareSoftware Coding means software development. If you want to build your carrier in software development, few questions arises in the mind. How much you can earn being a software developer?How long does it take to learn to code?What is job security?What is the future? How long does it take to learn coding? Answer of the above question is ...

How long does it take to learn python?

Posted on June 26, 2020June 26, 2020 by Ankush Verma

How long does it take to learn python? 1.Python is easy to learn:- Python is very easy to learn because a person has no knowledge of any programming language can learn python. Python supports all the programming paradigms such as structured programming, procedural programming, object-oriented programming, etc. 1.a Example to demonstrate how easy Python is If you compare Python with other languages such as C,C++, and Java you will find that python is easiest. Take the example...

Data types in SQL with example

Posted on June 26, 2020June 28, 2020 by Ankush Verma

In this post you will be told how many types of data types are there in SQL, Let us go into detail, so let's start. When you create a new relation (Table), you specify a data type for each of its columns/attributes. Similarly, when you create a new procedure, you specify a data type for each of its arguments. The data type defines the allowed values that each column or argument can store. For example, a DATE column cannot store a value of March 32, because this is not a valid date. ...

Anomalies in DBMS

Posted on June 22, 2020June 22, 2020 by Ankush Verma

What is Anomalies in DBMS Normalization is necessary if you do not do it then the overall integrity of the data stored in the database will eventually degrade. Specifically, this is due to data anomalies. These anomalies in DBMS naturally occur and result in data that does not match the real-world database purports to represent. Anomalies in DBMS are caused when there is too much redundancy in the database's information. Anomalies can often be caused when the tables that make...

Joins in SQL with Example

Posted on June 7, 2020August 27, 2020 by Ankush Verma

What is Joins in SQL? Joins in SQL combines rows from two or more tables. It creates a set of rows in a temporary table. Joins two or more tables is one of the most powerful features of relational systems. In fact, it is the availability of the Join operation, almost more than anything else that distinguishes relational from non- relational systems. So what is a Joins in SQL? With the help of join, we can retrieve data from more than one table. If we required data from more than on...

How to find second highest salary in SQL

Posted on March 12, 2020July 11, 2020 by Ankush Verma

How to find second highest salary in SQL To find the second highest salary in SQL is a very common important interview question. If you are going for the role at the junior level. There are many ways to find the second highest salary in SQL. Some important questions to find the salary are given below. How to find 2nd, 3rd and Nth highest salary in SQL How to find 2nd,3rd and Nth lowest salary in SQL Employees table for this demo Create table Employee(&nbsp...

What is Relational database management system?

Posted on March 3, 2020July 11, 2020 by Ankush Verma

What is a Relational Database Management System? Relational Database Management System Relational DataBase Management System representation of tables only.A relational database refers to a database that stores data in a structured format, using rows and columns.In RDBMS we can store the data in the form of tables.Using this RDBMS we can create databases easily.We can insert the data easily.We can modify the data easily.Using the RDBMS we can perform all operations on the table. In relatio...

What is candidate key in DBMS?

Posted on October 7, 2019August 29, 2020 by Ankush Verma

What is Candidate Key in DBMS? A Candidate Key in DBMS is a minimal set of columns/attributes that can be used to uniquely identify a single/every tuple or row in a relation. Candidate Keys are determined during database design based on the underlying business rules of the database. After finding all possible candidate keys in a relation.DBA choose one key as a primary key. Consider the following relation in the context of a business firm: candidate key E...

Codd Rules for RDBMS | Codd’s 12 rules

Posted on August 1, 2019August 29, 2020 by Ankush Verma

12 Codd Rules for RDBMS:- Codd Rules for RDBMS were given by E.F Codd which should be satisfied by the DBMS to become an RDBMS. Dr. E.F codd describes the relational model in 1970. He has put 12 rules to describing the Relational Model. 12 Codd's Rules for RDBMS:- Dr. E.F codd given 12 codd,s rules which are given below Zero Rule:- For a system to qualify as an RDBMS it must be able to manage its databases entirely through its Relational capabilities Rul...

DISTINCT Command in SQL

Posted on April 11, 2019February 27, 2020 by Ankush Verma

DISTINCT Command in SQL a very important keyword for a select statement In a table. In a particular table, columns may contain duplicate or repeated values and you want to fetch only distinct values from the table. The DISTINCT keyword can be used to return only distinct (different) values. for eg: in a city column if New york exists more than one time than with the help of the distinct keyword we eliminate duplicate values for the city column. Some key points are given below- DISTINCT ...

DML Commands in SQL

Posted on April 8, 2019February 26, 2020 by Ankush Verma

Data manipulation language(DML Commands) is a core part of SQL. When you want to add, update and delete data in the database then we execute a DML statement. SQL is divided into mainly four sub-languages and Data manipulation language is one of them. So there are four DML commands which are given below:- INSERT - Add a new row to a tableUPDATE - Modify existing rows in a tableDELETE - Remove existing rows in a tableSELECT - To retrieve particular rows from the table. CREATE TABLE Cust...

DBMS Assignment-Level-1

Posted on April 4, 2019August 31, 2020 by Ankush Verma

Create table Vendors as follows: Ven_id Ven_name Contact Street City Salary Dept_id 1 Ratna 9044670000 Rajiv Chowk Delhi 30000 A01 2 Anjali 9839780000 Vijay Nagar Kanpur 21000 A01 3 Rahul 9532890000 Model Town Delhi 35000 B02 4 Ankit 7522900000 Rajajipuram Lucknow 24500 C03 5 Sumit 7271000000 Ramadevi Kanpur 26000 B02 6 K...

Database Interview Questions Answers

Posted on April 3, 2019August 31, 2020 by Ankush Verma

What is a database? A database is a logically coherent collection of data with some inherent meaning, representing some aspect of the real world and which is designed, built and populated with data for a specific purpose. What is DBMS? It is a collection of programs that enables the user to create and maintain a database. In other words, it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applicat...

SUB QUERIES in SQL/Oracle

Posted on April 3, 2019June 8, 2020 by Ankush Verma

A subquery is a query within a query for the same or different table.The inner query is enclosed in parentheses ().The result of the inner query would be given as input to the outer query.Subqueries enable you to write queries that select data rows for criteria that are actually developed while the query is executing at run time.Sub-queries can be used in SELECT, FROM, WHERE and HAVING clauses. There are four broad divisions of subqueries: - Single-row subqueries: Subquery which r...

Primary key in SQL

Posted on March 16, 2019August 30, 2020 by Ankush Verma

A primary key is a one-column or combination of the column with a unique value for each row or tuple. The value of the primary key must be unique within the table. The purpose is to bind data together, across tables, without repeating all of the data in every table. It enforces two restrictions on the column - First is Unique value and second is Not null A primary key is the candidate key that is selected to uniquely identify a tuple in a relation. The mandatory and desired attributes...

Operating System Multiple Choice Questions Set-6

Posted on October 31, 2020November 4, 2020 by Ankush Verma

1.Which of the following process scheduling algorithm may lead to starvationA.FIFOB.Round RobinC.Shortest Job NextD.None of the aboveAnswer-C If the quantum time of round robin algorithm is very large, then it is equivalent to:(A) First in first out(B) Shortest Job Next(C) Lottery scheduling(D) None of the above Answer: (A) 3.Orders are processed in the sequence they arrive if _ rule sequences the jobs.a) earliest due dateb) slack time remainingc) first come, first servedd) critical ra...

Operating System Multiple Choice Questions Set-5

Posted on October 30, 2020November 4, 2020 by Ankush Verma

What is a long-term scheduler?a) It selects which process has to be brought into the ready queueb) It selects which process has to be executed next and allocates CPUc) It selects which process to remove from memory by swappingd) None of the mentioned Answer: (a) If all processes I/O bound, the ready queue will almost always be _ and the Short term Scheduler will have a _ to do.a) full, littleb) full, lotc) empty, littled) empty, lotAnswer: (c)What is a medium-term scheduler?a) It selects ...

What is Deadlock in DBMS and OS

Posted on October 29, 2020October 29, 2020 by Ankush Verma

A deadlock in DBMS and OS is a condition wherein two or more processes or transactions are waiting for each other in order to be finished but none of the processes or transactions are willing to give up the resources that the other processes need. In this situation, no processes ever get finished and are in the waiting state forever. Deadlock Deadlock Characterization Deadlock can arise if four conditions hold simultaneously. Mutual exclusion: Only one process at...

Vault Configuration and deployment

Posted on October 2, 2020October 2, 2020 by Ankush Verma

Vault is a tool for securely accessing secrets. A secret is anything that you want to tightly control access to, such as API keys, passwords, or certificates. Vault provides a unified interface to any secret, while providing tight access control and recording a detailed audit log. Vault Component Storage Backend: It configures the location for the storage of vault data.Secret Engines: It stores, generates, or encrypts data. Many secret engines can be enabled and used as needed. Secret eng...

Operating System Multiple Choice Questions Set-4

Posted on September 22, 2020November 4, 2020 by Ankush Verma

Dual mode of operating system has a.1 modeb. 2 modesc.3 modesd.4 modes Answer: (a) Multi-processor system gives a a.small systemb.tightly coupled systemc.loosely coupled systemd.both a and b Answer: (b) Logical extension of multiprogramming operating system is a.time sharingb.multi-taskingc.single programingd.both a and b Answer: (d) Multiprocessor system have advantage of a.Increased Throughputb.Expensive hardwarec.operating systemd.both a and b Answer: C. S...