MIST 4630 FINAL EXAM QUESTIONS &
SOLUTIONS
JDBC stands for - ANSWERJava Database Connectivity
In a relational data model, ________ provides the means for accessing and
manipulating data. - ANSWERSQL
A __________ is a stand-alone, software component that enables a Java application to
interact with a database. - ANSWERdatabase driver
Which of the following Eclipse Dynamic Web Project folders is the best place to import
the Connector/J jar file? - ANSWERWebContent/Web-Inf/lib
Which of the following statements can be used to connect to a local MySQL database
named test? - ANSWERConnection connection =
DriverManager.getConnection("jdbc:mysql://localhost/test");
What is the return value from:
preparedStatement.executeUpdate("insert into T values (100, 'Smith')") - ANSWERan
int value indicating how many rows are effected from the invocation
Which of the following methods will move the cursor for the ResultSet rs one record
forward? - ANSWERrs.next()
Assume that you move the cursor of a ResultSet rs forward one record, but there are no
more records there. What would be the result? - ANSWERthe rs.next() method would
return a value of false
The Elastic Beanstalk service is an example of Platform-as-a-Service (PaaS). -
ANSWERTrue
With AWS Elastic Beanstalk, an _____________
is a collection of AWS resources running an application version. - ANSWERenvironment
Which of the following is true about PaaS? - ANSWERPaaS can make it easier to
develop for multiple platforms.
The ________________ designates the type of application that the environment runs,
and determines what resources Elastic Beanstalk provisions to support it. -
ANSWERenvironment tier
, A complete development and deployment environment in the cloud is known as
_______________ - ANSWERPaaS
Only Java web applications can be hosted in an Elastic Beanstalk environment. -
ANSWERFalse
Deploying a web project to the Cloud using Elastic Beanstalk requires much less work
than configuring and deploying directly to an EC2 instance. - ANSWERTrue
An Elastic Beanstalk ________________ is a logical collection of Elastic Beanstalk
components, including environments, versions, and environment configurations. In
Elastic Beanstalk an application is conceptually similar to a folder. -
ANSWERapplication
Which of the following application components are generally provided by Platform-as-a-
Service (PaaS)? Select all that apply. - ANSWER- Development tools, DBMS, business
analytics
- Operating systems
- Servers and storage
- Data Center
- Networking components
Serverless applications are ones that don't require you to provision or manage any
servers. You can focus on your core product and business logic instead of
responsibilities like operating system (OS) access control, OS patching, provisioning,
right-sizing, scaling, and availability. - ANSWERTrue
S3 is a serverless storage service. - ANSWERTrue
DynamoDB is a serverless database service. - ANSWERTrue
Function as a Server is - ANSWER- Lambda
- event driven computing
Lamda supports the below programming languages - ANSWER- Node.js
-Python
- Go
API Gateway - ANSWER- receives an HTTPS request
- use the GET method
When a Lambda function is invoked, code execution begins at what is called the
handler. The handler is a specific function (segment of code) that you've created and
included in your code. - ANSWERTrue
A database URL for a MySQL database named test on host panda.armstrong.edu is
________. - ANSWERjdbc:mysql://panda.armstrong.edu/test
SOLUTIONS
JDBC stands for - ANSWERJava Database Connectivity
In a relational data model, ________ provides the means for accessing and
manipulating data. - ANSWERSQL
A __________ is a stand-alone, software component that enables a Java application to
interact with a database. - ANSWERdatabase driver
Which of the following Eclipse Dynamic Web Project folders is the best place to import
the Connector/J jar file? - ANSWERWebContent/Web-Inf/lib
Which of the following statements can be used to connect to a local MySQL database
named test? - ANSWERConnection connection =
DriverManager.getConnection("jdbc:mysql://localhost/test");
What is the return value from:
preparedStatement.executeUpdate("insert into T values (100, 'Smith')") - ANSWERan
int value indicating how many rows are effected from the invocation
Which of the following methods will move the cursor for the ResultSet rs one record
forward? - ANSWERrs.next()
Assume that you move the cursor of a ResultSet rs forward one record, but there are no
more records there. What would be the result? - ANSWERthe rs.next() method would
return a value of false
The Elastic Beanstalk service is an example of Platform-as-a-Service (PaaS). -
ANSWERTrue
With AWS Elastic Beanstalk, an _____________
is a collection of AWS resources running an application version. - ANSWERenvironment
Which of the following is true about PaaS? - ANSWERPaaS can make it easier to
develop for multiple platforms.
The ________________ designates the type of application that the environment runs,
and determines what resources Elastic Beanstalk provisions to support it. -
ANSWERenvironment tier
, A complete development and deployment environment in the cloud is known as
_______________ - ANSWERPaaS
Only Java web applications can be hosted in an Elastic Beanstalk environment. -
ANSWERFalse
Deploying a web project to the Cloud using Elastic Beanstalk requires much less work
than configuring and deploying directly to an EC2 instance. - ANSWERTrue
An Elastic Beanstalk ________________ is a logical collection of Elastic Beanstalk
components, including environments, versions, and environment configurations. In
Elastic Beanstalk an application is conceptually similar to a folder. -
ANSWERapplication
Which of the following application components are generally provided by Platform-as-a-
Service (PaaS)? Select all that apply. - ANSWER- Development tools, DBMS, business
analytics
- Operating systems
- Servers and storage
- Data Center
- Networking components
Serverless applications are ones that don't require you to provision or manage any
servers. You can focus on your core product and business logic instead of
responsibilities like operating system (OS) access control, OS patching, provisioning,
right-sizing, scaling, and availability. - ANSWERTrue
S3 is a serverless storage service. - ANSWERTrue
DynamoDB is a serverless database service. - ANSWERTrue
Function as a Server is - ANSWER- Lambda
- event driven computing
Lamda supports the below programming languages - ANSWER- Node.js
-Python
- Go
API Gateway - ANSWER- receives an HTTPS request
- use the GET method
When a Lambda function is invoked, code execution begins at what is called the
handler. The handler is a specific function (segment of code) that you've created and
included in your code. - ANSWERTrue
A database URL for a MySQL database named test on host panda.armstrong.edu is
________. - ANSWERjdbc:mysql://panda.armstrong.edu/test
