i Search

Q:

What is Log Shipping?

Answer

Log shipping defines the process for automatically taking backup of the database and transaction files on a SQL Server and then restoring them on a standby/backup server. This keeps the two SQL Server instances in sync with each other. In case production server fails, users simply need to be pointed to the standby/backup server. Log shipping primarily consists of 3 operations:

Backup transaction logs of the Production server.

Copy these logs on the standby/backup server.

Restore the log on standby/backup server.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

If the truediscount on a sum due 2yrs hence at 14% per annum be Rs168. The sum due is?

A) 700	B) 760
C) 768	D) 786

Answer & Explanation Answer: C) 768

Explanation:

P.W = (100 x T.D)/(R x T) = (100 x 168)/(14 x 2)= 600

Sum = (P.W + T.D) = Rs. (600+ 168) = Rs.768.

Report Error

View Answer Report Error Discuss

Filed Under: True Discount

Q:

The Present worth of Rs.2310 due $2 \frac{1}{2}$ years hence ,the rate of interest being 15% per annum, is :

A) Rs.1440	B) Rs.1750
C) Rs.1680	D) Rs.1840

Answer & Explanation Answer: C) Rs.1680

Explanation:

$P . W = R s . (\frac{100 \times 2310}{100 + (15 \times \frac{5}{2})})$ = Rs.1680

Report Error

View Answer Report Error Discuss

Filed Under: True Discount

Q:

Go command is a signal to execute the entire batch of SQL statements after previous Go

A) TRUE

B) FALSE

Answer & Explanation Answer: A) TRUE

Explanation:

Workspace

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

The difference between Simple Interest and True Discount on a certain sum of money for 6 months at $12 \frac{1}{2}$ % per annum is Rs 25. Find the sum.

A) Rs.6800	B) Rs.6500
C) Rs.6000	D) Rs.6200

Answer & Explanation Answer: A) Rs.6800

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: True Discount

Q:

Explain Data Control Language

Answer

Data Control Language (DCL):-statements to take care of the security and authorization.

Examples:

GRANT

REVOKE

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

Explain Data Definition Language

Answer

Data Definition Language (DDL):- are the SQL statements that define the database structure.

Example:

CREATE

ALTER

DROP

TRUNCATE

COMMENT

RENAME

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

What is XPath?

Answer

XPath is an expressions to select a xml node in an XML document.

It allows the navigation on the XML document to the straight to the element where we need to reach and access the attributes.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Searching for "i"

Quick Links