Questions and Answers of Concepts Of Database Management

Many-to-many relationships _____.a. Are common in almost all relational databasesb. Represent unnormalized datac. Create orphan recordsd. Can be directly implemented using two link lines in most
For the table Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate), which field is the primary key field?a. LastNameb. BirthDatec.
For the table Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate), which field is a foreign key?a. LastNameb. CustomerIDc. There
For the table Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate), which of the following is a secondary key?a. LastName,
What field(s) in the Customers table would be the most appropriate for a CustomerName index?a. LastNameb. LastName and FirstNamec. LastName, FirstName, and BirthDated. CustomerID
What is the relationship between the tables Classes and Reservations?a. One to oneb. One to manyc. Many to manyd. The tables aren’t related.
What is the relationship between the tables Instructors and Classes?a. One to oneb. One to manyc. Many to manyd. The tables aren’t related.
What is the relationship between the tables Classes and Customers?a. One to oneb. One to manyc. Many to manyd. The tables aren’t related.
Which of the following tables could be considered a composite entity in an ERM and a junction table in an E-R diagram?a. Classesb. Instructorsc. Reservationsd. Customers
Which of the following tables could be considered a composite entity in an ERM and a junction table in an E-R diagram?a. ClassInstructorsb. Instructorsc. Customersd. Classes
The Pitt Fitness program director wants to list customer last names and first names along with the classes they are taking. He creates a query using the Customers and Classes tables. In the query
What would be a possible alternative key field for the Session table?a. There isn’t a good choice for an alternative key field.b. SessionDatec. PatientNumd. TherapyCode
What is a good choice for a secondary key in the Therapist table?a. Streetb. LastName, FirstNamec. FirstNamed. City
Identify the foreign key(s) in the Session table.a. SessionDateb. PatientNum, TherapyCodec. PatientNum, TherapistIDd. PatientNum, TherapyCode, TherapistID
What is the relationship between the tables Patient and Session?a. One to oneb. One to manyc. Many to manyd. There isn’t a relationship.
What is the relationship between the tables Patient and Therapies?a. One to oneb. One to manyc. Many to manyd. There isn’t a relationship.
What is the relationship between the tables Therapist and Therapies?a. One to oneb. One to manyc. Many to manyd. There isn’t a relationship.
What is the relationship between the tables Therapist and Session?a. One to oneb. One to manyc. Many to manyd. There isn’t a relationship.
Which of the following tables is a junction table?a. Patientb. Therapiesc. Sessiond. Therapist
What is the main difference between the SQL keywords and HTTP methods shown in Figure 7-1? Operation Create Read Update Delete SQL Keyword INSERT SELECT UPDATE DELETE Common HTTP
Which of the following fields in the Therapist table would have the highest cardinality?a. TherapistIDb. LastNamec. FirstNamed. Street
Which of the following programming languages does the “P” in modern software solution stacks such as the LAMP, LAPP, and WAMP stacks not stand for:a. PHPb. Pythonc. Perld. Pascal
Create a list of five practical and free precautions you can take to protect your Social Security number.
Which of the following types of Access objects may not be used for data entry?a. ProjectEstimates reportb. Projects formc. ProjectEstimates queryd. Projects table
How do modern online shopping carts help maintain data concurrency?
Which of the following would not be an example of metadata found in a database catalog?a. Values in a primary key fieldb. Table and view namesc. Relationship descriptionsd. Index definitions
Use Figure 7-5 to research a database service for an enterprise-level relational database and document three new key terms based on how that particular vendor handles that particular service.
Which of the following represents information that the Database Documenter feature cannot supply?a. property information for tablesb. list of current unique values for fieldsc. index information for
What symbol does Access use to the left of a record when it is currently being edited and is therefore locked so that other users cannot currently update it?a. Lockb. Black right arrowc. Plus signd.
How do you back up an online service such as a cloud-based database?
Data consistency means .a. Allowing two or more users to access the database at the same timeb. Giving each user a consistent view of the data including changesc. Using properties such as the
What type of backup schedule and process would you recommend for JC Consulting?
Which Access tool helps you recover data in the current database?a. Analyze Performanceb. Database Documenterc. Compact and Repair Databased. Backup Database
How do you create a strong password (one that can’t be easily hacked)?
Which feature potentially helps you recover data in an Access database?a. Journalingb. Incremental backupsc. Two-step lockingd. Compact and repair
What type of compact and repair schedule would you recommend for JC Consulting?
A database password in Access works at the level.a. Recordb. Userc. Filed. Group
What is the main difference between reconciling the copies of data involved in traditional database replication as compared to the copies created in the distributed database model used by Git?
Which SQL statement would give user cyclone1 the ability to select, insert, update, or delete records from the Students table?a. GRANT SELECT, INSERT on STUDENTS to cyclone1b. GRANT ALL on STUDENTS
Pitt Fitness would like to analyze their options for an in-house database versus a cloud database-as-a-service. What are the benefits to moving their database to the cloud?
What does Access automatically add to backup files?a. Current user’s nameb. Current datec. Current time of dayd. Backup sequential value
Which of the following is not a constraint on the primary key field for a table?a. There may be no null values.b. All values must be unique.c. All values must have a matching value in the foreign key
Create a data integrity constraint for the Pitt Fitness database that only allows a user to enter one of the three fitness locations into the Classes table.
Which SQL statement would add a new field in the Employees table to a query?a. SELECT ALL FROM EMPLOYEESb. SELECT * FROM EMPLOYEESc. SELECT EACH FROM EMPLOYEESd. SELECT FROM EMPLOYEES
Which of the following changes to a database would most likely require the most rework to existing programs and queries?a. Adding a new field to a tableb. Creating a new indexc. Changing
The IT manager at Sports Physical Therapy finds it useful to identify all objects that are dependent on a particular table, query, form, or report. List the tables that the Session table depends on.
Which process can you set to automatically occur when a database is closed?a. Compactb. Backupc. Documentd. Analyze
GitHub and BitBucket are popular websites for .a. Hosting projects that use the Git language for version controlb. Completing full-stack web app projectsc. Posting technical questions and receiving
The IT manager at Sports Physical Therapy needs to know all the relationships in the database. Use Access to create a Relationship report for the Sports Physical Therapy database for your own
The new DBA at Pitt Fitness is working on catalog services in Microsoft Access. This employee has published an internal report on the database schema, but the managers receiving this report are
The new IT person hired by Pitt Fitness is becoming familiar with the database and requests the database schema. How can you generate the schema from the current Access database?a. Click the All
Two clerks at Pitt Fitness need to update an address in the Access database for the customer Min Jee Choi. One clerk sees a note about updating the address and begins to edit Min Jee’s record. At
Popular classes at Pitt Fitness fill up almost immediately. What database technique would work well to determine which people should be admitted into a popular class based on when they requested
Pitt Fitness’s IT person backs up the database every day at the end of business hours. After completing their evening classes, customers register for classes for the upcoming week. Assume that a
Suppose Pitt Fitness were using an enterprise-level DBMS when a thunderstorm caused a brief power loss to the database, stopping a class registration entry in midstream. When the power was fully
The IT manager at Pitt Fitness is creating a backup of the company database. What is the best location for storing the backup?a. At the Downtown locationb. Next to the current database for easy
Which of the following data integrity constraints would ensure Pitt Fitness has a consistent method to record customer phone numbers?a. Format (Input Mask)b. Legal valuesc. Data typed. Validation Rule
Pitt Fitness is now routinely creating backups of their database. They store them on a server and have a number of backup files that need to be deleted. Which of the following files is the correct
The IT manager at Pitt Fitness wants to secure the database using a method that includes processing logic to periodically change and synchronize with passwords stored on the database. Which of the
If Sports Physical Therapy had an enterprise DBMS, the IT manager might look at the journal log if a record seemed wrong. Which log entry would indicate that a transaction was completed
If Sports Physical Therapy had an enterprise DBMS and the IT manager looked at the journal log, which log entry would indicate a change of a record?a. Startb. Commitc. Insertd. Update
Security is especially important for Sports Physical Therapy because the medical information stored on the database must be kept private by law. What is the federal law that protects medical records
The IT manager at Sports Physical Therapy would like to secure the database with an authentication method that identifies users by physical or behavioral characteristics. What type of authentication
The IT manager at Sports Physical Therapy would like to incorporate a data integrity constraint to ensure accuracy and consistency to the database. Specifically, the manager wants to consider a legal
Which of the following fields in the Patient table in the Sports Physical Therapy database would be appropriate for an Access input mask?a. LastNameb. FirstNamec. Addressd. State
How can Sports Physical Therapy ensure that if an unauthorized user attempts to gain access to the database, they see only an indecipherable version of the database?a. Set a strong password.b.
What type of concurrent update occurs when two physical therapists are trying to update the record of the same patient at the same time?a. Record-level lockingb. Read-only lockingc. Stateless
What is the property of the Sports Physical Therapy database that lets the users change the database structure without requiring changes to all the programs that might access that database?a. Clean
The IT manager at Sports Physical Therapy finds it useful to identify all objects that depend on a particular table, query, form, or report. How can that be accomplished in Access?a. Double-click the
What is the main difference between traditional and emerging careers in the database industry?
Which of the following is a common job responsibility for someone in the database industry?a. Network securityb. Data securityc. Application programmingd. Web app development
What policies have you seen your school or college take to protect your privacy?
Which of the following types of external data might be valuable to JC Consulting, but is not currently stored in their internal Access database?a. Clicks on their home pageb. Hashtag references in
What are the major areas of responsibility for a DBA?
Which of the following would generally not be a typical responsibility of the DBA?a. Data securityb. Data entryc. Data disaster planningd. Data dictionary maintenance
What mission-critical applications must your college or university protect?
JC Consulting is a small business without a dedicated DBA. An employee with which of the following skills would probably be the best candidate to train for the position?a. Marketing background and
What has been one of the most recent significant cyberattacks?
Which of the following technical job titles typically does not report to the DBA?a. Data analystb. Data operations managerc. Application programmerd. System DBA
Is it as important for a small business like JC Consulting to have a disaster recovery plan as it is for a large corporation? Please cite three different examples to support your position.
JC Consulting is a small business without a dedicated DBA. An employee with which job title is most likely to be in charge of the database?a. Operations managerb. Sales managerc. Personnel managerd.
What are the most sought-after technical skills in the database industry?
Which of the following is typically not a responsibility of a data analyst?a. Data visualizationb. Writing SQLc. Big data analysisd. Transaction data analysis
How might JC Consulting use the cloud?
What skills would someone need at JC Consulting to analyze the potential revenue by ZipCode?a. How to build summary queriesb. How table relationships are set upc. How fields are organized within each
How long does it take to become a DBA?
Which of the following is typically not a primary responsibility of a data scientist?a. Data securityb. Statistical analysisc. Big data analysisd. Data visualization
The database administrator at Pitt Fitness wants to develop and test new applications. What is the safest way to do this, considering the company has customers reserving classes frequently?
JC Consulting just hired a new summer intern in his first year of college to gather social media information about the company. The intern wants to be called a “data scientist.” Is this an
What is the best career path to becoming a DBA?
Which of the following is not a currently popular database industry credential?a. Microsoft Access MOSb. Microsoft Technology Associatec. Oracle Certified Professional, MySQLd. Universal Relational
Considering that Pitt Fitness is a small company, what type of backup site would be appropriate for their smaller budget?
Which of the following would be the most appropriate industry credential to earn for the person responsible for the JCConsulting database?a. Microsoft Access MOSb. Microsoft Technology Associatec.
What are typical qualifications for a data analyst?
Considering that Sports Physical Therapy constantly deals with health information, who would be the best person to hire to handle the government regulations and compliance? This person would report
Pitt Fitness realizes that the company needs to be on top of all trends in fitness centers to keep up with the competition. To ensure they stay on the cutting edge, the company would like to employ a
What are typical qualifications for a data scientist?
What sorts of big data might be important for Sports Physical Therapy? Research physical therapy clinics online to find out more information about what they might find vital to be competitive.
Pitt Fitness employs a person who defines and models data requirements, business rules, and database policies.This employee installs, configures, and tests database hardware and software. What is
What should someone considering a career in the database industry keep in mind?

Showing 200 - 300 of 497