SQL Exam MIS 180 SDSU Meader
Questions And Answers 100% Correct!!!
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 - ANSWER✔✔A key
Typical relational DBMS's in use today include all of the following EXCEPT...
Symantec
PostgresSQL
DB2
MySQL - ANSWER✔✔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 - ANSWER✔✔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
Provide complex functionality.
Format and display the results. - ANSWER✔✔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 - ANSWER✔✔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 - ANSWER✔✔Attributes and Relationships
Which is NOT one of the responsibilities of a DBMS?
Questions And Answers 100% Correct!!!
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 - ANSWER✔✔A key
Typical relational DBMS's in use today include all of the following EXCEPT...
Symantec
PostgresSQL
DB2
MySQL - ANSWER✔✔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 - ANSWER✔✔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
Provide complex functionality.
Format and display the results. - ANSWER✔✔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 - ANSWER✔✔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 - ANSWER✔✔Attributes and Relationships
Which is NOT one of the responsibilities of a DBMS?
