Database Administration Questions


Q:

The SQL keyword(s) ________ is used with wildcards.

A) LIKE only B) IN only
C) NOT IN only D) IN and NOT IN
 
Answer & Explanation Answer: A) LIKE only

Explanation:
Report Error

View Answer Report Error Discuss

35 13647
Q:

Which of the following is a comparison operator in SQL?

A) = B) <>
C) ` D) /
 
Answer & Explanation Answer: A) =

Explanation:

The comparison operator that is used in SQL is '='. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

Report Error

View Answer Report Error Discuss

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

7 13615
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 Report Error Discuss

Filed Under: Database
Job Role: Database Administration

10 13370
Q:

An Excel Workbook is a collection of

A) Charts B) Worksheets
C) Both A & B D) None of the above
 
Answer & Explanation Answer: C) Both A & B

Explanation:

An M.S Excel Workbook is a collection of both Worksheets and Charts.

 

An_Excel_Workbook_is_a_collection_of1558067892.jpg image

Report Error

View Answer Report Error Discuss

29 13357
Q:

Natural Rubber is a Polymer of

A) butadiene B) 2methyl-1,3butadiene
C) ethylene D) isoprene
 
Answer & Explanation Answer: D) isoprene

Explanation:

Natural Rubber is a Polymer derived from Isoprene. 

 rubber-bands-503028_6401547100511.jpg image

      • Natural rubber is an addition polymer that is obtained as a milky white fluid known as Latex from a Tropical Rubber Tree.
Report Error

View Answer Report Error Discuss

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

37 13341
Q:

The product of a number and its multiplicative inverse is

A) 1 B) 0
C) -1 D) Infinity
 
Answer & Explanation Answer: A) 1

Explanation:

The mutiplicative inverse of a number is nothing but a reciprocal of a number.

Now, the product of a number and its multiplicative inverse is always equal to 1.

 

For example :

Let the number be 15

Multiplicative inverse of 15 = 1/15

The product of a number and its multiplicative inverse is = 15 x 1/15 = 1.

Report Error

View Answer Report Error Discuss

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

21 13209
Q:

The Basic Architecture of Computer was developed by

A) Charles Babbage B) Blaise Pascal
C) Garden Moore D) John Von Neumann
 
Answer & Explanation Answer: D) John Von Neumann

Explanation:

Computer Architecture refers to how a computer system is designed and what technologies it is compatible with. In brief, Computer architecture is a specification detailing how a set of software and hardware technology standards interact to form a computer system or platform.  

                                     comp1518074667.jpg image 

The Von Neumann Architecture, which is also known as the Von Neumann Model and Princeton architecture, is a computer architecture based on the 1945 description of computer by the mathematician and physicist John von Neumann.

Report Error

View Answer Report Error Discuss

19 12948
Q:

Which of the following is not a function of a Warehouse?

A) Ensuring Profit B) Stabilisation in price
C) Risk-bearing D) Storage
 
Answer & Explanation Answer: A) Ensuring Profit

Explanation:
Report Error

View Answer Report Error Discuss

2 12859