Database Administration Questions


Q:

A program in execution is called

A) Procedure B) Function
C) Process D) Instruction
 
Answer & Explanation Answer: C) Process

Explanation:

We know that a computer program is a set of instructions to be executed. And if the instructions are in execution, then it is called as process. In brief, a program in execution is called as process.

Report Error

View Answer Report Error Discuss

18 11980
Q:

Which of the following is Not an Operating System?

A) UNIX B) Windows NT
C) C++ D) DOS
 
Answer & Explanation Answer: C) C++

Explanation:

C++ is not an Operating System.

 

An Operating System is a collection of system programs that manages all the other programs application programs in a computer as well as the allocation and use of hardware resources such as the CPU, Memory and the Hard Disk Drive.

It acts as an interface between the hardware and the user level program.

It controls and facilitates the overall operation of a computer. 

 

Here

UNIX : UNIX is a popular multi-user, multitasking operating system (OS) developed at Bell Labs.

 

Windows NT : Windows NT is a family of operating systems produced by Microsoft, the first version of which was released in July 1993.

 

DOS : DOS is Disk Operating System. The term DOS can refer to any operating system.

 

C++ : C++ is a programming language and computing platform.

 

Hence, C++ is not an Operating System.

Report Error

View Answer Report Error Discuss

46 11962
Q:

O_er_t_o_

Complete the missing letters of the given word.

A) Ordination B) Oterration
C) Ovvulation D) Operation
 
Answer & Explanation Answer: D) Operation

Explanation:
Report Error

View Answer Report Error Discuss

16 11880
Q:

Which dml command is used in conjunction with @@identity?

A) INSERT and UPDATE B) UPDATE and DELETE
C) SCOPE_IDENTITY and IDENT_CURRENT D) Commit and rollback
 
Answer & Explanation Answer: C) SCOPE_IDENTITY and IDENT_CURRENT

Explanation:

Using automatically incrementing IDENTITY columns is very popular with database developers. You don’t need to explicitly calculate unique surrogate keys when inserting new data, the IDENTITY column functionality does that for you. The IDENTITY feature also allows you to specify useful Seed and Increment properties. When you use an INSERT statement to insert data into a table with an IDENTITY column defined, SQL Server will generate a new IDENTITY value.

 

You can use the @@IDENTITY variable and the SCOPE_IDENTITY and IDENT_CURRENT functions to return the last IDENTITY value that has been generated by SQL Server. This is very useful when you need to return the key for the row that has just been inserted, back to the caller.

Report Error

View Answer Report Error Discuss

20 11748
Q:

Five boxes of bananas sell for Rs. 30. how many boxes can you buy for Rs.9?

A) 2 B) 1.5
C) 1.25 D) 2.5
 
Answer & Explanation Answer: B) 1.5

Explanation:

Given Five boxes of bananas sell for Rs. 30.

=> 1 Box of Bananas for = 30/5 = Rs. 6

 

Then, for Rs. 9

=> 9/6 = 3/2 = 1.5

 

Hence, for Rs. 9, 1.5 box of bananas can buy.

Report Error

View Answer Report Error Discuss

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

25 11669
Q:

Lichens are the best indicator of

A) Air pollution B) Sound pollution
C) Noise pollution D) Water pollution
 
Answer & Explanation Answer: A) Air pollution

Explanation:

1. Lichens are plants that grow in exposed places such as rocks or tree bark.

 

2.  Lichens are widely used as environmental indicators or bio-indicators. They can be used as air pollution indicators, especially of the concentration of sulfur-di-oxide in the atmosphere.  

 

3. They need to be very good at absorbing water and nutrients to grow there.

Report Error

View Answer Report Error Discuss

30 11603
Q:

Main storage is also called

A) Memory B) Control unit
C) Accumulator D) Register unit
 
Answer & Explanation Answer: A) Memory

Explanation:

In a computer, the area where the data is stored for the quick access by the computer's processor is called Main storage or Primary storage or Memory or RAM.

 

Hence, main storage is also called Memory.

Report Error

View Answer Report Error Discuss

15 11558
Q:

Oldest Oil Field in India

A) Mumbai High, Maharashtra B) Anleshwar, Gujarat
C) Digboi, Assam D) None
 
Answer & Explanation Answer: C) Digboi, Assam

Explanation:

Digboi has the distinction of being India's oldest continuously producing oilfield. Digboi refinery, now a division of Indian Oil Corporation, had a capacity of about 0.65 MMTPA as of 2003. Digboi is now Headquarter of Assam Oil Division of Indian Oil Corporation Limited, though the crude production is not high today.

Report Error

View Answer Report Error Discuss

27 11554