Can You Help Me Answering Some SQL Objective Question ??

Sep 18, 2007

i am unable to solve/answer this question related to sql... anybody ..!!??
[i am reposting my queries.. as before i posted in the wrong forum section.. so pease bear with me... Thanx] 
 Q-1: How would you add a country field to your database to ensure that your Argentinean subsidiary does business only with other Argentinean companies?

a) CHECK constraint
b) PRIMARY KEY constraint
c) FOREIGN KEY constraint
d) DEFAULT constraint

Q-2: You want to set up replication between two databases, so the financial data and the sales data will be the same. You want the data to replicate at 1:00 a.m. every morning. You would like to completely remove all data from the financial database each night and overwrite data from the sales database. Which database replication model would you choose?

a) Transactional replication
b) DTC replication
c) Subscriber replication
d) Snap shot replication
e) Merge replication

Q-3: Your company has 3 offices each of which is responsible for sales in their respective territory. Which of the following actions should you take to ensure a successful merge replication among you three offices?

a) You must include all tables with primary keys that are referenced by the foreign keys in the replicated tables
b) Prior to merge replication, create a unique identifier column in each table that are to be included in the publication
c) Do nothing, DTS will take care of it.
d) Prior to merge, you must create an index in the tables that are to be included in the publication.

Q-4: The SQL server that Michael manages crashed. The disk drives were not damaged but there was data that had not been written to some databases. Which transactions will be rolled forward in each database when his SQL server starts the automatic recovery process?

a) All committed transactions that are in the transaction log between the last checkpoint and the failure
b) All committed transactions that are in the transaction log
c) All committed transactions that are in the transaction log between the last two checkpoints
d) All uncommitted transactions that are in the transaction log

Q-5: What can occur when multiple users try to access the same schema object

 

Thanx in Advance..

View 2 Replies


ADVERTISEMENT

Test Your DB Skills By Answering This

Sep 21, 2006

given below is the sql server 2005 script.what is the oracle equivalent of this.



CREATE TABLE [omx].[UserAuthorization](
[MemberAuthorizationRecordIdentifier] [varchar](50) NOT NULL,
CONSTRAINT [PK_UserAuthorization] PRIMARY KEY CLUSTERED
(
[MemberAuthorizationRecordIdentifier] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Last edited by rajesh438 : Today at 01:01.

View 1 Replies View Related

Multiple Queries For One Objective

Dec 25, 2014

If you have a dozen or so queries related to the same thing such as an exception report do you wrangle with the query to make it a one stop shop or do you do something different? Is it possible to drop them into a SP and have them all execute at the same time?

I am running queries for against business rules and wanted to do it the right way. I don't have a solid mentor at work, two guys who are experienced and off a lot but not in the world of reports.

View 8 Replies View Related

Can The Implementation Of Database Shared File Method To Achieve The Objective Of High Availability?

May 2, 2008

Hi,
can I assign a NAS(Network Attached Storage) server to store the database file(readable and writable) and assign other several MS SQL database servers which will use the same database file in NAS to achieve the objective of high availability?

If it can, how can I set it up in MS SQL Server or it requires another 3rd patry software to set it up?

Thanks.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved