1033 + Mcqs in Database Page 16 McqOptions

751.	When you type Start FILENAME, the statement in your file will be executed automatically.
A.	True
B.	False
Answer» B. False

Discussion

752.	You can check on the status of tables with the DESCRIBE or DESC command.
A.	True
B.	False
Answer» B. False

Discussion

753.	Oracle directly supports the definition of surrogate keys.
A.	True
B.	False
Answer» C.

Discussion

754.	Oracle does NOT support a CASCADE UPDATE constraint.
A.	True
B.	False
Answer» B. False

Discussion

755.	Sequences guarantee valid surrogate key values.
A.	True
B.	False
Answer» C.

Discussion

756.	Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.
A.	True
B.	False
Answer» C.

Discussion

757.	If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.
A.	True
B.	False
Answer» B. False

Discussion

758.	The only time that case matters is inside quotation marks of strings.
A.	True
B.	False
Answer» B. False

Discussion

759.	When you type into SQL*Plus and press enter, the statement will be finished and executed.
A.	True
B.	False
Answer» C.

Discussion

760.	The semicolon terminates a SQL statement (and executes it).
A.	True
B.	False
Answer» B. False

Discussion

761.	SQL*Plus is a text editor.
A.	True
B.	False
Answer» B. False

Discussion

762.	Oracle allows the ORDER BY clause in view definitions.
A.	True
B.	False
Answer» B. False

Discussion

763.	The data model produced from the reverse engineering process does not include intersection table data.
A.	True
B.	False
Answer» C.

Discussion

764.	If a database is built correctly the first time, it will not have to be redesigned.
A.	True
B.	False
Answer» C.

Discussion

765.	The UML notation is useful for graphically depicting an object-oriented analysis or design model.
A.	True
B.	False
Answer» B. False

Discussion

766.	An aggregation is a stronger form of association relationship and is represented with a solid diamond at the aggregate end.
A.	True
B.	False
Answer» C.

Discussion

767.	Multiple inheritance allows a class to inherit features from more than one superclass.
A.	True
B.	False
Answer» B. False

Discussion

768.	A derived element is typically shown by placing either a slash (/) or a stereotype of <> before the name of the element.
A.	True
B.	False
Answer» B. False

Discussion

769.	The SQL-92 command to change a table name is RENAME TABLE.
A.	True
B.	False
Answer» C.

Discussion

770.	Information systems and organizations do not just influence each other; they create each other.
A.	True
B.	False
Answer» B. False

Discussion

771.	Adding null columns to a table is straightforward.
A.	True
B.	False
Answer» B. False

Discussion

772.	The NOT EXISTS keyword will be true if any row in the subquery meets the condition.
A.	True
B.	False
Answer» C.

Discussion

773.	An attribute's value is either a literal or an object identifier.
A.	True
B.	False
Answer» B. False

Discussion

774.	You may specify an object identifier with only one unique tag name.
A.	True
B.	False
Answer» C.

Discussion

775.	In ODL, you specify an operation using parentheses after its name.
A.	True
B.	False
Answer» B. False

Discussion

776.	An ordered collection of elements of the same type are called sets.
A.	True
B.	False
Answer» C.

Discussion

777.	An attribute's value is always literal.
A.	True
B.	False
Answer» B. False

Discussion

778.	An identifier typically uses more than one attribute.
A.	True
B.	False
Answer» C.

Discussion

779.	An identifier determines the type of relationship that an entity has.
A.	True
B.	False
Answer» C.

Discussion

780.	A recursive relationship is a relationship between an archetype and an instance of that archetype.
A.	True
B.	False
Answer» C.

Discussion

781.	The degree of a relationship refers to the number of entity classes in the relationship.
A.	True
B.	False
Answer» B. False

Discussion

782.	Entities use identifiers while tables use keys.
A.	True
B.	False
Answer» B. False

Discussion

783.	Specifying a key ensures that no two objects belonging to a class have the same value for the key attribute(s).
A.	True
B.	False
Answer» B. False

Discussion

784.	If you know all the possible values that an attribute can have, you can enumerate those values in ODL.
A.	True
B.	False
Answer» B. False

Discussion

785.	Literals do not have identifiers, and, therefore, cannot be individually referenced like objects.
A.	True
B.	False
Answer» B. False

Discussion

786.	A collection of literals or object types is called a bag.
A.	True
B.	False
Answer» C.

Discussion

787.	An entity class is a collection of entities and is described by the structure of the entities in that class.
A.	True
B.	False
Answer» B. False

Discussion

788.	Relationship classes are associations between entity classes.
A.	True
B.	False
Answer» B. False

Discussion

789.	The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
A.	True
B.	False
Answer» C.

Discussion

790.	The default extension for SQL*Plus is .sql.
A.	True
B.	False
Answer» B. False

Discussion

791.	Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.
A.	True
B.	False
Answer» B. False

Discussion

792.	An advantage of the database approach is the creation of maximum data redundancy.
A.	True
B.	False
Answer» C.

Discussion

793.	In UML, a class is represented by a rectangle with three compartments separated by vertical lines.
A.	True
B.	False
Answer» C.

Discussion

794.	A solid diamond represents a stronger form of aggregation, known as composition.
A.	True
B.	False
Answer» B. False

Discussion

795.	When a business rule involves three or more graphical symbols, you can show the constraint as a note and attach the note to each of the symbols by a dashed line.
A.	True
B.	False
Answer» B. False

Discussion

796.	One of the most popular systems development life cycle methods is prototyping.
A.	True
B.	False
Answer» B. False

Discussion

797.	Functional decomposition is the process of breaking down the functions of an organization into greater levels of detail.
A.	True
B.	False
Answer» B. False

Discussion

798.	Packaged data models can reduce implementation times and costs.
A.	True
B.	False
Answer» B. False

Discussion

799.	The goal of information systems planning is to align information technology with the business strategies of the organization.
A.	True
B.	False
Answer» B. False

Discussion

800.	With an enterprise data model, it is much easier to build applications because you know exactly what data exist and what needs to be added.
A.	True
B.	False
Answer» B. False

Discussion

Explore topic-wise MCQs in Engineering.

When you type Start FILENAME, the statement in your file will be executed automatically.

You can check on the status of tables with the DESCRIBE or DESC command.

Oracle directly supports the definition of surrogate keys.

Oracle does NOT support a CASCADE UPDATE constraint.

Sequences guarantee valid surrogate key values.

Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.

If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.

The only time that case matters is inside quotation marks of strings.

When you type into SQL*Plus and press enter, the statement will be finished and executed.

The semicolon terminates a SQL statement (and executes it).

SQL*Plus is a text editor.

Oracle allows the ORDER BY clause in view definitions.

The data model produced from the reverse engineering process does not include intersection table data.

If a database is built correctly the first time, it will not have to be redesigned.

The UML notation is useful for graphically depicting an object-oriented analysis or design model.

An aggregation is a stronger form of association relationship and is represented with a solid diamond at the aggregate end.

Multiple inheritance allows a class to inherit features from more than one superclass.

A derived element is typically shown by placing either a slash (/) or a stereotype of &lt;&gt; before the name of the element.

The SQL-92 command to change a table name is RENAME TABLE.

Information systems and organizations do not just influence each other; they create each other.

Adding null columns to a table is straightforward.

The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

An attribute's value is either a literal or an object identifier.

You may specify an object identifier with only one unique tag name.

In ODL, you specify an operation using parentheses after its name.

An ordered collection of elements of the same type are called sets.

An attribute's value is always literal.

An identifier typically uses more than one attribute.

An identifier determines the type of relationship that an entity has.

A recursive relationship is a relationship between an archetype and an instance of that archetype.

The degree of a relationship refers to the number of entity classes in the relationship.

Entities use identifiers while tables use keys.

Specifying a key ensures that no two objects belonging to a class have the same value for the key attribute(s).

If you know all the possible values that an attribute can have, you can enumerate those values in ODL.

Literals do not have identifiers, and, therefore, cannot be individually referenced like objects.

A collection of literals or object types is called a bag.

An entity class is a collection of entities and is described by the structure of the entities in that class.

Relationship classes are associations between entity classes.

The left-leaning slash tells Oracle to execute whatever statement is in the buffer.

The default extension for SQL*Plus is .sql.

Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.

An advantage of the database approach is the creation of maximum data redundancy.

In UML, a class is represented by a rectangle with three compartments separated by vertical lines.

A solid diamond represents a stronger form of aggregation, known as composition.

When a business rule involves three or more graphical symbols, you can show the constraint as a note and attach the note to each of the symbols by a dashed line.

One of the most popular systems development life cycle methods is prototyping.

Functional decomposition is the process of breaking down the functions of an organization into greater levels of detail.

Packaged data models can reduce implementation times and costs.

The goal of information systems planning is to align information technology with the business strategies of the organization.

With an enterprise data model, it is much easier to build applications because you know exactly what data exist and what needs to be added.

A derived element is typically shown by placing either a slash (/) or a stereotype of <> before the name of the element.