- Study guides, Class notes & Summaries

Database management systems (DBMS) Exam Questions and Answers (Latest Update 2024)

-

8 pages

Written in 2024/2025

Allivia

TYPICAL QUESTIONS & ANSWERS OBJECTIVE TYPE QUESTIONS Each question carries 2 marks. Choose the correct or best alternative in the following: Q.1 In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints. Ans: A Q.2 Relational calculus is a (A) Procedural language. (B) Non- Procedural language. (C) Data definition language. (D) High level language. Ans: B ...

-

92 pages

Written in 2024/2025

Grade A+

TIFFACADEMICS

DATABASE MANAGEMENT SYSTEMS: EXAM REVIEW QUESTIONS AND ANSWERS, GRADED A+. What are Forms? - -A screen objects used to maintain, view, and print data from a database What are Reports? - -DBMS asks questions about the desired content and appearance of each report then creates it automatically based on the answers What are the problems associated with redundancy? - -Difficulty accessing related data, limited security, size limitations, changes are cumbersome and time consuming, waste spac...

-

3 pages

Written in 2023/2024

Grade A+

Terryl

Database management systems (DBMS) What is a database management system? - a program controlling the structure of a database and access to the data; creates, processes, and administers database What are some advantages of a DBMS? - -reduced data redundancy -improved data integrity -more program independence -increased user productivity -increased security What is DBMS used for? - to create tables and relationships in databases What do applications use DBMS for? - to read, inse...

-

6 pages

Written in 2023/2024

Grade A+

ExcellentScores

Database management systems (DBMS) | Questions with 100% Correct Answers | Latest Update 2024 | Verified

-

6 pages

Written in 2023/2024

Grade A+

Themanehoppe

Database Management Systems 2 - Final/Midterm Questions & Answers (A+GRADED 100%VERIFIED)

-

23 pages

Written in 2023/2024

Grade A+

carrington

Database Management Systems midterm review Questions & Answers 2024(A+GRADED 100%VERIFIED)

-

11 pages

Written in 2023/2024

Grade A+

carrington

Database Management Systems Midterm Exam Questions & Answers 2024(A+GRADED 100%VERIFIED)

-

10 pages

Written in 2023/2024

Grade A+

carrington

Database management systems (DBMS) What is a database management system? - a program controlling the structure of a database and access to the data; creates, processes, and administers database What are some advantages of a DBMS? - -reduced data redundancy -improved data integrity -more program independence -increased user productivity -increased security What is DBMS used for? - to create tables and relationships in databases What do applications use DBMS for? - to read...

-

4 pages

Written in 2023/2024

Grade A+

otebamanyuru

Database management systems (DBMS) | Questions with 100% Correct Answers | Latest Update 2024 | Verified

-

6 pages

Written in 2023/2024

Grade A+

ClassHero

What is a database management system? - a program controlling the structure of a database and access to the data; creates, processes, and administers database What are some advantages of a DBMS? - -reduced data redundancy -improved data integrity -more program independence -increased user productivity -increased security What is DBMS used for? - to create tables and relationships in databases What do applications use DBMS for? - to read, insert, modify, and delete data What is a struc...

-

6 pages

Written in 2023/2024

Grade A+

Preach

Commercial DBMS products such as Oracle and MS SQL Server uses the Relational model. Relational Conceptual (high level) provide concepts that are close to the way user perceives model Entity based, object based Physical (low level) describes details of how data is stored in the computer Implementation in between the two above. Easily understood by end users but not too far from the way data is organized in computer storage. Relational Self-describing combines t...

-

10 pages

Written in 2022/2023

Grade A+

YANCHY