U
amMeader
MIS 180
SQL
Questions
SDSU
ExamMeader
with
MIS Correct
180
Questions
SDSU
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Meader
with Correct
Questions
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~
with Correct Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~
SQL Exam MIS 180 SDSU Meader
Questions with Correct Answers
In a database table, a column or set of columns which are used to uniquely identify each row is a called
what?
An attribute
A calculated field
A key
An identifier
A key
Typical relational DBMS's in use today include all of the following EXCEPT...
Symantec
PostgresSQL
DB2
MySQL
Symantec
What is DBMS Data Security concerned with?
Enforcing restrictions about who is able to access what data
Ensuring that the data center is secure from intrusion
Protecting against malware and other viruses
Protecting against SQL injection attacks
Enforcing restrictions about who is able to access what data
In the database approach to information systems, which of the following is NOT one of the
responsibilities of the application software?
Define the schema.
Send a request to the DBMS
U
amMeader
MIS 180
SQL
Questions
SDSU
ExamMeader
with
MIS Correct
180
Questions
SDSU
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Meader
with Correct
Questions
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~
with Correct Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~
,U
amMeader
MIS 180
SQL
Questions
SDSU
ExamMeader
with
MIS Correct
180
Questions
SDSU
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Meader
with Correct
Questions
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~
with Correct Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~
Provide complex functionality.
Format and display the results.
Define the schema
What is a recursive relationship?
A relationship that is implied but not directly defined
A relationship between a parent and child entities
A relationship between distinct instances of the same entity
A relationship that is not valid
A relationship between distinct instances of the same entity
What are two of the most important pieces of information stored in a database about an entity?
Identifiers and Attributes
Field sizes and values
Attributes and Relationships
Identifiers and Relationships
Attributes and Relationships
Which is NOT one of the responsibilities of a DBMS?
Display query results
Ensure data integrity
Define the data
Execute queries
Display query results
The ______________ is the industry standard language used to manipulate data in a relational
database. (use full words, not acronyms)
Structured query language
An attribute that serves to uniquely identify a particular entity is called a(n) ________.
Key
In a database a set of data that is organized in rows and columns is called a(n) _____________.
Table
True or False: Every industry uses databases and requires people with database skills.
True
True or False: Only very large and complex databases are required to have a schema.
False
U
amMeader
MIS 180
SQL
Questions
SDSU
ExamMeader
with
MIS Correct
180
Questions
SDSU
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Meader
with Correct
Questions
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~
with Correct Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~
amMeader
MIS 180
SQL
Questions
SDSU
ExamMeader
with
MIS Correct
180
Questions
SDSU
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Meader
with Correct
Questions
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~
with Correct Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~
SQL Exam MIS 180 SDSU Meader
Questions with Correct Answers
In a database table, a column or set of columns which are used to uniquely identify each row is a called
what?
An attribute
A calculated field
A key
An identifier
A key
Typical relational DBMS's in use today include all of the following EXCEPT...
Symantec
PostgresSQL
DB2
MySQL
Symantec
What is DBMS Data Security concerned with?
Enforcing restrictions about who is able to access what data
Ensuring that the data center is secure from intrusion
Protecting against malware and other viruses
Protecting against SQL injection attacks
Enforcing restrictions about who is able to access what data
In the database approach to information systems, which of the following is NOT one of the
responsibilities of the application software?
Define the schema.
Send a request to the DBMS
U
amMeader
MIS 180
SQL
Questions
SDSU
ExamMeader
with
MIS Correct
180
Questions
SDSU
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Meader
with Correct
Questions
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~
with Correct Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~
,U
amMeader
MIS 180
SQL
Questions
SDSU
ExamMeader
with
MIS Correct
180
Questions
SDSU
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Meader
with Correct
Questions
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~
with Correct Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~
Provide complex functionality.
Format and display the results.
Define the schema
What is a recursive relationship?
A relationship that is implied but not directly defined
A relationship between a parent and child entities
A relationship between distinct instances of the same entity
A relationship that is not valid
A relationship between distinct instances of the same entity
What are two of the most important pieces of information stored in a database about an entity?
Identifiers and Attributes
Field sizes and values
Attributes and Relationships
Identifiers and Relationships
Attributes and Relationships
Which is NOT one of the responsibilities of a DBMS?
Display query results
Ensure data integrity
Define the data
Execute queries
Display query results
The ______________ is the industry standard language used to manipulate data in a relational
database. (use full words, not acronyms)
Structured query language
An attribute that serves to uniquely identify a particular entity is called a(n) ________.
Key
In a database a set of data that is organized in rows and columns is called a(n) _____________.
Table
True or False: Every industry uses databases and requires people with database skills.
True
True or False: Only very large and complex databases are required to have a schema.
False
U
amMeader
MIS 180
SQL
Questions
SDSU
ExamMeader
with
MIS Correct
180
Questions
SDSU
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Meader
with Correct
Questions
Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~~~~~~~~~~~~~~
with Correct Answers.pdf~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!_(*))))))))))))))))))*@&^#(&^~&*@&*&!~&*@((*~~~~~~~~~