1.Which of the following best defines a distributed database management system (DDBMS)? DDBMS governs the storage and processing of logically related data over interconnected computer systems in which both data and processing functions are distributed among several sites. 2. Which…
1. Which of the following best defines a database performance tuning? Database performance tuning refers to a set of activities and procedures designed to reduce the response time of the database system 2. Which of the following is NOT a…
1. Which of the following best defines a transaction? A transaction is a logical unit of work that must be entirely completed or entirely aborted 2. Which of the following is not a transaction property? Completeness 3. Which of the…
1. What is the process that establishes the need for an information system and its extent? Systems analysis 2. Which of the following is NOT a factor of the performance of an information system? Database management functions and features 3.…
1.Which statement best defines a schema? A schema is a logical group of database objects—such as tables and indexes—that are related to each other. 2. Which of the following is NOT a valid clause of CREATE TABLE statement? SECONDARY KEY…
1. Which of the following is a valid SQL statement? SELECT column1, column2 FROM table_name; 2. Which of the following arithmetic operators is not valid? @ : Raise to power of 3. Which of the following is not performed as…
1. Using attributes such as STU_LNAME and STU_FNAME, the entity STUDENT would be represented with a _____ in the Chen model. rectangle 2. One important inheritance characteristic is that all entity subtypes inherit their _____ key attribute from their supertype.…
1. Use the above business rules for the cruise database to answer what is the appropriate connector for number 1 2. Use the above business rules for the cruise database to answer what is the appropriate connector for number 2…
1. The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming…
1. What is the result of redundant data in the database? Data anomalies that lead to data inconsistencies 2. Which of the following is not a function of a DBMS? User management 3. Why is identifying and documenting business rules…
