Introduction to Databases Practice Questions
Course Introduction
Introduction to Databases provides a comprehensive overview of database concepts, design, and implementation. Students will explore fundamental topics such as data models, relational databases, and database management systems. The course covers key concepts including schema design, normalization, query languages (with a focus on SQL), and data integrity. Practical exercises offer hands-on experience in creating, querying, and managing databases, preparing students to apply best practices in real-world settings. By the end of the course, learners will possess a strong foundation in managing and working with databases to store, organize, and retrieve information efficiently.
Recommended Textbook
Database Design Application Development and Administration 3rd Edition by Michael Mannino
Available Study Resources on Quizplus
17 Chapters
1294 Verified Questions
1294 Flashcards
Source URL: https://quizplus.com/study-set/3249 Page 2
Chapter 1: Introduction to Database Management
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64545
Sample Questions
Q1) To be considered a true DBMS,a database product should be able to obtain access to data without writing a specialized computer program.
A)True
B)False
Answer: False
Q2) Which one of the following is not a nonprocedural access to data in a database?
A) The user types and executes a SQL query
B) The user writes and executes a Cobol program
C) The bank teller types the name of a customer into a form to retrieve this customer's bank account
D) The sales manager executes a report showing a salesperson's sales for the current week
Answer: B
Q3) When a database can be used by multiple users at one time,the database is said to be ______________.
Answer: shared
Q4) An arrangement of components and data among computers connected by a network is known as a(n)__________________ architecture.
Answer: client-server
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Introduction to Database Development
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64544
Sample Questions
Q1) Which of the following shows the correct order of various phases of the traditional Systems Development Life Cycle?
A) Systems Design, Systems Analysis, Systems Implementation
B) Systems Analysis, Systems Design, Systems Implementation
C) Systems Implementation, Systems Analysis, Systems Design
D) Systems Analysis, Systems Implementation, Systems Design
Answer: B
Q2) Entity Relationship Diagrams are input to the following phase of Database Development:
A) Physical Database Design
B) Conceptual Data Modeling
C) Logical Database Design
D) Distributed Database Design
Answer: C
Q3) CASE tools that create prototypes and generate code that can be used to cross check a database with other components of an information system are classified as ____________ CASE tools.
Answer: back-end
To view all questions and flashcards with answers, click on the resource link above.
4
Chapter 3: The Relational Data Model
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/64543
Sample Questions
Q1) The extended cross product operator can only combine two tables that are union compatible.
A)True
B)False
Answer: False
Q2) The _______________ clause of the CREATE TABLE statement is used to define primary and foreign keys.
Answer: CONSTRAINT
Q3) To prohibit actions on referenced rows to occur when a record is deleted,you would specify the clause __________________________ in the CREATE TABLE statement.
Answer: ON DELETE RESTRICT
Q4) In the case of a natural join,where one of the join columns is removed in the result table,it is important for future reference to be able to determine the particular column that will be removed.
A)True
B)False
Answer: False
Q5) A(n)_________________ set operator retrieves all rows in either input table.
Answer: union
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Query Formulation With SQL
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/64542
Sample Questions
Q1) The last value of Cname shown by the execution of the (ORACLE)SQL query SELECT Cname,Date_Out FROM RENTALS
WHERE to_number(to_char(Date_Out,'YYYY'))>1994
ORDER BY Cname
Is:
A) BLACK
B) GREEN
C) SIMON
D) WARP
Q2) The execution of the query SELECT BirthPlace,AVG(Age)AS Avgage FROM CUSTOMER
WHERE BirthPlace = 'TAMPA' OR BirthPlace = 'ERIE' GROUP BY BirthPlace
Will produce the following number of rows:
A) 1
B) 2
C) 3
D) 4 or more
Q3) To test for null values in columns you would use the _________________ operator.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Understanding Entity Relations
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64541
Sample Questions
Q1) One of the attributes an entity type should always have is a primary key.
A)True
B)False
Q2) In Crow's Foot and most other notations,entity types are denoted by a triangle.
A)True
B)False
Q3) Which of the following statements is true?
A) An md may be an administrator
B) An RN may be an administrator
C) An md may not be an administrator
D) An md may be an RN
Q4) If we want to indicate that the authors of a book have conceived it when visiting another author in some country,the usual symbol used in the Chen ERD notation would be:
A) A relationship connecting Book, Country, and Author
B) An associative entity type connecting to Book and Country
C) Three binary relationships connecting pairwise Book, Country, and Author
D) Two binary relationships connecting Book and Country, and Book and Author
Q5) In an ERD,a named association among entity types is known as a(n)_____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Developing Data Models for Business Databases
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/64540
Sample Questions
Q1) Redundant relationships in a database design:
A) Can be derived from other relationships
B) Cannot be identified by reviewing the ERD
C) Should always be removed from the database design
D) None of the above
Q2) Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of attributes in the key of the table MEMBER is:
A) 3
B) 4
C) 5
D) 6
Q3) Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,title will appear as a foreign key the following number of times:
A) 2
B) 3
C) 4
D) 5
To view all questions and flashcards with answers, click on the resource link above.
Page 8
Chapter 7: Normalization of Relational Tables
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64539
Sample Questions
Q1) The following is a nontrivial multivalued dependency in the table STUDENTC:
A) Name -> ->Major | Minor
B) Name -> Major
C) Name -> Minor
D) None of the above
Q2) The goal of 2NF and 3NF is to produce tables in which every key determines the other columns.
A)True
B)False
Q3) The following is a functional dependency in the table STUDENTD:
A) Name -> Minor
B) Name -> Major
C) Major -> Minor
D) Major -> Name
Q4) The table STUDENTC satisfies the following normal form (choose the highest NF):
A) 1NF
B) 2NF
C) 3NF
D) 4NF
Q5) 1NF prohibits the occurrence of __________________ in a table.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Physical Database Design
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64538
Sample Questions
Q1) In the processing of an SQL statement by the DBMS,code generation:
A) Comes first
B) Follows query transformation
C) Follows syntax and semantics analysis
D) Follows access plan evaluation
Q2) Which of the following types of file is usually not provided by relational DBMS?
A) Heap
B) Hash file
C) Stack
D) B-tree
Q3) In the processing of an SQL statement by the DBMS,a parsed query is the output of the code generation task.
A)True
B)False
Q4) A simple file structure in which records are stored by a key value is a(n)_________________ file.
Q5) File structures,data placement,data formatting,and denormalization are all ____________ of the physical database design process.
Q6) ______________ is a collection of disks that operates as a single disk.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Advanced Query Formulation With SQL
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/64537
Sample Questions
Q1) When performing a grouping operation,the SQL standard specifies that all rows with null values are grouped together.
A)True
B)False
Q2) SELECT DISTINCT CNAME,AGE FROM CUSTOMER,RENTALS
WHERE CUSTOMER.CID <> RENTALS.CID
The execution of this query produces the following number of rows:
A) 0
B) 1
C) 2
D) 6
Q3) Type I nested queries can be used like loops and Type II nested queries can be used like procedures in a programming language.
A)True
B)False
Q4) Using a Type I nested query is the standard way to reference related tables in SQL DELETE statements.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Application Development With Views
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/64536
Sample Questions
Q1) Typically in a hierarchical form,which of the following statements is not true?
A) At a given time, the main form may show several records
B) At a given time, the main form may show one record
C) At a given time, the subform may show several records
D) At a given time, the subform may show one record
Q2) Which of the following operations is typical in queries for hierarchical reports?
A) Join
B) Outer Join
C) Count
D) All of the above
Q3) To process queries that reference a view,the DBMS can use either a _________ or __________ strategy.
A) direct, indirect
B) materialization, modification
C) materialization, indirect
D) realistic, virtual
Q4) A view that can be used in SELECT,UPDATE,INSERT,and DELETE statements is a(n)_________________.
Q5) The variable part of a hierarchical form is known as the __________________.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Stored Procedures and Triggers
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64535
Sample Questions
Q1) To catch a specific error in a stored procedure,you should use a predefined exception or create a user-defined exception.
A)True
B)False
Q2) Two triggers with the same timing,granularity,and applicable table ______________ if an SQL statement may cause both triggers to fire.
Q3) For each object defined in a package interface,the package body must define:
A) A private object.
B) An implementation.
C) A cursor.
D) An exception handler.
Q4) In the body of a function,a(n)______________ statement is used to generate the function's output value.
Q5) Which of the following is true of PL/SQL iteration statements?
A) The FOR LOOP iterates until a stopping condition is false.
B) The WHILE LOOP iterates over a range of integer values.
C) The LOOP statement iterates until an EXIT statement ceases termination.
D) All of the above.
Q6) A package ________________ contains the private details of a package.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: View Design and Integration
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64534
Sample Questions
Q1) The structure of the form is:
A) Parent node X, child node Y
B) Parent node X, two child nodes Y and Z
C) Parent node X, node Y child to node X and parent to child node Z
D) Nodes X and Y, both parent to child node Z
Q2) To resolve synonyms and homonyms,you would rename the homonyms to the same term,and rename the synonyms to different terms.
A)True
B)False
Q3) The use of forms in view design precludes gathering requirements in other formats such as interviews and documentation of an existing system.
A)True
B)False
Q4) How many entity types should be identified?
A) 2
B) 3
C) 4
D) at least 5
Q5) In a parent node,how is the node key value unique? ______________________
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 14: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64533
Sample Questions
Q1) One of the main problems with the independent development of separate operational databases is that decision-making information for the overall organization is not readily available.
A)True
B)False
Q2) A(n)____________________ is a workload used to evaluate the performance of a system or product.
Q3) The first step in the DBMS selection and evaluation process is a detailed analysis of the requirements,which usually include data definition support,procedural and nonprocedural access,and recovery management.
A)True
B)False
Q4) Tables with the names USERS,DOMAINS,COLUMNS,and REFERENTIAL_CONSTRAINTS would be examples of important ________________________ found in the SQL:2003 Definition_Schema.
Q5) To support object-oriented databases,SQL:2003 provides for ________________,which are more powerful than domains or distinct types and can be defined with new operators and functions.
Q6) ___________________ rules are checked when a user first connects to a DBMS. To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 15: Transaction Management
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/64532
Sample Questions
Q1) Name three types of inconsistent retrievals:
Q2) When transactions T1 and T2 are in a deadlock,one of the transactions will eventually execute to completion and let the other one continue execution.
A)True
B)False
Q3) With the _____________________ approach,database updates are written to disk only after a transaction commits.
Q4) When transaction T1 has a lock on a resource that transaction T2 needs,and T2 has a lock on a resource that T1 needs,this situation is known as a(n)_______________.
Q5) The optimistic concurrency control approach may delay a transaction longer than the pessimistic approach would have,because with the optimistic approach the conflicting transactions have to be rolled back and restarted,rather than waiting for a lock to be released.
A)True
B)False
Q6) A measure of the amount of work performed by a DBMS is the number of transactions processed per time unit.This measure is known as
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: Data Warehouse Technology and Management
Available Study Resources on Quizplus for this Chatper
78 Verified Questions
78 Flashcards
Source URL: https://quizplus.com/quiz/64531
Sample Questions
Q1) A stored view created to provide fast response for queries involving large fact tables is a(n)____________________ view.
Q2) An oper mart is a just-in-time data mart,usually built from one operational database in anticipation or in response to major events such as disasters and new product introductions.
A)True
B)False
Q3) In both query rewriting for materialized views and query modification for traditional views,the query optimizer must evaluate whether the substitution will improve performance over the original query.
A)True
B)False
Q4) When N is the number of grouped columns,the result of a ROLLUP operation can be produced by using N)additional SELECT statements connected by a UNION operator.
A)True
B)False
Q5) The subjects that data are grouped by in a data cube are known as
To view all questions and flashcards with answers, click on the resource link above.
Chapter 17: Client-Server Processing and Distributed Databases
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/64530
Sample Questions
Q1) _______________ provide a high level of interoperability and message intelligence.They also resolve platform differences between a client and a server.
Q2) Distributed DBMSs must conform to the Three Schema Architecture just like traditional DBMSs do.
A)True
B)False
Q3) A(n)_______________________,the oldest kind of middleware,relieves the operating system of managing database processes.
Q4) In a tightly integrated distributed DBMS,the fragmentation schema contains the definition of each fragment and the allocation schema contains the location of each fragment.
A)True
B)False
Q5) Which of the following is not a kind of middleware?
A) transaction-processing monitors
B) message-oriented middleware
C) object-request brokers
D) Meta data repository hyper-access utilities
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 18: Object Database Management Systems
Available Study Resources on Quizplus for this Chatper
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/64529
Sample Questions
Q1) Which of the following is not an object-oriented language?
A) SQL2
B) Java
C) C++
D) Smalltalk
Q2) Which of the following is not true of the object database middleware approach?
A) The usual data and complex (e.g. media) data reside on the same database
B) The client issues SQL statements for both usual data and complex data
C) The object middleware issues the API calls for the complex data
D) Combined requests for usual and complex data are not optimized
Q3) The principle of encapsulation in object-oriented programming means that the internal details of an object are not accessible through their interface.
A)True
B)False
Q4) One of the fundamental principles of object-oriented computing is _________________,which means that an object can only be accessed through its interface.
Q5) ___________ binding binds a method name with a method implementation at the time of execution of the message.
To view all questions and flashcards with answers, click on the resource link above. Page 19