Premium Essay

Sample Text

In:

Submitted By princeatoz
Words 2990
Pages 12
STEPS TO ACCESS ORACLE SERVER AND CERTAIN BASIC QUERIES

(Note: To access the oracle server, sometimes it is required to create a cspc1 account. If the username and password step described below doesn’t work then create a cspc1 account from university website at http://cs.uwindsor.ca/password and use those credentials in the steps described below.)

1. First, download “bitvise ssh client” from the university website on your local machine. This is a secure shell required to connect to the oracle server. A link to download this ssh is as follows: bitvise download.

2. Once this SSH is downloaded, connect to the server using the following credentials:
Hostname: cs.uwindsor.ca
Username: enter your unique username (same as that of university website)
Password: enter your unique password (same as that of university website)Port number: usually it is 22.

3. After step 2, you will observe that on connecting to the server, a new terminal window appears on the screen along with the ssh.

4. On this terminal window, which opens with your account information, type in “sqlplus”.

5. Again, the system will ask you for your username and password credentials. Please enter the same.

6. On entering your credentials on the terminal window you will see that you have finally connected to the server and can now try working with all the possible queries you need which are illustrated below.

Now, let us work with tables after we get access to the database server.
We directly need to start with table creation.
(Note: we cannot create databases as the university has a common database for everyone, which is database cs01)

I have used an example table and the commands that can be used to work with these are also explained as follows:

1. Create table syntax:

Similarly, I have made a few more tables and various sql commands can be performed

Similar Documents

Premium Essay

This Is a Sample Text

...Investing in the Indian market India, among the European investors, is believed to be a good investment despite political uncertainty, bureaucratic hassles, shortages of power and infrastructural deficiencies. India presents a vast potential for overseas investment and is actively encouraging the entrance of foreign players into the market. No company, of any size, aspiring to be a global player can, for long ignore this country which is expected to become one of the top three emerging economies worldwide. ------------------------------------------------- Quick Facts about India ------------------------------------------------- On a cumulative basis, the FDI equity inflows received by India stood at US$ 20.92 billion during April-December 2009, according to the latest data released by the Department of Industrial Policy and Promotion (DIPP). ------------------------------------------------- The Prime Minister's Economic Advisory Council (PMEAC) has pegged India's growth at 8.2 per cent for 2010-11 and 9 per cent in 2011-12, expecting the agriculture, industrial and services sectors to perform well through the next two years. ------------------------------------------------- India's industrial output grew at its fastest year-on-year pace in almost two decades at 16.8 per cent in December 2009, signalling a strong recovery. The manufacturing sector that constitutes around 80 per cent of industrial output, expanded by 18.5 per cent to set the pace of growth. ------------------------------------------------- ...

Words: 1035 - Pages: 5

Free Essay

Sample of Persuasive Speech Text

...SPEECH TEXT INTRODUCTION The existence of Internet has obviously given us huge impacts in many aspects including in Education. Today’s students are all lucky since they are all born in high-technology era with numerous of gadgets and things to ease their lives. It is undeniable that Internet has helped us in many ways consistently with the modernised people in this modernisation ages. However, is the education today relies on Internet merely? Is today’s students are too lazy that they trained their brains to take whatever they learned, without the urges to find more? Well, an Irish poet, William Butler Yeats once said, “Education is not the filling of a pail, but the lighting of a fire.” which indicates today’s phenomenon, where many students seems to seek for shortcuts in searching for answers rather than using their minds to be creative in finding solutions. Are you a part of that people? In this case, I am strongly believed that Google Translate is not the best alternative to improve students’ English skills. How many of you used to use Google Translate while doing your assignments? Is anybody here have not used it even once? So today, let me show you why do I believe that Google Translate is not the best alternative for us. Let me give you a picture of the impacts of using Google Translate. BODY First and foremost, students have high degree of tendency to rely merely on Google Translate in understanding and doing assignments. This is due to the fact that...

Words: 970 - Pages: 4

Premium Essay

Pyc3704 Assignment 1

...Assignment One: Data Sheet 1 Kimmy Givins NorthCentral University Dr. Boysen-Rotelli 08/10/2014 Date File 1 Chapter One 1) Determine whether the evaluated group is a population or a sample. a) Based on a randomly selected group of 500 patients with high cholesterol, it was found that 67% have heart disease. Is this a population or a sample; explain your answer. Sample is made up of of the raw data collected from 500 patients which is the sample and 67% is the sample statistics. Bennett, Briggis, & Triola (2009) the raw data is collected from a subnet of patient with high cholesterol (p.3). Which indicate this as a sample from the raw data and sample statistics. b) An investigation of 150 randomly selected local restaurants concluded that 42% of local...

Words: 1907 - Pages: 8

Premium Essay

Sampling Design

...(1) Assign a single number to each element in the sampling frame. – (2) Use random numbers to select elements into the sample until the desired number of cases is obtained. • The method is not very different from winning a lottery. 2. Systematic Sampling • Steps: – (1) Calculate the sampling interval as the ratio between population size and sample size, I = N/n. – (2) Arrange all elements in the population in an order. – (3) Select a case in the first interval randomly. – (4) Select every ith case from this point. 2. Systematic Sampling (continued) I I 1st element, randomly chosen I I I I – Systematic Sampling is easier and simpler than SRS – The text warns of a danger to this method. What is it? 3. Stratified Sampling • Stratified sampling is more complicated than SRS. The advantage is the guaranteed representativeness in some important characteristics. • For example, say that we want to select a sample of 100 individuals. Sex ratio in the sample is up to chance if we do SRS. We can guarantee the 50-50 split if we do stratified sampling: Stratified Sampling, Graphic Representation Population SRS SRS Sample • Stratified sampling is often used to reduce the variability of a sample. Oversampling, Graphic Representation Population SRS SRS Sample • Increasing the representation of a group in a sample. This is often done when groups are very different in size – e.g., race 4. Cluster Sampling • Cluster sampling is...

Words: 921 - Pages: 4

Premium Essay

Home Work

...1.12 What is the difference between a sample and a population? In most studies, it is difficult to obtain information from the entire population. We rely on samples to make estimates or inferences related to the population. Population means the population of the whole area. Sample means a sample of people taken out of the population to be tested or studied. 1.13 What is the difference between a statistic and parameter? The difference between parameter and a statistic is that a parameter is a number obtained by calculation from a population while statistic is a number calculated from a sample. A statistic is usually used to estimate a parameter. 1.22 A Gallup poll indicated that 74% of Americans who had yet to retire look to retirement accounts as major funding sources when they retire. Interestingly, 40% also said that they looked to stocks or stock market mutual fund investments as major funding sources when they retire. (data extracted from D.Jacobs, “Investors Look Beyond Social Security to Fund Retirement,” www.gallup.com, March 28, 2011). The results are based on telephone interviews conducted March 24, 2011, with 1,000 or more adults living in the United States, aged 18 and older. a. Describe the population of interest. They are the Americans that have not retire yet. b. Describe the sample that was collected. They are the 18 and older group of adults. c. Is 74% a parameter or a statistic? Explain. It is a parameter...

Words: 1086 - Pages: 5

Premium Essay

Indian Customer Perception Regarding Multi Brand Cosmetic Stores

...multi brand stores. * To understand the consumer behavior regarding a multi brand cosmetic store, NewU stores. Literature Review Completed: Yes Research Methodology: * The methodology used for the research will be mixed, quantitative and qualitative. * The quantitative research will be used for the analysis of questionnaires responses. * The qualitative research will be used for analysis for the depth interviews responses. Database: * The primary data collection will be done by the questionnaires and the depth interviews. * The secondary data collection will be done by the different sources like internet, text books and reports. Sample Size and Sampling Method: * The sample size for questionnaires is 150. The judgmental sampling method will be used for questionnaires responses. * The sample size for depth interviews will be 10. The stratified sampling method will be used for depth interviews. Research Tools: * The tools used to analyze the quantitative research data will be SPSS for factor analysis. * The tools used to analyze the qualitative research data will be Microsoft Excel to make narrative summary. Status of Progress: During the research process and implementation of previous stated research methodology, I faced some problems and to solve these problems, I have made some changes. To find the factors which affect to make purchase from multi brand cosmetic stores, factor analysis in which factors will...

Words: 468 - Pages: 2

Premium Essay

Business Statistics Assignment

... Student Name: JL ACADEMIC INTEGRITY DECLARATION Breaches of academic integrity (cheating, plagiarism, falsification of data, collusion) seriously compromise student learning, as well as the University’s assessment of the effectiveness of that learning and the academic quality of the University’s awards. All breaches of academic integrity are taken seriously and could result in penalties including failure in the course and exclusion from the University. Students should be aware that the University uses text-matching software to safeguard the quality of student learning and that your assignment will be checked using this software. I acknowledge and agree that the examiner of this assessment item may, for the purpose of marking this assessment item:  reproduce this assessment item and provide a copy to another Griffith staff member; and/  submit this assessment item to a text-matching service. This web-based service will retain a copy of this assessment item for checking the work of other students, but will not reproduce it in any form. Examiners will only award marks for work within this assignment that is your own original work. I, hereby certify that :  except where I have indicated, this assignment is my own work, based on my personal study and/or research....

Words: 2938 - Pages: 12

Premium Essay

Sampling

...Sampling Sampling Third Edition STEVEN K. THOMPSON Simon Fraser University A JOHN WILEY & SONS, INC., PUBLICATION Copyright © 2012 by John Wiley & Sons, Inc. All rights reserved. Published by John Wiley & Sons, Inc., Hoboken, New Jersey. Published simultaneously in Canada. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 750-4470, or on the web at www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permission. Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or...

Words: 10191 - Pages: 41

Free Essay

Customers Satisfaction of Airtel Bangladesh

...Topic Name Customers Attitude towards AIRTEL BANGLADESH Section: I Group: C Submitted To: Dr.Md.Mamun Habib Name ID 1. DAS, AMIT 10-17652-3 2. ISLAM, NABILA 10-17731-3 3. Chapter 1: Introduction 1.1 Introduction of the study: As we know that there are 6 operators in Bangladesh who provide their service in telecommunicating service sector. All the operators are trying to provide the best service. So there is a huge competition is going on between them. From our research we will try to find out the current position of Airtel and the customers satisfaction level. 2. Research Objective: We know that Airtel is one of the leading cellular service providers in Bangladesh. People from all ages are using Airtel. So, our main target is to communicate with all ages people who are using Airtel sim and find out their comment and on the basis of that make an overall comment. 1.3 Scope of Research: ...

Words: 1813 - Pages: 8

Free Essay

Consumer Buying Behaviour Towards Gold Jewellery in India

...A STUDY OF FACTORS INFLUENCING PURCHASE DECISION IN AN ONLINE JEWELRY STORE A STUDY OF FACTORS INFLUENCING PURCHASE DECISION IN AN ONLINE JEWELRY STORE An Independent Study Presented to The Graduate School of Bangkok University In Partial Fulfilment of the Requirements for the Degree Master of Business Administration by Risto-Pekka Myllymäki 2010 © 2010 Risto-Pekka Myllymäki All Right Reserved i Myllymäki, Risto-Pekka. M.B.A. (Master of Business Administration), August 2010, Graduate School, Bangkok University. A study of factors influencing purchase decision in an online jewelry store (63 pp.) Advisor of Independent Study Dr. Paul TJ James ABSTRACT The objective of this study was to find factors influencing purchase decision in an online jewelry store, in order to help Precium Oy Ltd. to prepare its launch of a web store selling silver jewelry. A quantitative online survey was conducted to Finnish Facebook users, who were connected with the owners of Precium Oy Ltd. Out of 502 questionnaires sent, 206 responses were collected in the time of one week. The findings of the study indicate that reliability is the most important upper-level factor influencing purchase decision in an online jewelry store. More detailed factors which create reliability were found, such as familiar payment methods, appearance of the online store and third party recommendations. From the products and services perspective, the appearance of the jewelry was the most important factor influencing...

Words: 18252 - Pages: 74

Premium Essay

Synopsis

...ASMA FATHIMA REG NO: 11SKCMA016 TITLE OF THE STUDY: “A STUDY ON PERFORMANCE MANAGEMENT SYSTEM OF LIFESTYLE INTERNATIONAL PVT LTD” 1. TITLE OF THE STUDY: “A STUDY ON THE PERFORMANCE MANAGEMENT SYSTEM OF LIFESTYLE INTERNATIONAL PVT LTD.” 1.0. INTRODUCTION TO THE STUDY: Performance Management System (PMS) includes activities which ensure that goals are consistently being met in an effective and efficient manner. Performance management can focus on the performance of an organization, a department, employee, or even the processes to build a product of service, as well as many other areas. PMS is also known as a process by which organizations align their resources, systems and employees to strategic objectives and priorities. In organizational development (OD), performance can be thought of as Actual Results vs Desired Results. Any discrepancy, where Actual is less than Desired, could constitute the performance improvement zone. Performance management and improvement can be thought of as a cycle: • Performance planning where goals and objectives are established • Performance coaching where a manager intervenes to give feedback and adjust performance • Performance appraisal where individual performance is formally documented and feedback delivered It is to understand the gap between two things: A performance problem is any gap between Desired Results and Actual Results. Performance improvement is any effort targeted at closing...

Words: 1406 - Pages: 6

Premium Essay

Hamilton Power Tools (a)

...needs, motives, attitude and values at a sub-conscious level. Purpose of research: The research was primarily exploratory to gain insights into reasons why people make certain purchases. Mr. Campagna also wanted to get a flavour of language people use in talking about chain saw. Analysis of method: The research was conducted in states of Illionois and Wisconsin. People who were selected for TAT were screened on basis of whether they planned to purchase a chain saw in next 12 months or already owned a chain saw or had used a chain saw in past. However this was the only information collected, ideally some more information must have been collected regarding their demographics and more regions could have been considered. They restricted the sample to only two states. How should Conway and Baggins respond to Hamilton’s question? Hamilton...

Words: 856 - Pages: 4

Free Essay

Marketing Research

...All of the following data are demographic data except a. income b. age c. education d. residence e. religion * Data Types The following question elicits _____ data. How satisfied are you with the last flight you took with American Airlines? Very Somewhat Neutral Somewhat Very Dissatisfied Dissatisfied Satisfied Satisfied 1 2 3 4 5 a. demographic b. psychographic c. attitude d. behavioristic Types of variables marketing researchers may work with include all of the following except a. nominal b. ordinal c. logistic d. ratio The variable in which numbers serve only as labels to identify or categorize objects or events is the ____. a. nominal variable b. ordinal variable c. interval variable d. ratio variable The following question will result in a ____ variable. Which is your favorite Yogurt brand? __ Yoplait __ Dannon __ Chobani __ Stonyfield __ Other () a. nominal variable b. ordinal variable c. interval variable d. ratio variable Which type of scale is the following question? Please rank the importance of the following product features in your decision to buy a laptop computer. (1=most important, 4=least important) a. Rank order b. Likert scale ...

Words: 679 - Pages: 3

Premium Essay

Argumentative

...200 workers who responded to the survey questionnaires expressed a high level of interest in the topics of corporate restructuring and redesign of benefits programs. However, a critical review of the claim and its premise cast some doubts on the validity of the argument. First, corporate restructuring and redesign of benefit programs is a small part of management issues and thus cannot be used as a basis to say workers have interest in management issues. Second, for workers to have merely indicate on a questionnaire that they have interest in the topics of corporate restructuring and design of benefit programs is not enough to conclude that they actually do it in reality. Finally, a generalization made from the result of a survey with a sample size of 1,200 workers without stating the population size is not adequate. First and foremost, the discussion will touch on the inadequacy of the premise as against the claim. With this, I state that, corporate restructuring and redesign of benefit programs is a small part of management issues and thus cannot be used as a basis to say workers have interest in management issues. Management issues encompass several measures. These are inclusive of spinning of departments into agencies to enhance efficiency, changing of product lines, merging with or acquiring of other firms and so on. Again, the emphasis of benefit programs is so obvious that workers will be concerned with since it directly affect them thereby resulting in the kind of response...

Words: 498 - Pages: 2

Free Essay

Irreg

...INTRODUCTION The Study is entitled “IRREGULAR SUDENTS CAUSES AND EFFECTS TO ITSELF”. The researchers chose this topic because nowadays, the researchers have noticed that there is an increasing population of irregular students. The researchers would like to know what causes them to become an irregular and the effects of being one. STATEMENT OF THE PROBLEM The main Problem is about the causes and effects of being an irregular student. The study seek to solve the following sub-problems: 1. What is the percentage of CITHM Tourism irregular students? 2. What are the causes that make the Tourism students irregular? 3. What are the effects of being an irregular student to the following? a. Grades/Class performance b. Schedule c. Course Completion d. Financially e. Social Life/Classmates 4. What are the actions being implemented by the college to minimize this problem? OBJECTIVES OF THE STUDY 1. To know the percentage of CITHM Tourism irregular Students. 2. To determine the causes that make the Tourism students irregular. 3. To find out the effects of being an irregular student to the following. a. Grades/Class performance b. Schedule c. Course Completion d. Financially e. Social Life/Classmates 4. To know the actions being implemented by the college to minimize this problem. BACKGROUND OF THE STUDY (Discuss the significance of the study, how the study contributes to existing knowledge, social relevance of the study...

Words: 597 - Pages: 3