ICS Computer 2nd year Full Book MCQs - MDCATustad

A collection of mdcat, ecat, f.sc, ics and matric examination all subjects MCQs and past papers chapter wise.

Post Top Ad

Tuesday, May 5, 2020

ICS Computer 2nd year Full Book MCQs



ICS Full Book-II

1). SQL is used for.
(a) data definition          (b) data manipulation                
(c) a and b                      (d)  searching record
2). Which of the following may be a temporary file?
(a) Master file               (b) Transaction file                    
(c) Backup file              (d) None
3). Which of the following representing an object.
(a) Organization            (b) An event                             
(c) Book                        (d) All of these
4). The set of related characters that represent a unit of a data is called.
(a) File                         (b) Record                                
(c) Field                       (d) Database
5). An attribute is also known as.
(a) Relation                   (b) Row                                    
(c) Field                        (d) Tuple
6). How many primary keys can a relation have.
(a) At least two             (b) Only one                             
c) No limit                    (d) None
7). A field or set of fields for which more than one record can have the same values is called.
(a) Sort key                   b) Candidate key                       
(c) Secondary key       (d) Composite key
8). Which of the following is not a database management system.
a. MS Access       b. MS Word                              
c. MySQL                   d. Both a & c
9). Data in a relational database system is stored in:
a.         tables               b. records                                 
c. forms or queries      d. None
10). Which of the following contain data definition.
(a) Data dictionary        (b) Database                             
(c) Data Integrity          (d) All
11). Which of the following is a query language.
(a) DBMS                     (b) Utilities                               
(c) Report                      (d) SQL
12). The process of making the copy of the original is called:
(a) Storage                    (b) Retrieval                             
(c) Backup                    (d) None of these
13). In which normal form repeating groups are removed.
a) 1NF                          (b) 2NF                                     
(c) 3NF                         (d) None of these
14). The foreign key is found in.           
(a) parent table              (b) dependent table                    
(c) pivot table                (d) index table
15). The actual data of the database is stored in.
(a) Forms                      (b) Reports                               
(c) Query                        d) Table
16). A database object used to display and changes the records is called.
(a) Report                     b) Macro                                  
(c) Form                       d) Query
17). The identifier of an entity is also called.
(a) Key                         (b) Primary key                         
(c) Attribute                  (d) All of these
18). Insert command is used to insert.
(a) a new table              (b) a new record                        
(c) a view                      (d) dependencies
19). The C statements are normally written in ___________ letters.
(a) Lowercase               (b) Keywords                           
 c) Upper case               d) a and c
20). A program written in high level language is called.
(a) Re locatable code     b) Source Code                         
(c) Object code              d) None
21). Which of the following cannot be used in variable name?
(a) Number                   (b) Alphabets                            
(c) Under score             (d) Space
22). Which of the following is a valid variable name.
(a) Roo No                   (b) Roll No.                              
(c) Roll_No                  (d) Roll #
23). The conditional operator takes ______________ operands.
(a) One                         (b) Two                                    
(c) Three                      (d) None
24). Which of the following is a valid format specifier.
(a) %10d                       (b) %7.2f                                  
(c) %-7f                        (d) All
25). The function scanf( ) is defined in:
(a) stdio.h                     b) string.h                                 
c) math.h                     (d) conio.h
26). How many types of loop structures are in C.
 (a) 3                           (b) 2                                        
(c) 4                            (d) 5
27). The conditional operator takes ______________ operands.
(a) One                        (b) Two                                   
(c) Three                        (d) None
28). A block of code is surrounded by.
(a) ( )                           (b) { }                                     
(c) [ ]                           (d) “ “
29). Local variables are also called.
(a) Automatic             (b) Normal                              
(c) Global                        (d) None
30). The actual values are passed to the function in.
(a) Function declaration (b) Function call                 
(c) Function definition (d) None of these

No comments:

Post a Comment

Post Top Ad