Database Administration Questions


Q:

The ratio of K’s and M’s ages is 4: 5. If the difference between the present age of M and the age of K, 5 years hence is 3 years, then what is the difference and total of present ages of K and M?

A) 8, 72 yrs B) 16, 65 yrs
C) 12, 84 yrs D) 10, 60 yrs
 
Answer & Explanation Answer: A) 8, 72 yrs

Explanation:

Let the present ages be K,M

Given K/M = 4/5

5K - 4M = 0 ......(1)

Also given that,

M - (K + 5) = 3

M - K = 8 .........(2)


Then, by solving (1) & (2)

M = 40 yrs and K = 32 yrs

Hence, Total of ages = 40 + 32 = 72 yrs

Difference of ages = 40 - 32 = 8 yrs.

Report Error

View Answer Report Error Discuss

3 6305
Q:

Although glory but not at my best. Power will fall to me when the man who made me dies. What am I?

Answer

PRINCE.

Report Error

View answer Workspace Report Error Discuss

20 6289
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 6278
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 6273
Q:

Social engineering attacks are best identified by

A) Ransomware B) Phishing
C) Both A & B D) None of the above
 
Answer & Explanation Answer: C) Both A & B

Explanation:

Social engineering is the art of tricking users into performing certain harmful activities or attacks, users must be trained to identify social engineering. Social engineering attacks typically involve some form of psychological manipulation, fooling otherwise unsuspecting users or employees into handing over confidential or sensitive data. Commonly, social engineering involves email or other communication that invokes urgency, fear, or similar emotions in the victim, leading the victim to promptly reveal sensitive information, click a malicious link, or open a malicious file. Because social engineering involves a human element, preventing these attacks can be tricky for enterprises.

 

Report Error

View Answer Report Error Discuss

1 6204
Q:

Which best describes transformation in bacteria?

A) Bacteria take DNA from their environment. B) Bacteria inject DNA into another cell.
C) Bacteria lie dormant for many weeks. D) Bacteria transfer DNA with a bacteriophage.
 
Answer & Explanation Answer: A) Bacteria take DNA from their environment.

Explanation:

"Bacteria take DNA from their environment" is what best describes transformation in bacteria.

Report Error

View Answer Report Error Discuss

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

4 6191
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

13 6163
Q:

A hater of knowledge and learning is

A) Philologist B) Misologist
C) Bibliophile D) Misogynist
 
Answer & Explanation Answer: B) Misologist

Explanation:

The one word substitution for a hater of knowledge and learning is Misologist.

Report Error

View Answer Report Error Discuss

6 6133