1. What is different between TRUNCATE and DELETE? The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data removed by TRUNCATE. Truncate is a DDL statement whereas DELETE is a DML statement. 2. What are ORACLE PRECOMPILERS? A precompiler is a tool that allows programmers to embed SQL statements in high-level source programs like C, C++, COBOL, etc. The
Words: 3117 - Pages: 13
ORCL) specializes in developing and marketing enterprise software products particularly database management systems. Through organic growth and a number of high-profile acquisitions, Oracle enlarged its share of the software market. By 2007 Oracle ranked third on the list of largest software companies in the world, after continued Chapter 5 Case 1 Maruti suzuki Business intelligenCe and enterprise dataBases 2 Microsoft and IBM. Subsequently it became larger than IBM after its acquisition of Hyperion
Words: 595 - Pages: 3
NOTE:Relational datastructures LOGIN is in 3NF,data structure STAFF satisfies 1NF and 2NF to satisfy 3normalisation form table should decompose into 2 ,2nd table containing code and phoneno,similarly in TICKET database structure cost is dependant on flightinformation so it should decomposed,remaining database structures CUSTOMER,INSURANCE,PAYMENT is in 3rd normalisation form(3NF). ASSUMPTIONS LOGIN: Staff should have mandatory login id and password to enter into reservations site of AAA travels and to
Words: 456 - Pages: 2
Week 2 Homework The following practice may need to be completed using the databases hosted on wmc3317-2 using WB. Use WB whether you are running queries or creating a relational schema (a data model, essentially). 1. Database: ‘bigpvfc’. Copy/paste your SQL queries below after testing that they work. a) List each customer name, address and the number of orders each has placed. (use tables: customer_t, order_t) SELECT customeraddress, customername, COUNT(*) AS number_of_orders FROM customer_t
Words: 341 - Pages: 2
This is an OPEN book examination. Personal copies of textbook, supplementary book and class notes can be used but NOT shared. Practice Question -01 Consider the above E-R diagram, which models an online bookstore. a. List the entity sets and their primary keys. b. Suppose the bookstore adds music cassettes and compact disks to its collection. The same music item may be present in cassette or compact disk format, with differing prices. Extend the E-R diagram to model this addition, ignoring the
Words: 1214 - Pages: 5
1) You need to design a new Access database. The first step is to organize the smallest to largest data, also called: D) Hierarchy of data. 2) Access is a relational database, which means that the data are organized into a collection of related: C) Tables. 3) In Access, a collection of numbers and/or characters that describes one aspect of a business object or activity is called: C) A field. 4) A pre-designed database that contains various pre-built objects is called: A) A template
Words: 305 - Pages: 2
IS 337 Midterm Exam for Database Applications http://homeworkfy.com/downloads/is-337-midterm-exam-for-database-applications/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) The ____ operator selects records that match at least one of two or more conditions in a query The ____ data type can store field values containing up to 65,535 characters A ____________________
Words: 482 - Pages: 2
redundancy. Relational DataBase tables – relational model emerged due to list problems. It is a collection of separate tables. Table holds data for only one theme, not multiple. When evaluating a database design, consider mod actions: insert/delete/update. Structured Query Language SQL – leading tech for data definition and manipulation. Can reconstruct lists from their underlying tables, query for specific data conditions, perform computations, can update/delete/insert data. Database System four components:
Words: 2798 - Pages: 12
DATABASE MANAGEMENT CONCEPTS 1. The DBA asks for your help in planning the data archive for the following Premiere Products database: Rep (RepNum, LastName, FirstName, Street, City, State, Zip, Commission, Rate) Customer (CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum) Orders (OrderNum, OrderDate, CustomerNum) OrderLine (OrderNum, PartNum, NumOrdered, QuotedPrice) Part (PartNum, Description, OnHand, Class, Warehouse, Price) Determine
Words: 471 - Pages: 2
companies and individuals. The database system we use is called Ginger, a custom database designed to achieve the following objectives for our company: 1. Replace our old database. 2. Combine date from the old database. 3. Improve usability of the database by improving performance and stability. 4. Make modifications to the design of the database that will enable it to adapt to the changing needs of our home sales office. Ginger was created with the 4th Dimension Database platform that is a powerful
Words: 495 - Pages: 2
