Online MCQ Assignment Answer

QN1: Which of the following are the properties of entities?

a. Groups

b. Table

c. Attributes

d. Switchboards

Answer

Answer: c. Attributes

QN2: Rows of a relation are called

a. tuples

b. a relation row

c. a data structure

d. an entity

Answer

Answer: a. tuples

QN3: Which clause is required in an SQL query for getting information from a database?

a. JOIN

b. ON

c. ORDER BY

d. SELECT

Answer

Answer: d. SELECT

QN4: Administrative supervision of database activities is responsibility of

a. Database administrator

b. DP Manager

c. DB Manager

d. None of above

Answer

Answer: a. Database administrator

QN5: By data security in DBMS we mean

a. preventing access to data

b. allowing access to data only to authorized users

c. preventing changing data

d. introducing integrity constraints

Answer

Answer: b. allowing access to data only to authorized users

QN6: is preferred method for enforcing data integrity

a. Constraints

b. Stored Procedure

c. Triggers

d. Cursors

Answer

Answer: a. Constraints

QN7: Data item characteristics that are important in data management include

a. punctuation

b. language

c. spelling

d. width

Answer

Answer: d. width

QN8: The number of tuples in a relation is called its .

a. Degree

b. Cardinality

c. Rows

d. Columns

Answer

Answer: b. Cardinality

QN9: The relational model feature is that there

a. is no need for primary key data

b. is much more data independence than some other database models

c. are explicit relationships among records

d. are tables with many dimensions

Answer

Answer: d. are tables with many dimensions

QN10: Which property of the database must the connection object contain?

a. Location

b. Type

c. Query

d. Both 1 and 2

Answer

Answer: d. Both 1 and 2

QN11: ..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

a. Instance

b. Schema

c. Program

d. Super Key

Answer

Answer: b. Schema

QN12: is the process of organizing data into related tables.

a. Normalization

b. Generalization

c. Specialization

d. None of the above

Answer

Answer: a. Normalization

QN13: The database schema is written in

a. HLL

b. DML

c. DDL

d. DCL

Answer

Answer: c. DDL

QN14: The candidate key is that you choose to identify each row uniquely is called

a. Alternate Key

b. Primary Key

c. Foreign Key

d. None of the above

Answer

Answer: b. Primary Key

QN15: Database management systems are used to

a. eliminate data redundancy

b. establish relationships among records in different files

c. manage file access

d. none of above

Answer

Answer: a. eliminate data redundancy

QN16: Which two files are used during operation of the DBMS?

a. Query languages and utilities

b. DML and query language

c. Data dictionary and transaction log

d. Data dictionary and query language

Answer

Answer: c. Data dictionary and transaction log

QN17: DCL stands for

a. Data Control Language

b. Data Console Language

c. Data Console Level

d. Data Control Level

Answer

Answer: a. Data Control Language

QN18: The number of attributes in a relation is called its

a. Cardinality

b. Degree

c. Columns

d. Rows

Answer

Answer:b. Degree

QN19: Fragmentation of a file system

a. Can always be prevented

b. occurs only is file is not used properly

c. Can be temporarily removed by compaction

d. None of above

Answer

Answer: a. Can always be prevented

QN20: The normalization process is:

a. used to remove redundant data

b. used to make the storage of data more efficient

c. not recommended for most databases

d. Both 1 and 2

Answer

Answer: d. Both 1 and 2

QN21: “Given an attribute x, another attribute y is dependent on it, if for a given x”

a. there are many y values

b. there is only one value of y

c. there is one or more y values

d. there is none or one y value

Answer

Answer: b. there is only one value of y

QN22: Data integrity in a file based system may be lost because

a. the same variable may have different values in different files (b) (c) (d)

b. files are duplicated

c. unnecessary data is stored in files

d. redundant data is stored in files

Answer

Answer: a. the same variable may have different values in different files (b) (c) (d)

QN23: Which command is used to set a link between two database files

a. JOIN

b. UPDATE

c. BROWSE

d. SET RELATION

Answer

Answer: d. SET RELATION

QN24: Where is a single element of data stored?

a. Field

b. Record

c. Table

d. All of the above

Answer

Answer: a. Field

QN25: Which are the two ways in which entities can participate in a relationship?

a. Passive and active

b. Total and partial

c. Simple and Complex

d. All of the above

Answer

Answer: b. Total and partial

QN26: Ascending order of data hierarchy is

a. bit->byte->record->field->file->database

b. bit->byte->field->record->file->database

c. byte->bit->field->record->file->database

d. byte->bit->field->file->record->database

Answer

Answer: b. bit->byte->field->record->file->database

QN27: The way a particular application views the data from the database that the application uses is a

a. module

b. relational model

c. schema

d. sub schema

Answer

Answer: d. sub schema

QN28: Which is not a program that can create a database?

a. Access

b. MySQL

c. Oracle

d. All of the above can be used to create a database

Answer

Answer: d. All of the above can be used to create a database

QN29: The WHERE clause is used to restrict the number of ___ retrieved by an SQL statement.

a. fields

b. records

c. tables

d. Both 1 and 2

Answer

Answer: b. records

QN30: How many fields can be specified in the SELECT clause?

a. 0

b. 1

c. 2

d. As many as needed

Answer

Answer: d. As many as needed

QN31: “A Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.”

a. Weak entity

b. Strong entity

c. Non attributes entity

d. Dependent entity

Answer

Answer: a. Weak entity

QN32: “The diagrams which are used to distribute files, libraries and tables across topology of hardware are called”

a. deployment diagrams

b. use case diagrams

c. sequence diagrams

d. collaboration diagrams

Answer

Answer: a. deployment diagrams

QN33: A foreign key:

a. has nothing to do with the primary key.

b. has different values than the primary key

c. is found in tables that don t have a primary key

d. is related to the primary key of a different table

Answer

Answer: d. is related to the primary key of a different table

QN34: Which is a type of DBMS software

a. utilities

b. query language

c. report writer

d. All of above

Answer

Answer: d. All of above

QN35: Which is the symbol for selecting all the fields in a table?

a. @

b. #

c. ^

d. *

Answer

Answer: d. *

QN36: By redundancy in a file based system we mean that

a. unnecessary data is stored

b. same data is duplicated in many files

c. data is unavailable

d. files have redundant data

Answer

Answer: b. same data is duplicated in many files

QN37: ___is used to determine whether of a table contains duplicate rows.

a. Unique predicate

b. Like Predicate

c. Null predicate

d. In predicate

Answer

Answer: a. Unique predicate

QN38: A check pointing system is needed

a. to ensure system security

b. to recover from transient faults

c. to ensure system privacy

d. to ensure system integrity

Answer

Answer: b. to recover from transient faults

QN39: Which is true about the primary key?

a. Every table should have a primary key

b. A primary key exclusively identifies each row in a table

c. A primary key can be made of multiple fields

d. All of the above

Answer

Answer: d. All of the above

QN40: To eliminate duplicate rows is used

a. NODUPLICATE

b. ELIMINATE

c. DISTINCT

d. None of these

Answer

Answer: a. NODUPLICATE