DBMS Q1

Identify the correct statement

• Data is processed information

• Information is independent

• Data is raw fact and has no specific meaning

• Data and information are same

Database Designers are ------------------

• Workers behind the scene

• Actors on the scene

• End Users

• Software Professionals

Which of the following is a category of End User?

• Parametric / Naive

• Software Engineer

• DBMS System Designer

• Personal End User

Data Model describes ----------------

• Structure, Operations, Constraints

• Three Schema Architecture

• Database Hierarchy

• Implementing categories of Data Model

Identify the odd one out with respect to Data Models

• Conceptual

• Logical

• Physical

• Representational

Which of the following statements are false?

• The actual data stored in a database at a particular time is Database instance

• Database schema changes every time the database is updated.

• Schema construct is a component of the schema

• Data Model operations refer to retrieval and updates

Three schema architecture does not support:

• Support of multiple views of the data

• Use of a catalog

• Program Data independence

• Physical and Logical independence

SQL stands for ----------------

• Simple Query Language

• Structured Queuing Language

• Structured Query Language

• Serialized Query Language

USE keyword is used to select a ___________

• COLUMN

• TABLE

• DATABASE

• KEY

In SQL, which of the following statement is used to insert new data in a database?

• ADD RECORD

• INSERT NEW

• INSERT INTO

• ADD NEW