Technology Sharing

How to Learn the Art of Articulation

2023-08-25T17:08:00.004-07:00

Articulation is the ability to express thoughts, ideas, and information clearly and effectively. It involves using appropriate language, tone, and structure to convey your message. Here are some strategies to help you learn the art of articulation:1. Improve Your VocabularyExpand your vocabulary by reading widely and purposefully. Expose yourself to different genres, styles, and types of writing.

Art of story telling

2023-08-25T16:53:00.006-07:00

Storytelling is a powerful tool that can greatly influence communication and engagement within an IT company. It allows for the effective transmission of ideas, experiences, and information in a relatable and memorable manner. Here are some key elements of the art of storytelling in an IT company:1. Context and RelevanceWhen sharing a story within an IT company, it is crucial to establish the

Hands On PL/SQL

2023-08-25T15:55:00.006-07:00

Look, we all have limited time on our hands. And we’re getting closer to the interview date every single minute. That shouldn’t scare. That should motivate you!Time is limited, that’s why we must do the things we want: Today with proper planning ."Hands On PL/SQL" book can guide you to achieve success in your next interview. This book covers PL/SQL interview experiences, questions

pivot and unpivot in sql server

2022-06-09T14:09:00.001-07:00

---PIVOT EXAMPLE Drop table Students;CREATE TABLE Students( Id INT PRIMARY KEY IDENTITY, StudentName VARCHAR (50), Course VARCHAR (50), Score INT);INSERT INTO dbo.Students(StudentName,Course,Score) VALUES ('Abhishek', 'English', 95 )INSERT INTO Students VALUES ('Abhishek', 'History', 82)INSERT INTO Students VALUES ('Nayan', 'English', 45)INSERT INTO Students VALUES ('Nayan', 'History',

Pipeline function in oracle

2022-06-09T14:08:00.000-07:00

--Q: what is pipeline function : --Q: What is pipe rows --Q: why return is empty ?drop type country_type force ---1 create the object type create or replace type country_type as OBJECT (country_id char(2), country_name VARCHAR2(100));---2 create the object of that type (step1) create or replace type country_table_type as TABLE OF country_type;---3 create the

Tricky Oracle Interview Question

2021-10-01T05:20:00.001-07:00

we can achieve the above functionality by using DEFERRABLE INITIALLY DEFERRED as belowCREATE TABLE TAB1(C VARCHAR2(5) PRIMARY KEY);CREATE TABLE TAB2(C VARCHAR2(5) PRIMARY KEY);ALTER TABLE TAB1 ADD CONSTRAINT TAB1_FK FOREIGN KEY(C) REFERENCES TAB2(C) DEFERRABLE INITIALLY DEFERRED;ALTER TABLE TAB2 ADD CONSTRAINT TAB2_FK FOREIGN KEY(C) REFERENCES TAB1(C) DEFERRABLE INITIALLY

Oracle Interview Question Bank

2021-08-23T00:56:00.009-07:00

Oracle Interview Question BankHere is the below oracle interview question commonly asked in many MNC company . Try to prepare it before appearing for an interview you can refer HAND ON SQL for interview question and answer .1. What is an RDBMS ? what are different Database models ? 2.

Oracle Database Performance Tuning Tips and Tricks

2021-04-19T05:29:00.007-07:00

What is Database Tuning?Database tuning is a group of activities used to optimize the performance of a database. Goal Of Database Tuning? To maximize use of system resources To perform task as efficiently To work rapidly as possible Why and when should one tune? Slow Physical I/O: -caused by poorly-configured disks -caused by unnecessary physical I/O -caused by poorly-tuned SQL.

Procedure Example using cursor

2021-01-05T07:37:00.004-08:00

Problem Statement : 1. Create a procedure using cursor that will show the names of all banks and providers that are using these bank and count how many providers are for each bank.For example,Transilvania BANK_________ProfessionalCiocoFidesco2 providersDiagram : Procedure Script : ---create the procedure CREATE OR replace PROCEDURE pr_get_provdr_name (i_bank_name

SQL INTERVIEW QUIZ SET:-3

2021-01-04T10:01:00.003-08:00

Before submitting please remember below two points :- 1.In section 1 please enter your valid mail ID else you won't be able to submit the quiz and view the score of the quiz. 2.In section 2 please enter student details. If you enjoy giving this quiz and found it useful? If so, please share it with your friends. Note : If anyone is interested for demo interview then you can drop your CV to

ODD MAN OUT : SET 1

2020-10-11T14:10:00.005-07:00

Hands On SQL

2020-09-29T12:06:00.002-07:00

Look, we all have limited time on our hands. And we’re getting closer to the interview date every single minute. That shouldn’t scare. That should motivate you!Time is limited, that’s why we must do the things we want: Today with proper planning ."Hands On SQL" book can guide you to achieve success in your next interview. This book covers SQL interview experiences, questions and answers for

Find the number of unique days each employee worked ?

2020-04-06T13:42:00.002-07:00

Problem Statement : Find the number of unique days each employee worked ? Table Name : unq_days Expected Output : Script to Populate the Above sample table Data : create table unq_days( emp_id number, task_id number, start_dy varchar2(20), end_dy varchar2(20) ); insert into unq_days values(2,1,'Tuesday','Wednesday');

C INTERVIEW QUIZ SET:-2

2020-01-19T11:01:00.002-08:00

Data Structure and Algorithm

2019-12-28T11:21:00.000-08:00

SQL INTERVIEW QUIZ SET:-2

2019-12-21T07:26:00.001-08:00

Mobile App Development Setup

2019-11-28T10:12:00.001-08:00

In this section will cover the list of software and download link which are required to build a mobile apps as well as hybrid apps development using ionic. Part 1 : Downloading the Prerequisites 1.Node.js : https://nodejs.org/en/download/ To check the installation execute the command node -v 2.VS Code : https://code.visualstudio.com/download 3. Android Studio : https://

Export Import Schemas level using data pump

2016-10-10T09:13:00.004-07:00

In the previous section we have done Table level export import now we will do the schema level import export . We will use the directory which we have already created in table level export section. Please visit the below link for Table level export import: Tables Export Import and follow the steps 2,3,4 if you are have not created any directory else you can use your created

Export Import Schemas level using data pump

2016-10-10T09:13:00.002-07:00

Export Import Table level using data pump

2016-06-05T12:27:00.000-07:00

In this section will do Hands on Export Import Table level using data pump. Step 1: Create a copy of the employees table under the HR schema CREATE TABLE EMP2 AS SELECT * FROM EMPLOYEES; Step 2. Create directory at the OS Level D:\data_pump_dir Step 3. Create a DIRECTORY at DB level CREATE DIRECTORY testdir AS 'D:\data_pump_dir'; Step 4:Give Read /Write to User system GRANT

XML file data loading using EXTERNAL TABLE

2016-02-12T13:26:00.000-08:00

Today we will learn about how to use the external table to load the xml data file . Before going to for the steps lets discuss about What is External Table ? An external table is database object in which table structure and definition are stored inside the Oracle but the data as the name suggest reside outside the oracle . The External table enable us to access the external data and &

Generating the AWR Report

2015-07-17T09:55:00.000-07:00

In this section we will learn about how to generate awr report but before generating lets discuss something about AWR Report . One day i asked my DBA friends how you all are get to know about your database performance statistics and Workload .So they said oracle itself collecting all this statistical data automatically in every hours wise and we collect the information from

Table Name from Rowid

2014-10-11T09:36:00.001-07:00

In this section we will learn about . How we can get the Table Name from Rowid? Before going to get the answer of the above question lets have a quick review on Rowid. ROWID: Rowid is a pseudocolumn that returns the address of the row. A rowid value uniquely identifies a row in the database. The rowid is intended to be immutable (that is, unchangeable) and the user should not

Alias name

2014-02-25T09:50:00.001-08:00

A column alias name is an alternative name given to the column in a select statement.It is used to rename a column heading in select statement and it allows the user to understand the output easily. Syntax: Select column_name AS "Alias Name" from table_name ; The keyword AS used between the column name and alias name is optional.we can

Merge statement

2014-02-24T10:34:00.001-08:00

In oracle 9i Release 2, Merge statement is introduced to select rows from one or more source for update or insertion into one or more tables .Merge statement have the ability to delete rows,as well as update and insert them So it is also known as "UPSERT" Useful in data warehousing . Increases performance and ease of use Syntax: MERGE