06

Satisfactory Essays
Chapter 6: Additional Database Objects

TRUE/FALSE

1. A sequence serves as a nickname for a database object.

ANS: F PTS: 1 REF: 158

2. A database index allows users and application programs to quickly locate specific records.

ANS: T PTS: 1 REF: 158

3. A synonym is an alternate name assigned to a database object.

ANS: T PTS: 1 REF: 158

4. When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

ANS: F PTS: 1 REF: 161

5. When a negative value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

ANS: T PTS: 1 REF: 161

6. The START WITH clause is used to identify the starting numeric value for a synonym.

ANS: F PTS: 1 REF: 161

7. By default, the START WITH clause has a value of one.

ANS: T PTS: 1 REF: 161

8. By default, the lowest value that can be generated by a sequence is 0.

ANS: F PTS: 1 REF: 161-162

9. If the minimum value for a sequence is not specified, then NOMINVALUE will be assumed as the default.

ANS: T PTS: 1 REF: 161

10. The highest possible value for a descending sequence is -1.

ANS: T PTS: 1 REF: 162

11. The highest possible value for a sequence can be specified through the MAXVALUE clause.

ANS: T PTS: 1 REF: 161

12. After the highest possible value for a sequence has been reached, previous values can be reused if the NOCYCLE option has been specified.

ANS: F PTS: 1 REF: 162

13. The NOCACHE option specifies that the sequence can generate a number only after a request has been made by a user.

ANS: T PTS: 1 REF: 162

14. Pre-generated sequence numbers that have not been used when the database is shut down will no longer be available when the database is restarted.

ANS: T PTS: 1 REF: 162

15. When a sequence is created for internal control purposes, the values should not be cached otherwise gaps may appear in the sequence.

ANS: T PTS: 1 REF: 162

16. The

You May Also Find These Documents Helpful

  • Good Essays

    06

    • 865 Words
    • 6 Pages

    www.batabd.com Bata is a trusted name in shoe market all around the world. Bata Shoe Company ( Bangladesh) Ltd. is one of the leading shoe ret ailers in our cou ntr y . T oda y t he B at a S hoe O rganizat ion is a sprawling geo - centr ic company encompas sing operations in more than 70 countries around the world and is managed by 4 Meaningful Busines s Units ( MBU) acros s 5 continents. I t serves more than 1 million customers per day, employs more than 42,000 people, operates more than 5,500…

    • 865 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    Chapter 06

    • 1952 Words
    • 21 Pages

    Introduction to information & Communication Technologies Chapter 06 Output Lecturer: Sana Aurangzeb sanaa.uos@gmail.com https://sites.google.com/site/csict2021 1 What Is Output? • Output is data that has been processed into a useful form Pages 304 – 305 Figure 6-1 Discovering Computers 2010: Living in a Digital World Chapter 6 2 What Is Output? • An output device is any type of hardware component that conveys information to one or more people Display devices Interactive whiteboards Page…

    • 1952 Words
    • 21 Pages
    Powerful Essays
  • Satisfactory Essays

    Ms 06

    • 250 Words
    • 1 Page

    ASSIGNMENT Course Code : MS-6 Course Title : Marketing for Managers Assignment Code : MS-06/TMA/SEM-II/2012 Coverage : All Blocks Note: Answer all the questions and send them to the Coordinator of the Study Centre you are attached with. 1. Discuss the various characteristics of services that make them unique from product. Briefly explain the implications of these characteristics in designing suitable…

    • 250 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    ASSIGNMENT 06

    • 886 Words
    • 5 Pages

    Student ID: 1312311 Full name: Hùynh Văn Lâm ASSIGNMENT 06 1). Exercises 6.5.1: Write the following database modifications, based on the database schema Product (maker , model , type) PC (model , speed , ram , hd , rd , price) Laptop (model , speed , ram , hd , screen , price) Printer (model , color , type , price) of Exercise 5.2.1. Describe the effect of the modifications on the data of that exercise. a)Using two INSERT statements store in the database the fact that PC model 1100 is made…

    • 886 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Ms-06

    • 6765 Words
    • 28 Pages

    UNIT 1 QUANTITATIVE DECISION MAKING - AN OVERVIEW Objectives After studying this unit, you should be able to: • • • • • • • understand the complexity of today's managerial decisions know the meaning of quantitative techniques know the need of using quantitative approach to managerial decisions appreciate the role of statistical methods in data analysis know the various models frequently used in operations research and the basis of their classification have a brief idea of various statistical methods…

    • 6765 Words
    • 28 Pages
    Powerful Essays
  • Satisfactory Essays

    PEX 06 04

    • 511 Words
    • 3 Pages

    affects the heart rate by You correctly answered: a. increasing the rate of depolarization and increasing the frequency of action potentials. 4. The __________ receptor binds norepinephrine and epinephrine. You correctly answered: b. ß-1 adrenergic 05/06/15 page 1 Experiment Results Predict Question: Predict Question 1: Pilocarpine is a cholinergic drug, an acetylcholine agonist. Predict the effect that pilocarpine will have on heart rate. Your answer : b. Pilocarpine will decrease heart rate. Predict…

    • 511 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    03 06 04

    • 896 Words
    • 2 Pages

    Lesson 06: Prepping Your Sources Annotated Bibliography Note-Taking Guide Fill in the notes for the amendment and for each of the three categories (multi-media, contemporary cases, advocacy documents). If you need support for the citation, consult the MLA Formatting Guide you printed from the lesson. Amendment for your topic (from the Bill of Rights) Citation: http://www.law.cornell.edu/constitution/fourth_amendment What information from this source seems the most important? Note key points mentioned…

    • 896 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    sustainability 06 06236

    • 5736 Words
    • 33 Pages

    Sustainability 2014, 6, 6236-6249; doi:10.3390/su6096236 OPEN ACCESS sustainability ISSN 2071-1050 www.mdpi.com/journal/sustainability Article Sustainable Fashion Supply Chain: Lessons from H&M Bin Shen Glorious Sun School of Business and Management, Donghua University, Shanghai 200051, China; E-Mail: binshen@dhu.edu.cn; Tel./Fax: +86-216-237-3621 Received: 15 July 2014; in revised form: 15 August 2014 / Accepted: 19 August 2014 / Published: 11 September 2014 Abstract: Sustainability is significantly…

    • 5736 Words
    • 33 Pages
    Powerful Essays
  • Satisfactory Essays

    PEX 05 06

    • 614 Words
    • 5 Pages

    Exercise 5: Cardiovascular Dynamics: Activity 6: Studying the Effect of Stroke Volume on Pump Activity Lab Report Pre-lab Quiz Results You scored 100% by answering 5 out of 5 questions correctly. 1. Which of the following variables directly contributes to preload? You correctly answered: b. venous return 2. Which of the following would not increase end diastolic volume? You correctly answered: c. dehydration 3. Increased contractility of the heart results in all but which of the following? You correctly…

    • 614 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    1 06 workfile

    • 695 Words
    • 3 Pages

    1.06 The Scientific Method Work File Science and Theories 1. After reading through the information titled Is it Science or does it just look like Science? What conditions must be met for information to be considered true science? Label the following practices as science or pseudo science: Astrology: Science of the stars Biology: Science of the cell and living creatures Phrenology: Science of the brain and skull. Paranormal Investigation: Investigating the paranormal; Philosophy: Science of…

    • 695 Words
    • 3 Pages
    Satisfactory Essays