Database Administration Questions


Q:

Fastest Shorthand Writer was

A) Dr. G. D. Bist B) J.R.D. Tata
C) J.M. Tagore D) Khudada Khan
 
Answer & Explanation Answer: A) Dr. G. D. Bist

Explanation:

Dr. G. D. Bist, Guinness Record Holder, the first-ever Ph.D. in Stenography in the world.

 

He had achieved a highest speed of 250 w.p.m. in Shorthand.

Report Error

View Answer Workspace Report Error Discuss

77 33118
Q:

Which region in India is known as the "Rice Bowl of India"?

A) Indo-Gangetic plain B) Krishna-Godavari Delta region
C) North-East region D) Kerala and Tamil Nadu
 
Answer & Explanation Answer: B) Krishna-Godavari Delta region

Explanation:

In India, the Krishna-Godavari Delta region is called as "Rice Bowl of India".

 

Coming to the Indian State, Chhattisgarh is known as Rice Bowl of India.

Report Error

View Answer Workspace Report Error Discuss

72 17845
Q:

It is necessary to sort a file before searching a particular item 

A) True B) False
C) May or may not be true D) None of the above
 
Answer & Explanation Answer: C) May or may not be true

Explanation:

If less work is involved in searching a element than to sort and then extract, then we don’t go for sort

If frequent use of the file is required for the purpose of retrieving specific element, it is more efficient to sort the file.

Thus it depends on situation

Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database
Job Role: Database Administration

1 3325
Q:

Which operator performs pattern matching ?

A) LIKE operator B) EXISTS operator
C) BETWEEN operator D) None of these
 
Answer & Explanation Answer: A) LIKE operator

Explanation:

LIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN).

The syntax is as follows:
SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN}

{PATTERN} often consists of wildcards. In SQL, there are two wildcards:



% (percent sign) represents zero, one, or more characters.
_ (underscore) represents exactly one character.

Report Error

View Answer Workspace Report Error Discuss

1 2823
Q:

What are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms?

A) Polish B) Reverse Polish
C) Both A and B D) None of the above
 
Answer & Explanation Answer: C) Both A and B

Explanation:

Polish and Reverse Polish are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms

Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database
Job Role: Database Administration

2 2422
Q:

Default read write and execute permissions given to a file for owner, group and others are

A) 6-4-4 B) 6-4-2
C) 6-4-6 D) 6-6-6
 
Answer & Explanation Answer: A) 6-4-4

Explanation:

Default permissions given to a file are:

Owner - read write and execute - 6

group - write - 4

others - write - 4

Report Error

View Answer Workspace Report Error Discuss

5 2228
Q:

What is the maximum number of triggers, can apply to a single table?

A) 8 B) 10
C) 12 D) 14
 
Answer & Explanation Answer: C) 12

Explanation:

Maximim number of triggers that can be applied to a single table is 12

Report Error

View Answer Workspace Report Error Discuss

6 2107
Q:

A source program is the program written in which level language  ?

A) Alpha Numeric B) High-Level
C) Symbolic D) Machine
 
Answer & Explanation Answer: B) High-Level

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Programming
Exam Prep: Bank Exams
Job Role: Analyst , Database Administration , IT Trainer

2 1790