Sawaal
  • Home/
  • Searching for US

 Searching for "US"

Q:

Explain Given the following SQL statement: GRANT REFERENCES ON TABLE tab1 TO USER usera.Which of the following describes what USERA is allowed to do?

A) Create a read?only view using TAB1. B) Alter TAB1 to add a check constraint.
C) Define a primary key or unique constraint on TAB1. D) Define a dependent table where TAB1 is the parent.
 
Answer & Explanation Answer: D) Define a dependent table where TAB1 is the parent.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

You are working with a previously saved document and you have deleted a logical operator. Which two methods can you use to recover the logical operator?

A. Click the Undo button in the Query panel.

B. Rebuild the filters.

C. Close the Query panel without executing and then open the query

D. From the Tools menu, select Recover Operator.

Answer

Answer : B , C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Which two operators are available when using wildcards in a query filter? (Choose two.)

A. Matches Pattern

B.  LIKE

C. Different from Pattern

D. Not equals Pattern

Answer

Answer : A , C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Which message appears when you select Use query drill while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report?

A. The Scope of Analysis is empty

B. The query drill mode option is enabled

C. The query drill mode option is not enabled

D. The Scope of Analysis is not empty

Answer

Answer : D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Which tab should you use to change the page orientation of a report?

A. Select the report tab; in Report Manager, select the Properties tab and select the Page Orientation

B. Click File Page Setup and select Page Orientation

C. In InfoView Preferences, change the default page orientation

D. Select the report page; in Report Manager, select the Properties tab and select the Page Orientation

Answer

Answer : D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)?

A. Dimension - Measure

B. Dimension - Detail

C. Measure - Measure

D. Dimension - Dimension

Answer

Answer : D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Which method should you use to group query filters together to form one AND statement?

A. Select the filters, then click the Group Filters button on the toolbar

B. Select the filters, right-click and select Group

C. Drag the queries together

D. Drag the query filters to the Group panel

Answer

Answer : C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Can Queries be used after changes are made to the InfoProvider?

A. Maybe

B. No

C. Yes

Answer

Answer : C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW