Database Administration
Pre-Test Questions
Course Introduction
Database Administration is a comprehensive course designed to introduce students to the core principles and practices involved in managing and maintaining database systems. Students will learn about database architecture, user management, security protocols, backup and recovery techniques, performance tuning, and automation of administrative tasks. Emphasizing both theory and hands-on exercises, the course equips learners with the skills necessary to efficiently administer relational database management systems, ensure data integrity and security, optimize system performance, and support organizational data needs.
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) In addition to application development tools,most DBMSs provide a(n)_________________________,which is a method to combine a nonprocedural language with a programming language.
Answer: procedural language interface
Q2) A(n)______________ is a cluster of data usually about a single topic that can be accessed together.
Answer: entity
Q3) Database administrators:
A) Have technical responsibilities
B) Have non technical responsibilities
C) Participate in database design
D) All of the above
Answer: D
Q4) Which of the following is not a level of the three-schema architecture?
A) Procedural
B) External
C) Internal
D) Conceptual
Answer: A
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) A design approach in which ERDs are constructed for each group of users and merged into a complete conceptual schema is referred to as
Answer: view design and integration
Q2) Which of the following is a feature provided by prototyping tools?
A) create forms and reports
B) create an initial database from a library of databases
C) generate code
D) all of the above
Answer: D
Q3) The __________________ strategy,which breaks a large problem into many smaller problems,is one way to manage complexity in database design.
Answer: divide-and-conquer
Q4) The waterfall model characterizes the following systems development model:
A) Prototyping
B) Traditional Systems Development Life Cycle
C) Spiral Development
D) Data model development
Answer: B
To view all questions and flashcards with answers, click on the resource link above. Page 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) A(n)_________________ set operator retrieves the rows that occur in the first input table but not in the second input table.
Answer: difference
Q2) The Intersection of a table of N rows and of a table of M rows (M<=N)has the following number of rows:
A) M+N
B) A number in the range N to M+N
C) N
D) A number in the range 0 to M
Answer: D
Q3) When the join condition specifies that rows from two or more tables have an identical value in one or more columns,this join is called a(n)_________________ . Answer: equi-join
Q4) The referential integrity rule prohibits foreign keys to have null values.
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) When mixing AND and OR in a complex logical expression,you should always use ________________ to make the grouping of the conditions explicit.
Q2) As a result of the execution of the query SELECT MIN(Age)AS Minage,MAX(Age)AS
Maxage FROM CUSTOMER
GROUP BY Resid_City,BirthPlace
Which one of the following values does not appear in the column with heading Maxage?
A) 22
B) 25
C) 30
D) 35
Q3) The COMMIT,GRANT and REVOKE statements,used primarily by database administrators and analysts,are all statements used for database
Q4) To perform a difference operation between two tables,Oracle uses the ____________ keyword.
Q5) In SQL queries,the _______________ clause is used to summarize groups of rows.
Q6) The SQL:2003 standard for single character string matching is _________.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Q7) The results table of a query can be sorted using the _____________ clause.
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) Which of the following entities does not inherit the primary key SS#?
A) Administrator
B) Department
C) RN
D) Md
Q2) 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
Q3) No two books in the database:
A) May have the same publisher
B) May have been written by the same author
C) May have the same title
D) All of the above
Q4) In Crow's Foot notation,the Crow's Foot (two angled lines and one straight line)means a cardinality of ______________.
Q5) In Crow's Foot notation,a circle means a cardinality of ______________.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
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) A common design error that occurs when you do not consider all of the queries that a database should support is to omit relationships between entities that map an important business rule.These omitted relationships are known as ______________.
Q2) One important reason for documenting design decisions it to _______________ those decisions to others.
Q3) When converting a narrative problem into an ERD,which of the following would potentially be converted into an entity type:
A) Things
B) Places
C) Events
D) All of the above
Q4) Assuming that we do not use the rule(s)that avoid null values in tables,the table BOOK obtained in converting the ERD diagram to a relational database will contain the following number of attributes:
A) 3
B) 4
C) 5
D) 6
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) Due to the extra joins involved,splitting a table because it has multiple candidate keys can degrade query performance.
A)True
B)False
Q2) The following is a transitive functional dependency in the table STUDENTC:
A) Name -> Minor
B) Name -> Major
C) Major -> Minor
D) All of the above
Q3) A table is said to be in ___________ if every determinant is a candidate key.
Q4) When you split one table into two smaller tables to achieve 2NF,you can no longer derive the functional dependencies of the original table.
A)True
B)False
Q5) The table STUDENTC satisfies the following normal form (choose the highest NF):
A) 1NF
B) 2NF
C) 3NF
D) 4NF
To view all questions and flashcards with answers, click on the resource link above. Page 9
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) A(n)______________ is a collection of bytes that are transferred between volatile storage in main memory and stable storage on a disk.
Q2) To improve the response time to access and change a database,consumption of all of the resources used by database processing should be minimized,including physical record transfers,main memory and disk space.
A)True
B)False
Q3) Physical records are synonymous to blocks or pages.
A)True
B)False
Q4) Which of the following statements is not true when having overall_gpa and gpa_in_major as attributes of the STUDENT table?
A) This will increase the time of retrieving the overall_gpa and gpa_in_major for students
B) This will increase the time of updates whenever a grade is changed
C) This will not change the normal form of the table STUDENT
D) This will avoid join operations when retrieving the gpa_in_major for a student
Q5) ______________ 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) The SQL keyword(s)____________ in a SELECT query generate a result table that contains the matching rows and the non-matching rows of the right table.
Q2) In SQL statements,________________ conditions involve one or more simple conditions connected by a Boolean operator.
Q3) 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
Q4) The following SQL statement could not be executed because what column is included in the SELECT? _____________ SELECT StdSSN,StdLastName,StdMajor,EnrGrade FROM Student
WHERE Student.StdSSN IN (SELECT StdSSN FROM Enrollment WHERE EnrGrade > 3.5)
To view all questions and flashcards with answers, click on the resource link above.
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) In a 1-M updatable query,to insert a row into the child table,you would provide only the values needed to insert a row into the child table.
A)True
B)False
Q2) To process queries that reference a view,____________________ is not usually the best strategy because it requires the DBMS to execute two queries.
Q3) (Access)Which of the following statements is true?
A) Data in RENTALS may be updated, using an UPDATE command on View3
B) Data in CUSTOMER may be updated, using an UPDATE command on View3
C) Data in RENTCOST may be updated, using an UPDATE command on View3
D) All of the above
Q4) Views are the "building blocks" of both data entry forms and reports.
A)True
B)False
Q5) In Access,a(n)_____________________ query involves two tables,with one table playing the role of parent and another table playing the role of child.
Q6) Depending on its definition,a view can be read-only or updateable.All views are at least __________.
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) As with other programming languages,in PL/SQL the IF-THEN-ELSE statement construct is:
A) A comparison operator.
B) A conditional statement.
C) A logical operator.
D) None of the above.
Q2) A ______________ can be implicit or explicit.
Q3) A database programming language allows a program to combine procedural statements with non-procedural database access.
A)True
B)False
Q4) A trigger execution procedure can be affected by which of the following?
A) The DBMS the triggers are executed on.
B) The type of data manipulation statements specified in a trigger.
C) Foreign key constraints on referenced rows.
D) All of the above.
Q5) In a PL/SQL IF statement,the keywords AND,OR and NOT are ____________ operators.
Q6) A package ________________ contains the private details of a package.
Q7) When a procedure calls itself,this is known as ______________________.
Q8) The common SQL*Plus command used to list the columns of a table is ___________. Page 13
To view all questions and flashcards with answers, click on the resource link above.
Page 14
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) On a large project with many database developers,the ________________ approach to view integration supports more independent work.
Q2) The incremental approach to view integration has more steps than the parallel approach,but the steps are smaller.
A)True
B)False
Q3) Which of the following groups of names would be considered to be homonyms?
A) ADDRESS in CUSTOMER and ADDRESS in CLIENT
B) CID in CUSTOMER and ID in CLIENT
C) LAST_NAME and LNAME
D) All of the above
Q4) If form A must be completed before form B is used,and form A must be completed before form C is used,there is a precedence relationship between A and B,and between A and C,but not between B and C.
A)True
B)False
Q5) The complexity of an individual database can be measured by the size of its
To view all questions and flashcards with answers, click on the resource link above. Page 15
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) Switching from a badly chosen DBMS to a good DBMS will typically involve the following costs:
A) Data conversion
B) Recoding software
C) Retraining employees
D) All of the above
Q2) The SQL:2003 statement to create a user role that is allowed to assign their role to another user is ________________________.
Q3) A(n)____________________ is a workload used to evaluate the performance of a system or product.
Q4) After execution of the commands SQL#1 and SQL#2,a member of the user group Personnel2 may:
A) Change the Salary of any Employee
B) Access the Salary of any Employee
C) Change the Salary of an Employee whose job is 'Clerk'
D) All of the above
Q5) For complex integrity constraints beyond the capability of CHECK constraints,SQL:2003 provides for ___________________,which can be used for constraints involving multiple tables and statistical calculations.
To view all questions and flashcards with answers, click on the resource link above. Page 16
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) Which of the following will cause a deadlock?
A) Transaction T1 requests an exclusive lock on data A at the same time as transaction T2
B) Simultaneously, transaction T2 places an exclusive lock on data B, then requests one on data A
C) Transaction T1 places an exclusive lock on data A, then transaction T2 requests a shared lock on data A
D) Transaction T1 places an exclusive lock on data A, then requests one on data
E) Transaction T1 and T2 modify data A without any lock
Q2) Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee)under the immediate update mode and completes after a checkpoint but before a system failure.The system crashes after the checkpoint.What should the recovery procedure perform to make sure the transaction completes as desired?
A) Nothing
B) Redo forward from checkpoint
C) Undo
D) Undo followed by execution of the transaction again
Q3) Name three types of inconsistent retrievals:
To view all questions and flashcards with answers, click on the resource link above. Page 17
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) 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
Q2) The dimension StoreDim gets data from how many columns of the source table Store?
A) 1
B) 5
C) 6
D) None of the above
Q3) ______________ is the process of discovering implicit data patterns in the data of a data warehouse,and using those patterns for business advantage.
Q4) Because of its advantages over MOLAP and ROLAP,HOLAP is expected to become the dominant storage engine for data warehouses.
A)True
B)False
Q5) ______________ indicates the extent of empty cells in a data cube.
Page 18
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) In client-server database development,proprietary methods typically allow for easier resolution of problems because one vendor is responsible,but these methods may prove to be expensive and inflexible in the long run.
A)True
B)False
Q2) In parallel database processing one of the standard classifications of architecture is referred to as shared everything (SE).Which of the statements below is true of the SE architecture?
A) In the SE architecture, each processor has its private memory, but disks are shared among all processors.
B) In the SE architecture, each processor has its own memory and disks.
C) In the SE approach, memory and disks are shared among a collection of processors.
D) None of the above
Q3) The two-phase commit protocol involves a voting phase and a decision phase which must be coordinated by a centralized coordinator site.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 19
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) In SQL:1999,the keywords ___________________ are used to define a new structured data type.
Q2) An implicit method of a user-defined type used to change the value stored in an attribute is called a(n)______________ method.
Q3) In object-oriented computing,the object DBMS is responsible for binding a message to the appropriate method implementation.
A)True
B)False
Q4) Both the large object architecture and the specialized media server architecture may exhibit poor performance because query optimization and indexing on complex objects are not available.
A)True
B)False
Q5) The ability by a program do to the following violates encapsulation principles:
A) Directly Access LastName
B) Retrieve LastName with method GetLastName();
C) Retrieve Job with the method GetJob();
D) Compute salary with method Salary()
Q6) A(n)______________ definition is a collection of variables and methods.
Page 20
To view all questions and flashcards with answers, click on the resource link above.