Sawaal
  • Home/
  • Searching for ip

 Searching for "ip"

Q:

 When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?

A) Disjoint with total specialization B) Disjoint with partial specialization
C) Overlap with total specialization D) Overlap with partial specialization
 
Answer & Explanation Answer: C) Overlap with total specialization

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

Which of the following indicates the maximum number of entities that can be involved in a relationship?

A) Minimum cardinality B) Maximum cardinality
C) ERD D) Greater Entity Count (GEC)
 
Answer & Explanation Answer: B) Maximum cardinality

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 In the relational model, relationships between relations or tables are created by using:

A) composite keys. B) determinants.
C) candidate keys. D) foreign keys.
 
Answer & Explanation Answer: D) foreign keys.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

You recently been promoted to Network Administrator for DLM Shipping. When you took over this position the first thing you notice is this Windows 2000 environment using DNS naming convention, root domain is DIM.COM, with numerous child domains. User accounts are stored in the child domains. However your supervisor informs you that root domain is misspelled and should be DLM.COM. He explains this is causing tremendous problems with the users and customers. He wants you to rename the domain. What will happen if you rename this root domain server?

A) When you rename the root domain server you will only have to rebuild the user accounts since the root domain holds the authentication (SAM) database. B) When you rename the root domain server you will simply rename the child domain also.
C) When you rename the root domain server you will lose the entire network orphaning the child domains. D) When you rename the root domain server you will not need to do anything else since domain names are inherited the child domains will acquire the new domain name.
 
Answer & Explanation Answer: C) When you rename the root domain server you will lose the entire network orphaning the child domains.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

Q:

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database has a Parts table that has a field named InStock.When parts are shipped, a table named PartsShipped is updated. When parts are received, a table named PartsReceived is updated. The relationship of these tables is shown in the exhibit. (Click the Exhibit button.)

You want the database to update the InStock field automatically. What should you do?

A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table. B) Use a view that creates anInStock field as part of an aggregate query.
C) Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock field in the Parts table. Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables. D) Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
 
Answer & Explanation Answer: A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.

Explanation:

Triggers are a special class of stored procedure defined to fire automatically when an UPDATE, INSERT, or DELETE statement is issued against a table or view. They are powerful tools that can be used to enforce business rules automatically when data is modified. Triggers can extend the integrity checking logic of SQL Server constraints, defaults, and rules, although constraints and defaults should be used instead whenever they provide all the needed functionality. In this scenario an AFTER UPDATE trigger can be used to update the tables to update the PartsShipped and the PartsReceived tables that update the InStock column in the parts table.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

Q:

You use Microsoft Visual Studio 2010 and Microsoft ADO.NET Framework 4 to create an application. The application connects to a Microsoft SQL Server 2008 database. You use the ADO.NET LINQ to SQL model to retrieve data from the database. You use stored procedures to return multiple result sets. You need to ensure that the result sets are returned as strongly typed values. What should you do?

A) Apply the FunctionAttribute and ResultTypeAttribute to the stored procedure function. Use the GetResult B) Apply the FunctionAttribute and ParameterAttribute to the stored procedure function and directly access the strongly typed object from the results collection.
C) Apply the ResultTypeAttribute to the stored procedure function and directly access the strongly typed object from the results collection. D) Apply the ParameterAttribute to the stored procedure function. Use the GetResult
 
Answer & Explanation Answer: A) Apply the FunctionAttribute and ResultTypeAttribute to the stored procedure function. Use the GetResult

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSD-Microsoft Certified Solutions Developer

Q:

Which of the following tools is used to create subscription sets and add subscription?set members to subscription sets?

A) Journal B) License Center
C) Replication Center D) Development Center
 
Answer & Explanation Answer: C) Replication Center

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

When can we have a Line Item Dimension?

A. When we have less number of Characteristics in a Dimension

B. When we have a Single Characteristic in a Dimension

C. When we have multiple Line Items

Answer

Answer : B

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW