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

ALTER TABLE exams RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID. Syntax of ALTER TABLE is NOT correct

Question # 2

Identify the correct statement

Question # 3

Which of the following is used to add or drop columns in an existing table?

Question # 4

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

Question # 5

Consider the following statements. A. An entity integrity constraint states that no primary key value can be null. B. A referential integrity constraint is specified between two relations. C. A foreign key cannot be used to refer to its own relation. Identify which of the above statements is/are correct

Question # 6

A collection of concepts that can be used to describe the structure of a database

Question # 7

Which of the following statements is correct with respect to the two relations given above?

Question # 8

Partitions may become unbalanced in:

Question # 9

Which of the following will be deleted relating to a table if you use TRUNCATE command?

Question # 10

Which of the following is incorrect with respect to indexed sequential files?

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 is not a form of optical disk?
A. CD ROM
B. WORM
C. Erasable Optical
D. EEPROM
2 Which of the following is true about NOT NULL constraint?
A. enforce domain integrity
B. limit the values that can be placed in a column
C. prevents any actions that would destroy links between tables with the corresponding data values
D. enforces the uniqueness of the values in a set of columns
3 Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
A. User accessible catalog
B. Data processing
C. Authorization service
D. Recovery service
4 Which of the following is CORRECT about database management system's languages?
A. Data definition languages are used to specify the conceptual schema only.
B. Data manipulation languages are used to create the databases
C. Data manipulation languages are used for retrieval, insertion, deletion and modification of data
D. Data definition langauges are only used to update data in the DBMS.
5 Which of the following is NOT a feature of HASH ACCESS?
A. indexes to search or maintain
B. Very fast direct access
C. Inefficient sequential access
D. Use when direct access is needed, but sequential access is not.
6 What is the maximum limit of keys in context with Indexed sequential files?
A. 7
B. 255
C. 1
D. 235
7 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
8 Which of following is not the feature of Indexes?
A. consume storage space
B. must be refreshed when the data in their master tables changes
C. improve the performance of SQL execution when they are used for query rewrites
D. can be accessed directly using a SELECT statement
9 Which of the following is NOT a feature of Indexed sequential files?
A. Records are stored in sequence and index is maintained
B. Dense and nondense types of indexes are maintained
C. Track overflows and file overflow areas can not be ensured.
D. Cylinder index increases the efficiency
10 DML commands are used for:
A. inserting data into databases
B. creating databases
C. destroying databases
D. creating DB objects

Test Questions

Is this page helpful?

Share your comments & questions here

Guest

  • No comments yet. Be the first to comment!