am,
uestions,
complete
Page
verified
verified
1 of
exam
12test
answers,
bank, exam
already
questions
gradedand
exam,
answers,
complete
realverified
exam questions
test bank,pdf,
examverified
questions
test bank
and answers,
answers, real
graded
exam
A exam
questions
test bank,
pdf, verified
latest exam
test bank
questions,
answers, graded
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
am,
uestions,
complete
real
verified
verified
exam exam
test
test
answers,
bank,
bank,actual
exam
already
verified
questions
graded
exam
and
exam,
questions,
answers,
complete
verified
realverified
exam
exam
questions
test
answers,
bank,pdf,
exam
already
verified
questions
graded
test bank
and
exam,
answers,
answers,
complete
real
graded
verified
exam A exam
questions
test bank,
test bank,
pdf,
examverified
latest
questions
exam
test bank
and
questions,
answers,
answers, real
graded
ex
,am,
uestions,
complete
Page
verified
verified
2 of
exam
12test
answers,
bank, exam
already
questions
gradedand
exam,
answers,
complete
realverified
exam questions
test bank,pdf,
examverified
questions
test bank
and answers,
answers, real
graded
exam
A exam
questions
test bank,
pdf, verified
latest exam
test bank
questions,
answers, graded
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
am,
uestions,
complete
real
verified
verified
exam exam
test
test
answers,
bank,
bank,actual
exam
already
verified
questions
graded
exam
and
exam,
questions,
answers,
complete
verified
realverified
exam
exam
questions
test
answers,
bank,pdf,
exam
already
verified
questions
graded
test bank
and
exam,
answers,
answers,
complete
real
graded
verified
exam A exam
questions
test bank,
test bank,
pdf,
examverified
latest
questions
exam
test bank
and
questions,
answers,
answers, real
graded
ex
uestions,
complete
Page
verified
verified
1 of
exam
12test
answers,
bank, exam
already
questions
gradedand
exam,
answers,
complete
realverified
exam questions
test bank,pdf,
examverified
questions
test bank
and answers,
answers, real
graded
exam
A exam
questions
test bank,
pdf, verified
latest exam
test bank
questions,
answers, graded
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
am,
uestions,
complete
real
verified
verified
exam exam
test
test
answers,
bank,
bank,actual
exam
already
verified
questions
graded
exam
and
exam,
questions,
answers,
complete
verified
realverified
exam
exam
questions
test
answers,
bank,pdf,
exam
already
verified
questions
graded
test bank
and
exam,
answers,
answers,
complete
real
graded
verified
exam A exam
questions
test bank,
test bank,
pdf,
examverified
latest
questions
exam
test bank
and
questions,
answers,
answers, real
graded
ex
,am,
uestions,
complete
Page
verified
verified
2 of
exam
12test
answers,
bank, exam
already
questions
gradedand
exam,
answers,
complete
realverified
exam questions
test bank,pdf,
examverified
questions
test bank
and answers,
answers, real
graded
exam
A exam
questions
test bank,
pdf, verified
latest exam
test bank
questions,
answers, graded
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
am,
uestions,
complete
real
verified
verified
exam exam
test
test
answers,
bank,
bank,actual
exam
already
verified
questions
graded
exam
and
exam,
questions,
answers,
complete
verified
realverified
exam
exam
questions
test
answers,
bank,pdf,
exam
already
verified
questions
graded
test bank
and
exam,
answers,
answers,
complete
real
graded
verified
exam A exam
questions
test bank,
test bank,
pdf,
examverified
latest
questions
exam
test bank
and
questions,
answers,
answers, real
graded
ex
