The process of adding redundancy to a database

Using triggers to automate tasks

Abstracting data

Putting the database in an exceptional state that prevents public access

True

False

Data Manipulated Language

Defined Manipulation Language

data Morphed Language

Data Manipulation Language

Data Definition Language

Data Directed Language

Data Defined Language

Derived Data Language

insert into

insert new

add new

add record

Using inline queries in a SqlCommand object

Using Parameters to take inputs from users

Injecting a SQL Statement as user input

Installing a plugin to SQL Server Management Studio

Update only one row at a time

Update multiple rows at a time

Delete a row based on a where clause

Update the current system time of the database

CREATE

ALTER

DROP

UPDATE

Shorthand Query Language

Structured Query Lines

Structured Query Language

Structured Query Lambda

True

False

True

False

True

False

True

False

DELETE

DROP

TRUNCATE

REMOVE

True

False

ADD()

SUM()

COUNT()

TOTAL()

SELECT * FROM Customers

SELECT % FROM Customers

SELECT all FROM Customers

SELECT all columns FROM Customers

Create, Retrieve, Update, Derive

Create, Retrieve, Undo, Delete

Create, Read, Update, Delete

Control, Read, Undo, Delete

True

False

True

False

Unique Value

Integer Data Type

Not Null

Foreign

Connection Key

Primary Key

Candidate Key

Foreign Key

DQL

DML

TCL

DDL

Aggregate Functions

Constraints

Scalar functions

Filters

Aggregate functions

Scalar functions

Operators

Sequences

Every table must have a primary key

Foreign keys must always reference a valid unique key

Joins should only be used with foreign and primary keys

Columns should be atomic

May throw NullPointerExceptions

Have undefined behavior in logical expressions

Represent the lack of a value for a column

Are only valid in columns with the NULLABLE constraint

Unique in the table

Uniquely reference a primary key

Unique in the row

Unique in the column

Operations meant to encapsulate a task and must maintain ACID properties

Used to track sequence values

A column data type used to represent arrays

The set of valid values in a BETWEEN clause

composite key

double-primary key

consisting key

foreign key

It is an open source framework.

All of the above.

It provides Annotation to identify the test methods.

It provides Assertions for testing expected results.

@Test

@After

@BeforeClass

@Before

HashMap

ArrayMap

Hashtable

TreeMap

The process of negating methods from a super class.

The process of restoring orphaned objects.

The process of de-allocating memory automatically.

The process of creating a new object.

Process of writing tests first, then ensuring the tests pass

The process of writing tests at the end of development

The process of having end users test out the application and report bugs

The process of automating deployment of the application and then testing

Manually testing your application through the GUI or the command line

Testing the smallest components of the application in isolation.

A way of testing the integration of many different components

Having the end users of the application try it out and report bugs

An integration testing framework for Java

A unit test framework for any programming language

A unit testing framework for Java

A testing library which provides a few helper methods

Provide stand-in objects for dependencies to isolate tested code.

Modify the tested class state at runtime.

Assert values to ensure they meet expectations.

Fake unit tests so that they pass regardless of code stability.

XML

HTML

JSON

Groovy

List

Map

Set

Queue

True

False

True

False

True

False

public void main(String args[])

public void static main(String args[])

public static void main(String args[])

public static void main()

True

False

True

False

Method with different number or type of parameters

When the JVM overrides your calls for Garbage Collection.

None of the Above

Same method signature but different implementation

myArray.size

myArray.size()

myArray.length

myArray.length()

||

&

&&

True

False

When the class has no other constructors

When you define at least one constructor with at least one parameter

When you define at least one constructor

none of the above

True

False

True

False

Collections

Throwable

List

Collection

They provide a GUI for writing code

They can compile your code for you

They automatically download 3rd-party libraries from the internet

They make it easy to manage your project structure

To transform Java code into instructions usable by a web browser

To transform Java code into instructions usable by the JVM

To transform Java code into instructions usable by the operating system

int 5 = x;

5 = x int;

int x = 5;

x = 5 int;

The = operator is assignment, the == operator tests equality

The == operator is assignment, the = operator tests equality

True

False