Database Administration Questions


Q:

OSI Reference Model provides a framework for discussing network operations and design

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

It provides a framework for discussing network operations and design

Report Error

View Answer Workspace Report Error Discuss

Subject: Networking
Job Role: Database Administration

0 3080
Q:

What is silly window syndrome?

Answer

It is a problem that can ruin TCP performance. This problem occurs when data are passed to the sending TCP entity in large blocks, but an interactive application on the receiving side reads 1 byte at a time.

Report Error

View answer Workspace Report Error Discuss

Subject: Networking
Job Role: Database Administration

0 3419
Q:

What is wide-mouth frog?

Answer

Wide-mouth frog is the simplest known key distribution center (KDC) authentication protocol

Report Error

View answer Workspace Report Error Discuss

Subject: Networking
Job Role: Database Administration

0 1879
Q:

What is Proxy ARP?

Answer

It is using a router to answer ARP requests. This will be done when the originating host believes that a destination is local, when in fact is lies beyond router.

Report Error

View answer Workspace Report Error Discuss

Subject: Networking
Job Role: Database Administration

1 2264
Q:

Which command is used to return maximum value from result set?

A) MAX B) MIN
C) MAXIMUM D) MAXI
 
Answer & Explanation Answer: A) MAX

Explanation:

MAX command is used to return maximum value from result setMAX 

Report Error

View Answer Report Error Discuss

1 2405
Q:

Can’t update primary table’s primary key if row being modified has related rows in secondary table once referential integrity is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:
Report Error

View Answer Workspace Report Error Discuss

0 2942
Q:

We Can still delete a row from primary table if there are related rows in secondary table once a refferential integrity is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

Can’t delete a row from primary table if there are related rows in secondary table.

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2647
Q:

Breaking of relationships is allowed once referential integrity on a database is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

Breaking of relationships is prevented once referential integrity on a database is enforced

Report Error

View Answer Workspace Report Error Discuss

0 4000