Welcome

welcome...

No comments

Posted at 03:54 |  by Pritam

How to Create SCOTT Schema and default tables in Oracle Database 11g

If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database.

• Open the sql plus in your system.
• Login as username : sys as sysdba and the password which is given at the time of installation.
• After connected to Oracle database you need to create the scott schema.

         Run this script:

                  CREATE USER scott IDENTIFIED BY tiger;

                 scott is the user
                 tiger is the password.

          Grant all access to user scott,run this script:
                 GRANT ALL PRIVILEGES TO scott;

• Download the Oracle default tables file: Click here

• Extract the downloaded file in your system.

• Then Connect to Scott user as:

                 CONNECT scott

                 Password: tiger

• Then type this in your sql command prompt:

              @(extract file path)\oracle.sql;
              for example:
             @C:\Users\ABC\oracle\oracle.sql;

• Now you done all the steps completely and you can work with scott schema and all the default tables.

• Check This in your system to show all the tables in scott user:

             Select * from tab;

• After that you can see all the default table in scott user.

         Just run it to show the default data inside the tables.
            Select * from emp;

If 14 row selected....Then You sucessfully Created the scott schema and the default Oracle tables in your
system.


Like and subscribe this video:
http://www.youtube.com/watch?v=vHcAs7k93AQ

No comments

Posted at 09:06 |  by Pritam

How to Install and Configure Oracle Database 11g Release 2

Welcome to the tutorial series of ORACLE DATABASE 11G Release 2 . Here i am pritam kumar , will guide you on different topics you need to learn about ORACLE DATABASE 11G Release 2. I am putting my whole effort in making this series a learn-able one for beginners who i assume dont have any idea about this .

In this video the complete installation process of Oracle Database 11g R2 is shown . I have made it from the very beg ginning .Starting from downloading the software from the official website of Oracle up to Installing  all the required things. Just do the steps shown in the video and  install the oracle database on your windows OS.Make sure that you are following my steps and not skipping anything , because in some  part if  you miss a step then the installation may show you some errors and will again ask you to install from the beginning .

While  installing the oracle database , it  should create a database automatically after the installation of the software but if some error occurs then it will not create the database . Then you have to make the database manually which i have shown you on the video , I have tried to cover all the context required but if i missed anything or you do have any questions feel free to contact us by putting a comment below the video.

Download the software from:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

No comments

Posted at 08:56 |  by Pritam

Introduction to Oracle Database 11g 1Z0 015 SQL Fundamentals 1

A Complete Tutorial Series on Oracle 11g , SQL Quries,Basic Fundamentals on Database and all the related Topics.

If you want any details you can contact us here by putting a comment below this video.

No comments

Posted at 08:50 |  by Pritam

Latest Movies Songs

Sl No.

Download Link

Movies

1

Download

2

Download

3

Download

4

Download

5

Download

6

Download

7

Download

8

Download

9

Download

10

Download

No comments

Posted at 22:58 |  by Pritam

TURKEY TANDOORI

Description: turky cooked with tandoori marination in the oven .any meat preperation really goes well when we cook in tandoori style because the yogurt and the spices which are applying to the turkey it makes the dish tasty and juicey .

RECIPE OF TURKEY TANDOORI

Ingredient Name	Quantity	Unit
Turkey Legs	4	Numbers
Curd	1	Cup
Red Chill Powder	1	Teaspoons
Turmuric	picnch	Pinch
Coriander Powder	1	Teaspoons
Cumin Powder	1/2	Teaspoons
Ginger Garlic Paste	1	Teaspoons
Lemon Juice	1	Numbers
Garama Masala	pinch
Red Coulou	pinch	Pinch

DIRECTIONS

1. Take turkey legs slit the legs so that marination goes in 
2. Take a pan add curd, red chill powder, turmeric,coriander powder,cumin powder,ginger garlic paste,kasturi methi powder,lemon juice,garam masala powder and mix well and some red colour and mix again.
3. Now marinate this to turkey legs leave it for 30min a side. 

No comments

Posted at 20:56 |  by Pritam

HAWAIIN CHICKEN SANDWICH

Description: Sandwich is a quickly snack made of boiled chicken pieces mixed with yummy mayonnaise sauce served on a bed of fresh salad greens with pineapple pieces placed between fresh bread rolls or croissants.

RECIPE OF HAWAIIN CHICKEN SANDWICH

Ingredient Name	Quantity	Unit
Bread Roll Or Croissant	1	Numbers
Celery	15	Grams
Pineapple	30	Grams
Mayonaise	20	Grams
Chicken Cooked	100	Grams
Lettuce	1	Leaf
Shredded Cabbage	15	Grams

DIRECTIONS

mix chicken,pineapple,celery ,with mayonasie and put it on bed of lettuce and bread

No comments

Posted at 20:46 |  by Pritam

Java Language Interview Question and Answers : 5

21.	What are wrapper classes?
	primitive data types may be converted into object types by using the wrapper classes contained in the java.lang package. Exampes : int, float, long, char, double

22.	What is the difference between an instance variable and a static variable?
	Class variables are called static variables. There is only one occurrence of a class variable per JVM per class loader.When a class is loaded the class variables are initialized. Instance variables are non-static and there is one occurrence of an instance variable in each class instance.Also known as a member variable or a field.

23	Where and how can you use a private constructor?
	Private constructor is used if you do not want other classes to instantiate the object and to prevent subclassing.The instantiation is done by a public static method (i.e. a static factory method) within the same class.

24.	What is type casting?
	Type casting means treating a variable of one type as though it is another type. Examples : int m = 5; byte n =i;

25.	What is a user defined exception?
	User defined exceptions may be implemented by defining a new exception class by extending the Exception class. <<<PREV                                                                                              NEXT>>>

No comments

Posted at 04:56 |  by Pritam

Java Language Interview Question and Answers : 4

16.	What is an array?
	Array is a group of related data items that share a common name.For instance, we can define an array name salary to represent a set of salaries of a group of employees. Examples : salary[10]

17.	What is a list iterator?
	The List and Set collections provide iterators, which are objects that allow going over all the elements of a collection in sequence. The java.util.Iterator interface provides for one-way traversal and java.util.ListIterator is an iterator for lists that allows the programmer to traverse the list in either direction (i.e. forward and or backward) and modify the list during iteration.

18

What is the main difference between a String and a StringBuffer class?

String is immutable : you can’t modify a string object but can replace it by creating a new instance. Creating a new instance is rather expensive. StringBuffer is mutable : use StringBuffer or StringBuilder when you want to modify the contents. StringBuilder was added in Java 5 and it is identical in all respects to StringBuffer except that it is not synchronized,which makes it slightly faster at the cost of not being thread-safe.

19.	When to use serialization?
	A common use of serialization is to use it to send an object over the network or if the state of an object needs to be persisted to a flat file or a database.

20.	What is the main difference between shallow cloning and deep cloning of objects?
	Java supports shallow cloning of objects by default when a class implements the java.lang.Cloneable interface. Deep cloning through serialization is faster to develop and easier to maintain but carries a performance overhead. <<<PREV                                                                                                  NEXT>>>

No comments

Posted at 04:52 |  by Pritam

Java Language Interview Question and Answers : 3

11.	What is an abstract class?
	Abstract class is a class which contain one or more abstract methods, which has to be implemented by sub classes. An abstract class can contain no abstract methods also i.e. abstract class may contain concrete methods.

12.	what are class variables
	Class variables are global to a class and belong to the entire set of objects that class creates. Only one memory location is created for each variable.

13.	What is the Collection interface?
	The Collection interface provides support for the implementation of a mathematical bag - an unordered collection of objects that may contain duplicates.

14.	What must a class do to implement an interface?
	The class must provide all of the methods in the interface and identify the interface in its implements clause.

15.	What is the Collections API?
	The Collections API is a set of classes and interfaces that support operations on collections of objects. <<<PREV                                                                                               NEXT>>>

No comments

Posted at 04:49 |  by Pritam

Java Language Interview Question and Answers : 2

6.	What is variables and then types?
	Variables is an identifier that denotes a storage location used to store a data values.unlike constants that remain unchanged during the execution of a program, a variable may takes different values at different times during the execution of the program. Instance variables Class variables Local variable Parameters

7.	what is dot operator?
	The dot operator(.) is used to access the instance variables and methods of class objects.It is also used to access classes and sub-packages from a package. Examples :  Person1.age ---------> Reference to the variable age

8.	Define strings?
	Strings represent a sequence of characters.The easiest way to represent a sequence of characters in java is by using a character array.

9.	What is serialization?
	Serialization is the process of converting a objects into a stream of bytes.

10.	What are different types of access modifiers?
	Access specifiers are keywords that determine the type of access to the member a class. Public Protected Private Default <<<PREV                                                                                             NEXT>>>

No comments

Posted at 22:26 |  by Pritam

Java Language Interview Question and Answers :1

1.	What is Java?
	A high-level programming language developed by Sun Microsystems. Java was originally called OAK, and was designed for handheld devices and set-top boxes. Oak was unsuccessful so in 1995 Sun changed the name to Java and modified the language to take advantage of the burgeoning World Wide Web.

2.	what are the main features of java?
	The main features of java are Compiled and Interpreted Object oriented Robust and secure Type safe High Performance.

3.	What are pass by reference and passby value?
	Pass By Reference means the passing the address itself rather than passing the value. Passby Value means passing a copy of the value to be passed.

4.	What is the Java API?
	The Java API is a large collection of ready-made software components that provide many useful capabilities, such as graphical user interface (GUI) widgets.

5.	What is the Java Virtual Machine (JVM)?
	The Java Virtual Machine is software that can be ported onto various hardware-based platforms.                                                                                                                  NEXT>>>

   

No comments

Posted at 22:15 |  by Pritam

C++ Interview Question and Answers : 5

21.	What is the difference between macro and iniine?
	Inline follows strict parameter type checking, macros do not. Macros are always expanded by preprocessor, whereas compiler may or may not replace the inline definitions.

22.	How variable declaration in c++ differs that in c?
	C requires all the variables to be declared at the beginning of a scope but in c++ we can declare variables anywhere in the scope. This makes the programmer easier to understand because the variables are declared in the context of their use.

23.	What is multiple inheritance?
	A class can inherit properties from more than one class which is known as multiple inheritance.

24.	what is the use of virtual destructor in c++?
	A destructor is automatically called when the object is destroyed. A virtual destructor in C++ is used primarily to prevent resource leaks by performing a clean-up of the object.

25.	What do you mean by reference variable in c++?
	A reference variable provides an alias to a previously defined variable. Data -type & reference-name = variable name

                <<<PREV                                                                                                       NEXT>>>

No comments

Posted at 22:05 |  by Pritam