Questions and Answers of Concepts Of Database Management

Who at Pitt Fitness determines access privileges for users and enters the appropriate authorization rules in the DBMS?a. Chief security officerb. Chief information officerc. Database administratord.
Pitt Fitness suspects their system contains software that enables someone to surreptitiously record keystrokes.What might their system be infected with?a. Spywareb. Keywarec. Recordersd. Keystroke
Pitt Fitness requires that all employees come into the main office (Shadyside) on a Saturday to practice a step-bystep plan to minimize the effects of a natural disaster. For example, if a freak
Assume that a destructive storm hit the city of Pittsburgh and it took 20 hours for Pitt Fitness’s computer specialists to return the system to normal working operation. Twenty hours, the length of
As a backup system, Pitt Fitness replicates their DBMS to multiple hard drives that can process reservations if another hard drive fails. What is this system for backup called?a. HDb. RAIDc.
In the summer months, Pitt Fitness often suffers from power outages due to thunderstorms. What would be a good investment to prevent losing data during power outages?a. A dedicated electrical lineb.
Considering Pitt Fitness is a privately held company, which of the following data archiving laws must they comply with?a. Sarbanes–Oxleyb. Patriot Actc. FERPAd. None of the choices is required of
What is the repository at Pitt Fitness that contains the log of database maintenance, license keys, and updates to the system?a. DB Diaryb. Check list registerc. Run-bookd. Captain notes
The Sports Physical Therapy group has hired a student intern who is an expert in using the software Tableau.What position should that intern fill?a. Data analystb. Database administratorc. SQL
Sports Physical Therapy is looking to hire an employee that is certified in Microsoft Office to help run the Access database, analyze data with Excel, and use other Office tools. What certification
If you consider that Sports Physical Therapy is a large organization employing many computer personnel, who is the employee that the database administrator most likely reports to?a. Chief executive
An employee at Sports Physical Therapy who had access to the database management system has been fired for inappropriate conduct. Immediately, their database privileges must be rescinded. What is the
Because Sports Physical Therapy deals with sensitive health data, only certain employees should be able to access the sensitive data. What is the process of granting specific rights and privileges to
The database at Sports Physical Therapy that contains the health records of the patients is essential to the survival of the business and all the business processes. In terms of disaster planning,
Which of the following laws most likely governs the data archiving of the database at Sports Physical Therapy, considering it is a privately held company?a. HIPAAb. FERPAc. SOXd. Patriot Act
Sports Physical Therapy regularly uses hardware, software, and databases in a ___________ system and tests and develops applications in a ____________ system.a. Test, liveb. Test, sandboxc.
How much does Amazon Web Services cost?
Which of the following database architectures is most closely aligned with traditional, enterprise-level relational databases?a. Centralizedb. Client/serverc. Data warehoused. Distributed
Identify the characteristics of a new application that lends itself to the MEAN or MERN stack.
Which of the following database architectures best describes how Access works when the database is stored on a file server and accessed by many users with personal computers?a. Centralizedb.
What competitors dominate the operating systems for mobile devices today?
Which of the following best describes the concept of an OLAP cube?a. Selected columns and rows from one or more tables.b. A read-only snapshot of data organized in levels and hierarchies of
The term “big data” is trendy and means different things to different businesses. Ask five people in the Computer Science Department within your college what the term means to them, and organize
If you wanted to evaluate Access data using Excel PivotTables and PivotCharts, what would be the first step?a. Select the data you want to evaluate with a query.b. Export all of your tables to text
How does a browser and the web represent an application of client/server computing?
Big data typically does not include which of the following?a. Clicks on webpagesb. Imagesc. Billing informationd. Keyword search data
What hierarchies and levels of data do you see in Figure 9-10? ProjectEstimates ClientD Record ClientName Tri-Lakes Realtors 1 Tri-Lakes Realtors 1 Tri-Lakes Realtors 1 Tri-Lakes Realtors 1 Tri-Lakes
Identify the characteristics of the business problem that lends itself to an Access solution.
For the following exercises, you will answer problems and questions from management at JC Consulting. You do not need to use the JCConsulting database for any of these exercises.If JC Consulting used
Which of the following databases would probably be considered for a web app if your company had a significant commitment to JavaScript?a. IBM Db2b. Microsoft Accessc. Microsoft SQL Serverd. MongoDB
As JC Consulting grows, they may need to convert their Access application into technologies that can handle more users and locations. What solution stacks would you recommend they consider?
For the following exercises, you will answer problems and questions from management at JC Consulting. You do not need to use the JCConsulting database for any of these exercises.JC Consulting wants
Why might distributed databases work extremely well for software version control projects but not so well for traditional transaction systems?
Which of the following types of databases would most likely be used for tracking connections between people?a. Documentb. Relationalc. Graphd. Flat file
Pitt Fitness would like to enhance their web presence and enable the exchange of data on the web. What type of markup language should they use and why?
Which of the following is a NoSQL database?a. IBM Db2b. Microsoft Accessc. Microsoft SQL Serverd. MongoDB
What makes Access a RAD (rapid application development) framework, and when is it appropriate to choose Microsoft Access as the relational database system for a new application?
Which file extension is a type of XML file?a. Xlsxb. Jsonc. Txtd. Dbf
Describe some of the big data that Pitt Fitness might collect and find useful.
Which menu option on the More button of the External Data tab of the ribbon in Access do you use to export data to SQL Server?a. ODBC Databaseb. dBASE Filec. SQL Serverd. Relational
What primary limitation of relational database management systems do NoSQL database management systems address?
Line charts are best used for which type of visualization?a. Comparing valuesb. Identifying relationshipsc. Showing trends over timed. Displaying cumulative totals
When creating a query in Access for data that you later want to analyze as a PivotTable or PivotChart in Excel, how many fields do you typically use in the visualizations?a. 1b. 2c. 3d. At least 4 or
The Sports Physical Therapy clinic is considering centralizing their database operations. What are their options for this centralized computing?
Object-oriented database management systems are most appropriate for what types of data, and in what applications are they commonly implemented?
The Sports Physical Therapy clinic is having trouble with the performance of their Access database. They would like to split the database between front end and back end to improve performance. How
Pitt Fitness, having transitioned to a larger database system to accommodate their recent growth, is now considering moving their database to the cloud. However, management is concerned that they
How do you start using Google Analytics at a website?
Pitt Fitness stores their Access database on a centralized file server for usage by a few employees. What type of architecture are they using?a. Client/serverb. Cloud-basedc. LAN-basedd. Front end
Why might it be helpful to export data from an Access database to an HTML file?
Pitt Fitness has hired summer interns for data analysis. The interns are running complex queries that take enormous processing power. The clerks at Pitt Fitness have found that registering customers
Where can you find more examples of data visualizations?
The summer interns at Pitt Fitness explain to management that they will be initially summarizing data in a crosstabular organization. What type of tool are the interns using to create these cubes of
Considering that Pitt Fitness is a relatively new company, what types of computer programs does Pitt Fitness not have?a. Legacyb. Dinosaurc. JavaScriptd. object-oriented
Managers at Pitt Fitness want developers to write back-end applications that interact with the centralized database. Which computer language should they use?a. Java Liteb. JavaScriptc. Javad. JavaVB
Pitt Fitness has decided to employ Google Analytics to analyze traffic on their website. The first report has come in with a recording of the bounce rate. What does the bounce rate measure?a. A site
Pitt Fitness has hired a full-time data analyst to produce various data visualizations to help management better serve their customers. Which of the following tools could the new employee use for
The new data analyst at Pitt Fitness wants to create a chart that compares the monthly class registrations by displaying them in horizontal lines. What type of chart would be appropriate?a. Columnb.
The data analyst at Pitt Fitness is creating a chart that displays the relationship between advertising expenses and new customers. What type of chart is she using?a. Barb. Areac. XY Scatterd. Map
When physical therapists are scheduled to see a patient, they ask the clerk for a “hard copy” to view what is needed for that day’s session with the specific treatments. What are the physical
The Sports Physical Therapy clinic is considering moving their database to the cloud. Which of the following is the current market leader in cloud storage, and therefore would be a safe bet for the
The Sports Physical Therapy clinic’s Access database is stored on a centralized computer for usage by a few trusted colleagues. They are therefore running a ______ application.a. Client/serverb.
As the Sports Physical Therapy clinic grows, management is considering moving to a larger database management system, where the clients perform the presentation functions, a database server performs
The Sports Physical Therapy clinic has an Access database for patients, therapists, and appointments. The clinic also has other systems that record information such as insurance details, accounting
The IT manager at the Sports Physical Therapy clinic created a system to consolidate and summarize data from its Access database and other insurance, accounting, and employee systems to produces
The summer intern at Sports Physical Therapy clinic has been using Excel to analyze some data. The intern is displaying a crosstabular organization of the data with the session date as the row
The Sports Physical Therapy clinic is not a large business, but management still would like to analyze their “big data” using a moderately priced service. Which of the following would be
The summer intern at Sports Physical Therapy clinic would like to do data visualizations that are more sophisticated than the software Excel can provide. Which of the following solutions would be the
The summer intern at Sports Physical Therapy clinic is using Excel to create some interesting charts of the activities at the clinic. The intern would like to show trends over time based on a
List ProjectLineItemID values that are related to ProjectID 3.a. ProjectLineItemIDs 1 and 2b. ProjectLineItemIDs 8 and 9c. ProjectLineItemIDs 39, 40, and 41d. ProjectLineItemID 4 EmployeelD LastName
Which projects had an estimated start date prior to 1/1/2020?a. ProjectIDs 1, 2, 3, and 7b. ProjectIDs 8, 16, and 24c. ProjectIDs 8–30d. ProjectID 1, 9, and 17 EmployeelD LastName FirstName
What client is not a government entity?a. Project Lead The Wayb. Aspire Associatesc. The HELPCardd. All are government entities. EmployeelD LastName FirstName
Which employee has a salary value of $8,100?a. Nathan Gellerb. Nigel Horvatc. Hector Garciad. Nada Prohm EmployeelD LastName FirstName
List the name of the client related to ProjectID 3.a. SecureCom Wirelessb. Loren Groupc. Midstates Auto Auctiond. Project Lead The Way EmployeelD LastName FirstName
For the record with a ProjectLineItemID value of 7, why does the Factor field contain 1.3?a. It represents an estimated increase of 1.3% due to risk or complexity for that task.b. It represents an
Find the total, average, and count of the Salary field for all employees grouped by title. Sort the records in ascending order by title. What is the average of the salaries for the first title in the
Select the records in the TaskMasterList table with a CategoryID field value of Database and then create an update query to update their Estimate field values by 10 percent. How many records are
Make a table with the ClientName, ProjectID, ProjectStartDate, and TaskID fields for all projects with a TaskID field value of MEET00. Sort the records in ascending order by the ProjectStartDate
Complete the following statement to list the employee ID, first name, and last name of all employees. _____EMPLOYEES OVER (EmployeeID, LastName, FirstName) GIVING Answera. PROJECTb. JOINc.
Complete the following statement to list all information from the TaskMasterList table for task ID CODE05. SELECT TaskMasterList WHERE _____ GIVING Answera. TaskID = CODE05b. TaskID = 'CODE05'c.
Complete the following statements to list the project ID, project start date, client ID, and client name for each project. JOIN Projects Clients WHERE _____ GIVING Temp1 PROJECT Temp1 OVER
Complete the following statements to list the project ID, project start date, client ID, and client name for each project created for the employee with the last name of Winter. _____ Projects Clients
Select the EmployeeID, LastName, HireDate, and Salary fields for employees hired on or before 1/1/2020. Create a calculated field named Bonus that is calculated as 50 percent of their monthly salary,
Select the ProjectID, ProjectStartDate, ClientName, TaskID, and Description fields for TaskID TEST01 and a ProjectStartDate after 1/1/2020. Sort the records in ascending order by ProjectStartDate.
Select the ProjectID, ClientName, TaskID, and Description fields for TaskIDs TEST01 or TEST02. Sort the records in ascending order by ProjectID and then by TaskID. What are the ProjectID and TaskID
If your database is performing well, why is it still important to concern yourself with techniques that improve the performance of queries?
Which of the following tasks is not priced by the project?a. TaskID DB01 Design relational databaseb. Task ID DB04 Install SQL Server databasec. Task ID MEET00 Initial customer meetingd. Task ID
For the record with a ProjectLineItemID value of 7, why does the Quantity field contain 20?a. It represents an estimate of 20 hours.b. It represents an estimate of 20 minutes.c. It represents an
Answer each of the following questions using the JCC data shown in Figure 1-5. No computer work is required.Figure 1-5What is the cost for an initial meeting with a client, TaskID MEET00?a. $100b.
Answer each of the following questions using the JCC data shown in Figure 1-5. No computer work is required.Figure 1-5What is the cost for creating a shopping cart, TaskID CODE15?a. $150/hourb.
Which instructor lives on Webster Avenue?a. Vicki Peguesb. Neda Tahanc. Memo Saidd. Luke Lane Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity
Who is the oldest customer?a. Glenn Spencerb. Jess Hillc. Gene Shafferd. Nour Aboud Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity
What class did Terrance Feldman reserve?a. Barreb. Barbell Powerc. Yoga Balanced. Yogalates Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity
In what location and room is ClassID 9, Barre, held?a. Shadyside, 159Bb. Oakland, Mainc. Shadyside, Maind. Oakland, 159B Instructors InstructoriD InstructorLastName InstructorFirstName
What time does ClassID 24, Intense Cycle, begin?a. 2 pmb. 1 pmc. 12 pmd. 10 am Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState
How long is the ClassID 15, Bootcamp?a. 60 minutesb. 45 minutesc. 30 minutesd. 90 minutes Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity
Who teaches ClassID 21, Combination?a. Maria D’Angelob. Robert Sistoc. Michael Nguyend. Megan Kobinski Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress
What customer has reservation 2100014?a. Debbie Thornb. Tamara Larac. Sylvia Devitod. Margo Patterson Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress
When was customer Ramiro Sanchez born?a. 10/21/2000b. 4/20/1984c. 2/16/1957d. 4/1/1953 Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity
How many classes are offered on Mondays?a. 2b. 3c. 0d. 5 Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode

Showing 300 - 400 of 497