Chpt 1 CS 292
What is the lowest level of abstraction? A. Physical level B. Logical level C. Internal level D. View level
A. Physical level
Which data model permits the specification of data where the individual data items of the same type may have different sets of attributes? A. Semi-structured Model B. Relational Model C. Object-Based Model D. Entity-Relationship Model
A. Semi-structured Model
What is the job of a database administrators? A. They are the one that decide what information to keep in the database B. They are the one that decide what information to delete in the database C. They are the one that decide what information is to use in the database D. They are the one that decide what information gets added in the database
A. They are the one that decide what information to keep in the database
Underlying the structure of a database is the data model A. a collection of conceptual tools for describing data, data relationships, data semantics B. That is, the system hides certain details of how the data are stored and maintained C. The data models can be classified into four different categories D. Data Abstraction
A. a collection of conceptual tools for describing data, data relationships, data semantics
What are the different type of data models in a database system? A. relational, entity-relationship, semi-structured, object-based B. Logistic Regression C. network D. dimensional
A. relational, entity-relationship, semi-structured, object-based
What is Physical data independence ? A. the ability to modify the physical schema without changing the logical schema B. the overall logical structure of the database C. A database system is partitioned into modules that deal with each of the responsibilities of the overall system. D. The process of designing the general structure of the database
A. the ability to modify the physical schema without changing the logical schema
How does abstraction play a role in database systems. Reference: page 2, paragraph 3
Abstraction allows users to use and operate databases, without having to know specific details about the data, like where the data is stored.
What is a database-management system? A. A database-management system is a collection of irrelevant data that you gain access to B. A database-management system is a collection of interrelated data and a set of programs to access those data C. A database-management system is a collection data that can only be accessed by the maker D. A database-management system is a collection of programs that people use to save information
B. A database-management system is a collection of interrelated data and a set of programs to access those data
Which Query interprets DDL statements and records the definitions in the data dictionary?. A. DML compiler B. DDL interpreter C. Query Optimization D. Query Evaluation Engine
B. DDL interpreter
Which of the following would not be used to allow users to access information from a relational database? A. Data-Manipulation Language B. Data-Definition Language C. SQL Data-Manipulation Language D. Database Access from Application Programs
B. Data-Definition Language
Is a language that enables users to access or manipulate data as organized by the appropriate data model. A. Data-Definition language B. Data-Manipulation language C. Query D. Data model
B. Data-Manipulation language
What is The DBMS expected to do? A. Allow users to create new websites B. Give users the ability to query the data C. Support the storage of very little amounts of data D. Control access to data from only one user
B. Give users the ability to query the data
All of the below are database engines except: A. Storage Manager B. Physical Data Memory C. Query processing D. Transaction manager
B. Physical Data Memory
The overall design of the database is called as the database A. Design B. Schema C. Instance D. Model
B. Schema
What is the primary goal of DBMS? A. program to access data B. a way to store and retrieve database information C. collection of data D. none of the above
B. a way to store and retrieve database information
What are application programs? A. a program module that provides the interface between the low level data stored B. are programs that are used to interact with the data in the database C. language for accessing and updating the data organized by the data model D. The actual content of the database at a particular time
B. are programs that are used to interact with the data in the database
A database system provides a A. data-manipulation language B. data-definition language (DDL) C. data storage and definition D. Domain Constraints
B. data-definition language (DDL)
The following are disadvantages of keeping organized files on a file-processing system EXCEPT A. Difficulty accessing data B. Data isolation C. Adding information D. Security problems
C. Adding information
Data Models can be classified into the except A. Relational Model B. Entity-Relationship Model. C. All the above D. None of the above
C. All the above
What is the central aspect of any database application? A. Storage capacity B. Usability C. Data D. Performance
C. Data
Which manages the allocation of space on disk storage and the data structures used to represent information stored on disk? A. Authorization and integrity manager B. Transaction Manager C. File Manager D. Buffer Manager
C. File Manager
What are the four data models that underlie the structure of a database? A. relational model and relationship model B. view model and relational model C. Relational Model, Entity-Relationship Model, Semi-structured Data Model, Object-Based Data Model D. scientific model, computer model, relational model and logical model
C. Relational Model, Entity-Relationship Model, Semi-structured Data Model, Object-Based Data Model
The primary role of a database is to... A. Store Data B. Retrieve data C. Store and retrieve data D. Manipulate and transfer data
C. Store and retrieve data
What is the first mode in which databases are used? A. The first mode is to support data analytics B. The first mode is to support project managers C. The first mode is to support online transaction processing D. The first mode is to support online users
C. The first mode is to support online transaction processing
What are the different schema of a database system? A. logical, analytical, & data B. physical, analytical & subschemas C. physical, logical & subschemas D. subschemas, data, logical
C. physical, logical & subschemas
Database systems are used to manage collection of data that are A. Highly valuable B. Large C. Accessed by multiple users and application D. All of the above
D. All of the above
Databases are used in which areas? A. Accounting : For payments, receipts, and other accounting information. B. Airlines: For reservations and schedule information. C. Online advertisers: For keeping records of click history, product suggestions, and search terms D. All of the above
D. All of the above
Manipulating a database includes A. retrieve specific data B. updating database C. generating reports from data D. All of the above
D. All of the above
What are some disadvantages of a file-processing system? A. data redundancy B. data isolation C. difficulty in accessing data D. All of the above
D. All of the above
Which of the following difficulties in data management are overcome by database systems? A. Data redundancy and inconsistency B. Difficulty in accessing data C. Integrity problems D. All of the above
D. All of the above
Which one is the web-based service in data-base management? A. Social-media B. Online retailers C. Online advertisements D. All of the above
D. All of the above
Database systems are used to manage collections of data that are: A. Highly valuable B. Relatively large C. Accessed by multiple users and applications. D. All the above
D. All the above
The main characteristics of database approach verses the file processing approach are A. sharing data and multi-user transaction processing B. creating new data C. self-describing nature of a database system D. Both A and C
D. Both A and C
Which one of the below is not count as components of information? A. Data B. Metadata C. Statistics D. Buffers
D. Buffers
It is a collection of a conceptual tools for describing data, data relationships, data semantics and consistency constraints. A. Schema B. Data-Definition Language C. Data-Manipulation Language D. Data Model
D. Data Model
What is the primary goal of a Database Management System? A. Provide a way to retrieve database information that is convenient B. Provide a way to store database information that is efficient C. Provide a way to store and retrieve database information D. Provide a way to store and retrieve database information that is both convenient and efficient
D. Provide a way to store and retrieve database information that is both convenient and efficient
The most widely used query language is- A. Contextual Query Language (CQL) B. Facebook Query Language (FQL) C. Java Persistence Query Language ( JPQL) D. SQL
D. SQL
Which database has several schemas at the view level? A. Schema B. Physical schema C. Logical schema D. Subschemas
D. Subschemas
These are the different types of access that enables the users to access or manipulate data in data-manipulation language (DML) EXCEPT A. Retrieval B. Insertion C. Deletion D. Usage
D. Usage
What is data inconsistency? A. When a system hides details of how data is stored. B. When data is not fetched from disk storage into main memory. C. When a database system detects system failure. D. When various copies of the same data no longer agree.
D. When various copies of the same data no longer agree.
The storage manager components include: A. Authorization and integrity manager B. Transaction manager C. File manager & buffer manager D. all above
D. all above
Database systems are used to manage collections of data that. A. are highly valuable B. are relatively large C. are accessed by multiple users and applications D. all of the above
D. all of the above
Which of the following are examples of database applications A. telecommunication B. web based services C. banking and fiance D. all of the above
D. all of the above
The primary goal of a DBMS is to be: A. extensive and thorough B. effective and efficient C. convenient and concise D. convenient and efficient
D. convenient and efficient
What is data abstraction ?
Data abstraction is to retrieve data efficiently
In addition to the normal processing of day to day business transactions explain briefly how business organizations are using relational databases.,
Data analysis and data mining tools are being used on database data to discover rules and patterns in the data that can be used in strategic planning and decision making
What is data-manipulation language (DML)? Reference: Chapter 1. section 1.4.3. page 15
Data-manipulation language (DML) is a language that enables users to access or manipulate data as organized by the appropriate data model.
A transaction is a collection of operations that performs a multiple logical function in a database application
F
A data manipulation language (DML) is a language that enables users to access or manipulate data as organized by the appropriate data model.
T
A data-manipulation language (DML) is a language that enables users to access or manipulate data as organized by the appropriate data model
T
A database can be of any size and complexity
T
A database is a collection of data that contains information relevant to an enterprise.
T
A database management system is a computerized system that enables users to create and maintain a database.
T
A database system has several subsystems
T
A database system is a collection of interrelated data and a set of programs that allow users to access and modify these data
T
A database system provides a data-definition language (DDL) to specify the database schema and a data-manipulation language (DML) to express database queries and updates
T
A database system provides a data-definition language to specify the database schema and a data-manipulation language to express database queries and updates.
T
A database-management system (DBMS) is a collection of interrelated data and a set of programs to access those data.
T
A major purpose of a database system is to provide users with an abstract view of the data.
T
Abstraction allows a person to use a complex device or system without having to know the details of how that device or system is constructed.
T
Data models are a collection of conceptual tools for describing data, data relationships, data semantics, and consistency constraints.
T
Database systems are used to manage collections of data that are highly valuable
T
Databases change over time as information is inserted and deleted.
T
Declarative DMLs are usually easier to learn and use than procedural DMLs
T
Domain Constraints. A domain of possible values must be associated with every attribute (for example, integer types, character types, date/time types).
T
In the relational model, data are represented in the form of tables.
T
In the relational model, data are represented in the form of tables. Each table has multiple columns, and each column has a unique name. Each row of the table represents one piece of information.
T
Its possible for application programmers to utilize more than one tool to create the user interface in a database
T
Object-oriented programming has become the dominant software-development methodology
T
Physical level is the lowest level of abstraction and describes how the data is actually stored
T
SQL language is nonprocedural
T
The DDL is also used to specify additional properties of the data.
T
The Storage Manager component of the relational database engine is the component responsible for storing, retrieving and updating data in the database.
T
The functional components of a database system can be divided into: "the storage manager", "the query processing components", and "the transaction management component"
T
The portion of the DBMS that most affects the performance that the user sees is the query processor
T
The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient
T
The transaction manager consists of the concurrency-control manager and the recovery manager.
T
The two types of data-manipulation language are procedural and declarative.
T
There are two modes in which databases are used.
T
We specify a database schema by a set of definitions expressed by a special language called a data-definition language (DDL)?
T
the application resides at the client machine, where it invokes database system functionality at the server machine is a two tier architecture.
T
What are two disadvantages of a file-processing system?
data isolation & integrity problems
What is the primary goal of DBMS ? Reference: Page Ref: 29, Sec 1.10 Summary.
provide an environment that is both convenient and efficient for people to use in retrieving and storing information.
What is logical Schema Reference: chapter 1 Instances and Schemas
the overall logical structure of the database
Database Access from Application Programs
F
Declarative DMLs require a user to specify what data are needed with specifying how to get those data.
F
During late 1970s and 1980s, The magnetic tapes were developed for data storage
F
Keeping organizational information in a file processing system is the best thing to do.
F
Logical schema describes the database design at the view level
F
Physical schema is the overall logical structure of the database
F
Query Processing consists of Parsing and translation, Optimization, and Modification
F
A query is a statement requesting to update information
F
There are basically two types of data-manipulation languages. List them and briefly define each. Reference: Chapter 1 Page 15
-Procedural DMLs require a user to specify what data is needed and how to obtain the data. -Declarative DMLs require a user to specify what data is needed without specifying how to obtain the data.
Define what is a Database-management system (DBMS)? Reference: pp. 1 (introduction)
A collection of interrelated data and a set of programs to access those data.
What is a database-management system? Reference: Page # 1, section 1
A database-management system is a collection of interrelated data and a set of programs to access those data.
What are the major units for the query compiler? Reference: Ch 1.2.5 Page 10
A query parser, a query preprocessor, a query optimizer
The following are the disadvantages of file processing system except A. Back-up and competencies B. Difficulty in accessing data C. Data redundancy and inconsistency D. Integrity problems
A. Back-up and competencies
What is a database management system? A. DBMS is a collection of interrelated data and a set of programs to access those data. B. is an international standard language for processing a database C. to express database queries and up- dates. In practice, the data-definition and data-manipulation languages are not two separate languages; D. none of the above
A. DBMS is a collection of interrelated data and a set of programs to access those data.
The storage manager is the component of a database system that provides the interface between the low-level data stored in the database and the application programs and queries submitted to the system. What are the components of a storage manager? Reference: page 19
Authorization and integrity manager, Transaction manager, File manager, Builder manager
type instructor = record ID : char (5); name : char (20); dept name : char (20); salary : numeric (8,2); end; How many fields does the code have? A. 2 B. 4 C. 5 D. none of them
B. 4
The database at a given point in time A. Schema B. Instance C. Data Warehouse D. Physical Database
B. Instance
A program module that provides the interface between the low-level data stored in the database and the application programs and queries submitted to the system is ? A. Database Design B. Database Engine C. Storage Manager D. Query Processor
C. Storage Manager
Database systems are used to manage collections of data that A. are highly valuable B. are relatively large C. are accessed by multiple users and applications, often at the same time D. all of the above
D. all of the above
The Entry relationship model permits the specification of data where individual data items of the same type may have different sets of attributes.
F
The buffer manager is responsible for partitioning the available main memory into log records, which are page-sized regions into which disk blocks can be transferred.
F
The two types of data-manipulation languages are called "referential" and "declarative"
F
There are basically four types of data-manipulation language.
F
There are two levels of data abstraction
F
There is only one type of schema.
F
procedural and declarative DML's are the same
F
Why do Database designers and programmers normally prefer to use single-tier architecture ? Reference: https://www.tutorialspoint.com/dbms/dbms_architecture.htm
In 1-tier architecture, the DBMS is the only entity where the user directly sits on the DBMS and uses it. Any changes done here will directly be done on the DBMS itself.
What is the difference between a naive and a sophisticated database user? Reference: section 1.8.1, page 24.
Sophisticated users formulate their solicitations by utilizing a database inquiry language or utilizing tools like data analysis software Naive users works with predefined user interfaces like web or compact applications
What is the name of the lowest data abstraction level? Reference: Pg 9
The physical level is the lowest level of abstraction and explains how the data is actually stored
List the different data models. Reference: pages 8-9, section 1
The relational model, entity-relationship model, semi-structured data model, and the object-based data model.
Database systems are designed to manage large bodies of information. Why is it that these large bodies of information do not exist in isolation? Reference: page 14
They are part of the operation of some enterprise whose end product may be information from the database or may be some device or service for which the database plays only a supporting role