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 <> 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.