Study Guides and Actual Real Exam Questions For Oracle OCP, MCSE, MCSA, CCNA, CompTIA


Advertise

Submit Braindumps

Forum

Tell A Friend

    Contact Us

 Home

 Search

Latest Brain Dumps

 BrainDump List

 Certifications Dumps

 Microsoft

 CompTIA

 Oracle

  Cisco
  CIW
  Novell
  Linux
  Sun
  Certs Notes
  How-Tos & Practices 
  Free Online Demos
  Free Online Quizzes
  Free Study Guides
  Free Online Sims
  Material Submission
  Test Vouchers
  Users Submissions
  Site Links
  Submit Site

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Online Training Demos and Learning Tutorials for Windows XP, 2000, 2003.

 

 

 

 





Braindumps for "HP0-780" Exam

NonStop Structured Query Language (SQL)

 Question 1.
Which combination of SQLCI commands can be used to capture a row layout for inclusion in a host language program?

A. CAPTURE and SHOW
B. OUTPUT and TABLE LAYOUT
C. LOG and INVOKE
D. SOURCE and INFO TABLE

Answer: C

Question 2.
In which situation can denormalization enhance performance?

A. Subsets of data apply to multiple rows of a table.
B. Many critical tables contain redundant data.
C. The columns of a table are queried equally.
D. Many critical online queries rely upon data from more than one table.

Answer: D

Question 3.
Which tool would you use to analyze a deadlock situation?

A. FUP LISTLOCKS
B. MEASURE ENTITY deadlocks
C. TPDC ANALYZE DEADLOCKS
D. SQLCI LISTLOCKS

Answer: A

Question 4.
A program is found to be executing from the object file $system.object.zzbi2437.

Typically this is the result of a program being compiled to an object file that is still in use. 

What can be implied about the zzbi2437 file?

A. It is the latest version of the object file.
B. It will be used to start new copies of the program.
C. It is a copy of the new object file.
D. It is the previous version of the object file.

Answer: D

Question 5.
Alternate index access is chosen by the optimizer. The index is not available at runtime.

What happens?

A. Query execution fails.
B. Automatic recompilation is launched.
C. The query executes successfully because the query execution plan (QEP) is available.
D. AUTORECOMPILE fails if SIMILARITYCHECK is not enabled.

Answer: B

Question 6.
DDL and DML operations on tables or indexes that have large numbers of partitions might return Error 31 or 34 due to insufficient memory in the process file segment (PFS) used by the SQL file system. 

Which utility can be used to increase the PFS space?

A. COBOL85
B. SQLCI
C. BINDER
D. SQLCOMP

Answer: C

Question 7.
The exhibit shows the Employee and Department Tables. 

Which field in the Employee Table is a foreign key?

 

A. dept_number
B. location
C. first_name
D. employee_number

Answer: A

Question 8.
Which verb ensures that the host variables match the SQL table definition?

A. INCLUDE
B. SOURCE
C. INVOKE
D. DECLARE

Answer: C

Question 9.
Which SQL object alters the standard ASCII sort order?

A. constraint
B. collation
C. view
D. index

Answer: B

Question 10.
Which NonStop SQL component is used to form an executable query plan?

A. update statistics
B. sqlcomp
C. sqlci2
D. sqlcat

Answer: B

Question 11.
Tandem Reload Analyzer (TRA) can be used to determine if files or tables would benefit from being reloaded. 

For which file or table organization can TRA be used?

A. key-sequenced
B. entry-sequenced
C. relative
D. any structured type

Answer: A

Question 12.
Click the Exhibit button. The exhibit shows an incomplete table creation statement.

Which PARTITION clause is valid to complete the statement?

 

A. $b.b.mytable FIRST KEY ( "97", "91BRUT00", "0", DATE "2000-01-01")
B. $b.b.mytable FIRST KEY ( 97, "91BRUT00", "0", DATE "2000-01-01")
C. $b.b.mytable FIRST KEY ( 97, "91BRUT00", "0", "2000-01-01")
D. $b.b.mytable FIRST KEY ( 97, "91BRUT00", 0, DATE "2000-01-01")

Answer: B

Question 13.
What are the different NUMERIC SQL data types?

A. float, real, double precision
B. smallint, largeint, integer
C. date, largeint, integer
D. datetime, smallint, integer

Answer: B

Question 14.
The "CONTROL TABLE RETURN or WAIT " directive controls row access in which access options? Select TWO.

A. browse
B. repeatable
C. exclusive
D. stable
E. shared

Answer: B, D

Question 15.
When a SQL statement uses the BROWSE ACCESS clause_______, .

A. the statement implicitly locks rows that the statement accesses in SHARED mode
B. the statement accesses all rows required for validating the predicates
C. the statement accesses all rows except those that are locked in EXCLUSIVE mode
D. the statement only accesses a consistent view of the database

Answer: B

Question 16.
The SQL catalog version number is used to______ .

A. identify the latest version of SQL objects that can be registered
B. determine the release version of the NonStop operating system installed
C. provide version control for all system components on a node
D. force the optimizer to choose a new access strategy for new SQL objects

Answer: A

Question 17.
Which action can be performed on partitions independently of the other partitions?

A. move partition boundaries
B. drop empty partition
C. change the AUDIT flag
D. allocate or de allocate extents

Answer: D

Question 18.
Click on the Exhibit button to show an INVOKE of the table CUSTOMER and a partial FILEINFO of the same table. 

The SQL statement 'UPDATE SALES.CUSTOMER SET CREDIT = "A1" WHERE CUSTNUM IN (21, 3333, 324)'_______ .

 

A. updates at most three rows depending on the data content of CUSTOMER
B. updates no rows because the primary key cannot be updated
C. never updates any rows because CUSTNUM is alphabetic not NUMERIC
D. always updates three rows

Answer: A

Question 19.
The "EXEC SQL INCLUDE STRUCTURES SQLCA VERSION 2 SQLSA VERSION CURRENT" statement includes________ .

A. Version 2 of the SQLCA structure and a version equal to or greater than 330 of the SQLSA  
    structure
B. Version 2 of the SQLCA structure and the previous version of the SQLSA structure
C. Version 315 of the SQLSA structure
D. Version 2 of the SQLDA structure

Answer: A

Question 20.
Which utilities provide performance information about SQL statements? Select TWO.

A. ViewSys
B. Measure
C. SQLCI
D. PEEK
E. OMF

Answer: B, C


Google
 
Web www.certsbraindumps.com


Braindumps: Dumps for 70-526 Exam Brain Dump

Study Guides and Actual Real Exam Questions For Oracle OCP, MCSE, MCSA, CCNA, CompTIA


Advertise

Submit Braindumps

Forum

Tell A Friend

    Contact Us





Braindumps for "70-526" Exam

TS: Microsoft .NET Framework 2.0 - Windows-Based Client Development

 Question 1.
You are working as an application developer at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. ITCertKeys.com uses Visual Studio 2005 as an application platform. ITCertKeys.com consists of a Development department. You as the developer of ITCertKeys.com use a client computer named ITCERTKEYS-WS002 as developing collateral. You have received instructions to make sure that the PictureBox control's properties cannot be changed with a logo that you have added to the PictureBox in the designer of the form base. Before the time you have added a form to the Microsoft Windows Forms Control Library project and add a PictureBox control to the form. The form is presenting CertKiller.com's logo.

What action should you take?

A. You should set the Locked property to False.
B. You should set the Locked property to True.
C. You should set the Modifiers property to Private.
D. You should set the Modifiers property to Protected.

Answer: C

Explanation: 
When you set the Modifiers property to Private, the value will show that only the base form can modify the control.

Incorrect Answers:
A: You should not set it to False, because the control can be moved and resized.
B: If you set the property to True the control cannot be removed of resized. .
D: If you set the Modifiers property to Protected, the value will show that the base form and any of the form yet to come can modify the control.

Question 2.
You are working as an application developer at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. ITCertKeys.com uses Visual Studio 2005 as an application platform. ITCertKeys.com consists of a Development department. You as the developer of ITCertKeys.com use a client computer named ITCERTKEYS-WS005 as developing collateral. You have just included a DateTimePicker control to a form. You then set the format property to Time. During the cause of the day, you check how the DateTimePicker control is working, and learnt that it does not allow the ITCertKeys.com users to change the selected time.

What should you do to change the control so that it will allow the ITCertKeys.com uses to change the selected time?

A. You should set the ShowUpDown property to True.
B. You should set the ShowSelectBox property to True.
C. You should set the Visible property to False.
D. You should set the Checked property to False.

Answer: A

Explanation: 
The ShowUpDown property is by default set on False. You should set it on True. On False it will show the DateTimePicker must simulate a drop-down control. This setting will allow the users to set the MonthCalender. If it is set to True the users can select the time.

Incorrect Answers:
B: The ShowSelectBox will not resolve the problem. This will show if a CheckBox should be displayed on the DateTimePicker.
C: If you set the Visible property to False, it will hide the DateTimePicker. .
D: You should not set the Checked property to False. If this is set on True, a CheckBox control will be displayed on the DateTimePicker.

Question 3.
You are working as an application developer at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. ITCertKeys.com uses Visual Studio 2005 as an application platform. ITCertKeys.com consists of a Development department. You as the developer of ITCertKeys.com use a client computer named ITCERTKEYS-WS002 as developing collateral. The manager of ITCertKeys.com wants to have a borderless form with the background shown in the exhibit.
 

When the form is view, the manager named Rory Allen does not want the maroon area to be visible. He only wants the blue to be visible when the form is displayed. 

Which of the following code segments should be used?

A. this.TransparencyKey = Color.Maroon;
B. this.BackColor = Color.Maroon;
C. this.TransparencyKey = Color.CornflowerBlue
D. this.BackColor = Color.Transparent;

Answer: A

Explanation: 
The TransparencyKey = Color.Maroon specify the color that the transparent represents the area on the form. With this setting the blue will respond to the mouse.

Incorrect Answers:
B: You should not use the BackColor = Color.Maroon. This will determine the background color of the form.
C: You should not use this code segment. The manager does not wan the blue area to be transparent.
D: You should not use the BackColor = Color.Transparent. The manager does not want the background to be transparent.

Question 4.
You are working as an application developer at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. ITCertKeys.com uses Visual Studio 2005 as an application platform. ITCertKeys.com consists of a Development department. You as the developer of ITCertKeys.com use a client computer named ITCERTKEYS-WS020 as developing collateral. You have configured three columns to a form and add a TableLayoutPanel to the form. You want the two side columns to have a fix width of 200 pixels each and anchor the four edges of the form to the control. A ITCertKeys.com manager wants the center column to fill the remaining space, when ever the form is resized. You need to change the ColumnStyle instance that represents the center column? 

How should you set the ColumnStyle instance's Size Type property?

A. Set it to AutoSize and the Width property to 100F.
B. Set it to Absolute and the Width property to 100F.
C. Set it to Percent and the Width property to 100F.
D. Set it to AutoSize and the Width property to 0F.

Answer: C

Explanation: 
This setting will show that the column should fill the remaining space.

Incorrect Answers:
A: This setting will allow the column to be sized enough so that not any of its child controls are clipped. In this setting the middle will not occupy the remaining free space. 
B: If you set it to Absolute, the value of the Width property will show the number of pixels for the column.
D: You need to set the ColumnStyle instance's Size Type property to AutoSize and the Width property to 100F.

Question 5.
You are working as an application developer at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. ITCertKeys.com uses Visual Studio 2005 as an application platform. ITCertKeys.com consists of a Development department. You as the developer of ITCertKeys.com use a client computer named ITCERTKEYS-WS020 as developing collateral. You have added a SplitContainer control named ITCertKeysSplitContainer to a form. You then left the control to the default properties. To the right-most container of the SplitContainer control, you need to add a PropertyGrid.

Which of the following code segments should you use?

A. PropertyGrid propertyGrid = new PropertyGrid[];
    Panel rightPanel = [Panel] ITCertKeysSplitContainer.GetContainerControl[];
    rightPanel.ControlAdd[porpertyGrid];
B. PropertyGrid propertyGrid = new PropertyGrid[];
    Panel rightPanel = [Panel] ITCertKeysSplitContainer.GetNextControl[propertyGrid, true];
    rightPanel.ControlAdd[porpertyGrid];
C. PropertyGrid propertyGrid = new PropertyGrid[];
    ITCertKeysSplitContainer.Container.Add[propertyGrid, "RightPanel"];
D. PropertyGrid propertyGrid = new PropertyGrid[];
    ITCertKeysSplitContainer.Panel2.Control.Add[propertyGrid];

Answer: D

Explanation: 
An area can be divided into two containers, which is separated by a movable bar, if you use the SplitContainer control. When the two Panels are created, the left one is the Panel1 and the right is Panel2. You are adding a panel so it will be on the right. You then need to specify Panel2.

Incorrect Answers:
A, B, C: You should not use the Add method of the SplitContainer.Container to add the PropertyGrid. You also should not pass a PropertyGrid instance to the GetNextControl method to return a Panel instance. This will actually retrieve the next tab-ordered control given the current control. You also should not call the GetContainerControl method to return a Panel instance. This will return the logical container of the SplitContainer control.

Question 6.
You are working as an application developer at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. ITCertKeys.com uses Visual Studio 2005 as an application platform. ITCertKeys.com consists of a Development department. You as the developer of ITCertKeys.com use a client computer named ITCERTKEYS-WS020 as developing collateral. You are busy to develop a Microsoft Windows Forms exam delivery application. This is going to be used to access the content of the exam via the Internet. A WebBrowser named testbrowser is added to the control to a form named ITCertKeysForm, which is define as follows:
[PermissionSet[SecurityAction.Demand, Name="FullTrust"]]
[System.Runtime.InteropServices.ComVisible[true]]
public ITCertKeysForm : Form
{
public ITCertKeysForm[]
{
InitializeComponent[];
}
public void Expire[]
{
}
}
The JavaScript-based timer that is used by the Web site for the exam has a function to inform the exam delivery application when the time has expired for the exam, which is the following:
window.external.Expire[];

What should you do to make sure that the Expire method of ITCertKeysForm is called when the JavaScrip function is carry out? 

A. You should set the Document.DomDocument property of the browser instance to the current 
    instance of the ITCertKeysForm class.
B. You should set the ObjectForScripting property of the browser instance to the current instance 
    of the ITCertKeysForm class.
C. You should call the AttachEventHandler of the Document property of the browser instance.
D. You should call the ExecCommand method of the Document property of the browser instance.

Answer: B

Explanation: 
You must set the ObjectForScripting for the browser instance to the current instance of the ITCertKeysForm class.

Incorrect Answers:
A: The property of the Document.DomDocument represents the true DOM object of an HTML document.
C: The AttachEventHandler allows you to attach a HTML Document Object Model event to an event handler.
D: The ExecCommand method allows you to execute commands against DOM documents.

Question 7.
You are working as an application developer at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. ITCertKeys.com uses Visual Studio 2005 as an application platform. ITCertKeys.com consists of a Development department. You as the developer of ITCertKeys.com use a client computer named ITCERTKEYS-WS003 as developing collateral. You have received instructions to make sure that the PictureBox will display dynamically loaded images.

Which property will display a static image if any dynamic image fails to load?

A. BackgroundImage
B. Image
C. ErrorImage
D. InitailImage

Answer: C

Explanation: 
The ErrorImage property specifies the image that should be displayed. This will happened only if the image that you are trying to load dynamically fails.

Incorrect Answers:
A: The BackgroundImage property specifies a background image which is used by the control.
B: The Image property specifies the image you want the PictureBox control to display.
D: The InitailImage specifies the image you want the PictureBox control to display while the other one is loading.

Question 8.
You are working as an application developer at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. ITCertKeys.com uses Visual Studio 2005 as an application platform. ITCertKeys.com consists of a Development department. You as the developer of ITCertKeys.com use a client computer named ITCERTKEYS-WS020 as developing collateral. You are developing a Web service for new updates to query automatically, by use of a Microsoft Windows Forms application. You then add a NotifyIcon component named ITCertKeysnotify to the application's main form. Whenever a new update is available you want the following balloon tip to display as seen in the exhibit for 5 seconds.
 

Which segment should you use to write a code to download the updates if the users click the balloon tip?

A. ITCertKeysnotify.BallonTipClick +=delegate
{
// Download the updates
}
ITCertKeysnotify.ShowBallonTip[5000, "New Update Available"; "Click here to download"
, ToolTipIcon.Info];
B. ITCertKeysnotify.ShowBallonTip[5];
   ITCertKeysnotify.BalloonTipIcon = ToolTipIcon.Info;
ITCertKeys.Balloon TipTitle = "New Update Available";
ITCertKeys.BalloonTipText = "Click here to download";
ITCertKeys.Click += delegate
{
// Download the updates
}
C. ITCertKeysnotify.BalloonTipIcon = ToolTipIcon.Info;
   ITCertKeys.Balloon TipTitle = "New Update Available";
ITCertKeys.BalloonTipText = "Click here to download";
ITCertKeys.Click += delegate
{
// Download the updates
}
ITCertKeysnotify.ShowBallonTip[5000];
D. ITCertKeysnotify.ShowBallonTip[5, New Update Available", "Click here to download",
   ToolTipIcon.Info];
ITCertKeys.BalloonTipClick += delegate
{
// Download the updates
}

Answer: A

Explanation: 
You should use an event handler, attach the BalloonTipClicked to the event and call the ShowBalloon Tip method of the NotifyIcon class. When a user clicks a balloon tip, a BalloonTipClicked event is raised.

Incorrect Answers:
B, C, D: You should not attach the BalloonTipClicked even to an event handler after you have called the ShowBalloonTip method. Also note that the event is raised when the icon is clicked and not the balloon tip.

Question 9.
You are working as an application developer at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. ITCertKeys.com uses Visual Studio 2005 as an application platform. ITCertKeys.com consists of a Development department. You as the developer of ITCertKeys.com use a client computer named ITCERTKEYS-WS020 as developing collateral. You are busy adding a MenuStrip control, which has an instance of a ToolStripMenu item named testjobItem, to a form in a Microsoft Windows Forms application. This item's display text is Job. You have received instructions to add two menu items to the Job menu item. The first item's display text should be Create New Job, and the second one is Run Job.

Which code segment should you use to programmatically add the two menu items?

A. ToolStripMenuItem createNewJobItem = new ToolStripMenuItem["Create New Job"];
ToolStripMenuItem runJobItem = new ToolStripMenuItem["Run Job"];
jobItem.Container.Add[createNewJobItem];
jobItem.Container.Add[runJobItem];
B. ToolStripMenuItem createNewJobItem = new ToolStripMenuItem["Create New Job"];
ToolStripMenuItem runJobItem = new ToolStripMenuItem["Run Job"];
jobItem.Owner.Items.Add[createNewJobItem];
jobItem.Owner.Items.Add[runJobItem];
C. ToolStripMenuItem createNewJobItem = new ToolStripMenuItem["Create New Job"];
ToolStripMenuItem runJobItem = new ToolStripMenuItem["Run Job"];
ToolStripMenuItem[] items = new ToolStripMenuItem[]{create NewJobItem,
runJobItem}
jobItem.DropDownItems.AddRange[items];
D. ToolStripMenuItem createNewJobItem = new ToolStripMenuItem["Create New Job"];
ToolStripMenuItem runJobItem = new ToolStripMenuItem["Run Job"];
ToolStripMenuItem[] items = new ToolStripMenuItem[]{create NewJobItem,
runJobItem}
jobItem.Owner.Items.AddRange[items];

Answer: C

Explanation: 
For the jobItem instance you should call the AddRange. The property of the DropDownItems represents a collection of child items of the jobItem instance, which allows you to add the two items to the job menu item.

Incorrect Answers:
A: This property returns an instance of IContainer, which represents a logical container for other components.
B: The Owner property returns the Menu script instance that owns the ToolStripMenuItem instance.
D: This action will add the two new menu at the same level as the Job menu item.

Question 10.
You are working as an application developer at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. ITCertKeys.com uses Visual Studio 2005 as an application platform. ITCertKeys.com consists of a Development department. You as the developer of ITCertKeys.com use a client computer named ITCERTKEYS-WS050 as developing collateral. You were busy with a task to add a ContextMenuStrip control to a form.

What should you do to display a custom control as a menu item of the ContextMenuStrip control?

A. Add a ToolstripContainer control to the form and add the custom control to the Controls 
    collection residing on the toolStripContainer control. You should then add the ContextMeniStrip 
    control to the controls of the ToolStripContainer control.
B. Of ToolStripControlHost, create an instance and specify your custom control instance as a 
    parameter to the conductor. You should then the ToolStripControlHost instance to the Items 
    collection of the ContextMeniStrip control.
C. Add a ToolstripContainer control to the form and add the custom control to the Controls 
    collection residing on the toolStripContainer control. You should then add the 
    ToolstripContainer control to the controls of the ContextMeniStrip controls.
D. Of ToolStripControlHost, create an instance and specify your custom control instance as a 
    parameter to the conductor. You should then the ContextMeniStrip controls to the collection of 
    the ToolStripControlHost instance.

Answer: B

Explanation: 
The ToolStripControlHost class to host a custom control as a menu item in the ContextMeniStrip. You should also the custom control instance as the parameter to the constructor.

Incorrect Answers:
A, C, D: The ToolstripContainer should not be used to reach your goal. Furthermore, you cannot host a ToolstripContainer control as the menu item in a ContextMeniStrip controls.



Google
 
Web www.certsbraindumps.com


Study Guides and Real Exam Questions For Oracle OCP, MCSE, MCSA, CCNA, CompTIA





              Privacy Policy                   Disclaimer                    Feedback                    Term & Conditions

www.helpline4IT.com

ITCertKeys.com

Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.