What type of join is needed when you wish to include rows that do not have matching values?
Equi-join
Natural join
Outer join
All of the above.
3
``````````````````````````````````````````````````````````````````````````````````````````````````````
What type of join is needed when you wish to return rows that do have matching values?
Equi-join
Natural join
Outer join
All of the above.
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is true concerning a procedure?
You do not create them with SQL.
They do not need to have a unique name.
They include procedural and SQL statements.
They are the same thing as a function.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is one of the basic approaches for joining tables?
Subqueries
Union Join
Natural join
All of the above
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is true concerning systems information in an RDBMS?
RDBMS store database definition information in system-created tables.
This information can be accessed using SQL.
This information often cannot be updated by a user.
All of the above.
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Embedded SQL is which of the following?
Hard-coded SQL statements in a program language such as Java.
The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a procedure.
Hard-coded SQL statements in a trigger.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
A UNION query is which of the following?
Combines the output from no more than two queries and must include the same number of columns. Combines the output from no more than two queries and does not include the same number of columns. Combines the output from multiple queries and must include the same number of columns.
Combines the output from multiple queries and does not include the same number of columns.
3
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following statements is true concerning subqueries?
Involves the use of an inner and outer query.
Cannot return the same result as a query that is not a subquery.
Does not start with the word SELECT.
All of the above.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is a correlated subquery?
Uses the result of an inner query to determine the processing of an outer query.
Uses the result of an outer query to determine the processing of an inner query.
Uses the result of an inner query to determine the processing of an inner query.
Uses the result of an outer query to determine the processing of an outer query.
2
``````````````````````````````````````````````````````````````````````````````````````````````````````
How many tables may be included with a join?
one
two
three
all
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is true concerning triggers?
You do not create them with SQL.
They execute against only some applications that access a database.
They have an event, condition, and action.
They cannot cascade (cause another trigger to fire).
3
``````````````````````````````````````````````````````````````````````````````````````````````````````
The fact that the same operation may apply to two or more classes is called what?
Inheritance
Polymorphism
Encapsulation
Multiple classification
2
``````````````````````````````````````````````````````````````````````````````````````````````````````
The object-oriented development life cycle is which of the following?
Analysis, design, and implementation steps in the given order and using multiple iterations. Analysis, design, and implementation steps in the given order and going through the steps no more than one time.
Analysis, design, and implementation steps in any order and using multiple iterations. Analysis, design, and implementation steps in any order and going through the steps no more than one time.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
Multiplicity is the same as what concept for an ERD?
Relationship
Attribute
entity
Cardinality
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Composition is a stronger form of which of the following?
Aggregation
Encapsulation
Inheritance
all
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
An abstract class is which of the following?
A class that has direct instances, but whose descendants may have direct instances.
A class that has no direct instances, but whose descendants may have direct instances.
A class that has direct instances, but whose descendants may not have direct instances.
A class that has no direct instances, but whose descendants may not have direct instances
2
``````````````````````````````````````````````````````````````````````````````````````````````````````
The term Complete for a UML has the same meaning as which of the following for an EER diagram?
Overlapping rule
Disjoint rule
Total specialization rule
Partial specialization rule
3
``````````````````````````````````````````````````````````````````````````````````````````````````````
A UML diagram includes which of the following?
Class name
List of attributes
List of operations
All of the above.
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
An object can have which of the following multiplicities?
Zero
one
More than one
all
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following statement is true concerning objects and/or classes?
An object is an instance of a class.
A class is an instance of an object.
An object includes encapsulates only data.
class includes encapsulates only data.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following applies to a class rather than an object?
Query
update
scope
constructor
3
``````````````````````````````````````````````````````````````````````````````````````````````````````
The benefits of object-oriented modeling are which of the following?
The ability to tackle more challenging problems
Reusability of analysis, design, and programming results
Improved communication between users, analysts, etc.
All of the above.
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
Overlapping rule
Disjoint rule
Total specialization rule
Partial specialization rule
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
A constructor operation does which of the following?
Creates a new instance of a class
Updates an existing instance of a class
Deletes and existing instance of a class
All of the above.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is a technique for hiding the internal implementation details of an object?
Encapsulation
Polymorphism
Inheritance
All of the above.
1
Equi-join
Natural join
Outer join
All of the above.
3
``````````````````````````````````````````````````````````````````````````````````````````````````````
What type of join is needed when you wish to return rows that do have matching values?
Equi-join
Natural join
Outer join
All of the above.
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is true concerning a procedure?
You do not create them with SQL.
They do not need to have a unique name.
They include procedural and SQL statements.
They are the same thing as a function.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is one of the basic approaches for joining tables?
Subqueries
Union Join
Natural join
All of the above
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is true concerning systems information in an RDBMS?
RDBMS store database definition information in system-created tables.
This information can be accessed using SQL.
This information often cannot be updated by a user.
All of the above.
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Embedded SQL is which of the following?
Hard-coded SQL statements in a program language such as Java.
The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a procedure.
Hard-coded SQL statements in a trigger.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
A UNION query is which of the following?
Combines the output from no more than two queries and must include the same number of columns. Combines the output from no more than two queries and does not include the same number of columns. Combines the output from multiple queries and must include the same number of columns.
Combines the output from multiple queries and does not include the same number of columns.
3
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following statements is true concerning subqueries?
Involves the use of an inner and outer query.
Cannot return the same result as a query that is not a subquery.
Does not start with the word SELECT.
All of the above.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is a correlated subquery?
Uses the result of an inner query to determine the processing of an outer query.
Uses the result of an outer query to determine the processing of an inner query.
Uses the result of an inner query to determine the processing of an inner query.
Uses the result of an outer query to determine the processing of an outer query.
2
``````````````````````````````````````````````````````````````````````````````````````````````````````
How many tables may be included with a join?
one
two
three
all
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is true concerning triggers?
You do not create them with SQL.
They execute against only some applications that access a database.
They have an event, condition, and action.
They cannot cascade (cause another trigger to fire).
3
``````````````````````````````````````````````````````````````````````````````````````````````````````
The fact that the same operation may apply to two or more classes is called what?
Inheritance
Polymorphism
Encapsulation
Multiple classification
2
``````````````````````````````````````````````````````````````````````````````````````````````````````
The object-oriented development life cycle is which of the following?
Analysis, design, and implementation steps in the given order and using multiple iterations. Analysis, design, and implementation steps in the given order and going through the steps no more than one time.
Analysis, design, and implementation steps in any order and using multiple iterations. Analysis, design, and implementation steps in any order and going through the steps no more than one time.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
Multiplicity is the same as what concept for an ERD?
Relationship
Attribute
entity
Cardinality
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Composition is a stronger form of which of the following?
Aggregation
Encapsulation
Inheritance
all
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
An abstract class is which of the following?
A class that has direct instances, but whose descendants may have direct instances.
A class that has no direct instances, but whose descendants may have direct instances.
A class that has direct instances, but whose descendants may not have direct instances.
A class that has no direct instances, but whose descendants may not have direct instances
2
``````````````````````````````````````````````````````````````````````````````````````````````````````
The term Complete for a UML has the same meaning as which of the following for an EER diagram?
Overlapping rule
Disjoint rule
Total specialization rule
Partial specialization rule
3
``````````````````````````````````````````````````````````````````````````````````````````````````````
A UML diagram includes which of the following?
Class name
List of attributes
List of operations
All of the above.
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
An object can have which of the following multiplicities?
Zero
one
More than one
all
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following statement is true concerning objects and/or classes?
An object is an instance of a class.
A class is an instance of an object.
An object includes encapsulates only data.
class includes encapsulates only data.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following applies to a class rather than an object?
Query
update
scope
constructor
3
``````````````````````````````````````````````````````````````````````````````````````````````````````
The benefits of object-oriented modeling are which of the following?
The ability to tackle more challenging problems
Reusability of analysis, design, and programming results
Improved communication between users, analysts, etc.
All of the above.
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
Overlapping rule
Disjoint rule
Total specialization rule
Partial specialization rule
4
``````````````````````````````````````````````````````````````````````````````````````````````````````
A constructor operation does which of the following?
Creates a new instance of a class
Updates an existing instance of a class
Deletes and existing instance of a class
All of the above.
1
``````````````````````````````````````````````````````````````````````````````````````````````````````
Which of the following is a technique for hiding the internal implementation details of an object?
Encapsulation
Polymorphism
Inheritance
All of the above.
1
No comments:
Post a Comment