Q&A Hero

Q: Knowing the ____ number of entity occurrences is very helpful at the application software level.a. maximum b. minimum c. approximated. maximum and minimum

Q: A relationship is an association between ____.a. objects b. entities c. databasesd. fields

Q: A derived attribute is indicated in the Chen model by a ____.a. single line b. dashed line c. circled. double line

Q: A derived attribute ____. a. must be stored physically within the database b. need not be physically stored within the database c. has many values d. must be based on the value of three or more attributes

Q: A ____ should be a derived attribute.a. person's name b. person's age c. person's social security numberd. person's phone number

Q: Although the conceptual model can handle ____ relationhips and multivalued attribues, you should not implement them in the RDBMS.a. 1:1 b. M:N c. 1:Md. 1:N

Q: Some attributes are classified as ____.a. simple b. complex c. definedd. grouped

Q: ____ attributes can have many values.a. Composite b. Simple c. Single-valuedd. Multivalued

Q: A ____ attribute can have only one value.a. composite b. simple c. single-valuedd. multivalued

Q: A ____ attribute is one that cannot be subdivided.a. composite b. simple c. single-valuedd. multivalued

Q: A ____ attribute can be further subdivided to yield additional attributes.a. composite b. simple c. single-valuedd. multivalued

Q: The ____ attribute(s) make up the primary key in the table definition:CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)a. CRS_CODE b. CLASS_SECTION c. CRS_CODE and CLASS_SECTIONd. There is no primary key

Q: A ____ identifier is composed of more than one attribute.a. primary b. foreign c. composited. domain

Q: Ideally, an entity identifier is composed of ____ attribute(s).a. zero b. one c. twod. six

Q: In an ER diagram, primary keys are indicated by ____.a. bolding b. italics c. underliningd. a special font

Q: The set of possible values for an attribute is a ____.a. domain b. range c. setd. key

Q: Attributes may share a ____.a. name b. domain c. locationd. table

Q: Some ____ database modeling concepts can be expressed only using the Chen notation.a. developmental b. conceptual c. actuald. specific

Q: The ERD represents the ____ database as viewed by the end user.a. condensed b. physical c. logicald. conceptual

Q: A recursive relationship is one in which a relationship can exist between occurrences of the same entity set

Q: Relationships operate only in one direction.

Q: The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.

Q: A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Q: You should always load data from the 1 side of a 1:M relationship.

Q: A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.

Q: Connectivities and cardinalities are established by business rules.

Q: In Chen notation, there is no way to represent cardinality.

Q: Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

Q: A relationship is identified by a name that describes the relationship.

Q: Derived attributes are stored in a special database table.

Q: The DBMS can easily handle multivalued attributes.

Q: In the Chen model, a multivalued attribute is connected to the owning entity with a double line.

Q: All simple attributes are also single-valued.

Q: All attributes are either simple or composite.

Q: A composite identifier is a primary key composed of more than one attribute.

Q: Ideally, a primary key is composed of several attributes.

Q: In an ER diagram, primary keys are usually bolded.

Q: Attributes cannot share a domain.

Q: Attributes have a domain that specifies the data type of the attribute.

Q: Software vendors have adopted the Chen representation because of its compact representation.

Q: In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line.

Q: Attributes are types of entities.

Q: The ER model refers to a specific table row as an entity occurrence.

Q: In both the Chen and Crow's Foot models, an entity is represented with a rectangle containing the entity's name.

Q: The ER model refers to a specific table row as an entity instance.

Q: The ER diagram represents the conceptual database as viewed by the end user.

Q: The Crow's Foot model is less implementation-oriented than the Chen model.

Q: The word "entity" in the ER model corresponds to a table.

Q: An ERM is dependent on the database type.

Q: The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.

Q: A stored function uses the ____ statement to return a value.a. EXIT b. END c. RETURNd. PROCESS

Q: Oracle recommends ____ for creating audit logs.a. triggers b. stored procedures c. stored functionsd. tables

Q: The PL/SQL block starts with the ____ clause.a. IS b. OPEN c. DECLAREd. BEGIN

Q: In Oracle, ____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.a. triggersb. indexes c. embedded SQLd. procedural SQL

Q: A(n) ____ is a block of code (containing standard SQL statements and procedural extensions) that is stored and executed at the DBMS server.a. PSM b. PLS c. SQL Statementd. PMR

Q: The ____ pseudo-column is used to select the next value from a sequence.a. CURRVAL b. NEXTVAL c. NEXTd. GET_NEXT

Q: The Oracle equivalent to an MS Access AutoNumber is a(n) ____.a. auto-number b. sequence c. TO_NUMBER functiond. trigger

Q: The ____ operator could be used in place of MINUS if the RDBMS does not support it.a. IN b. NOT IN c. ANDd. UNION

Q: The ____ operator could be used in place of INTERSECT if the RDBMS does not support it.a. IN b. OF c. ANDd. UNION

Q: Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the MINUS operator?a. 0 b. 2 c. 8d. 10

Q: The ____ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.a. UNION b. UNION ALL c. INTERSECTd. MINUS

Q: Assume you are using the INTERSECT operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the INTERSECT operator?a. 0 b. 2 c. 7d. 10

Q: Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator?a. 7 b. 10 c. 15d. 17

Q: Assume you are using the UNION operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator?a. 7 b. 10 c. 15d. 17

Q: The syntax for the UNION query is ____.a. query + query b. UNION (query, query) c. UNION: query queryd. query UNION query

Q: The ____ query combines rows from two queries and excludes duplicates.a. UNION b. UNION ALL c. INTERSECTd. MINUS

Q: The ____ data type is compatible with NUMBER.a. VARCHAR(15) b. SMALLINT c. DATEd. CHAR(10)

Q: The Oracle ____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.a. NVL b. TO_CHAR c. DECODEd. CONVERT

Q: The ____ data type is considered compatible with VARCHAR(35).a. DATE b. INT c. TINYINTd. CHAR(15)

Q: "Union-compatible" means that the ____. a. names of the relation attributes can be different, but the data types must be alike b. names of the relation attributes must be the same, but the data types can be different c. names of the relation attributes must be the same and their data types must be alike d. number of attributes must be the same, but the names and data types can be different

Q: ____ is a relational set operator.a. MINUS b. PLUS c. ALLd. EXISTS

Q: When using the Oracle TO_NUMBER function to convert a character string into a number, ____ represents a digit.a. 0 b. 9 c. $d. #

Q: The Oracle string concatenation function is ____.a. CONCAT b. + c. ||d. &&

Q: In Oracle, the ____ function converts a date to a character string.a. CONVERT() b. TO_DATE c. TO_CHAR()d. TO_STRING()

Q: The Oracle ____ function returns the current date.a. DATE b. SYSDATE c. CURRENT_DATEd. TO_DATE

Q: When using the Oracle TO_DATE function, the code ____ represents a three-letter month name.a. MON b. MM3 c. MONTHd. MM

Q: The ____ function returns the current system date in MS Access.a. TO_DATE() b. SYSDATE() c. DATE()d. TODAY()

Q: In a subquery, the ____ query is executed first.a. left b. right c. innerd. outer

Q: In subquery terminology, the first query in the SQL statement is known as the ____ query.a. outer b. left c. innerd. base

Q: A ____ is a query (SELECT statement) inside a query.a. subquery b. range query c. joind. set query