1. What is database middleware?A) Database middleware is database connectivity software through which application programs connect and communicate with data repositories. 2. Which of the following is NOT a component of Open Database Connectivity (ODBC) architecture?A) Dynamic-link library 3. Which…
1.Big Data generally refers to a set of data that displays the characteristics of_____.A) Volume, Velocity, and Variety 2. Which of the following is NOT a characteristic of Hadoop Distributed File System (HDFS)?A) Read-once, write-many 3. Which of the following…
1.Which of the following best defines business intelligence?A) A comprehensive set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making 2. Which of…
1.Which of the following best defines a distributed database management system (DDBMS)?A) 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?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.…
