Database Management Questions & Answers: part12



Software Programming : Database Management QUESTIONS AND ANSWERS :: part12 : 6 to 10

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :

6.What is the Duplicate data in multiple data files called?

Data redundancy
Always necessary in networked databases
Typical of the relational model
A characteristic of a hierarchy
Data dictionary.

7.Which of the following SQL statements drop the primary key of Department relation? The fields in Employee should reflect the removal in Department table.

ALTER TABLE Department DROP PRIMARY KEY
ALTER TABLE Department DROP PRIMARY KEY(Dept_Code)
ALTER TABLE Department DROP PRIMARY KEY CASCADE
ALTER TABLE Department DROP PRIMARY KEY RESTRICT
DROP PRIMARY KEY Dept_Code FROM Department CAS.

8.Embedded SQL means

Using the EMBED key word in a SQL statement
Writing a SQL statement to retrieve data from more than one relation
Writing SQL statements within codes written in a general programming language
Specifying a condition and action to be taken in case the given condition is satisfied in a trigger
Using SQL language constructs like revoke and grant respectively for revoking and granting privileges to users.

9.Data integrity refers to

The inability to view a database because of system problems
Data being unavailable because it is being used by another user
Maintaining consistency of the data in a database
Preventing disclosure of information that causes harm
The ability to view a database because of system problems.

10.Which of the following database structure consists of a set of two or more related tables with a minimum of one shared field between them?

Hierarchical
Network
Object-oriented
Relational
ER.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Identify your problems but give your power and energy to solutions- Tony Robbins