Practice questions, with answers and explanations included

In traditional file processing systems, the problem where the same information is stored in more than one file is called:

Which keyword surrounds the part of the code that might generate an exception?

What should you do if the computer becomes completely frozen/unresponsive?

If a file is updated but other files containing similar information are not updated, this results in:

Which keyword defines a block containing the exception handler code, executed when a matching exception occurs?

Describe the steps to troubleshoot a computer that is unable to connect to the network.

A Database Management System (DBMS) is best described as:

Which block is ALWAYS executed when a try block exits, whether or not an exception occurred?

A network protocol defines:

Which operation on a database involves specifying the data type and constraints of the data to be stored?

Which method of the Exception class is used to print/retrieve the error message that caused an exception?

Social network refers to a network of people interacting and sharing information such as views, photos, and videos.

Storing data on some storage medium controlled by the DBMS is called:

If multiple catch blocks follow a try block, what determines which catch block executes?

Hacking refers only to legally authorized access to a computer system for testing purposes.

The description of data (structure and constraints) stored in a database catalogue/data dictionary is called:

Which Java package contains the classes needed to connect a Java program to a database (e.g., Connection, Statement, ResultSet)?

Spam emails are always harmless and never contain links to phishing sites.

The DBMS property that allows a change in the structure of data (in the catalogue) without needing to modify the programs that access the data is called:

Which class's getConnection() method is used to establish a connection to a database?