Database Administration Questions


Q:

The time complexity of sequential search is

A) O(n) B) O(2n)
C) O(n^2) D) None
 
Answer & Explanation Answer: A) O(n)

Explanation:

The time complexity of sequential search is O(n)

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 2763
Q:

A subset of the database which contain virtual data that is derived from the database files but is not explicitly stored is called

A) Touple B) View
C) Relation D) Key
 
Answer & Explanation Answer: B) View

Explanation:

A view may be a subset of the database or it may contain virtual data that is derived from the database files but is not explicitly stored .

 

 

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 2752
Q:

Which of the following is an example of system software?

A) Microsoft word B) Calculator
C) Operating system D) RAM
 
Answer & Explanation Answer: C) Operating system

Explanation:

In a brief, the system software is the interface between the hardware and user applications. System software is a type of computer program that is designed to run a computer’s hardware and application programs.

 

Examples : OS, System utilities, BIOS like mouse, keyboard, hard disc, Device drivers, Assembler,...

Report Error

View Answer Report Error Discuss

4 2751
Q:

Not including the sun, the closest stars to earth are

A) 4300 light-years away B) 430 light-years away
C) 43 light-years away D) 4.3 light-years away
 
Answer & Explanation Answer: D) 4.3 light-years away

Explanation:

The nearest stars to Earth are in the Alpha Centauri triple-star system, about 4.37 light-years away. One of these stars, Proxima Centauri, is slightly closer, at 4.26 light-years.

 

Of all the stars closer than 15 light-years, only two are spectral type G, similar to our sun: Alpha Centauri A and Tau Ceti. The majority are M-type red dwarf stars.

 

Only nine of the stars in this area is bright enough to be seen by the naked human eye from Earth. These brightest stars include Alpha Centauri A and B, Sirius A, Epsilon Eridani, Procyon, 61 Cygni A and B, Epsilon Indi A and Tau Ceti.

Report Error

View Answer Report Error Discuss

2 2749
Q:

What is a stub network?

A) A network with only one entry and no exit point. B) A network that has only one entry and exit point.
C) A network with more than one exit point. D) A network with more than one exit and entry point.
 
Answer & Explanation Answer: B) A network that has only one entry and exit point.

Explanation:

A stub network has only one default path to non-local hosts and no outside network knowledge. Non-local stub network traffic uses a single logical path when traveling in and out of the network.

 

Stub networks are essentially local area networks (LAN) that either do not connect to the outside and relay data packets internally or are dead-end LANs that know of only one network exit. Stub networks may have multiple connections but use one path to single points of destination.

 

Hence, a stub network is a network that has only one entry and exit point.

Report Error

View Answer Report Error Discuss

3 2747
Q:

Copying the logs on the standby/backup server is an operation of Log Shipping

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

Explanation:

It is one of the operation of Log Shipping

Report Error

View Answer Workspace Report Error Discuss

0 2739
Q:

Physical data models describe the details of how data is stored in the computers

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

Explanation:

They describe the details of how data is stored in the computers

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2717
Q:

Switching between portrait and landscape modes involves the

A) print layout view B) Arc map
C) header and footer toolbar D) page setup dialog box
 
Answer & Explanation Answer: D) page setup dialog box

Explanation:

Switching between portrait and landscape modes involves the page setup dialog box.

Report Error

View Answer Report Error Discuss

3 2696