1.Which of the following best defines a database performance tuning?A) 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 factor…
1.Which of the following best defines a transaction?A) 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?A) Completeness 3. Which of the following…
1.What is the process that establishes the need for an information system and its extent?A) Systems analysis 2. Which of the following is NOT a factor of the performance of an information system?A) Database management functions and features 3. What…
1.Which statement best defines a schema?A) 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?A) SECONDARY KEY…
1.Which of the following is a valid SQL statement?A) SELECT column1, column2 FROM table_name; 2. Which of the following arithmetic operators is not valid?A) @ : Raise to power of 3. Which of the following is not performed as a…
1. Veterinarian Office Case Part 1 The veterinarian office created a database to keep track of owner and pet information. It also includes tracking appointments and treatments for each pet. The veterinarians need to retrieve the data for different reasons.…
1.Normalization is a process for evaluating and correcting table structures to minimize _____.A) data redundancy and anomalies 2. Which of the following is false about unnormalized data?A) Unnormalized data is related data. 3. Which of the following is NOT true?A)…
1.When looking into the extended entity relationship model (EERM), which of the following statements is not valid about entity supertypes and subtypes?A) The entity subtype contains common characteristics. 2. In an extended entity relationship, which of the following statements is…
1. Cruise Business Case: Part 1 The specialty cruise has a pirate theme and goes on fun missions. Cruise members become part of the crew. Use the following business rules for the cruise database: 2. Cruise Business Case: Part 2…
1. When working with entity relationship models (ERM), which of the following is not a valid statement regarding an entity?A) An entity is an object of interest to the end designer. 2. In an entity relationship model (ERM), attributes are…
