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

Start Test Download PDF

CS-403 Final Term Exams Preparation Virtual University

00:00
Question # 1

Which of the following constraints enforces referential integrity?

Question # 2

Which of the following is INCORRECT with respect to file systems?

Question # 3

How many clustered index(es) do each database table have?

Question # 4

Which of the following concept is applicable with respect to 2NF?

Question # 5

Which of the following concepts is applicable with respect to 3NF

Question # 6

A collection of related data is

Question # 7

Which of the following functions are NOT performed by a database administrator?

Question # 8

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

Question # 9

As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the _______.

Question # 10

GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION; What does this SQL statement do?

Submit

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


Topic Test

00:00
Submit

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
  • H
    hussain sheikh 17 - Sep - 2022 00 Min 56 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

Virtual University CS-403 Chapter 1 Important MCQ's

Sr.# Question Answer
1 Which of the following enforces a relation into 1st normal form?
A. The domain of attribute must include only atomic values.
B. Every non-key attribute is fully functionally dependent on primary key
C. non-key attribute is non-transitively dependent on primary key.
D. Every non-key attribute is partially dependent on super key
2 Which of the following is true about relational schema?
A. The sequence of columns is significant
B. The sequence of rows is significant.
C. Contains only derived attributes.
D. Values are atomic
3 A database system allows the following EXCEPT
A. management and control of data towards an efficient working of an organisation
B. more critical functions in organisations to be computerised and the need to keep a large volume of data available in an up to the minute current state increased.
C. any user to access all its data
D. integration of data across multiple applications into a single application.
4 A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
A. strong
B. weak
C. business
D. relationship
5 A description on a particular collection of data using the given data model
A. Database
B. Schema
C. None of the above
D. Relation
6 Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 columns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?
A. 24 ( The number of rows in the first table multiplied by the number of rows in the second table )
B. 32
C. 12
D. 16
7 Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
A. Physical data independence.
B. Concurrency control
C. Logical data independence.
D. Functional dependency
8 Which of the following most certainly implies the need for an entire table to implement?
A. A binary relationship
B. A ternary relationship
C. A recursive relationship
D. An identifying relationship
9 Which of the following is incorrect with respect to indexed sequential files?
A. New records are added to an overflow file
B. Record in main file that precedes it is updated to contain a pointer to the new record
C. The overflow is merged with the main file during a batch update
D. Multiple indexes for the same key field cannot be setup
10 DML commands are used for:
A. inserting data into databases
B. creating databases
C. destroying databases
D. creating DB objects

Test Questions

Share your comments & questions here

  • No comments yet. Be the first to comment!

Is this page helpful?