VU CS-403 Online Test Preparation

MCQ's Test For CS-403 Final Term Exams Preparation Virtual University

Try The MCQ's Test For CS-403 Final Term Exams Preparation Virtual University

  • Total Questions10

  • Time Allowed10

CS-403 Final Term Exams Preparation Virtual University

00:00
Question # 1

Which of the following is true about application programs?

Question # 2

In SQL queries, while creating tables or relations in database, key columns may be specified by

Question # 3

Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?

Question # 4

Which of the following is not true about input forms?

Question # 5

Which of the following is correct regarding Dataflow diagram?

Question # 6

An entity can be logically connected to another by defining a ____.

Question # 7

A collection of related data is

Question # 8

Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from a table named PERSON.

Question # 9

Which of the following is not true regarding Indexes?

Question # 10

A ____ relationship exists when an association is maintained within a single entity.

Prepare Complete Set Wise CS-403 Final Term Exams Preparation Virtual University MCQs Online With Answers


Topic Test

00:00

Top Scorers Of CS-403 Final Term Exams Preparation Virtual University MCQ`s Test

  • T
    Tahira Nawaz 27 - Feb - 2023 00 Min 02 Sec 10/10
  • U
    Unknown 28 - Feb - 2023 00 Min 05 Sec 10/10
  • S
    sadaf jameel 21 - Sep - 2022 00 Min 45 Sec 10/10
  • S
    saba shafiq 14 - Aug - 2023 01 Min 37 Sec 10/10
  • H
    Humna Nawaz 01 - Jun - 2024 01 Min 50 Sec 10/10
  • D
    Daniyal Tahir 15 - Feb - 2024 02 Min 25 Sec 10/10
  • M
    Muhammad Jamil 28 - Sep - 2022 02 Min 59 Sec 10/10
  • S
    Shafqat Ali 08 - Oct - 2022 00 Min 04 Sec 9/10
  • B
    bc200404586 AYESHA WARIS 18 - Feb - 2024 01 Min 34 Sec 9/10
  • N
    Nouman Ahmed Khan 18 - Sep - 2022 01 Min 56 Sec 9/10
  • S
    saqib saqib 08 - Jan - 2023 02 Min 20 Sec 9/10
  • I
    Iqra Akhtar 10 - Oct - 2022 03 Min 15 Sec 9/10
  • U
    Uzair sajid 21 - Jul - 2024 04 Min 22 Sec 9/10
  • S
    Syed Jahanzeb Ali 24 - Jun - 2023 01 Min 59 Sec 8/10
  • A
    ATIF IQBAL 20 - Dec - 2023 04 Min 38 Sec 8/10

Virtual University CS-403 Chapter 1 Important MCQ's

Sr.# Question Answer
1 Which of the following is true about DELETE command?
A. is DDL Command
B. Resets identity of the table
C. cannot activate a trigger
D. Can be Rolled back
2 Which of the following SQL keywords is not used with DDL statements?
A. Table
B. Update
C. Create
D. Alter
3 Which of the following is correct regarding Dataflow diagram?
A. Single DFD is required to represent a system
B. The dataflow must be bidirectional
C. Created at increasing levels of detail
D. Used to represent the relationships among the external entities
4 Which of the following serves as a milestone or reference point in the log file?
A. Constraints
B. Relations
C. Check points
D. Transactions identities
5 Which of the following is Advantage of Re-Hashing technique to handle the collisions?
A. Collisions don’t use primary table space
B. Unlimited number of elements
C. Fast access through use of main table space
D. Overhead of multiple linked lists
6 Which of the following is NOT one of the ways of resolving deadlocks?
A. Undoing all the updates made by the particular transaction which is the cause of deadlock.
B. A message is passed to the victim and depending on the system the transaction may or may not be started again automatically
C. Picking a list of all previously completed transactions and undoing all the updates.
D. Rollback `victim' transaction and restart it
7 Which of the following concepts is applicable with respect to 3NF?
A. Full functional dependency
B. Any kind of dependency
C. Transitive dependency
D. Partial functional dependency
8 _______ is a control that users click to perform an action, set or toggle a state, or set an option.
A. Button
B. Text box
C. Input form
D. Report
9 Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order By CUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS Where REGION = 'E' Order By CUSTOMER The above statement
A. Has an error - the string should be in double quotes
B. Has an error - ORDER BY clause.
C. Does not have an error.
D. Has an error - the string in single quotes 'NORTH' and 'SOUTH'.
10 A collection of related data is
A. Logical model
B. Database
C. Data
D. Relational model

Test Questions

Share your comments & questions here

Guest
  • No comments yet. Be the first to comment!