Sawaal
  • Home/
  • Searching for Finance.

 Searching for "Finance."

Q:

Statements : Government has spoiled many top ranking financial institutions by appointing bureaucrats as Directors of these institutions.

Conclusions :

a) Government should appoint Directors of the financial institutes taking into consideration the expertise of the person in the area of finance.
b) The Director of the financial institute should have expertise commensurate with the financial work carried out by the institute.

A) Only a follows B) Only b follows
C) Both a & b follows D) Neither a nor b follows
 
Answer & Explanation Answer: C) Both a & b follows

Explanation:

According to the statement, Government has spoiled financial institutions by appointing bureaucrats as Directors. This means that only those persons should be appointed as Directors who are experts in finance and are acquainted with the financial work of the institute. So, both a and b follows.

Report Error

View Answer Report Error Discuss

Filed Under: Statement and Conclusions
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Bank Clerk , Bank PO

Q:

A large document contains meeting notes from all meeting that took place between HR and Finance. You need to find all instances of 'derive' or 'dive' or 'dave'. What would be the most efficient way to find these terms using the Find & Replace dialog box?

A) Choose Wildcard option and search for d?ve B) Choose Wildcard option and search for d*ve
C) Choose Wildcard option and search for ?ve D) Choose Wildcard option and search for *ve
 
Answer & Explanation Answer: B) Choose Wildcard option and search for d*ve

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MOS-Microsoft Office Specialist

Q:

You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information.BULK INSERT finance.dbo.customersFROM 'd:bulkaccts143_10142000.txt'WITH DATAFILETYPE = 'char', FIELDTERMINATOR = 't', ROWTERMINATOR = 'n', TABLOCK You want to ensure that response times do not slow when new account information is added to the database. What should you do?

A) Add the BATCHSIZE option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded. B) Add the ROWS_PER_BATCH option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded.
C) Drop the indexes for the Customers table before the data load, and then re-create the indexes after the data load is complete. D) Remove the TABLOCK option from the BULK INSERT statement.
 
Answer & Explanation Answer: D) Remove the TABLOCK option from the BULK INSERT statement.

Explanation:

The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.


Note: The BULK INSERT statement is used to copy a data file into a database table or view in a format specified by the user. The BULK INSERT statement accepts the TABLOCK hint, which allows the user to specify the locking behavior that the BULK INSERT statement should use. TABLOCK specifies that a bulk update table-level lock is taken for the duration of the bulk copy. If TABLOCK is not specified, the default uses row-level locks.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert