Explore topic-wise MCQs in Engineering.

Some advantages of the database approach include all, but:

User views are included as part of which schema?

A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.

A fact is a word or phrase that has a specific meaning for the business.

A candidate key must uniquely identify each row.

A pointer is a detailed coding scheme recognized by system software for representing organizational data.

Mirrored databases are almost always provided in high-availability systems.

A constructor operation does which of the following?

Composition is a stronger form of which of the following?

Database objects are almost always transient.

Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?

Which of the following is an SQL trigger supported by Oracle?

The SQL statement used to create a view is CREATE VIEW.

A tool that can help designers understand the dependencies of database structures is a:

Money is defined in Oracle with the Currency data type.

Legacy data is which of the following?

Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.

Which of the following is true for a relational database?

If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.

Hashing algorithm converts a primary key value into a record address.

It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.

ROLLBACK WORK asks SQL to empty the log file.

Activities of a DBMS occur in the processing component logic.

The extract process is which of the following?

The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

Indexes may be created or dropped at any time.

The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

ORDER BY can be combined with the SELECT statements.

Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

Most companies keep at least two versions of any database they are using.

Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.

The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.

To establish a range of values, < and > can be used.

If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.

The keyword LIKE can be used in a WHERE clause to refer to a range of values.

The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

There is an equivalent join expression that can be substituted for all subquery expressions.

The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.

A dynamic view is one whose contents materialize when referenced.

SQL is a programming language.

SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.

In all cases, normalization into BCNF is desirable.

Denormalized tables are in BCNF.

We can eliminate modification anomalies with proper normalization that results in tables in BCNF.

Proper normalization eliminates duplicated data.