Ch 32: SQL Data Manipulation Language (DML)

Practical guide to inserting data tuples, modifying existing records, avoiding accidental whole-table updates/deletions, and inserting from subqueries.

22 Questions22 MCQs0 Short Questions0 Long Questions

🎯 Exam Practice Papers

CS403 - Database Management Systems Examination Practice

Timed practice exam simulation for CS403 - Database Management Systems.

Showing 1 – 10 of 22 Questions

Page 1 of 3

❓ MCQ📘 CS403📑 Lec 32🏷️ 32.1. Role of Application ProgramsEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following are the general activities performed during the development and execution of application programs?

💻 text Snippet

-- Application logic handles input validation
-- before executing DML operations.

A.Data input programs
B.Editing
C.Display
D.All of given

❓ MCQ📘 CS403📑 Lec 32🏷️ 32.2. User Interface ConceptsEasy🔁⭐💡📄🎓VU🏛️VU

A ________ is an agreed-upon set of conventions that defines the rules of communication.

A.Protocol
B.Interconnection Medium
C.Data Packet
D.Message

❓ MCQ📘 CS403📑 Lec 32🏷️ 32.4. Design of User InterfacesMedium🔁⭐💡📄🎓VU🏛️VU

Which of the following is NOT a feature of a good interface?

A.Consistency
B.Process based
C.Data structure based
D.User friendly

❓ MCQ📘 CS403📑 Lec 32🏷️ 32.1. Role of Application ProgramsEasy🔁⭐💡📄🎓VU🏛️VU

True or False: An Information Technology (IT) audit is formally defined as an independent examination and evaluation of the security, management, and operational controls within an entity’s physical and logical information technology infrastructure.

A.True
B.False

❓ MCQ📘 CS403📑 Lec 32🏷️ 32.1. Role of Application ProgramsEasy💡📄🎓VU🏛️VU

Testing is relatively easy for application software that has been modeled using Object-Oriented Analysis and Design (OOAD) due to the heavy utilization of which of the following approaches?

A.Modular approach
B.Real-time modeling
C.Usability feature

❓ MCQ📘 CS403📑 Lec 32🏷️ 32.4. Design of User InterfacesMedium💡📄🎓VU🏛️VU

Browser-based forms are developed in the following languages and tools EXCEPT:

💻 html Snippet

<form action="/submit_grade" method="POST">
  <label>Student ID:</label>
  <input type="text" name="stId" />
  <input type="submit" value="Submit" />
</form>

A.HTML
B.Scripting languages (e.g., JavaScript)
C.Microsoft FrontPage
D.Web-based Forms

❓ MCQ📘 CS403📑 Lec 32🏷️ 32.1. Role of Application ProgramsMedium🔁⭐💡📄🎓VU🏛️VU

To accept the potential risk and continue operating the IT system, or to implement controls to lower the risk to an acceptable level, is known as which of the following risk management strategies?

A.Risk Planning
B.Risk Assumption
C.Risk Limitation
D.Risk Transference

❓ MCQ📘 CS403📑 Lec 32🏷️ 32.2. User Interface TypesEasy⭐💡📄🎓VU🏛️VU

When comparing application user interfaces, what are the primary structural differences between a Text-Based User Interface and a Graphical User Interface (GUI) from a usability and design standpoint?

💻 text Snippet

Text Interface: C:\> SELECT * FROM STUDENT;
GUI Interface: [Windows Form] -> Click [Show Students Button]

A.Text-based interfaces display strictly character-based menus requiring command entry, whereas GUIs display visual elements like windows, icons, forms, and buttons that minimize training time.
B.Text-based interfaces require advanced high-speed graphics hardware, whereas GUIs run efficiently on primitive text-only terminal displays.
C.Text-based interfaces only allow numeric data input, whereas GUIs only allow alphanumeric string input.
D.There are no structural differences, as both interface styles use the exact same mouse-driven pointers to execute DDL queries.

❓ MCQ📘 CS403📑 Lec 32🏷️ 32.1. Role of Application ProgramsMedium🔁⭐💡📄🎓VU🏛️VU

__________ is a type of computer software that facilitates group decision-making within an organization.

A.EMS (Electronic Meeting System)
B.DSS (Decision Support System)
C.MIS (Management Information System)

Q10

❓ MCQ📘 CS403📑 Lec 32🏷️ 32.1. Role of Application ProgramsMedium🔁⭐💡📄🎓VU🏛️VU

True or False: Risk assessment and analysis in IT security includes the assessment of technical, operational, and management controls that have already been implemented or planned by the organization.

A.True
B.False

Ch 32: SQL Data Manipulation Language (DML)

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

📖 Related CS403 - Database Management Systems Curriculum Units