More Classes
5th Class
6th Class
7th Class
8th Class
9th Class
10th Class
11th Class
12th Class
NAT I
NAT II
CSS
IQ
General Knowledge
MDCAT
ECAT
GAT General
GAT Subject
Other Links
Go to Home
Online Tests
CS-403 Final Term Exams Preparation Virtual University MCQs With Answers
Question # 1
Which of the following is true about DELETE command?
Choose an answer
is DDL Command
Resets identity of the table
cannot activate a trigger
Can be Rolled back
Previous
Skip
Next
Question # 2
Identify the INCORRECT statement among the given.
Choose an answer
An entity may be an object with a physical existence like a car, a house or an Employee
One cannot consider something which has conceptual existence like a course in a degree program as an entity
Age can be considered as a single value attribute of a person.
An entity type describes the schema or intension for a set of entities which share the same structure.
Previous
Skip
Next
Question # 3
Which of the following is incorrect with respect to indexed sequential files?
Choose an answer
New records are added to an overflow file
Record in main file that precedes it is updated to contain a pointer to the new record
The overflow is merged with the main file during a batch update
Multiple indexes for the same key field cannot be setup
Previous
Skip
Next
Question # 4
Which of the following is NOT a component of a DFD? Select correct option:
Choose an answer
Dataflow
Datastore
External entities
Relationship between external entities
Previous
Skip
Next
Question # 5
Which key word is available in SQL to enforce referential integrity?
Choose an answer
Check
Primary Key
Set Default
Unique
Previous
Skip
Next
Question # 6
Which of the following is NOT a feature of Context DFD?
Choose an answer
one process (which represents the entire system)
all sources/sinks (external entities)
data flows linking the process to the sources and sinks (external entities)
sub-processes (which explain and decomposed the major process into small processes)
Previous
Skip
Next
Question # 7
_______is a control that enables users to select one option from an associated list; users can also type an option.
Choose an answer
Combo box
Button
Text box
Static area
Previous
Skip
Next
Question # 8
DML commands are used for:
Choose an answer
inserting data into databases
creating databases
destroying databases
creating DB objects
Previous
Skip
Next
Question # 9
As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the _______.
Choose an answer
primary key
foreign key
index
determinant
Previous
Skip
Next
Question # 10
Incase of Context-level Diagram, the system is represented by
Select correct option:
Choose an answer
One process atleast
Two processes atleast
One process only
Any number of processes
Previous
Skip
Next
Question # 11
In a conceptual model for a university, what type of relationship exists between Grade and Student entities?
Choose an answer
1:1
1:M
M:M
Ternary
Previous
Skip
Next
Back