What is meant by a dedicated computer?

Correct Answer: IEEE 1284

Correct Answer: Breaks up broadcast domains in a layer 2 switch internetwork

Explanation:

virtual LAN (VLAN) is any broadcast domain that is partitioned and isolated in a computer network at the data link layer (OSI layer 2). LAN is the abbreviation for local area network and in this context, virtual refers to a physical object recreated and altered by additional logic.

VLANs work by applying tags to network packets and handling these tags in networking systems ? creating the appearance and functionality of network traffic that is physically on a single network but acts as if it is split between separate networks. In this way, VLANs can keep network applications separate despite being connected to the same physical network, and without requiring multiple sets of cabling and networking devices to be deployed.

Correct Answer: In networking and in other areas, a task is often begun before the previous task has ended This is known as pipelining

Correct Answer: The protocol specifies that frames need to be numbered This is done by using sequence numbers A field is added to the data frame to hold the sequence number of that frame Since we want to minimize the frame size, the smallest range that provides unambiguous communication The sequence numbers can wrap around

Correct Answer: In Stop and wait protocol, sender sends one frame, waits until it receives confirmation from the receiver (okay to go ahead), and then sends the next frame

Correct Answer: All the above

Explanation:

All the above listed actions are the functions of cursor

Correct Answer: A DBA is a Database Administrator, and this is the most common job that you find a database specialist doing There are Development DBAs and Production DBAs - A Development DBA usually works closely with a team of developers and gets more involved in design decisions, giving advice on performance and writing good SQL That can be satisfying at a human level because you are part of a team and you share the satisfaction of the teams accomplishments - A Production DBA (on the other hand) is responsible for maintaining Databases within an organization, so it is a very difficult and demanding job He or she, often gets involved when all the design decisions have been made, and has simply to keep things up and running Therefore, of course, it is also a rewarding job, both financially and in terms of job satisfaction But it is a more "lonely" job than being a Development DBA

Correct Answer: Complete database recovery from disk failure is possible only in ARCHIVELOG mode Online database backup is possible only in ARCHIVELOG mode

Correct Answer: UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted

Correct Answer: Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint