Test Developers
 

Look carefully at the sequence of symbols to find the pattern. Select correct pattern.
 
001
1
2
3
4
Choose the picture that would go in the empty box so that the two bottom pictures are related in the same way as the top two are related.
002
002
1
2
3
4

Remember, you are looking for the word that does NOT belong in the same group as the others. Sometimes, all four words seem to fit in the same group. If so, look more closely to further narrow your classification.

Two
Three
Six
Eight
Danielle has been visiting friends in Ridge-wood for the past two weeks. She is leaving tomorrow morning and her flight is very early. Most of her friends live fairly close to the airport. Madison lives ten miles away. Frances lives five miles away, Samantha, seven miles. Alexis is farther away than Frances, but closer than Samantha. Approximately how far away from the airport is Alexis?
Nine miles
Seven miles
Eight miles
Six miles
A train running at the speed of 60 km/hr crosses a pole in 9 seconds. What is the length of the train?
120 metres
180 metres
324 metres
150 metres
Two stations A and B are 110 km apart on a straight line. One train starts from A at 7 a.m. And travels towards B at 20 kmph. Another train starts from B at 8 a.m. And travels towards A at a speed of 25 kmph. At what time will they meet?
9 a.m.
10 a.m.
10.30 a.m.
11 a.m.
In SQL for Database Construction - The SQL command to create a table is:
MAKE TABLE.
ALTER TABLE.
DEFINE TABLE.
CREATE TABLE.
In SQL for Database Construction - A ________ is a stored program that is attached to a table or a view.
Pseudofile
Embedded SELECT statement
Trigger
None of the above is correct.
In SQL for Database Construction - The DROP TABLE statement:
Deletes the table structure only.
Deletes the table structure along with the table data.
Works whether or not referential integrity constraints would be violated.
Is not an SQL statement.
In SQL for Database Construction - SQL views can be used to hide:
Columns and rows only.
Complicated SQL syntax only.
Both of the above can be hidden by an SQL view.
None of the above is correct.
In SQL for Database Construction - The SQL statement to create a view is:
CREATE VIEW.
MAKE VIEW.
SELECT VIEW.
INSERT VIEW.
In SQL for Database Construction - To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
A particular column in a particular underlying table.
A particular column in a particular row.
A particular row in a particular underlying table.
None of the above is correct.
In SQL for Database Construction - Which of the following is NOT a type of SQL constraint?
PRIMARY KEY
FOREIGN KEY
ALTERNATE KEY
UNIQUE
In SQL for Database Construction - A ________ is a program that performs some common action on database data and that is stored in the database.
Trigger
Stored procedure
Pseudofile
None of the above is correct.
In SQL for Database Construction - For what purposes are views used?
To hide columns only
To hide rows only
To hide complicated SQL statements only
All of the above are uses for SQL views.
In SQL for Database Construction - What is an SQL virtual table that is constructed from other tables?
Just another table
A view
A relation
Query results
In SQL for Database Construction - When using the SQL INSERT statement:
Rows can be modified according to criteria only.
Rows cannot be copied in mass from one table to another only.
Rows can be inserted into a table only one at a time only.
Rows can either be inserted into a table one at a time or in groups.
In SQL for Database Construction - What is not an advantage of stored procedures?
Greater security
SQL can be optimized
Code sharing
Increased network traffic
In SQL for Database Construction - A reason for using an SQL view to hide columns is:
To simplify a result only.
To prevent the display of sensitive data only.
To accomplish both of the above.
None of the above are reasons for using an SQL view.
In SQL for Database Construction - The SQL ALTER statement can be used to:
Change the table structure.
Change the table data.
Add rows to the table.
Delete rows from the table.
In SQL for Database Construction - What SQL structure is used to limit column values of a table?
The LIMIT constraint
The CHECK constraint
The VALUE constraint
None of the above is correct.
In SQL for Database Construction - Which is NOT one of the most common types of SQL CHECK constraints?
System date
Range checks
Lists of values
Comparing one column value to another within the same table
In SQL for Database Construction - What is an advantage of placing computations in SQL views?
To save users from having to write an expression.
To ensure that the results are consistent.
To accomplish both of the above.
None of the above is correct - computations cannot be placed in a view.
In Database Design Using Normalization - Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Advantage
Disadvantage
Either an advantage or disadvantage
Neither an advantage nor disadvantage
In Database Design Using Normalization - Eliminating modification anomalies is a(n) ________ of normalization.
Advantage
Disadvantage
Either an advantage or disadvantage
Neither an advantage nor disadvantage
In Database Design Using Normalization - Multivalued dependencies should ________ be eliminated.
Always
Commonly
Seldom
Never
In Database Design Using Normalization - When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
First step.
Second step.
Third step.
Fourth step.
In Database Design Using Normalization - Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
The multivalue, multicolumn problem
The inconsistent values problem
The missing values problem
The general-purpose remarks column problem
In Database Design Using Normalization - When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
First step.
Second step.
Third step.
Fourth step.
In Database Design Using Normalization - Creating a read-only database is a task that is ________ assigned to beginning database professionals.
Always
Commonly
Seldom
Never
In Database Design Using Normalization - Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
Three rows have the values Brown, NULL, and Blue in the same column.
One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
In Database Design Using Normalization - For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
read-only
Updateable
Either a read-only or an updateable
None of the above is correct.
In Database Design Using Normalization - Most of the time, modification anomalies are serious enough that tables should be normalized into:
1NF.
2NF.
3NF.
BCNF.
In Database Design Using Normalization - Each answer below shows example data from a table. Which answer is an example of the missing values problem?
Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
Three rows have the values Brown, NULL, and Blue in the same column.
One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
In Database Design Using Normalization - When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
First step.
Second step.
Third step.
Fourth step.
In Database Design Using Normalization - Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
Three rows have the values Brown, NULL, and Blue in the same column.
One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
In Database Design Using Normalization - When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
First step.
Second step.
Third step.
Fourth step.
In Database Design Using Normalization - If a table has been normalized so that all determinants are candidate keys, then that table is in:
1NF.
2NF.
3NF.
BCNF.
In Database Design Using Normalization - Read-only databases are ________ updated.
Always
Commonly
Seldom
Never
In Database Design Using Normalization - Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
Advantage
Disadvantage
Either an advantage or disadvantage
Neither an advantage nor disadvantage
In Database Design Using Normalization - When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
First step.
Second step.
Third step.
Fourth step.
In Database Design Using Normalization - Normalization ________ data duplication.
Eliminates
Reduces
Increases
Maximizes
In Database Design Using Normalization - Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
Three rows have the values Brown, NULL, and Blue in the same column.
One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Advanced SQL - What type of join is needed when you wish to include rows that do not have matching values?
Equi-join
Natural join
Outer join
All of the above.
Advanced SQL - What type of join is needed when you wish to return rows that do have matching values?
Equi-join
Natural join
Outer join
All of the above.
Advanced SQL - Which of the following is true concerning a procedure?
You do not create them with SQL.
They do not need to have a unique name.
They include procedural and SQL statements.
They are the same thing as a function.
Advanced SQL - A CASE SQL statement is which of the following?
A way to establish an IF-THEN-ELSE in SQL.
A way to establish a loop in SQL.
A way to establish a data definition in SQL.
All of the above.
Advanced SQL - Which of the following statements is true concerning routines and triggers?
Both consist of procedural code.
Both have to be called to operate.
Both run automatically.
Both are stored in the database.
Advanced SQL - Which of the following is one of the basic approaches for joining tables?
Subqueries
Union Join
Natural join
All of the above
Advanced SQL - Which of the following is true concerning systems information in an RDBMS?
RDBMS store database definition information in system-created tables.
This information can be accessed using SQL.
This information often cannot be updated by a user.
All of the above.
Advanced SQL - The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
Equi-join
Natural join
Outer join
Cartesian join
Advanced SQL - Embedded SQL is which of the following?
Hard-coded SQL statements in a program language such as Java.
The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a procedure.
Hard-coded SQL statements in a trigger.
Advanced SQL - A UNION query is which of the following?
Combines the output from no more than two queries and must include the same number of columns.
Combines the output from no more than two queries and does not include the same number of columns.
Combines the output from multiple queries and must include the same number of columns.
Combines the output from multiple queries and does not include the same number of columns.
Advanced SQL - Which of the following statements is true concerning subqueries?
Involves the use of an inner and outer query.
Cannot return the same result as a query that is not a subquery.
Does not start with the word SELECT.
All of the above.
Advanced SQL - Which of the following is a correlated subquery?
Uses the result of an inner query to determine the processing of an outer query.
Uses the result of an outer query to determine the processing of an inner query.
Uses the result of an inner query to determine the processing of an inner query.
Uses the result of an outer query to determine the processing of an outer query.
Advanced SQL - How many tables may be included with a join?
One
Two
Three
All of the above.
Advanced SQL - The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Equi-join
Natural join
Outer join
Cartesian join
Advanced SQL - Which of the following is true concerning triggers?
You do not create them with SQL.
They execute against only some applications that access a database.
They have an event, condition, and action.
They cannot cascade (cause another trigger to fire).

Fundamentals of Java - Which four options describe the correct default values for array elements of the types indicated?

  1. int -> 0
  2. String -> "null"
  3. Dog -> null
  4. char -> '\u0000'
  5. float -> 0.0f
  6. boolean -> true
 
1, 2, 3, 4
1, 3, 4, 5
2, 4, 5, 6
3, 4, 5, 6
Fundamentals of Java - Which one of these lists contains only Java programming language keywords?
Class, if, void, long, Int, continue
Goto, instanceof, native, finally, default, throws
Try, virtual, throw, final, volatile, transient
Strictfp, constant, super, implements, do
Byte, break, assert, switch, include
Fundamentals of Java - Which will legally declare, construct, and initialize an array?
Int [] myList = {"1", "2", "3"};
Int [] myList = (5, 8, 2);
Int myList [] [] = {4,9,7,0};
Int myList [] = {4, 3, 7};
Fundamentals of Java - Which is a reserved word in the Java programming language?
Method
Native
Subclasses
Reference
Array
Fundamentals of Java - Which is a valid keyword in java?
Interface
String
Float
Unsigned

Fundamentals of Java - Which three are legal array declarations?

  1. int [] myScores [];
  2. char [] myChars;
  3. int [6] myScores;
  4. Dog myDogs [];
  5. Dog myDogs [7];
1, 2, 4
2, 4, 5
2, 3, 4
All are correct.
Fundamentals of Java:

public interface Foo { int k = 4; /* Line 3 */ }
Which three piece of codes are equivalent to line 3?
  1. final int k = 4;
  2. public int k = 4;
  3. static int k = 4;
  4. abstract int k = 4;
  5. volatile int k = 4;
  6. protected int k = 4;
1, 2 and 3
2, 3 and 4
3, 4 and 5
4, 5 and 6
Fundamentals of Java - Which one of the following will declare an array and initialize it with five numbers?
Array a = new Array(5);
Int [] a = {23,22,21,20,19};
Int a [] = new int[5];
Int [5] array;

Fundamentals of Java - Which three are valid declarations of a char?

  1. char c1 = 064770;
  2. char c2 = 'face';
  3. char c3 = 0xbeef;
  4. char c4 = \u0022;
  5. char c5 = '\iface';
  6. char c6 = '\uface';
1, 2, 4
1, 3, 6
3, 5
5 only
Fundamentals of Java - Which is the valid declarations within an interface definition?
Public double methoda();
Public final double methoda();
Static void methoda(double d1);
Protected void methoda(double d1);
Fundamentals of Java - Which one is a valid declaration of a boolean?
Boolean b1 = 0;
Boolean b2 = 'false';
Boolean b3 = false;
Boolean b4 = Boolean.false();
Boolean b5 = no;

Fundamentals of Java - Which three are valid declarations of a float?

  1. float f1 = -343;
  2. float f2 = 3.14;
  3. float f3 = 0x12345;
  4. float f4 = 42e7;
  5. float f5 = 2001.0D;
  6. float f6 = 2.81F;
1, 2, 4
2, 3, 5
1, 3, 6
2, 4, 6
Fundamentals of Java - Which is a valid declarations of a String?
String s1 = null;
String s2 = 'null';
String s3 = (String) 'abc';
String s4 = (String) '\ufeed';
Fundamentals of Java - What is the numerical range of a char?
-128 to 127
-(215) to (215) - 1
0 to 32767
0 to 65535
Flow control - Java
 
 

 

public void foo( boolean a, boolean b)
{ 
    if( a ) 
    {
        System.out.println("A"); /* Line 5 */
    } 
    else if(a && b) /* Line 7 */
    { 
        System.out.println( "A && B"); 
    } 
    else /* Line 11 */
    { 
        if ( !b ) 
        {
            System.out.println( "notB") ;
        } 
        else 
        {
            System.out.println( "ELSE" ) ; 
        } 
    } 
}
If a is true and b is true then the output is "A && B"
If a is true and b is false then the output is "notB"
If a is false and b is true then the output is "ELSE"
If a is false and b is false then the output is "ELSE"
Flow control - Java
 
 
public class While 
{
    public void loop() 
    {
        int x= 0;
        while ( 1 ) /* Line 6 */
        {
            System.out.print("x plus one is " + (x + 1)); /* Line 8 */
        }
    }
}
Which statement is true?
There is a syntax error on line 1.
There are syntax errors on lines 1 and 6.
There are syntax errors on lines 1, 6, and 8.
There is a syntax error on line 6.

Java - Operators and assignments - What will be the output of the program?

class PassA 
{
    public static void main(String [] args) 
    {
        PassA p = new PassA();
        p.start();
    }

    void start() 
    {
        long [] a1 = {3,4,5};
        long [] a2 = fix(a1);
        System.out.print(a1[0] + a1[1] + a1[2] + " ");
        System.out.println(a2[0] + a2[1] + a2[2]);
    }

    long [] fix(long [] a3) 
    {
        a3[1] = 7;
        return a3;
    }
}
12 15
15 15
3 4 5 3 7 5
3 7 5 3 7 5

Java - Operators and assignments - What will be the output of the program?

class Equals 
{
    public static void main(String [] args) 
    {
        int x = 100;
        double y = 100.1;
        boolean b = (x = y); /* Line 7 */
        System.out.println(b);
    }
}
True
False
Compilation fails
An exception is thrown at runtime

Java, exceptions - What will be the output of the program?

public class Foo 
{  
    public static void main(String[] args) 
    {
        try 
        { 
            return; 
        } 
        finally 
        {
            System.out.println( "Finally" ); 
        } 
    } 
}
Finally
Compilation fails.
The code runs with no output.
An exception is thrown at runtime.

Java, exceptions - What will be the output of the program?

public class RTExcept 
{
    public static void throwit () 
    {
        System.out.print("throwit ");
        throw new RuntimeException();
    }
    public static void main(String [] args) 
    {
        try 
        {
            System.out.print("hello ");
            throwit();
        }
        catch (Exception re ) 
        {
            System.out.print("caught ");
        }
        finally 
        {
            System.out.print("finally ");
        }
        System.out.println("after ");
    }
}
Hello throwit caught
Compilation fails
Hello throwit RuntimeException caught after
Hello throwit caught finally after
Java, Inner classes - Which is true about an anonymous inner class?
It can extend exactly one class and implement exactly one interface.
It can extend exactly one class and can implement multiple interfaces.
It can extend exactly one class or implement exactly one interface.
It can implement multiple interfaces regardless of whether it also extends a class.
Java, Inner classes
class Foo 
{
    class Bar{ }
}
class Test 
{
    public static void main (String [] args) 
    {
        Foo f = new Foo();
        /* Line 10: Missing statement ? */
    }
}
which statement, inserted at line 10, creates an instance of Bar?
Foo.Bar b = new Foo.Bar();
Foo.Bar b = f.new Bar();
Bar b = new f.Bar();
Bar b = f.new Bar();
Java
void start() {  
    A a = new A(); 
    B b = new B(); 
    a.s(b);  
    b = null; /* Line 5 */
    a = null;  /* Line 6 */
    System.out.println("start completed"); /* Line 7 */
} 
When is the B object, created in line 3, eligible for garbage collection?
After line 5
After line 6
After line 7
There is no way to be absolutely certain.
Java
class Bar { } 
class Test 
{  
    Bar doBar() 
    {
        Bar b = new Bar(); /* Line 6 */
        return b; /* Line 7 */
    } 
    public static void main (String args[]) 
    { 
        Test t = new Test();  /* Line 11 */
        Bar newBar = t.doBar();  /* Line 12 */
        System.out.println("newBar"); 
        newBar = new Bar(); /* Line 14 */
        System.out.println("finishing"); /* Line 15 */
    } 
}
At what point is the Bar object, created on line 6, eligible for garbage collection?
After line 12
After line 14
After line 7, when doBar() completes
After line 15, when main() completes

Java lang class - What is the value of "d" after this line of code has been executed?

double d = Math.round ( 2.5 + Math.random() );

2
3
4
2.5
Java lang class
public class Myfile 
{ 
    public static void main (String[] args) 
    {
        String biz = args[1]; 
        String baz = args[2]; 
        String rip = args[3]; 
        System.out.println("Arg is " + rip); 
    } 
}
Select how you would start the program to cause it to print: Arg is 2
Java Myfile 222
Java Myfile 1 2 2 3 4
Java Myfile 1 3 2 2
Java Myfile 0 1 2 3
Java, declarations and access control - You want subclasses in any package to have access to members of a superclass. Which is the most restrictive access that accomplishes this objective?
Public
Private
Protected
Transient

Java, declarations and access control - Which three form part of correct array declarations?

  1. public int a [ ]
  2. static int [ ] a
  3. public [ ] int a
  4. private int a [3]
  5. private int [3] a [ ]
  6. public final int [ ] a
1, 3, 4
2, 4, 5
1, 2, 6
2, 5, 6
Java, objects and collections - Suppose that you would like to create an instance of a new Map that has an iteration order that is the same as the iteration order of an existing instance of a Map. Which concrete implementation of the Map interface should be used for the new instance?
TreeMap
HashMap
LinkedHashMap
The answer depends on the implementation of the existing instance.
Java, objects and collections - You need to store elements in a collection that guarantees that no duplicates are stored and all elements can be accessed in natural order. Which interface provides that capability?
Java.util.Map
Java.util.Set
Java.util.List
Java.util.Collection

Java, Threads - Which two are valid constructors for Thread?

  1. Thread(Runnable r, String name)
  2. Thread()
  3. Thread(int priority)
  4. Thread(Runnable r, ThreadGroup g)
  5. Thread(Runnable r, int priority)
 
1 and 3
2 and 4
1 and 2
2 and 5
Java, Threads
class X implements Runnable 
{ 
    public static void main(String args[]) 
    {
        /* Missing code? */
    } 
    public void run() {} 
}
Which of the following line of code is suitable to start a thread ?
Thread t = new Thread(X);
Thread t = new Thread(X); t.start();
X run = new X(); Thread t = new Thread(run); t.start();
Thread t = new Thread(); x.run();
Java, assertions
public class Test 
{ 
    public void foo() 
    {
        assert false; /* Line 5 */
        assert false; /* Line 6 */
    } 
    public void bar()
    {
        while(true)
        {
            assert false; /* Line 12 */
        } 
        assert false;  /* Line 14 */
    } 
}
What causes compilation to fail?
Line 5
Line 6
Line 12
Line 14

Java, assertions - What will be the output of the program (when you run with the -ea option) ?

public class Test 
{  
    public static void main(String[] args) 
    {
        int x = 0;  
        assert (x > 0) : "assertion failed"; /* Line 6 */
        System.out.println("finished"); 
    } 
}
Finished
Compilation fails.
An AssertionError is thrown.
An AssertionError is thrown and finished is output.
{"name":"Test Developers", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Questa è la prima domanda. Serve solo per farti prendere confidenza con questo quiz.   Hai 3 minuti per dare la risposta ad ogni domanda compresa questa.   Inizia quando sei pronto., Domanda   Given:3.   public class RediMix extends Concrete { 4.     RediMix() { System.out.println(\"r \"); } 5.     public static void main(String[] args) { 6.        new RediMix(); 7.     } 8.   } 9.   class Concrete extends Sand { 10.    Concrete() { System.out.print(\"c \"); } 11.    private Concrete(String s) 12.  } 13.  abstract class Sand { 14.    Sand() { System.out.print(\"s \"); } 15.   }   What is the result?, Given:   2.  import java.text.*; 3.  public class Gazillion { 4.    public static void main(String[] args) throws Exception { 5.      String s = \"123.456xyz\"; 6.      NumberFormat nf = NumberFormat.getInstance(); 7.      System.out.println(nf.parse(s)); 8.      nf.setMaximumFractionDigits(2); 9.      System.out.println(nf.format(s)); 10.    } 11.  }   Which are true? (Choose all that apply.)","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
Powered by: Quiz Maker