Database Administration Questions


Q:

Difference between Arraylist and Linked list?

Answer

ArrayList and LinkedList both implements List interface and maintains insertion order. Both are non synchronized classes.


 


But there are many differences between ArrayList and LinkedList classes that are given below.


 

ArrayList    V/s     LinkedList ::


 

1) ArrayList internally uses dynamic array to store the elements.


                   Whereas


LinkedList internally uses doubly linked list to store the elements.


 

2) Manipulation with ArrayList is slow because it internally uses array. If any element is removed from the array, all the bits are shifted in memory.


                   Whereas


Manipulation with LinkedList is faster than ArrayList because it uses doubly linked list so no bit shifting is required in memory.


 

3) ArrayList class can act as a list only because it implements List only.


                   Whereas


LinkedList class can act as a list and queue both because it implements List and Deque interfaces.


 

4) ArrayList is better for storing and accessing data.


                   Whereas


LinkedList is better for manipulating data.

Report Error

View answer Workspace Report Error Discuss

3 2837
Q:

What has a ring but no finger?

Answer

A Telephone or an Alarm...

Report Error

View answer Workspace Report Error Discuss

5 2835
Q:

How long is an IPv6 address?

A) 128 bytes B) 32 bits
C) 128 bits D) 32 bytes
 
Answer & Explanation Answer: C) 128 bits

Explanation:

IPv6 - Internet Protocol Version 6.

IPv6 addresses have a size of 128 bits.

Internet Protocol Version 6 [IPv6] is the successor to the Internet's first addressing infrastructure, Internet Protocol version 4 (IPv4).

In contrast to IPv4, which defined an IP address as a 32-bit value, IPv6 address have a size of 128 bits. 

Report Error

View Answer Report Error Discuss

8 2821
Q:

Economic resources are also called

Answer

Economic resources include land, labour, capital and entrepreneurship. 


Entrepreneurship is also considered an economic resource because individuals are responsible for creating businesses and moving economic resources in the business environment.


 


These economic resources are also called as Factors of production.


 

Report Error

View answer Workspace Report Error Discuss

2 2819
Q:

Permanent hardness of water may be removed by the addition of

A) Alum B) Lime
C) Sodium Carbonate D) Potassium Permanganate
 
Answer & Explanation Answer: C) Sodium Carbonate

Explanation:

Permanent hardness of water may be removed by the addition of Sodium Carbonate.

Report Error

View Answer Report Error Discuss

Filed Under: Chemistry
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

0 2814
Q:

Name one problem that led to the civil war.

A) Slavery B) Economic reasons
C) State's Rights D) All the above
 
Answer & Explanation Answer: D) All the above

Explanation:
Report Error

View Answer Report Error Discuss

0 2814
Q:

Bleaching powder is used in drinking water as

A) Disinfectant B) Antibiotic
C) Coagulant D) Antiseptic
 
Answer & Explanation Answer: A) Disinfectant

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Chemistry
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration

2 2813
Q:

What is the difference between a Local and a Global temporary table?

Answer

Local :


Only available to the current Db connection for current user and are cleared when connection is closed.


Multiple users can’t share a local temporary table.


 


Global:


Available to any connection once created. They are cleared when the last connection is closed.


Can be shared by multiple user sessions

Report Error

View answer Workspace Report Error Discuss

1 2806