Database Administration Questions


Q:

What is always coming but never arrives?

Answer

It is Tomorrow. It always be tomorrow which represents coming but never arrives.

Report Error

View answer Workspace Report Error Discuss

7 6122
Q:

The memory unit is one part of

A) Input Device B) Central Processing Unit
C) Control Unit D) Output device
 
Answer & Explanation Answer: B) Central Processing Unit

Explanation:

In a computer, memory is one part of Central processing unit i.e, CPU.

Report Error

View Answer Report Error Discuss

14 6116
Q:

Wince : Pain :: Prostration : ?

A) Frustration B) Submissiveness
C) Strained D) Discomfiture
 
Answer & Explanation Answer: B) Submissiveness

Explanation:

First is the sigh of the second.

Hence, Wince : Pain :: Prostration :Submissiveness.

Report Error

View Answer Report Error Discuss

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

4 6106
Q:

GUI stands for

A) Graphical Universal Interface B) Graph Use Interface
C) Graphical Unique Interface D) Graphical User Interface
 
Answer & Explanation Answer: D) Graphical User Interface

Explanation:

GUI stands for Graphical User Interface.

 

A Graphical User Interface is a computer interface that allows users to interact with a device through graphical elements such as pictures and animations, as opposed to text-based commands.

Report Error

View Answer Report Error Discuss

9 6090
Q:

A term used interchangeably with diskette is

A) Floppy disk B) Disk pack
C) Disk cartridge D) Packette disk
 
Answer & Explanation Answer: A) Floppy disk

Explanation:

A term used interchangeably with diskette is Floppy disk.

Report Error

View Answer Report Error Discuss

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

5 6076
Q:

What color does blue and yellow make?

A) Green B) Black
C) Red D) White
 
Answer & Explanation Answer: A) Green

Explanation:

Mixing of blue and yellow colors make Green Color.

                                 400px-Color_mixture.svg_1521793884.png image

 

RYB (an abbreviation of red–yellow–blue) is a historical set of colors used in subtractive color mixing and is one commonly used set of primary colors. It is primarily used in art and design education, particularly painting.

RYB predates modern scientific color theory, which has determined that cyan, magenta, and yellow are the best set of three colorants to combine, for the widest range of high-chroma colors.

Report Error

View Answer Report Error Discuss

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

1 6057
Q:

80% of 900 + 162 x 4 x ? = 113 - 99

A) 0.5 B) 1
C) 4 D) 0
 
Answer & Explanation Answer: A) 0.5

Explanation:

80x900/100 + 256 x 4 x ? = 1331 - 99

720 + 1024 x ? = 1232

? = 1232 - 720/1024

? = 512/1024 = 0.5

? = 0.5 

Report Error

View Answer Report Error Discuss

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

11 6039
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

9 6030