Software Programming : Database Management QUESTIONS AND ANSWERS :: part18 : 1 to 5
Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :
1.Which of the following Relational Algebra operations require that both tables (or virtual tables) involved have the exact same attributes/data types? |
Join, Projection, Restriction |
Multiplication and Division |
Union, Intersection, Minus |
Minus, Multiplication, Intersection |
Projection, Selection, Rename. |
2.Out of the following activities, which is the one that normally performed by DBMS, without the interference of the DBA? |
Integrity |
Retention |
Security |
Granting the Privileges |
Recovery. |
3.A type of query that is placed within a WHERE or HAVING clause of another query is called |
Master query |
Sub query |
Super query |
Multi-query |
Co-related query. |
4.The protocol that ensures conflict serializability is |
Time stamp ordering protocol |
Two phase locking protocol |
Concurrency protocol |
Tree protocol |
Layered Protocol. |
5.Indexes are created in most RDBMS�s to |
Provide a quicker way to store data |
Decrease the amount of disk space utilized |
Provide rapid, random and sequential access to base-table data |
Increase the cost of implementation |
Decrease the cost of implementation. |
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