General Awareness: Computer Language Quiz
-
The DBMS acts as an interface between what two components of an enterprise-class database system?
-
Database application and the database
-
Data and the database
-
The user and the database application
-
Database application and SQL
-
This quiz is based on Computer languages created on Aug-19-2011
Quiz Preview
- 2.
Which of the following projects illustrates a database being designed from existing data?
-
A database using the Production Department's spreadsheets
-
A database designed to produce production reports for a new Production Department manufacturing process
-
A database that will combine two databases currently used by the Production Department
-
None of the above is correct.
Correct Answer
A. A database using the Production Department's spreadsheetsExplanation
The correct answer is a database using the Production Department's spreadsheets. This option suggests that the database is being designed based on existing data, specifically the spreadsheets used by the Production Department. This implies that the data from the spreadsheets will be organized and structured into a database format, allowing for easier management and analysis of the data. The other options either focus on the production reports or combining databases, which do not directly indicate designing a database from existing data.Rate this question:
-
- 3.
Which of the following projects illustrates a database being designed as a new systems development project?
-
A database using the Production Department's spreadsheets
-
A database designed to produce production reports for a new Production Department manufacturing process
-
A database that will combine two databases currently used by the Production Department
-
None of the above is correct.
Correct Answer
A. A database designed to produce production reports for a new Production Department manufacturing processExplanation
The correct answer is a database designed to produce production reports for a new Production Department manufacturing process. This project involves designing a database specifically for generating production reports for a new manufacturing process in the Production Department. This indicates that the database is being developed as part of a new systems development project. The other options either involve using existing spreadsheets or combining existing databases, which do not necessarily indicate the creation of a new system.Rate this question:
-
- 4.
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
-
IDMS
-
DB2
-
DBase-II
-
R:base
Correct Answer
A. DB2Explanation
DB2 was an early implementation of the relational model developed by E.F. Codd of IBM. It was one of the first commercially available relational database management systems (RDBMS) and played a significant role in popularizing the relational model. DB2 offered features like data integrity, data independence, and a powerful query language, making it a popular choice for businesses and organizations. Its success paved the way for the widespread adoption of the relational model in the database industry.Rate this question:
-
- 5.
The following are components of a database except ________ .
-
User data
-
Metadata
-
Reports
-
Indexes
Correct Answer
A. ReportsExplanation
Reports are not components of a database. A database is a structured collection of data that includes user data, metadata (information about the data), and indexes (data structures that improve the speed of data retrieval). Reports, on the other hand, are generated from the data stored in the database and are used for presenting and analyzing the data. While reports can be created using the data in a database, they are not considered as components of the database itself.Rate this question:
-
- 6.
Which of the following statements should be used to obtain a remainder after dividing 3.14 by 2.1 ?
-
Rem = 3.14 % 2.1;
-
Rem = modf(3.14, 2.1);
-
Rem = fmod(3.14, 2.1);
-
Remainder cannot be obtain in floating point division.
Correct Answer
A. Rem = fmod(3.14, 2.1);Explanation
The function fmod(x, y) is used to obtain the remainder after dividing x by y. In this case, 3.14 is divided by 2.1 using fmod(3.14, 2.1), which will give the remainder as the result.Rate this question:
-
- 7.
What are the types of linkages?
-
Internal and External
-
External, Internal and None
-
External and None
-
Internal
Correct Answer
A. External, Internal and NoneExplanation
The correct answer is "External, Internal and None". This answer suggests that there are three types of linkages: external, internal, and none. External linkages refer to connections between a company and external entities such as suppliers, customers, or partners. Internal linkages, on the other hand, pertain to connections within the company, such as between different departments or divisions. The inclusion of "none" implies that there may be situations where no linkages exist at all.Rate this question:
-
- 8.
Which of the following special symbol allowed in a variable name?
-
* (asterisk)
-
| (pipeline)
-
- (hyphen)
-
_ (underscore)
Correct Answer
A. _ (underscore)Explanation
The underscore symbol (_) is allowed in a variable name. In programming languages, the underscore is commonly used to separate words in variable names to improve readability. For example, a variable name like "first_name" is more readable than "firstname". The other symbols listed, such as the asterisk, pipeline, and hyphen, are not typically allowed in variable names and may cause syntax errors or confusion in the code.Rate this question:
-
- 9.
Is there any difference between following declarations? 1 : extern int fun(); 2 : int fun();
-
Both are identical
-
No difference, except extern int fun(); is probably in another file
-
Int fun(); is overrided with extern int fun();
-
None of these
Correct Answer
A. No difference, except extern int fun(); is probably in another fileExplanation
The answer states that there is no difference between the two declarations, except that "extern int fun();" is likely in another file. This means that both declarations are identical in terms of their function and behavior, but the location of the code for "extern int fun();" is different.Rate this question:
-
- 10.
How would you round off a value from 1.66 to 2.0?
-
Ceil(1.66)
-
Floor(1.66)
-
Roundup(1.66)
-
Roundto(1.66)
Correct Answer
A. Ceil(1.66)Explanation
To round off a value from 1.66 to 2.0, we would use the ceil() function. The ceil() function returns the smallest integer that is greater than or equal to the given value. In this case, the smallest integer greater than or equal to 1.66 is 2.0, so we would use ceil(1.66) to round off the value to 2.0.Rate this question:
-
- 11.
Which of the following can be facilitated by the Inheritance mechanism?
- Use the existing functionality of base class.
- Overrride the existing functionality of base class.
- Implement new functionality in the derived class.
- Implement polymorphic behaviour.
- Implement containership.
-
1, 2, 3
-
3, 4
-
2, 4, 5
-
3, 5
Correct Answer
A. 1, 2, 3Explanation
The correct answer is 1, 2, 3. The Inheritance mechanism allows a derived class to use the existing functionality of a base class (option 1). It also allows the derived class to override the existing functionality of the base class (option 2). Additionally, the derived class can implement new functionality (option 3) while inheriting the common attributes and behaviors from the base class.Rate this question:
- 12.
Which of the following is NOT an Integer?
-
Char
-
Byte
-
Integer
-
Short
Correct Answer
A. CharExplanation
A char is not an integer because it represents a single character rather than a numerical value. It is used to store characters like letters, digits, or symbols. Integers, on the other hand, are whole numbers without any fractional or decimal parts. Byte, integer, and short are all examples of integer data types.Rate this question:
-
- 13.
A property can be declared inside a class, struct, Interface.
-
True
-
False
-
Both are correct.
Correct Answer
A. TrueExplanation
In object-oriented programming, a property is a member of a class, struct, or interface that encapsulates a getter and/or setter method for accessing and modifying the state of an object. Therefore, it is true that a property can be declared inside a class, struct, or interface.Rate this question:
-
- 14.
Which of the following statements is correct about properties used in C#.NET?
-
A property can simultaneously be read only or write only.
-
A property can be either read only or write only.
-
A write only property will have only get accessor.
-
A write only property will always return a value.
Correct Answer
A. A property can be either read only or write only.Explanation
A property in C#.NET can be either read only or write only, but not both simultaneously. This means that a property can either have only a get accessor, making it read only, or only a set accessor, making it write only. It cannot have both get and set accessors together. Therefore, the correct statement is that a property can be either read only or write only.Rate this question:
-
- 15.
The keyword used to transfer control from a function back to the calling function is
-
Switch
-
Goto
-
Go back
-
Return
Correct Answer
A. ReturnExplanation
The keyword "return" is used to transfer control from a function back to the calling function. When a function is called, it executes its code and can return a value to the calling function using the "return" keyword. This allows the calling function to continue its execution using the returned value or perform any necessary actions based on the result of the called function.Rate this question:
-
Quiz Review Timeline (Updated): Jul 24, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jul 24, 2024Quiz Edited by
ProProfs Editorial Team -
Aug 19, 2011Quiz Created by
Tanmay Shankar
Back to top