Ch 13: Multitasking & Cooperative Kernels

Covers thread and process abstractions at the assembly level, initializing independent task stacks, switching execution contexts via register swapping, and cooperative scheduling algorithms.

141 Questions141 MCQs0 Short Questions0 Long Questions

🎯 Exam Practice Papers

CS401 - Computer Architecture and Assembly Language Programming Examination Practice

Timed practice exam simulation for CS401 - Computer Architecture and Assembly Language Programming.

Showing 81 – 90 of 141 Questions

Page 9 of 15

Q81

❓ MCQ📘 CS401📑 Lec 13🏷️ SQL DDL Table ConstraintsEasy🔁⭐💡📄🎓VU🏛️VU

Is the statement true or false: 'Only one type of constraint can be enforced on any table using a single CREATE TABLE statement in SQL'?

💻 sql Snippet

CREATE TABLE Example (id INT PRIMARY KEY, email VARCHAR(100) UNIQUE NOT NULL);

A.True
B.False

Q82

❓ MCQ📘 CS401📑 Lec 13🏷️ Hash Collision Resolution Techniques (Separate Chaining)Medium🔁⭐💡📄🎓VU🏛️VU

Which of the following is a main disadvantage of using the separate chaining technique to resolve hash collisions in database indexing and hash tables?

A.Limits the maximum number of elements that can be stored
B.Requires costly full table rehashing on every insertion
C.Overhead of storing pointers and traversing multiple linked lists
D.Requires knowing the maximum number of elements beforehand

Q83

❓ MCQ📘 CS401📑 Lec 13🏷️ Relational Normalization and Functional DependenciesMedium🔁⭐💡📄🎓VU🏛️VU

Consider a database relation R containing attributes EmpNo, ProjNo, and DeptNo. Which of the following functional dependency statements is NOT valid?

A.The functional dependency ProjNo -> DeptNo holds over R
B.The functional dependency (EmpNo, ProjNo) -> DeptNo holds over R
C.The functional dependency DeptNo -> ProjNo holds over R
D.The functional dependency EmpNo -> DeptNo holds over R

Q84

❓ MCQ📘 CS401📑 Lec 13🏷️ Entity-Relationship Modeling (Entity Type vs Instance)Easy🔁⭐💡📄🎓VU🏛️VU

In database design and Entity-Relationship (ER) modeling, what is an 'Entity Type'?

A.A physical data table constructed in physical disk storage
B.A primitive data type such as INTEGER, VARCHAR, or DATE
C.A coherent set or class of similar real-world objects about which data is stored (e.g., STUDENT, COURSE, CAR)
D.A specific privilege level defined by the database administrator

Q85

❓ MCQ📘 CS401📑 Lec 13🏷️ Entity-Relationship Modeling (Relationships)Easy🔁⭐💡📄🎓VU🏛️VU

In Entity-Relationship (ER) modeling, how can one entity type be logically connected or associated with another entity type?

A.By creating a Hyperlink
B.By defining a Relationship
C.By creating an Index
D.By defining an Attribute

Q86

❓ MCQ📘 CS401📑 Lec 13🏷️ Relational Database Keys and Common AttributesEasy🔁⭐💡📄🎓VU🏛️VU

In relational database design, how can one entity (or table) be logically connected to another table?

A.Hyperlink
B.Common attribute (Foreign Key)
C.Primary key
D.Superkey

Q87

❓ MCQ📘 CS401📑 Lec 13🏷️ Database Views Updatability RulesMedium🔁⭐💡📄🎓VU🏛️VU

Is the statement true or false: 'You cannot modify more than one underlying base table at a time through a single database view'?

A.True
B.False

Q88

❓ MCQ📘 CS401📑 Lec 13🏷️ SQL DML Commands (INSERT)Easy🔁⭐💡📄🎓VU🏛️VU

Which of the following is a primary purpose of using Data Manipulation Language (DML) commands in SQL?

💻 sql Snippet

INSERT INTO student (id, name) VALUES (1, 'Abrar');

A.Creating databases
B.Destroying database schemas
C.Inserting data into tables
D.None of the above

Q89

📝 Short Q📘 CS401📑 Lec 13🏷️ DDL vs DML Commands in SQLEasy🔁⭐💡📄🎓VU🏛️VU

What is the primary difference between Data Definition Language (DDL) and Data Manipulation Language (DML) in SQL?

Q90

📝 Short Q📘 CS401📑 Lec 13🏷️ Relational Data Model Attribute DomainsEasy🔁⭐💡📄🎓VU🏛️VU

Define the term 'domain of an attribute' in database relational design.

Ch 13: Multitasking & Cooperative Kernels

CS401 - Computer Architecture and Assembly Language Programming Examination Practice

Mid Term Examination

Final Term Examination

CS401 - Computer Architecture and Assembly Language Programming Examination Practice

Mid Term Examination

Final Term Examination

📖 Related CS401 - Computer Architecture and Assembly Language Programming Curriculum Units