David Lentz 27 January, 2004 CCIS2701 – Database Design and SQL Chapter 1 Review Questions Page 1 of 3 1. Discuss each of the following terms: a. data - Data are raw, unprocessed facts about a thing. They have little meaning unless organized. b. field – A field is a group of characters with a specific meaning, used to store data c. record – A connected set of fields. A record containes fields used to describe a specific person, place, thing or event. d. File – A collection
Words: 966 - Pages: 4
Entity | Attribute | Data type | Time | DateDate descriptionMonthMonth descriptionYearWeekWeek description | DATE_ID: INTEGERDATE_DESC: VARCHAR(30)MONTH_ID: IINTEGERMONTH_DESC: VARCHAR(30)YEAR: INTEGERWEEK_ID: INTEGERWEEK_DESC: VARCHAR(30) | Product | Product IDProduction DescriptionCategoryCategory descriptionUnit priceCreated | PRODUCT_ID: INTEGERPROD_DESC: VARCHAR(50)CATEGORY_ID: INTEGERCATEGORY_DESC: VARCHAR(50)UNIT_PRICE: FLOATCREATED: DATE | Sales | Store IDProduct IDDateItems soldSales
Words: 381 - Pages: 2
1.0 COMPANY BACKGROUND MYDIN is one of the supermarket which is very popular in Malaysia. MYDIN was established by Mr. Mydin Mohamed. Before start this business, he is a general merchant hawker in Penang. In 1956, he removes to Kelantan and introduced his first shop in here. Nowadays, MYDIN has so many branches that are expanded all around country. MYDIN business activity is in retailing and wholesaling. The products range from food line, household, soft-lines and hard-lines items. Hard-line
Words: 1033 - Pages: 5
Oracle DBA Interview Questions and Answers Compiled By Mohamed Fowjil Abdul Hameed Contents Oracle DBA Interviews - Overview 2 Oracle DBA Interview Questions and Answers – ARCHITECTURE 4 SENIOR ORACLE DBA INTERVIEW QUESTIONS 31 MID LEVEL ORACLE DBA INTERVIEW QUESTIONS 57 Oracle 11g Database New Features Interview Questions and Answers 65 Oracle RAC Interview Questions and Answers 70 Oracle RAC Interview Questions (10g) Questions and Answers 137 Oracle Data Guard Interview
Words: 97621 - Pages: 391
Larry Ellison is the founder and CEO of the enterprise software company Oracle Corporation. He is also a well-known American billionaire and philanthropist. Lawrence Joseph Ellison, better known as Larry Ellison, was born in New York City on August 17, 1944 to a young unwed Jewish mother. In order to provide her son with a better upbringing, Ellison's mother gave him to Lillian Spellman Ellison and Louis Ellison, her aunt and uncle in Chicago. They formally adopted Ellison when he was only nine months
Words: 1026 - Pages: 5
relation is called the: Select one: a. primary key b. foreign key c. alternate key d. candidate key Question 4 The first hierarchial DBMS was ____ and was released by IBM in 1968? Select one: a. IMS (Information Management System) b. SQL c. DB2 d. Oracle Question 5 What is a field that uniquely describes each record? Select one: a. Composite Key b. Foreign Key c. Primary Key d. None of the Above Question 6 The number of attributes in a relation is known as: Select
Words: 4344 - Pages: 18
| | |SQL for Business | Copyright © 2010, 2009, 2008, 2007, 2006 by University of Phoenix. All rights reserved. Course Description This course covers Structured Query Language (SQL) that provides a unified language that lets you query, manipulate, or control data in a business applications environment. Policies
Words: 2401 - Pages: 10
financial systems, and applications including a genealogical database SQL: Created by Donald D. Chamberlim and Rayman F. Boyce around 1974, this was Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language. The two saw the potential of the concepts described by Codd, Chamberlin, and Boyce, and developed their own SQL-based RDBMS with aspirations of selling it to the U.S. Navy, Central Intelligence Agency
Words: 1226 - Pages: 5
INSERT - insert data into a table * UPDATE - updates existing data within a table * DELETE - deletes all records from a table, the space for the records remain * MERGE - UPSERT operation (insert or update) * CALL - call a PL/SQL or Java subprogram * EXPLAIN PLAN - explain access path to data * LOCK TABLE - control concurrency DCL DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used
Words: 2240 - Pages: 9
problems with business-to-consumer e-commerce has been accuracy of data," Hammer says. "Some consumers were finding that they could not reliably order from online retailers, and that really hurt the business.” ETI recently introduced Accelerator for SQL/Teradata, which speeds the transformation and exchange
Words: 1255 - Pages: 6
