Quiz M01 Take 1

pdf

School

Ivy Tech Community College, Indianapolis *

*We aren’t endorsed by this school

Course

110

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

9

Uploaded by MagistrateScorpionPerson5065

Report
1/21/24, 2:49 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 1/9 M01 Quiz Due Jan 22 at 5pm Points 20 Questions 20 Time Limit 30 Minutes Allowed Attempts 2 Instructions Attempt History Attempt Time Score LATEST Attempt 1 30 minutes 15.33 out of 20 Score for this attempt: 15.33 out of 20 Submitted Jan 21 at 2:47am This attempt took 30 minutes. This assignment takes the format of a quiz over Module 1. This quiz consists of 20 multiple choices, multiple answer, and true-false questions. There is a 30-minute time limit on this quiz, and you will be provided two attempts, the highest score will be kept. This quiz is due by the stated due date. It is suggested that you print the questions, review the chapter, and then come back and enter your answers. Take the Quiz Again 0 / 1 pts Question 1 What is the role of data abstraction in a database? Provides users access to the data within the database. ou Answered ou Answered Provides an extra level of security Hide the complexity of storing data from the user. orrect Answer orrect Answer
1/21/24, 2:49 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 2/9 1 / 1 pts Question 2 In what decade did the type of data stored in a database evolve. 1980 to 1990 1990 1970 to 1980 2000 Correct! Correct! 1 / 1 pts Question 3 The types of database users are: Sophisticated user Correct! Correct! Naïve Correct! Correct! Testers Programmers Correct! Correct! Auditor 1 / 1 pts Question 4 What is a domain constraint?
1/21/24, 2:49 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 3/9 Domains that specify possible values that can be store in an attribute Correct! Correct! The rules that specifies the type of language used to define the data structure. Restrictions on the number of rows added to a table. 1 / 1 pts Question 5 Information processing drives the growth of computers. True Correct! Correct! False 1 / 1 pts Question 6 A variety of new data-intensive applications and the need for rapid development lead to NoSQL database. True Correct! Correct! False 1 / 1 pts Question 7 What does a database design involve?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1/21/24, 2:49 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 4/9 The design of an application module The design of a database schema Correct! Correct! The design of an information system The architecture of a database management system 0 / 1 pts Question 8 What was the first relational database product? IBM System R orrect Answer orrect Answer Ingress DEC rdb Oracle ou Answered ou Answered IBM DB2 1 / 1 pts Question 9 What are the two languages a database system provides? SQL and TSQL Java and Python DDL and DML Correct! Correct! R and CC++
1/21/24, 2:49 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 5/9 1 / 1 pts Question 10 What does the management of data involve? Defining structures for storage of information and providing mechanism for manipulating data. Correct! Correct! Transferring data from one device to another Securing the application from hackers gaining access to data Running software from remote location 1 / 1 pts Question 11 What data structures does the storage manager implement? Data files Correct! Correct! Tables File systems Data Dictionary Correct! Correct! Indices Correct! Correct! Constraints
1/21/24, 2:49 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 6/9 1 / 1 pts Question 12 A database management system (DBMS) is A collection of data A collection of interrelated data and set of programs used to access data Correct! Correct! A type of file system used to store data Software used to design a database 1 / 1 pts Question 13 The storage manager components includes: Transaction manager Correct! Correct! Log file manager Optimizer Buffer manager Correct! Correct! File manager Correct! Correct! Authorization and integrity manager Correct! Correct! 1 / 1 pts Question 14 An instance can be defined as:
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1/21/24, 2:49 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 7/9 A design of a database A set of instructions and rules that allows the database to operate A collection of information stored in the database at a particular moment Correct! Correct! A collection of tables and SQL commands that needs to be executed against the database. 1 / 1 pts Question 15 The three properties of transaction management discussed in this book are: Consistency Correct! Correct! Atomicity Correct! Correct! Durability Correct! Correct! Isolation Recovery 0.33 / 1 pts Question 16 Examples of the Database Administrator routine maintenance activities include: Monitoring access to the applications ou Answered ou Answered
1/21/24, 2:49 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 8/9 Ensure enough free disk space is available Correct! Correct! Backing up the database Correct! Correct! Ensuring database performance orrect Answer orrect Answer Applying patches to the operating system 1 / 1 pts Question 17 The earliest database system arose in 1980s True False Correct! Correct! 0 / 1 pts Question 18 Responsibilities of Database Administrators includes: Applying schema and physical organization modification orrect Answer orrect Answer Defining the storage structure and access method definition Correct! Correct! Patching the operating system ou Answered ou Answered Writing code for the application Defining the schema definition Correct! Correct! Granting access to the application ou Answered ou Answered
1/21/24, 2:49 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 9/9 1 / 1 pts Question 19 What language would you use to specify the storage structure of a database schema? Java .Net DML DDL Correct! Correct! 0 / 1 pts Question 20 What are applications? Software used to interact with users and servers ou Answered ou Answered Programs that are used to interact with the database orrect Answer orrect Answer Programs that allows the server to interact with the database. Quiz Score: 15.33 out of 20
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help