NET, IAS, State-SET (KSET, WBSET, MPSET, etc.), GATE, CUET, Olympiads etc.: Computers MCQs (Practice_Test 19 of 21)
Doorsteptutor material for competitive exams is prepared by world's top subject experts: get questions, notes, tests, video lectures and more- for all subjects of your exam.
- We can combine dBASE power with other software systems by transferring
- files to an fro dBASE
- program to another program
- files to an fro Database
- none of the above
- It is not possible to declare all the functions on an entity, or all of the subtypes, at the
- existing data
- entire database
- module creation
- none of the above
- Integrity constraints are predicates which must be free for data stored in
- an entity
- the database
- the system
- none of the above
- One of the aspects of data integrity is related to data access
- on the database
- the language programming
- privacy problems
- none of the above
- A DBMS allows data manipulation through primitive operations which can be grouped to form
- database transactions
- database modification
- software modules
- none of the above
- The INGRES system is composed with
- one module
- two modules
- four modules
- none of the above
- QUEL is interpreted by the
- DBMS system
- INGRES system
- SQL system
- none of the above
- It is also possible to access the relational DBMS through application program written in
- high-level programming language
- Pascal language programming
- procedural language
- none of the above
- We can send dBASE reports to word processing systems for further editing or inclusion
- in other programs
- in other documents
- in other systems
- none of the above
- The top three lines in a LOTUS 1 − 2 − 3 is termed as
- PANEL
- CONTROL PANEL
- EXTENSION
- none of the above
- The module scheme does not provide one of the common features of modules in programming, namely
- the accessing a number of shared modules
- the hiding of names
- and the partitioning of the same space
- both B and C
- Modules of the kind used in ADA and Module-2 allow one to declare a collection of procedures and functions that
- hiding the names
- reference each other
- partitioning of the same space
- none of the above
- The advantage of using storage system like binary relations or triples which does not keep all the function values on
- an entity together
- entire database
- existing data
- none of the above
- SQL is a relational language which has also been implemented in several
- DBMSs
- QUEL
- INGRES
- none of the above
- Several relational languages have been defined for different
- relational DBMS
- relational DBMSs
- QUEL languages
- none of the above
- Relational algebra is one of the basic concepts for defining
- programming languages
- relational languages
- high-level programming language
- none of the above
- Using the operators of relational algebra one may manipulate and query the database in a
- non-homogeneous manner
- homogeneous manner
- both A and B
- none of the above
- Modula-2 is an ideal language for interacting with an existing DBMS, where a suitable module
- has not been provided
- has been provided
- both A and B
- none of the above
- Locking mechanism guarantees exclusive access to an item of data while a lock
- has not been used
- is in force
- both A and B
- none of the above
- The ability to define such abstract objects, together with appropriate operations, is invaluable for
- programming language
- high-level programming language
- database applications
- none of the above
- One of the most important technique for dealing with complexity in software system is the principle of
- programming language
- abstraction
- database technology
- hone of the above
- The term ‘software engineering’ implies the application of scientific knowledge to the construction of
- computer software systems
- computer hardware systems
- high-level programming language
- none of the above
- By error we mean any deviation from the behavior stipulated by the
- database system
- requirements analysis
- incorrect data modeling
- none of the above
- By implementation we mean the transformation of our design into a database system which operates on a particular machine, usually under the control of
- software system
- hardware system
- Both
- none of the above
- Boolean variables are sometimes referred to as
- variables
- real variables
- logical variables
- none of the above
- In Pascal, decimal notation, requires that a real number contains at least one digit before and after the
- exponential notation
- decimal point
- zero
- none of the above