Database Administration Questions


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 2903
Q:

A restrictive clause is one that

A) usually occurs at the beginning of a sentence B) should be set off by commas
C) limits the meaning of the word it describes D) functions as an adverb
 
Answer & Explanation Answer: C) limits the meaning of the word it describes

Explanation:

A restrictive clause is one that limits the meaning of the word it describes.

For example :: 

The girl who lives next door is beautiful.

This restrictive clause limits "the girl" to say it's specifically the one next door.

Report Error

View Answer Report Error Discuss

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

1 2900
Q:

Database is a collection of concepts that can be used to describe the structure of a database

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

Explanation:

Database provides necessary means to achieve this abstraction. By structure of a database we mean the data types, relations, and constraints that should hold on the data.

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2900
Q:

The process of collecting, organizing and analyzing data is called

A) Statistics B) Data collection
C) Probability D) Systematic evaluation
 
Answer & Explanation Answer: A) Statistics

Explanation:

The process of collecting, organizing and analyzing data is called Statistics.

Report Error

View Answer Report Error Discuss

0 2899
Q:

How many black cards are in a deck?

A) 13 B) 26
C) 39 D) 52
 
Answer & Explanation Answer: B) 26

Explanation:

The total cards in the deck are 52. These 52 cards are divided into 4 suits of 13 cards in each suit. Two Red suits and Two black suits.

Red suits :: Heart suit and Diamond suit = 26

Black suits :: Spade suit and Club suit = 26.

Report Error

View Answer Report Error Discuss

0 2899
Q:

What is the primary purpose of most constitutions?

A) to provide a substitute for government B) to define and limit government power
C) to give the government absolute power D) to define a moral code for people to follow
 
Answer & Explanation Answer: B) to define and limit government power

Explanation:

There are many reasons why a constitution is needed. One of the primary purposes is to define and limit power of the government.

It gives the structures for the functioning of the country such as courts and parliament and limits the power.

e.g. to imprison without trial for the government.

Report Error

View Answer Report Error Discuss

4 2895
Q:

What is the difference between oracle,sql and sql server?

Answer

  • Oracle is based on RDBMS.

  • SQL is Structured Query Language.

  • SQL Server is another tool for RDBMS provided by MicroSoft


 

Report Error

View answer Workspace Report Error Discuss

2 2892
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 2888