
Software Programming : Database Management QUESTIONS AND ANSWERS :: part7 : 6 to 10
Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :
6.Check pointing when used in conjunction with incremental log reduces the actual recovery time. However, for proper recovery the system must ensure that (choose the correct one) |
At the time of check pointing there is no incomplete transaction |
If the updates are deferred, at the time of check pointing there is no incomplete transaction |
If updates are immediate, at the time of check pointing there is no incomplete transaction |
At the time of check pointing there exists an incomplete transaction |
All of the above. |
7.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. |
8.�When a very large record of a file is allocated to disk blocks, some unused spaces will remain and to utilize this unused space, parts of records can be allocated. Each and every part belongs to a record and is referenced through a pointer.� A record organization which has been distributed as parts among unused spaces of blocks and using a pointer to reference them is called |
Blocking factor |
Spanned record |
Separator |
Variable length record |
BLOB. |
9.�In 1978 committee proposed a generalized framework for database systems and it provides a three_level architecture. The of the architecture defines user views of the database. The defines the physical view of the database. The defines the logical schema of the database.� Which of the following set is suitable to fill the blanks in the above paragraph? |
i. ANSI/ARPANET |
Conceptual Level |
External Level |
Internal Level |
i. ANSI/SPARC |
10.The methodology for documenting databases illustrating the relationship between various entities in the database is |
Data flow diagram |
State transition diagram |
Entity-relationship diagram |
Entity sequence diagram |
Object model. |
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
