Get Instant Access to CIW 1D0-425 Exam and 1,200+ More

In a relational database, the modeling of a One to one relationship is possible with a minimum of how many tables?

Answers:
A. one (correct)
B. two
C. three
D. two per relationship
E. one per direction of each relationship

In a LIKE predicate, what character is used to match zero or more of any character?

Answers:
A. % (correct)
B. &
C. *
D. !
E. @
F. ^
G. _

Explanation:
In a LIKE predicate, the percent character (%. matches zero or more
of any character and the underscore character (_. matches any one character. The
percent and underscore characters can be used as literals in a LIKE predicate by
preceding them with an escape character.

When evaluating a DBMS, in terms of development tools which of the following will you consider, as recommended by CIW (Choose all that apply.?

Answers:
A. availability of fourth generation language tools (correct)
B. availability of case tool (correct)
C. availability of fifth generation language tools (correct)
D. availability of OO method
E. availability of XML support

Explanation:
According to webopedia.com DBMS - A collection of programs that
enables you to store, modify, and extract information from a database. There are
many different types of DBMSs, ranging from small systems that run on personal
computers to huge systems that run on mainframes. The following are examples of

- database applications
- computerized library systems
- automated teller machines
- flight reservation systems

computerized parts inventory systems
From a technical standpoint, DBMSs can differ widely. The terms relational, network,
flat, and hierarchical all refer to the way a DBMS organizes information internally. The
internal organization can affect how quickly and flexibly you can extract information.
Requests for information from a database are made in the form of a query, which is a
stylized question. For example, the query
SELECT ALL WHERE NAME = "SMITH" AND AGE > 35
requests all records in which the NAME field is SMITH and the AGE field is greater than
35. The set of rules for constructing queries is known as a query language. Different
DBMSs support different query languages, although there is a semi-standardized query
language called SQL (structured query language.. Sophisticated languages for managing
database systems are called fourth-generation languages, or 4GLs for short.
The information from a database can be presented in a variety of formats. Most DBMSs
include a report writer program that enables you to output data in the form of a report.
Many DBMSs also include a graphics component that enables you to output information
in the form of graphs and charts.

When evaluating a DBMS, in terms of GUI which of the following will you consider, as recommended by CIW (Choose all that apply.?

Answers:
A. Descriptive page titles (correct)
B. Clear instructions (correct)
C. Consistent grouping of input fields (correct)
D. Logical labelled field (correct)
E. Consistent color use (correct)

Explanation:
According to webopedia.com GUI - A program interface that takes
advantage of the computer's graphics capabilities to make the program easier to
use. Well-designed graphical user interfaces can free the user from learning
complex command languages. On the other hand, many users find that they work
more effectively with a command-driven interface, especially if they already know
the command language.
Graphical user interfaces, such as Microsoft Windows and the one used by the Apple
Macintosh, feature the following basic components
pointer A symbol that appears on the display screen and that you move to select objects
and commands. Usually, the pointer appears as a small angled arrow. Text -processing
applications, however, use an I-beam pointer that is shaped like a capital I.
pointing device A device, such as a mouse or trackball, that enables you to select
objects on the display screen.
icons Small pictures that represent commands, files, or windows. By moving the pointer
to the icon and pressing a mouse button, you can execute a command or convert the icon
into a window. You can also move the icons around the display screen as if they were
real objects on your desk.
desktop The area on the display screen where icons are grouped is often referred to as
the desktop because the icons are intended to represent real objects on a real desktop.
windows You can divide the screen into different areas. In each window, you can run a
different program or display a different file. You can move windows around the display
screen, and change their shape and size at will.
menus Most graphical user interfaces let you execute commands by selecting a choice
from a menu.

In a RDBMS, what is the fundamental concept of placing relations into 2nd Nomral Form?

Answers:
A. Functional dependency (correct)
B. Indexed relations
C. Vertical dependency
D. Horizontal dependency
E. None of the above.

Explanation:
According to webopedia.com There are three main normal forms,
each with increasing levels of normalization
First Normal Form (1NF. Each field in a table contains different information. For
example, in an employee list, each table would contain only one birthdate field.
Second Normal Form (2NF. No field values can be derived from another field. For
example, if a table already included a birthdate field, it could not also include a birth year
field, since this information would be redundant.
Third Normal Form (3NF. No duplicate information is permitted. So, for example, if two
tables both require a birthdate field, the birthdate information would be separated into a
separate table, and the two other tables would then access the birthdate information via
an index field in the birthdate table. Any change to a birthdate would automatically be
reflect in all tables that link to the birthdate table.

In the context of the E.tiered (or n-tiered) distributed architectures, scalability refers to which of the following?

Answers:
A. Additional functionality can be added to applications without affecting current functionality.
B. Multiple users can be authenticated simultaneously, allowing centralized security measures to be enforced.
C. Increased server resources can be added without affecting existing server applications. (correct)
D. Sensitive data is protected as it is held in the third tier.

Which statement is true regarding the ejb Load () method when invoked for an entity bean that is not linked with an EJB object?

Answers:
A. When the ejb Load () method is called for BMP entity beans, the remote object notifies the bean instance that its fields have been filled with data. For CMP entity beans, the bean is notified to fill its fields with data.
B. When the ejb Load () method is called for BMP entity beans, the remote object notifies the bean instance to fill its fields with data. For CMP entity beans, the bean is notified that its fields have been filled with data.
C. When the ejb Load () method is called for BMP entity beans, the home object notifies the bean instance to fill its fields with data. For CMP entity beans, the bean is notified that its fields have been filled with data. (correct)
D. When the ejb Load () method is called for BMP entity beans, the home object notifies the bean instance that its fields have been filled with data. For CMP entity beans, the bean is notified to fill its fields with data.

Which choice correctly describes the functionality of the begin() method of the User Transaction interface?

Answers:
A. The begin() method suspends any current transaction of the current thread, and starts a new transaction.
B. The begin() method checks to see if a transaction is associated with the current thread. If there is no transaction, a new transaction is started.
C. The begin() method associates a transaction with an existing transaction.
D. The begin() method starts a new transaction for the current thread. (correct)

Consider the following IDL definition: Struct address { string streets; string city; string state; string zip; }; interface Employee { Address method A (); void methodB (in Address a); void methodC (out Address a); void methodD ( inout Address a); }; Which statements correctly describe this IDL definition?

Answers:
A. Calling methodB will require the use of a holder class.
B. Calling methodC will require the use of a holder class.
C. Calling methodA will require the use of a holder class.
D. Calling methodD will require the use of a holder class.