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
- TNTET 2021 - Practice
- SSC CGL 2021 - Practice
- TNPSC Group 2A 2021 - Practice
- IIT JEE
- IIT JEE Q&A
- TNPSC Answer Keys
- TNPSC Group 2 Syllabus
-
TNPSC Q&A
- Online Tests - TNPSC
- Online Tests - GK
- IBPS 2020-2021
- Online Tests - Bank
- Online Tests - RRB NTPC
- Online Tests - UGC NET
- Online Tests - TANCET
- Online Aptitude Test
-
Engineering
-
Programming
-
Basic Science
-
Quiz
- Plus Two Question Papers
- SSLC Question Bank
-
Aptitude Tests
-
Logical Reasoning
-
General Knowledge-Hindi
-
Indian History MCQ
-
Indian Geography MCQ
-
Indian Civics MCQ
-
Indian Economics MCQ
-
CTET Biology MCQ
-
CTET Chemistry MCQ
-
CTET Physics Solved MCQ
-
Arithmetic Tests
- Press Release
- FAQ
- Coaching Centres
- TNPSC Group 1 Syllabus
-
TNPSC Group IV Syllabus
- TRB 2017 in English PDF
- TRB 2017 in Tamil PDF
- TET
- TNTET
Identify your problems but give your power and energy to solutions- Tony Robbins
