Database Administration Questions


Q:

A UPS connects your computer and a power source.

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

A UPS (Uninterruptible Power Supply) is a device that provides battery backup when the electrical power fails or drops to an unacceptable voltage level.


Related image


Small UPS systems provide power for a few minutes; enough to power down the computer in an orderly manner, while larger systems have enough battery for several hours.

Report Error

View Answer Workspace Report Error Discuss

1 2579
Q:

Which of the following data structure is linear type?

A) Tree B) Binary Tree
C) Queue D) Graph
 
Answer & Explanation Answer: C) Queue

Explanation:

A data structure is a specialized format for organizing and storing data. General data structure types include the array, the file, the record, the table, the tree, and so on. Any data structure is designed to organize data to suit a specific purpose so that it can be accessed and worked with in appropriate ways.

 

Linear data structure: A linear data structure traverses the data elements sequentially, in which only one data element can directly be reached.

Ex: Arrays, Linked Lists, Stack, Queue, Any type of List all are linear.

 

Trees like Binary Tree, B Tree or B+ Tree are examples of non linear data structure.

Report Error

View Answer Report Error Discuss

5 2579
Q:

What command would you use to create a backup control file?

Answer

Alter database backup control file to trace

Report Error

View answer Workspace Report Error Discuss

3 2576
Q:

When should you stop at green and go at red?

Answer

While eating a watermelon, we all go along the red and stops at green.

Report Error

View answer Workspace Report Error Discuss

5 2575
Q:

According to new federal data released, the US state whose economy has surpassed that of the UK to become the world’s fifth largest was

A) Massachusetts B) Florida
C) Hawaii D) California
 
Answer & Explanation Answer: D) California

Explanation:

The US state California's  economy has surpassed that of the UK to become the world’s fifth largest, according to new federal data released.

 

With a GDP of $2.7 trillion, California is now only behind the US, China, Japan and Germany.

Report Error

View Answer Report Error Discuss

2 2575
Q:

What words are similar in meaning to Run?

A) Race B) Amble
C) Lope D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

All of the options given are synonyms of RUN.

 

Hence, Race, Amble, Lope are similar in meaning to the word Run.

Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

2 2570
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 2560
Q:

Autocorrect was originally designed to replace

A) Misspelled words B) Grammatically incorrect
C) Repetitive words D) All of the above
 
Answer & Explanation Answer: A) Misspelled words

Explanation:

autocorrect_was_originally_designed_to_replace1561613833.jpg image

 

Autocorrect was originally designed to replace Misspelled words. Its purpose is as part of the spell checker to correct common spelling or typing errors, saving time for the user. It is commonly found in word processors and text editing interfaces for smartphones, computers, etc.

Report Error

View Answer Report Error Discuss

6 2553