Sawaal

Database Administration Questions

Popular Latest Rated
Q:

Do you know the differences between Resume, C.V and Bio-Data ?

Report Error

View answer Workspace Report Error Discuss

Subject: Personal Interview Exam Prep: Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Database Administration , IT Trainer , Network Engineer , Project Manager

8 917
Q:

What is BCP ? When is it used ?

Answer

The Bulk Copy Program (BCP) is a command-line utility that ships with Microsoft SQL Server. It is a tool used to duplicate enormous quantity of information from tables and views. It does not facsimile the structures same as foundation to target.
BULK INSERT command helps to bring in a data folder into a record, table or view in a user-specific arrangement. With BCP, you can import and export large amounts of data in and out of SQL Server databases quickly and easily. Any DBA who has utilized this functionality will agree that BCP is an essential tool.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration
Job Role: Analyst , Database Administration , IT Trainer

3 1363
Q:

Which of the following are incorrect form of StringBuffer class constructor  ?

A) StringBuffer(int size , String str) B) StringBuffer(int size)
C) StringBuffer(String str) D) StringBuffer()
 
Answer & Explanation Answer: A) StringBuffer(int size , String str)

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Java
Job Role: Database Administration , IT Trainer

3 6165
Q:

Seven people A, B, C, D, E, F and G live on separate floors of a 7-floor building. Ground floor is numbered 1, first floor is numbered. 2 and so on until the topmost floor is numbered 7. Each one of these having a different cars-Cadillac, Ambassador, Fiat, Maruti, Mercedes, Bedford and Fargo but not necessarily in the same order. Only three people live above the floor on which A lives. Only one person lives between A and the one having a car Cadillac. F lives immediately below the one having a car Bedford. The one having a car Bedford lives on an even-numbered floor. Only three people live between the ones having a car Cadillac and Maruti. E lives immediately above C. E is not having a car Maruti. Only two people live between B and the one having a car Fargo. The one having a car Fargo lives below the floor on which B lives. The one having a car Fiat does not live immediately above D or immediately below B. D does not live immediately above or immediately below A. G does not have a car Ambassador.

Question :

 How many people live between the floors on which D and the one having a car Bedford ?

A) One B) Two
C) Three D) Four
 
Answer & Explanation Answer: B) Two

Explanation:

111-151497940723.png image

Above is the table obtained from the given information in the passage.

There are two people (B & G) live between the floors on which D and the one having a car Bedford.

Report Error

View Answer Report Error Discuss

Filed Under: Deriving Conclusions From Passages
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

21 15322
Q:

What do you mean by friend function in C++ ?

Answer

Friends can be either functions or other classes. The class grants friends unlimited access privileges.

* The declaration of the function should be preceded by the keyword 'friend'.
* The function definition will not use the keyword or the scope operator '::'.


Thus, a friend function is an ordinary function or a member of another class.

Report Error

View answer Workspace Report Error Discuss

Subject: C++
Job Role: Analyst , Database Administration , IT Trainer

15 3837
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 Report Error Discuss

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

14 10115
Q:

Values that are used to end loops are referred to as _____ values.

A) stop B) sentinel
C) end D) finish
 
Answer & Explanation Answer: B) sentinel

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: C++
Job Role: Analyst , Database Administration , IT Trainer , Project Manager

4 4583
Q:

Which of the following type casts will convert an Integer variable named amount to a Double type ?

A) (int to double) amount B) int (amount) to double
C) int to double(amount) D) (double) amount
 
Answer & Explanation Answer: D) (double) amount

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: C++
Job Role: Analyst , Database Administration , IT Trainer , Project Manager

6 4385