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 statements are Data Definition Language command?
Choose an answer
INSERT
UPDATE
GRANT
TRUNCATE
Previous
Skip
Next
Question # 2
Which of the following is NOT a feature of Indexed sequential files?
Choose an answer
Records are stored in sequence and index is maintained
Dense and nondense types of indexes are maintained
Track overflows and file overflow areas can not be ensured.
Cylinder index increases the efficiency
Previous
Skip
Next
Question # 3
Select the correct statement among the following.
Choose an answer
Role names are not technically necessary in relationship types when all the participating entity types are distinct
When different entity types participate only once in a single relationship type it is called a recursive relationship.
Cardinality ratios for binary relationship are displayed on Entity Relationship Diagrams by using a diamond shape notation.
Partial participation which is also called existence dependency is displayed as a double line connecting the participating entity type to the relationship.
Previous
Skip
Next
Question # 4
_______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 # 5
Which of the following is true about NOT NULL constraint?
Choose an answer
enforce domain integrity
limit the values that can be placed in a column
prevents any actions that would destroy links between tables with the corresponding data values
enforces the uniqueness of the values in a set of columns
Previous
Skip
Next
Question # 6
Browser based forms are developed in the following tools EXCEPT
Choose an answer
HTML
Scripting language
Front Page
Web-based Forms
Previous
Skip
Next
Question # 7
Which of the following is NOT a feature of Indexed sequential files?
Choose an answer
Records are stored in sequence and index is maintained.
Dense and nondense types of indexes are maintained.
Track overflows and file overflow areas can not be ensured
Cylinder index increases the efficiency
Previous
Skip
Next
Question # 8
How many clustered index(es) do each database table have?
Choose an answer
2
3
4
1
Previous
Skip
Next
Question # 9
Which of the following is a correct way of selecting all the columns from a table called PERSONS?
Choose an answer
SELECT FROM * Persons
SELECT * FROM Persons
SELECT * WHERE Persons
SELECT WHERE * Persons
Previous
Skip
Next
Question # 10
Identify the correct statement about ANSI/SPARC architecture.
Choose an answer
The external level is not concerned with individual user perceptions
The internal level, in a database system, will always be relational
Any given database has exactly one conceptual schema and one physical schema, but it may have several external schemas.
A data definition language is used to define the internal schema
Previous
Skip
Next
Question # 11
The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype
Choose an answer
specialization
uniqueness
inheritance
completeness
Previous
Skip
Next
Back