Quiz M01 Take 2

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, 3:05 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 KEPT Attempt 2 14 minutes 20 out of 20 LATEST Attempt 2 14 minutes 20 out of 20 Attempt 1 30 minutes 15.33 out of 20 Score for this attempt: 20 out of 20 Submitted Jan 21 at 3:04am This attempt took 14 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. 1 / 1 pts Question 1 What does the management of data involve? Defining structures for storage of information and providing mechanism for manipulating data. Correct! Correct! Securing the application from hackers gaining access to data
1/21/24, 3:05 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 2/9 Transferring data from one device to another Running software from remote location 1 / 1 pts Question 2 What does a database design involve? The design of a database schema Correct! Correct! The architecture of a database management system The design of an application module The design of an information system 1 / 1 pts Question 3 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 4 The earliest database system arose in 1980s
1/21/24, 3:05 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 3/9 True False Correct! Correct! 1 / 1 pts Question 5 The types of database users are: Programmers Correct! Correct! Naïve Correct! Correct! Sophisticated user Correct! Correct! Auditor Testers 1 / 1 pts Question 6 What was the first relational database product? Oracle Ingress IBM DB2 IBM System R Correct! Correct! DEC rdb
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, 3:05 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 4/9 1 / 1 pts Question 7 An instance can be defined as: A set of instructions and rules that allows the database to operate A collection of tables and SQL commands that needs to be executed against the database. A collection of information stored in the database at a particular moment Correct! Correct! A design of a database 1 / 1 pts Question 8 What language would you use to specify the storage structure of a database schema? DDL Correct! Correct! .Net Java DML 1 / 1 pts Question 9
1/21/24, 3:05 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 5/9 What is the role of data abstraction in a database? Provides an extra level of security Provides users access to the data within the database. Hide the complexity of storing data from the user. Correct! Correct! 1 / 1 pts Question 10 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 11 The storage manager components includes: Transaction manager Correct! Correct! File manager Correct! Correct! Authorization and integrity manager Correct! Correct! Buffer manager Correct! Correct!
1/21/24, 3:05 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 6/9 Log file manager Optimizer 1 / 1 pts Question 12 Examples of the Database Administrator routine maintenance activities include: Applying patches to the operating system Ensuring database performance Correct! Correct! Backing up the database Correct! Correct! Monitoring access to the applications Ensure enough free disk space is available Correct! Correct! 1 / 1 pts Question 13 Data manipulation language is a language that enables users to access or manipulate data. True Correct! Correct! False 1 / 1 pts Question 14
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, 3:05 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 7/9 Information processing drives the growth of computers. True Correct! Correct! False 1 / 1 pts Question 15 The three properties of transaction management discussed in this book are: Durability Correct! Correct! Isolation Recovery Consistency Correct! Correct! Atomicity Correct! Correct! 1 / 1 pts Question 16 Responsibilities of Database Administrators includes: Writing code for the application Defining the storage structure and access method definition Correct! Correct! Defining the schema definition Correct! Correct! Applying schema and physical organization modification Correct! Correct!
1/21/24, 3:05 AM M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349 8/9 Patching the operating system Granting access to the application 1 / 1 pts Question 17 What data structures does the storage manager implement? Data files Correct! Correct! Constraints Indices Correct! Correct! Tables File systems Data Dictionary Correct! Correct! 1 / 1 pts Question 18 What are the two languages a database system provides? R and CC++ Java and Python SQL and TSQL DDL and DML Correct! Correct!
1/21/24, 3:05 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 Some of the disadvantage of keeping information in a file-processing system are: Data redundancy and inconsistency Correct! Correct! Security problems Correct! Correct! Data stored is not organized Data a shared Data isolation Correct! Correct! Difficulty accessing the data Correct! Correct! 1 / 1 pts Question 20 Data models can be classified into four categories. True Correct! Correct! False Quiz Score: 20 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