Join Us ::

Menu Home Classes GK Engineering Past Papers Current Affairs Technical GAT Subject Programming Medical Papers

Engineering :: All Aptitude Test ::

Home » Engineering » Aptitude Test - 5
Hassan
1.Functions in MS Excel must begin with ?
A. An Equal Sign
B. A Plus Sign
C. A > Sign
D. An Equal Sign
2.Which function in Excel checks whether a condition is true or not ?
A. COUNT
B. SUM
C. IF
D. COUNT
3.In Excel, Columns are labelled as ?
A. 1,2,3 etc
B. A1, A2, etc.
C. $A$1, $A$2, etc.
D. 1,2,3 etc
4.Which field type will you select if you need to enter long text in that field ?
A. Memo
B. Currency
C. Hyperlink
D. Memo
5.The expression builder is an access tool that controls an expression for entering an expression ?
A. Palette
B. Cell
C. Box
D. Palette
6.Which of the following is not a type of MS Access database object ?
A. Worksheets
B. Form
C. Modules
D. Worksheets
7.In which method we don't need to specify the field type and size while creating a new Table ?
A. Create Table By Entering Data
B. While using Wizard
C. Design View
D. Create Table By Entering Data
8.The size of yes/no field is always ?
A. 1 Bit
B. 1 Byte
C. 1 Character
D. 1 Bit
9.The size of a field with number data type can not be ?
A. 2
B. 4
C. 8
D. 2
10.Ho can you edit a relationship already established between two tables ?
A. Right click the relationship line and choose Edit Relationship
B. Double click the relationship line
C. Both of above
D. Right click the relationship line and choose Edit Relationship
11.What does the show check box in query design window indicate ?
A. It indicates whether the field is to be used or not.
B. It indicates whether the field is to be displayed in query result or not
C. It indicates whether the field names to be displayed in query result or not.
D. It indicates whether the field is to be used or not.
12.Which of the following option creates a Drop Down List of values ?
A. Ole Object
B. Hyperlink
C. Memo
D. Ole Object
13.What can be the maximum length of a text field ?
A. 120
B. 255
C. 265
D. 120
14.Which kind of query that displays its own dialog box prompting you for entering information before executing ?
A. Select Query
B. Crosstab Query
C. Parameter Query
D. Select Query
15.What is a form that we can create in MS Access ?
A. It is used to take printout of a form from Access Tables.
B. It is an input screen for viewing and entering data.
C. It is used for storing special data other than text (e.g photo)
D. It is used to take printout of a form from Access Tables.
16.What Cascade Delete option is used for ?
A. It is used to delete all the records of all tables in a database
B. It repeats the recent delete operation to all the records of current table
C. It ensures that all the related records will be deleted automatically when the record from parent table is deleted.
D. It is used to delete all the records of all tables in a database
17.Which operator is used to filter and display rows when all (two or more) conditions are satiesfied ?
A. RANGE
B. IN
C. ALL
D. RANGE
18.The button on the tool box display data from a related table ?
A. Sub form sub report
B. Relationships
C. Select objects
D. Sub form sub report
19.The command center of Access File that appears when we create or open the MS Access database File ?
A. Database Window
B. Query Window
C. Design View Window
D. Database Window
20.While creating relationship using mouse, how the the mouse pointer looks like?
A. A thick plus sign
B. A thin plus sign
C. An outlined rectangle
D. A thick plus sign
21.How many Bytes are stored by ‘Long’ Data type in C# .net ?
A. 2 Bytes
B. 4 Bytes
C. 8 Bytes
D. 2 Bytes
22.Choose “.NET class” name from which data type “UInt” is derived ?
A. System.UInt16
B. System.UInt64
C. System.UInt32
D. System.UInt16
23.Correct Declaration of Values to variables ‘a’ and ‘b’?
A. int a = 32, b = 40.6;
B. int a = 42; b = 40;
C. int a = 32; int b = 40;
D. int a = 32, b = 40.6;
24.Arrange the following data type in order of increasing magnitude sbyte, short, long, int ?
A. short < int < sbyte < long
B. short < sbyte < int < long
C. sbyte < short < int < long
D. short < int < sbyte < long
25.Which data type should be more preferred for storing a simple number like 35 to improve execution speed of a program ?
A. sbyte
B. short
C. int
D. sbyte
26.Correct way to assign values to variable ‘c’ when int a=12, float b=3.5, int c ?
A. c = a + b;
B. c = a + int(float(b));
C. c = a + convert.ToInt32(b);
D. c = a + b;
27.Default Type of number without decimal is ?
A. Long Int
B. Unsigned Long
C. Int
D. Long Int
28.Select a convenient declaration and initialization of a floating point number ?
A. float somevariable = 12.502D
B. float somevariable = (Double) 12.502D
C. float somevariable = (float) 12.502D
D. float somevariable = 12.502D
29.Number of digits up-to which precision value of float data type is valid ?
A. Up-to 6 digit
B. Up-to 7 digit
C. Up-to 8 digit
D. Up-to 6 digit
30.Valid Size of float data type is ?
A. 10 Bytes
B. 6 Bytes
C. 4 Bytes
D. 10 Bytes
Related Subjects

Date to Date Current Affairs 2022

PakMCQs.net

Quick Links

GAT Subject



   Computer Science    English Mcqs    Agriculture    

Engineering



   Computer Science    Civil Engineering    

Technical



   Networking    Electronics    Database    

Past Papers



   Model Papers    FPSC Papers    
Our Team | Career | Contact | JoinUs | Privacy Policy | DMC

© 2020-2024 by Pak-MCQs.net All Rights Reserved.

Email: [email protected]