Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology programming languages

Given: 1. class Eco { 2. public static void main(String[] args) { 3. Eco e1 = new Eco(); 4. Eco e2 = new Eco(); 5. Eco e3 = new Eco(); 6. e3.e = e2; 7. e1.e = e3; 8. e2 = null; 9. e3 = null; 10. e2.e = el; 11. e1 = null; 12. } 13. Eco e; 14. } At what point is only a single object eligible for GC?

After line 8 runs.
After line 9 runs.
After line 10 runs.
After line 11 runs.
Compilation fails.
An exception is thrown at runtime.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

select Project_ID,Project_Name,Project_Status from Projects group by Project_ID,Project_Status,Project_Name

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

When "Join" is used in a query which should not be used with that

On
Where
Having
Non of the Above

Reveal answer Fill a bubble to check yourself

Multiple choice technology programming languages

Given: 1. class Bigger { 2. public static void main(String[] args) { 3. // insert code here 4. } 5. } 6. class Better { 7. enum Faster {Higher, Longer}; 8. } Which, inserted independently at line 3, will compile? (Choose all that apply.)

Faster f = Faster.Higher;
Faster f = Better.Faster.Higher;
Better.Faster f = Better.Faster.Higher;
Bigger.Faster f = Bigger.Faster.Higher;
Better. Faster f2; f2 = Better.Faster.Longer;
Better b; b.Faster = f3; f3 = Better.Faster.Longer;

Reveal answer Fill a bubble to check yourself

Multiple choice technology programming languages

Given: class Bird { { System.out.print("bl "); } public Bird() { System.out.print("b2 "); } } class Raptor extends Bird { static { System.out.print("r1 "); } public Raptor() { System.out.print("r2 "); } { System.out.print("r3 "); } static { System.out.print("r4 "); } } class Hawk extends Raptor { public static void main(String[] args) { System.out.print("pre "); new Hawk(); System.out.println("hawk "); } } What is the result?

pre b1 b2 r3 r2 hawk
pre b2 b1 r2 r3 hawk
pre b2 b1 r2 r3 hawk r1 r4
r1 r4 pre b1 b2 r3 r2 hawk
r1 r4 pre b2 b1 r2 r3 hawk
Compilation fails.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?

SELECT DISTINCT position, manager FROM employee;
SELECT position, manager DISTINCT FROM employee;
SELECT position, manager FROM employee;
SELECT position, DISTINCT manager FROM employee;

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which two are attributes of /SQL*Plus? (Choose two)

/SQL*Plus commands cannot be abbreviated.
/SQL*Plus commands are accesses from a browser.
/SQL*Plus commands are used to manipulate data in tables.
/SQL*Plus commands manipulate table definitions in the database.
/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which is an /SQL*Plus command?

INSERT
UPDATE
SELECT
DESCRIBE
DELETE
RENAME

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which two statements are true regarding the ORDER BY clause?

The sort is in ascending by order by default.
The sort is in descending order by default.
The ORDER BY clause must precede the WHERE clause.
The ORDER BY clause is executed on the client side.
The ORDER BY clause comes last in the SELECT statement
The ORDER BY clause is executed first in the query execution.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

The size of a table does NOT need to be specified.

True
False

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
1021
1022
1023
1024
1025
1026
1027
1028
1029
…
3670
3671
Next →