1033 + Mcqs in Database McqOptions

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

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

Discussion

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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

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

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

Discussion

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

Discussion

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

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

Discussion

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

Discussion

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

Discussion

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

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

Discussion

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

Discussion

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

Discussion

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

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

Discussion

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

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

Discussion

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

50.	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 Testing Subject.

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.