MCQExams
0:0:1
CBSE
JEE
NTSE
NEET
Practice
Homework
×
practice
Mis Chapter 5 Quiz
1) What are the differences between a spreadsheet and a database?
Report Question
0%
A) adding structures to improve the performance of database applications
0%
Database developers use the DBMS to create tables, relationships, and other structures in the database. A form is used to define a new table or to modify an existing one. To create a new table, the developer just fills the new table's metadata into the form. To modify an existing table, a developer opens the metadata form for that table and adds a new row of metadata.
0%
B) special data that describes the structure of a database
0%
The purpose of both a spreadsheet and a database is to keep track of things. However, unlike a spreadsheet, a database offers the solution of being able to keep track of more than one type of data. Lists of data involving a single theme can be stored in a spreadsheet. However, lists that involve multiple themes require a database.
4) In a database, bytes are grouped into ________.
Report Question
0%
record
0%
relation
0%
fields
0%
columns
6) In a database, rows are also called ________.
Report Question
0%
reports
0%
records
0%
columns
0%
fields
5) Explain database management systems (DBMS).
Report Question
0%
Database developers use the DBMS to create tables, relationships, and other structures in the database. A form is used to define a new table or to modify an existing one. To create a new table, the developer just fills the new table's metadata into the form. To modify an existing table, a developer opens the metadata form for that table and adds a new row of metadata.
0%
A database management system (DBMS) is a program used to create, process, and administer a database. A DBMS is different from a database in that a DBMS is a software program while a database is a collection of tables, relationships, and metadata. Almost no organization develops its own DBMS. Instead, companies license DBMS products from vendors such as IBM, Microsoft, Oracle, and others. Popular DBMS products are DB2 from IBM, Access and SQL Server from Microsoft, and Oracle Database from the Oracle Corporation. Another popular DBMS is MySQL, an open source DBMS product that is license-free for most applications.
0%
C) database management system (DBMS)
0%
Databases that carry their data in the form of tables and that represent relationships using foreign keys are called relational databases. Foreign keys are columns that are keys of a different table than the one in which they reside. The relational model was the single, standard way of processing databases for over thirty years. Recently, however, new styles of database processing have started appearing. Part of the reason is that the major principles of the relational model-fixed-sized tables, representing relationships with foreign keys, and the theory of normalization-came about because of limited storage space and limited processing speeds back in the 1960s and early 1970s. At some point, maybe the mid-1990s, these limitations were removed by improved storage and processing technology and today they do not exist. In other words, the relational model is not needed today. Other reasons for the development of nonrelational databases include the need to gain faster performance using many servers and to store new types of data such as images, audio, and videos.
18) The administrative functions of a DBMS include backing up database data.
Report Question
0%
F
0%
T
0%
C) inserting or deleting data
0%
DB2
5) In a database, columns are also called ________.
Report Question
0%
table
0%
key
0%
columns
0%
fields
9) The format of the metadata in a database depends on the software product that is processing the database.
Report Question
0%
F
0%
T
0%
key
0%
D) unnecessary in cases where relational databases meet the needs of organizations
33) Browser-based database applications differ from traditional applications in that they ________.
Report Question
0%
C) are usually open to the public
0%
C) inserting or deleting data
0%
C) Structured Query Language
0%
C) administering the database
14) In a database, a table is formally referred to as a ________.
Report Question
0%
foreign
0%
record
0%
table
0%
relation
22) ________ is an international standard language that is used for processing a database.
Report Question
0%
B) administrative function
0%
C) Structured Query Language
0%
B) application programs
0%
A) database application
26) Conducting training to ensure that users and operations personnel know and understand recovery procedures is a(n) ________ of the DBMS.
Report Question
0%
C) administering the database
0%
C) Structured Query Language
0%
D) administrative function
0%
B) administrative function
19) Which of the following is a function of the DBMS?
Report Question
0%
D) It represents relationships with the help of foreign keys.
0%
It is a character of data.
0%
D) unnecessary in cases where relational databases meet the needs of organizations
0%
D) processing a database by inserting or modifying data
35) Which of the following is a drawback of the relational database processing model?
Report Question
0%
C) It was never a natural fit with business documents.
0%
A) adding structures to improve the performance of database applications
0%
C) lost-update problem
0%
B) SQL Server
16) The DBMS can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database.
Report Question
0%
A) storing data types such as images, audio, and videos in organizations
0%
C) inserting or deleting data
0%
T
0%
F
What is a NoSQL DBMS?
Report Question
0%
: A database is self-describing in that it contains, within itself, a description of its contents. This is because it contains not only data, but also data about the data in the database. This data is known as metadata. It is the presence of metadata that makes databases much more useful than spreadsheets or data in other lists. Because of metadata, no one needs to guess, remember, or even record what is in a database. To find out what a database contains, we just look at the metadata inside the database
0%
Databases that carry their data in the form of tables and that represent relationships using foreign keys are called relational databases. Foreign keys are columns that are keys of a different table than the one in which they reside. The relational model was the single, standard way of processing databases for over thirty years. Recently, however, new styles of database processing have started appearing. Part of the reason is that the major principles of the relational model-fixed-sized tables, representing relationships with foreign keys, and the theory of normalization-came about because of limited storage space and limited processing speeds back in the 1960s and early 1970s. At some point, maybe the mid-1990s, these limitations were removed by improved storage and processing technology and today they do not exist. In other words, the relational model is not needed today. Other reasons for the development of nonrelational databases include the need to gain faster performance using many servers and to store new types of data such as images, audio, and videos.
0%
A few years back, Amazon.com determined that relational database technology wouldn't meet its processing needs, and it developed a nonrelational data store called Dynamo. Google (developed Bigtable) and Facebook (developed Cassandra) also followed suit. Such nonrelational DBMS have come to be called NoSQL DBMS. This term refers to software systems that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud. The rise of NoSQL does mean that, for large organizational IS, choosing a relational DBMS is no longer automatic. NoSQL DBMS products are very technical and can be used only by those with a deep background in computer science
0%
The purpose of both a spreadsheet and a database is to keep track of things. However, unlike a spreadsheet, a database offers the solution of being able to keep track of more than one type of data. Lists of data involving a single theme can be stored in a spreadsheet. However, lists that involve multiple themes require a database.
29) Which of the following elements of a database application presents data in a structured manner using sorting, grouping, filtering, and other operations?
Report Question
0%
C) They are thin-client applications that need not be pre-installed on a user's computer.
0%
Dynamo
0%
reports
0%
B) special data that describes the structure of a database
2) A database is a self-describing collection of integrated records.
Report Question
0%
F
0%
relation
0%
T
0%
columns
32) Which of the following is true of browser-based database applications?
Report Question
0%
B) special data that describes the structure of a database
0%
A) adding structures to improve the performance of database applications
0%
D) processing a database by inserting or modifying data
0%
C) They are thin-client applications that need not be pre-installed on a user's computer.
18) ________ is a popular enterprise DBMS product from IBM.
Report Question
0%
DB2
0%
T
0%
database
0%
key
11) Most organizations develop their own database management systems.
Report Question
0%
The purpose of both a spreadsheet and a database is to keep track of things. However, unlike a spreadsheet, a database offers the solution of being able to keep track of more than one type of data. Lists of data involving a single theme can be stored in a spreadsheet. However, lists that involve multiple themes require a database.
0%
DB2
0%
T
0%
F
A ________ is a self-describing collection of integrated records.
Report Question
0%
DB2
0%
database
0%
A) database application
0%
C) Structured Query Language
7) In a database, a key is a column or group of columns that identifies a unique row in a table.
Report Question
0%
F
0%
T
0%
file
0%
foreign
4) In a database, columns are also called records.
Report Question
0%
records
0%
F
0%
fields
0%
file
19) A database application serves as an intermediary between users and database data.
Report Question
0%
record
0%
F
0%
T
0%
relational
17) DBMS administrative functions include adding structures to improve the performance of database applications.
Report Question
0%
T
0%
table
0%
F
0%
key
8) In a database, a group of similar rows is called a ________.
Report Question
0%
table
0%
file
0%
fields
0%
relation
What are relational databases? What has led to the development of new nonrelational styles of database processing?
Report Question
0%
: A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data. Database applications reformat database table data to make it more informative and more easily updated. Application programs also have features that provide security, maintain data consistency, and handle special cases. The specific purposes of the four elements of a database application are:Forms- View data; insert new, update existing, and delete existing dataReports- Structured presentation of data using sorting, grouping, filtering, and other operations Queries- Search based upon data values provided by the userApplication programs- Provide security, data consistency, and special-purpose processing, e.g., handle out-of-stock situations.
0%
Databases that carry their data in the form of tables and that represent relationships using foreign keys are called relational databases. Foreign keys are columns that are keys of a different table than the one in which they reside. The relational model was the single, standard way of processing databases for over thirty years. Recently, however, new styles of database processing have started appearing. Part of the reason is that the major principles of the relational model-fixed-sized tables, representing relationships with foreign keys, and the theory of normalization-came about because of limited storage space and limited processing speeds back in the 1960s and early 1970s. At some point, maybe the mid-1990s, these limitations were removed by improved storage and processing technology and today they do not exist. In other words, the relational model is not needed today. Other reasons for the development of nonrelational databases include the need to gain faster performance using many servers and to store new types of data such as images, audio, and videos.
0%
A few years back, Amazon.com determined that relational database technology wouldn't meet its processing needs, and it developed a nonrelational data store called Dynamo. Google (developed Bigtable) and Facebook (developed Cassandra) also followed suit. Such nonrelational DBMS have come to be called NoSQL DBMS. This term refers to software systems that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud. The rise of NoSQL does mean that, for large organizational IS, choosing a relational DBMS is no longer automatic. NoSQL DBMS products are very technical and can be used only by those with a deep background in computer science
0%
Database developers use the DBMS to create tables, relationships, and other structures in the database. A form is used to define a new table or to modify an existing one. To create a new table, the developer just fills the new table's metadata into the form. To modify an existing table, a developer opens the metadata form for that table and adds a new row of metadata.
30) NoSQL DBMS products are very technical and can be used only by those with a deep background in computer science.
Report Question
0%
F
0%
T
0%
key
0%
A) storing data types such as images, audio, and videos in organizations
Define SQL.
Report Question
0%
: A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data. Database applications reformat database table data to make it more informative and more easily updated. Application programs also have features that provide security, maintain data consistency, and handle special cases. The specific purposes of the four elements of a database application are:Forms- View data; insert new, update existing, and delete existing dataReports- Structured presentation of data using sorting, grouping, filtering, and other operations Queries- Search based upon data values provided by the userApplication programs- Provide security, data consistency, and special-purpose processing, e.g., handle out-of-stock situations.
0%
Structured Query Language (SQL) is an international standard language for processing a database. DBMS products like DB2 from IBM, Access and SQL Server from Microsoft, and Oracle Database from the Oracle Corporation accept and process SQL statements. Another popular DBMS that accepts SQL statements is MySQL, an open source DBMS product that is license-free for most applications. One need not understand or remember SQL language syntax. Instead, one needs to just realize that SQL is an international standard for processing a database. Also, SQL can be used to create databases and database structures.
0%
A database is a self-describing collection of integrated records that is organized based on a hierarchy of data elements. A byte is a character of data. Bytes are grouped into columns. Columns are also called fields. A key is a column or group of columns that identifies a unique row in a table. Columns that are keys of a different table than the one in which they reside are called foreign keys. Columns or fields, in turn, are grouped into rows, which are also called records. Finally, a group of similar rows or records is called a table or a file. A database contains, within itself, a description of its contents called metadata. Metadata are data that describe data. Thus, a database is a collection of tables plus relationships among the rows in those tables, plus special data, called metadata, that describes the structure of the database.
0%
C) Structured Query Language
27) Security requirements are more stringent for traditional applications than for browser-based ones.
Report Question
0%
record
0%
F
0%
file
0%
T
17) Which of the following is a DBMS product from Microsoft?
Report Question
0%
C) They are thin-client applications that need not be pre-installed on a user's computer.
0%
A) adding structures to improve the performance of database applications
0%
C) It was never a natural fit with business documents.
0%
B) SQL Server
30) Which of the following elements of a database application provides security, data consistency, and special-purpose processing?
Report Question
0%
A) database application
0%
C) They are thin-client applications that need not be pre-installed on a user's computer.
0%
B) application programs
0%
D) It represents relationships with the help of foreign keys.
3) Bytes, which are characters of data, are grouped into rows in a database.
Report Question
0%
file
0%
T
0%
record
0%
F
Describe the contents of a database
Report Question
0%
database
0%
A database is a self-describing collection of integrated records that is organized based on a hierarchy of data elements. A byte is a character of data. Bytes are grouped into columns. Columns are also called fields. A key is a column or group of columns that identifies a unique row in a table. Columns that are keys of a different table than the one in which they reside are called foreign keys. Columns or fields, in turn, are grouped into rows, which are also called records. Finally, a group of similar rows or records is called a table or a file. A database contains, within itself, a description of its contents called metadata. Metadata are data that describe data. Thus, a database is a collection of tables plus relationships among the rows in those tables, plus special data, called metadata, that describes the structure of the database.
0%
Database developers use the DBMS to create tables, relationships, and other structures in the database. A form is used to define a new table or to modify an existing one. To create a new table, the developer just fills the new table's metadata into the form. To modify an existing table, a developer opens the metadata form for that table and adds a new row of metadata.
0%
It is a character of data.
39) ________ refers to software systems that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud.
Report Question
0%
A) storing data types such as images, audio, and videos in organizations
0%
C) lost-update problem
0%
database
0%
A) NoSQL DBMS
20) Queries in database applications present data in a structured manner using operations such as sorting, grouping, and filtering.
Report Question
0%
T
0%
forms
0%
file
0%
F
28) The lost-update problem caused by multi-user processing in databases can be prevented by avoiding all types of database locking.
Report Question
0%
forms
0%
F
0%
foreign
0%
T
5) In a database, the collection of data for all columns is called a file.
Report Question
0%
F
0%
T
0%
foreign
0%
metadata
14) Hypertext Markup Language is an international standard language for processing a database.
Report Question
0%
forms
0%
file
0%
F
0%
T
6) Describe the functions of a database management system.
Report Question
0%
The purpose of both a spreadsheet and a database is to keep track of things. However, unlike a spreadsheet, a database offers the solution of being able to keep track of more than one type of data. Lists of data involving a single theme can be stored in a spreadsheet. However, lists that involve multiple themes require a database.
0%
A database management system (DBMS) is a program used to create, process, and administer a database.1. Database developers use the DBMS to create tables, relationships, and other structures in the database. To create a new table, the developer just fills out a new table's metadata into a form. To modify an existing table-for example, to add a new column-the developer opens the metadata form for that table and adds a new row of metadata. 2. The second function of the DBMS is to process the database. The DBMS provides applications for four processing operations: to read, insert, modify, or delete data. These operations are requested in application calls upon the DBMS. From a form, when the user enters new or changed data, a computer program that processes the form calls the DBMS to make the necessary database changes. From a Web application, a program on the client or on the server application program calls the DBMS directly to make the change.3. A third DBMS function is to provide tools to assist in the administration of the database. Database administration involves a wide variety of activities. For example, the DBMS can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database. In addition to security, DBMS administrative functions include backing up database data, adding structures to improve the performance of database applications, removing data that are no longer wanted or needed and similar tasks.
0%
A database management system (DBMS) is a program used to create, process, and administer a database. A DBMS is different from a database in that a DBMS is a software program while a database is a collection of tables, relationships, and metadata. Almost no organization develops its own DBMS. Instead, companies license DBMS products from vendors such as IBM, Microsoft, Oracle, and others. Popular DBMS products are DB2 from IBM, Access and SQL Server from Microsoft, and Oracle Database from the Oracle Corporation. Another popular DBMS is MySQL, an open source DBMS product that is license-free for most applications.
0%
Databases that carry their data in the form of tables and that represent relationships using foreign keys are called relational databases. Foreign keys are columns that are keys of a different table than the one in which they reside. The relational model was the single, standard way of processing databases for over thirty years. Recently, however, new styles of database processing have started appearing. Part of the reason is that the major principles of the relational model-fixed-sized tables, representing relationships with foreign keys, and the theory of normalization-came about because of limited storage space and limited processing speeds back in the 1960s and early 1970s. At some point, maybe the mid-1990s, these limitations were removed by improved storage and processing technology and today they do not exist. In other words, the relational model is not needed today. Other reasons for the development of nonrelational databases include the need to gain faster performance using many servers and to store new types of data such as images, audio, and videos.
25) Monitoring the performance of a database after providing solutions for improving its performance is a(n) ________ of the DBMS.
Report Question
0%
D) administrative function
0%
B) administrative function
0%
B) application programs
0%
A) adding structures to improve the performance of database applications
8) Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases.
Report Question
0%
file
0%
forms
0%
T
0%
F
16) A(n) ________ is a program that is used to create, process, and administer a collection of self-describing integrated records.
Report Question
0%
C) database management system (DBMS)
0%
A) database application
0%
A database management system (DBMS) is a program used to create, process, and administer a database.1. Database developers use the DBMS to create tables, relationships, and other structures in the database. To create a new table, the developer just fills out a new table's metadata into a form. To modify an existing table-for example, to add a new column-the developer opens the metadata form for that table and adds a new row of metadata. 2. The second function of the DBMS is to process the database. The DBMS provides applications for four processing operations: to read, insert, modify, or delete data. These operations are requested in application calls upon the DBMS. From a form, when the user enters new or changed data, a computer program that processes the form calls the DBMS to make the necessary database changes. From a Web application, a program on the client or on the server application program calls the DBMS directly to make the change.3. A third DBMS function is to provide tools to assist in the administration of the database. Database administration involves a wide variety of activities. For example, the DBMS can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database. In addition to security, DBMS administrative functions include backing up database data, adding structures to improve the performance of database applications, removing data that are no longer wanted or needed and similar tasks.
0%
C) administering the database
13) A DBMS is also referred to as a database.
Report Question
0%
fields
0%
F
0%
file
0%
T
15) SQL statements can be issued directly to the DBMS by an application program.
Report Question
0%
T
0%
F
0%
relation
0%
table
24) Which of the following is considered an administrative function of the DBMS?
Report Question
0%
A) adding structures to improve the performance of database applications
0%
A) storing data types such as images, audio, and videos in organizations
0%
Dynamo
0%
B) special data that describes the structure of a database
15) Special data that describe the data contained in a database are called ________.
Report Question
0%
relation
0%
record
0%
metadata
0%
database
9) What is a database application?
Report Question
0%
A database is a self-describing collection of integrated records that is organized based on a hierarchy of data elements. A byte is a character of data. Bytes are grouped into columns. Columns are also called fields. A key is a column or group of columns that identifies a unique row in a table. Columns that are keys of a different table than the one in which they reside are called foreign keys. Columns or fields, in turn, are grouped into rows, which are also called records. Finally, a group of similar rows or records is called a table or a file. A database contains, within itself, a description of its contents called metadata. Metadata are data that describe data. Thus, a database is a collection of tables plus relationships among the rows in those tables, plus special data, called metadata, that describes the structure of the database.
0%
A few years back, Amazon.com determined that relational database technology wouldn't meet its processing needs, and it developed a nonrelational data store called Dynamo. Google (developed Bigtable) and Facebook (developed Cassandra) also followed suit. Such nonrelational DBMS have come to be called NoSQL DBMS. This term refers to software systems that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud. The rise of NoSQL does mean that, for large organizational IS, choosing a relational DBMS is no longer automatic. NoSQL DBMS products are very technical and can be used only by those with a deep background in computer science
0%
: A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data. Database applications reformat database table data to make it more informative and more easily updated. Application programs also have features that provide security, maintain data consistency, and handle special cases. The specific purposes of the four elements of a database application are:Forms- View data; insert new, update existing, and delete existing dataReports- Structured presentation of data using sorting, grouping, filtering, and other operations Queries- Search based upon data values provided by the userApplication programs- Provide security, data consistency, and special-purpose processing, e.g., handle out-of-stock situations.
0%
The purpose of both a spreadsheet and a database is to keep track of things. However, unlike a spreadsheet, a database offers the solution of being able to keep track of more than one type of data. Lists of data involving a single theme can be stored in a spreadsheet. However, lists that involve multiple themes require a database.
23) In single-user databases, the application, the DBMS, and the database all reside on a user's computer.
Report Question
0%
key
0%
foreign
0%
F
0%
T
12) DB2 is a popular DBMS product that is licensed from Microsoft.
Report Question
0%
file
0%
DB2
0%
T
0%
F
7) In a database, the collection of data for all columns is called a ________.
Report Question
0%
fields
0%
T
0%
record
0%
F
13) Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases.
Report Question
0%
foreign
0%
relational
0%
relation
0%
metadata
40) The conversion of the existing traditional databases in organizations to NoSQL databases is ________.
Report Question
0%
C) They are thin-client applications that need not be pre-installed on a user's computer.
0%
C) are usually open to the public
0%
D) unnecessary in cases where relational databases meet the needs of organizations
0%
A) storing data types such as images, audio, and videos in organizations
24) Traditional database application programs are written in object-oriented languages such as C++.
Report Question
0%
relation
0%
F
0%
metadata
0%
T
9) In a database, a table, which is a group of similar rows, is also called a ________.
Report Question
0%
F
0%
file
0%
relation
0%
forms
28) Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data?
Report Question
0%
reports
0%
forms
0%
foreign
0%
B) application programs
If you want to support the environment you will focus on building a strong sustainable MIS infrastructure, which identifies ways that a company can grow in terms of computing resources while simultaneously becoming less dependent on hardware and energy consumption.
Report Question
0%
True
0%
False
John works for Internal Computer Specialists, which focuses on helping small business owners resolve MIS infrastructure issues. John's tasks include cleaning and replacing motherboards, cables, and internal components such as DVDs and hard drives. What does John's role at Internal Computer Specialists focus on fixing?Hardware, Clients,Backup,Recovery.
Report Question
0%
Information
0%
Hardware
0%
False
0%
True
Which characteristics support an agile MIS infrastructure?Accessibility, availability, maintainability, portability, reliability, scalability, usability.Backup and recovery plan, disaster recovery plan, business continuity plan.Grid computing, cloud computing, and virtualization.All of the above.
Report Question
0%
Grid computing
0%
Accessibility, availability, maintainability, portability, reliability, scalability, usability
0%
Information MIS, agile MIS, and sustainable MIS infrastructures.
0%
Grid computing, cloud computing, virtualization
Hardware consists of the physical devices associated with a computer system, where software is the set of instructions the hardware executes to carry out specific tasks.
Report Question
0%
True
0%
False
The three primary areas of support provided by information infrastructure are backup and recovery, disaster recovery plan, and the business continuity plan.
Report Question
0%
True
0%
False
Web accessibility means that people with disabilities including visual, auditory, physical, speech, cognitive, and neurological disabilities can use the Web.
Report Question
0%
True
0%
False
0:0:1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
0
Answered
0
Not Answered
0
Not Visited
Correct : 0
Incorrect : 0
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqexams.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page