1 |
The columns of a table correspond to: |
Table
Record
Field
Cell
|
2 |
SQL is used for: |
Data definition
Data manipulaton
Data control
All
|
3 |
CREATE command is used to create: |
Record
View
Report
Query
|
4 |
The number of characters in variable field is: |
Constant
Variable
10
100
|
5 |
The number of characters in fixed-length field is: |
Constant
Variable
10
100
|
6 |
A virtual table that is constructed form other tables is called: |
Table
View
Relation
Tuple
|
7 |
The views are used : |
To hide columns
To hide rows
To hide complex SQL statements
Al of the above
|
8 |
The SQL statement to create a view is: |
CREATE VIEW
MAKE VIEW
SELECT VIEW
INSERT VIEW
|
9 |
Views are also called: |
Complex tables
Simple tables
Virtual tables
Actual tables
|
10 |
All the intersection of rows and columns must have: |
Single value
Constant value
Multiple values
No value
|
11 |
The columns of a relations can be of ___________ order. |
Any
Same
Sorted
Constant
|
12 |
The rows of a relations can be of ___________ order. |
Any
Same
Sorted
Constant
|
13 |
Insert command is used to insert: |
New table
New record
View
Dependences
|
14 |
The extension for a video file is: |
.avi
.mpg
.txt
a and b
|
15 |
Which of the following is an image file extension? |
.tif
.jpg
.bmp
All
|
16 |
The extension of program file is: |
.com
.exe
Both a and b
None
|
17 |
Which of the following file contains the software instructions? |
Program file
Data file
Both a and b
None
|