Preview

Oracle Mc Question

Good Essays
Open Document
Open Document
6708 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Oracle Mc Question
Ch1
Position the Oracle Product Family |

1. | Which of these languages can run within the database? (Choose all correct answers.) A. C B. Java C. PL/SQL D. SQL E. Any other language, if it is linked with the OCI libraries | | 2. | In a web application, on which tier does the application software run? (Choose the best answer.) A. In the web browser on the client tier B. On the middle tier C. Within a Java-enabled database | |
Answers
|

1. | B, C, and D. SQL, PL/SQL, and Java are implemented internally to the database. A is wrong because C is not available internally (though with OCI, it can of course be used for writing user processes). E is wrong because OCI is used for writing user processes that run externally to the database. | 2. | B. In a three-tier web application, the application software resides on the middle tier. A is wrong because the client tier manages only the user interface. C is wrong because the database tier manages only the data access. |
Explain Relational Structures |

3. | For what data storage paradigm must data be normalized? (Choose the best answer.) A. Hierarchical databases B. Network databases C. Object-oriented databases D. Relational databases | | 4. | What type of relationship should be avoided when normalizing data? (Choose the best answer.) A. One-to-many B. Many-to-one C. Many-to-many D. One-to-one | |
Answers
|

3. | D. Normalization is the process of converting data to two-dimensional relational tables. A, B, and C. Hierarchical, network, and object-oriented databases do not implement normalized data structures. | 4. | C. Many-to-many relationships should be resolved into one-to-many relationships, by inserting another entity between the two. A, B, and D. These are all acceptable in the third normal form model. |
Understand the SQL Language |

5. | SQL cannot do everything. What functions require another language? (Choose all correct
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Kudler Fine Foods: Analysis of a System Inventory
    • 912 Words
    • 4 Pages

    Kudler Fine Foods: Analysis of a System Inventory

    b. The main server for the company is an IBM blade server system C3000 running UNIX as its OS. This server also runs the corporate SAP ERP SW, has all the print/file services, the network services, email, storage control and the web.…

    • 912 Words
    • 4 Pages
    Good Essays
    Read More
  • Powerful Essays

    Nt3110 Unit 5 Practice Question Paper
    • 5339 Words
    • 22 Pages

    Nt3110 Unit 5 Practice Question Paper

    12. The PC (personal computer) and the Apple Macintosh are examples of two different: A. platforms. B. applications. C. programs. D. storage devices. 13. Apple Macintoshes (Macs) and PCs use different ____________ to process data and different operating systems. A. languages B. methods C. CPUs D. storage devices 14. Servers are computers that provide resources to other computers connected to a: A. network. B. mainframe. C. supercomputer. D. client. 15. Smaller and less expensive PC-based servers are replacing ____________ in many businesses. A. supercomputers B. clients C. laptops D. mainframes…

    • 5339 Words
    • 22 Pages
    Powerful Essays
    Read More
  • Good Essays

    Nt1330 Unit 3 Assignment 1 Paper
    • 785 Words
    • 4 Pages

    Nt1330 Unit 3 Assignment 1 Paper

    The application Set 3 requires a multi-tier network as the requirements vary a lot from one application to another. Application 1 could be classified in one tier and applications 2 and 3 in one as their requirement is quite similar. Applications 4 and application 5 can be a part of 2 more tiers.…

    • 785 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    IS3340 Unit 1 Assessment 1
    • 284 Words
    • 1 Page

    IS3340 Unit 1 Assessment 1

    9) Where is the most likely place a database management system would run? B) Server…

    • 284 Words
    • 1 Page
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Nt2670 Final Exam Paper
    • 408 Words
    • 2 Pages

    Nt2670 Final Exam Paper

    A – 64 – bit architecture, B – separation of roles, C – unlimited database size, D – Support for new business requirements such as UM and…

    • 408 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Nt2520 Unit 3 Assignment 1
    • 613 Words
    • 3 Pages

    Nt2520 Unit 3 Assignment 1

    7) In a one-to-many relationship, each row on in the primary key table can be related to any number of rows in the foreign key or child table.…

    • 613 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    IST223 Crib sheet
    • 3425 Words
    • 7 Pages

    IST223 Crib sheet

    rectangles, and relationships are shown by lines between the rectangles. Attributes are generally listed within the rectangle. The many side of many relationships is represented by a crows footentity-relationship (E-R) modelA set of constructs and conventions used to create data models. The things in the users world are represented by entities, and the associations among those things are represented by relationships. The results are usually documented in an entity-relationship (E-R) diagramID-dependent entityan entity whose identifier includes the identifier of another entityidentifierwhich are attributes that name, or identify, entity instancesidentifying relationshipIn such relationships, the parent is always required, but the child (the ID-dependent entity) may or may not be required, depending on application requirements. Identifying relationships are shown with solid lines in E-R diagrams.is-aRelationships among supertype/subtype entitiesmandatoryat least one entity instance must participate in the relationshipmaximum cardinalityThe maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.minimum cardinalityThe minimum cardinality is the minimum number of entity instances that must participate in a relationship instance.nonidentifying relationshiprelationship drawn with a dashed line (refer to Figure 5-7) is used between strong entities and is called a nonidentifying relationship because there are no ID-dependent entities in the relationship.null valueare a problem because they are ambiguous. They can mean that a value is inappropriate, unknown, or known, but not yet been entered into the databaseparentAn entity or row on the one side of a one-to-many relationshiprecursive relationshipoccurs when an entity type has a relationship to itself.relationship classAssociations among entity classesrelationship instanceassociations among entity instances.strong entityan entity that represents something that can exist…

    • 3425 Words
    • 7 Pages
    Powerful Essays
    Read More
  • Good Essays

    bis345345
    • 487 Words
    • 3 Pages

    bis345345

    1. (TCO 1) A database server can be best described with which of the following?…

    • 487 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Team A Service Request WK4 V2
    • 752 Words
    • 3 Pages

    Team A Service Request WK4 V2

    The normalization of the data helps to design the new databases so that it will meet the goals and to test the databases to see if the goals are met. The database designers will at times refer to the goals as data integrity, referential integrity, or keyed data access. It will be ideal to normalize the data before the database tables are made.…

    • 752 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Nt1320 Unit 7
    • 2041 Words
    • 9 Pages

    Nt1320 Unit 7

    The database design team transforms entities into tables and expresses relationships by defining foreign keys. The tables in the model are to be normalized before converting them into designs. Normalization is the process of converting poorly structured tables into two or more well-structured tables. Database practitioners classify tables into various normal forms according to the kinds of problems they have. Transforming a table into a normal form to remove duplicated data and other problems is called normalizing the table. After normalizing, the designer should represent the relationship among those tables to complete the design.…

    • 2041 Words
    • 9 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    DBM 380 Week 1 Individual Database Design Paper
    • 352 Words
    • 2 Pages

    DBM 380 Week 1 Individual Database Design Paper

    • Define relational database architecture. Consider Microsoft® Access*', Microsoft SQL Server®', Oracle®, IBM DB2®, and so on.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    week 4 Discussion 1
    • 447 Words
    • 2 Pages

    week 4 Discussion 1

    Many legacy systems require normalization. Identify at least two factors that should be considered in order to produce an optimal normalized set of tables when performing normalization. Include in your discussion a detailed example on how each factor would eliminate data redundancy.…

    • 447 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    ISM 4220
    • 2410 Words
    • 10 Pages

    ISM 4220

    MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.…

    • 2410 Words
    • 10 Pages
    Good Essays
    Read More
  • Powerful Essays

    Internet Protocol Suite and Layer
    • 694 Words
    • 3 Pages

    Internet Protocol Suite and Layer

    A divide and conquer approach permits concerns related to networking hardware to be completely separated from those related to networking software.…

    • 694 Words
    • 3 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    COS 101 WA1
    • 625 Words
    • 3 Pages

    COS 101 WA1

    b. Databases are a type of application that is well suited for PC’s. As well as Graphic and image processing. Programming and customized problem solving is also best suited for PC’s.…

    • 625 Words
    • 3 Pages
    Satisfactory Essays
    Read More

Related Topics