Database Administration Questions


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

3 1620
Q:

Which country shares the longest border with China?

A) India B) Russia
C) Mongolia D) Kazakhstan
 
Answer & Explanation Answer: C) Mongolia

Explanation:

China shares land borders with 14 different countries, the longest being with Mongolia followed by Russia and then India.

Report Error

View Answer Report Error Discuss

2 1607
Q:

Cell references in a formula are called

Answer

Cell references in a formula are called Assumptions rather than constant values.



All cell references are relative references by default. When copied across multiple cells, they change based on the relative position of rows and columns.

Report Error

View answer Workspace Report Error Discuss

0 1594
Q:

What is separation in HRM?

Answer

Separation of an employee exists when the service of an employee comes to an end because of one reason or other. "Separation of employment" refers broadly to the process of managing the termination of employment. It is a sensitive issue for any organization. 


 


Types of separation:


 


1) Volunntary:


a) Resignation
b) Job abandonment
c) Retirement


 


2) Involuntary:


a) Layoff
b) Dismissal
c) Plant closure
d) Death or Disability.

Report Error

View answer Workspace Report Error Discuss

1 1584
Q:

Which Indian state has the maximum number of Lok Sabha constituencies?

A) Uttar Pradesh B) Madhya Pradesh
C) Andhra Pradesh D) Gujarat
 
Answer & Explanation Answer: A) Uttar Pradesh

Explanation:

Indian state that has the maximum number of Lok Sabha constituencies is Uttar Pradesh with 80 Lok sabha seats.

Report Error

View Answer Report Error Discuss

3 1566
Q:

The first asian games was held in

A) Jakarta B) Tokyo
C) New Delhi D) Beijing
 
Answer & Explanation Answer: C) New Delhi

Explanation:

The first Asian games was held in New Delhi. The Asian Games, were regulated by the Asian Games Federation (AGF) from the first Games in New Delhi, India, until the 1978 Games.

Report Error

View Answer Report Error Discuss

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

5 1527
Q:

Both Joyel and Susy share a Windows 10 tablet with different user accounts. Joyel needs to access some files in Susy’s Documents folder. How can he do this ?

A) Joyel can access the files only if he has administrative rights B) Susy must choose to make the Documents folder Public for Joyel to see them
C) Joyel can, by default, see and access the files in any Documents folder on this computer D) Joyel cannot access those files without Susy moving them to another folder
 
Answer & Explanation Answer: A) Joyel can access the files only if he has administrative rights

Explanation:
Report Error

View Answer Report Error Discuss

6 1522
Q:

With YouTube Analytics, you can track metrics on

A) TrueView ad skip rates B) Playback locations
C) Cost-per-channel visit D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

With YouTube Analytics, you can track metrics on Playback locations. Playback locations gives you how many views your channel got and what videos they watched. 

 

With_YouTube_Analytics,_you_can_track_metrics_on1554273173.jpg image

 

With YouTube Analytics we can Find out who's watching, what they like to watch, and which videos could make you the most money.

Report Error

View Answer Report Error Discuss

0 1511