

MCQOPTIONS
Saved Bookmarks
This section includes 839 Mcqs, each offering curated multiple-choice questions to sharpen your C++ Programming knowledge and support exam preparation. Choose a topic below to get started.
601. |
Data Isolation caused due to ________ in traditional file system. |
A. | Complex Data |
B. | Scattering of Data |
C. | Atomic Data |
D. | Duplicate Data |
Answer» C. Atomic Data | |
602. |
A database is a complex type of ______. |
A. | Application |
B. | Data Structure |
C. | Manager |
D. | None of these |
Answer» C. Manager | |
603. |
In __________ data can be stored in structured manner. |
A. | CPU |
B. | ALU |
C. | Database |
D. | None of these |
Answer» D. None of these | |
604. |
Which of the following database object does not physically exist? |
A. | base table |
B. | index |
C. | view |
D. | none of the above |
Answer» D. none of the above | |
605. |
The person who implements the specifications of the database programs is considered as |
A. | software engineers |
B. | application programmers |
C. | software developers |
D. | all of above |
Answer» E. | |
606. |
Database structure definition is also referred to as |
A. | Database schema |
B. | Database domain |
C. | Database workspace |
D. | Database organization |
Answer» B. Database domain | |
607. |
Which of the following is considered as DBMS ? |
A. | Access |
B. | Oracle |
C. | Foxpro |
D. | All of these |
Answer» E. | |
608. |
The menu-driven interface of DBMS and the forms-style interface of DBMS is classified as |
A. | conceptual user interface |
B. | controlled user interface |
C. | graphical user interface |
D. | structural user interface |
Answer» D. structural user interface | |
609. |
Which of the user write program in host language and embed the DML statements into it ? |
A. | Specialized User |
B. | Sophisticated User |
C. | Application Programmer |
D. | Naive User |
Answer» D. Naive User | |
610. |
The users that maintain databases with the help of ready made program packages are considered as |
A. | standalone users |
B. | canned users |
C. | conceptual transactions |
D. | sophisticated end users |
Answer» B. canned users | |
611. |
The collection of known and useful raw facts that has some meaning and can be processed in useful way is classified as |
A. | management oriented facts |
B. | updated facts |
C. | data |
D. | recorded facts |
Answer» D. recorded facts | |
612. |
The process of designing new database or designing new application for database which already exists is classified as |
A. | storage design analysis |
B. | requirement definition |
C. | requirement analysis |
D. | both a and b |
Answer» E. | |
613. |
The collection of programs that helps users to create and maintain the useful databases according to their need is classified as |
A. | processed facts system |
B. | traditional data group creation |
C. | maintained records |
D. | database management system |
Answer» E. | |
614. |
Duplication of data at several places is called as _______________. |
A. | Data Inconsistency |
B. | Data Redundancy |
C. | Data Isolation |
D. | Atomicity Problem |
Answer» C. Data Isolation | |
615. |
Which of the following in true regarding Null Value? |
A. | Null = 0 |
B. | Null < 0 |
C. | Null > 0 |
D. | Null <> 0 |
Answer» E. | |
616. |
Database Manager is also known as ________. |
A. | Sophisticated User |
B. | System Manager |
C. | Application Programmer |
D. | Storage Manager |
Answer» E. | |
617. |
The user interface which uses both menus technique and forms is classified as |
A. | defined user interface |
B. | host user interface |
C. | query user interface |
D. | graphical user interface |
Answer» E. | |
618. |
Person A is Java Developer interacts with Person D to understand the complete database schema written by him.Person B knows the database Schema and he is able to hit complex queries. Unlike Person B, Person C does not use traditional database processing frameworks.Who among the 4 user will be called as Sophisticated User. |
A. | Person B |
B. | Person A |
C. | Person C |
D. | Person D |
Answer» D. Person D | |
619. |
Farmer goes to ATM Center to withdraw an amount of Rs.300/-. Which type of user farmer is ? |
A. | Unsophisticated User |
B. | Sophisticated User |
C. | Application Programmer |
D. | Specialized User |
Answer» B. Sophisticated User | |
620. |
Related fields in a database are grouped to form a |
A. | data file |
B. | data record |
C. | menu |
D. | bank |
Answer» C. menu | |
621. |
Which database level is closest to the users? |
A. | External |
B. | Internal |
C. | Physical |
D. | Conceptual |
Answer» B. Internal | |
622. |
DBMS helps achieve |
A. | Data independence |
B. | Centralized control of data |
C. | Neither a nor b |
D. | Both a and b |
Answer» E. | |
623. |
The parts of an operation or function must includes |
A. | storage capacity |
B. | implementation |
C. | interface |
D. | both a and b |
Answer» E. | |
624. |
The group of employees who are responsible for maintenance running hardware of system is classified as |
A. | well being personnel |
B. | operators and maintenance personnel |
C. | system personnel |
D. | execution personnel |
Answer» C. system personnel | |
625. |
The group of people whose job description requires updating database, generating reports or using queries is called |
A. | casual users |
B. | secondary users |
C. | end users |
D. | primary users |
Answer» D. primary users | |
626. |
The popular technique in Web-based user interfaces are |
A. | unstructured host manner |
B. | pull-down menus |
C. | pull-up options |
D. | structured host manner |
Answer» C. pull-up options | |
627. |
The standard which allows the access to DBMS by the Java client programs is classified as |
A. | JCBD standard |
B. | JDBC standard |
C. | BDJC standard |
D. | CJBD standard |
Answer» C. BDJC standard | |
628. |
In large database management applications, theses customary constraints are classified as |
A. | controlled rules |
B. | redundancy rules |
C. | index rules |
D. | business rules |
Answer» E. | |
629. |
_____________ refers to the correctness and completeness of the data in a database? |
A. | Data security |
B. | Data integrity |
C. | Data constraint |
D. | Data independence |
Answer» C. Data constraint | |
630. |
In database management system, the term which is used to represent the real world concept or object is classified as |
A. | entity |
B. | attribute |
C. | relationship |
D. | abstraction |
Answer» B. attribute | |
631. |
Granting and Authorization for data access is provided by ____________. |
A. | DBA |
B. | Application Developer |
C. | Storage Manager |
D. | Database Manager |
Answer» B. Application Developer | |
632. |
Schema Definition is written by __________. |
A. | Application Programmer |
B. | Naive User |
C. | Database Administrator |
D. | Sophisticated user |
Answer» D. Sophisticated user | |
633. |
A collection of objects whose behavior and states are defined in accordance to classes is said to be |
A. | Object relational databases |
B. | Object Oriented databases |
C. | Object entity databases |
D. | Object network databases |
Answer» C. Object entity databases | |
634. |
Greater flexibility of data organization in databases is provided with |
A. | Relational databases |
B. | Network databases |
C. | Object Oriented databases |
D. | Entity relationship databases |
Answer» B. Network databases | |
635. |
The application program interface in the two tier architecture database management system is provided by the |
A. | close module connectivity |
B. | open module connectivity |
C. | close database connectivity |
D. | open database connectivity |
Answer» E. | |
636. |
The objects in DBMS belongs to same structure and behaves in the same way are considered as |
A. | same class objects |
B. | different structure objects |
C. | behavioral structure objects |
D. | classical structure objects |
Answer» B. different structure objects | |
637. |
The DBMS in which the systems involved are coupled together while having local autonomy is classified as |
A. | single usage DBMS |
B. | non-classical DBMS |
C. | classical DBMS |
D. | federated DBMS |
Answer» E. | |
638. |
The software whose main function is to provide the access the database from remote location with the help of work stations, local PCs and computer terminals is called |
A. | module software |
B. | communications software |
C. | host software |
D. | client software |
Answer» C. host software | |
639. |
Suppose user have Saving Account and Checking Account in the Bank. Saving Account Stores following information -account-nonameaddressmobileand Checking Account stores -account-nonameaddressmobileWhich of the information is not redundant ? |
A. | account-no |
B. | name |
C. | address |
D. | mobile |
Answer» B. name | |
640. |
The standard used popularly for the interchanging the data over internet is classified as |
A. | extended markup language model |
B. | markup model |
C. | network markup model |
D. | functional markup language |
Answer» B. markup model | |
641. |
The users who access the database occasionally but need different information every time are classified as |
A. | isolated users |
B. | occasional users |
C. | logical users |
D. | casual end users |
Answer» E. | |
642. |
Which of the following in not a function of DBA? |
A. | Network Maintenance |
B. | Routine Maintenance |
C. | Schema Definition |
D. | Authorization for data access |
Answer» B. Routine Maintenance | |
643. |
A command-line interface tells you it is waiting for the next command by using a |
A. | menu |
B. | prompt |
C. | dialog box |
D. | system call |
Answer» D. system call | |
644. |
Which is the layer of a computer system between the hardware and the user program ? |
A. | Operating environment |
B. | Operating system |
C. | System environment |
D. | None of the above |
Answer» C. System environment | |
645. |
Which of the following is not OS layer? |
A. | Kernel |
B. | Shell |
C. | Application Programs |
D. | Critical Section |
Answer» B. Shell | |
646. |
The operating system creates _____ from the physical computer. |
A. | Virtual space |
B. | Virtual computers |
C. | Virtual device |
D. | None of the above |
Answer» C. Virtual device | |
647. |
Data that is copied from an application is stored in a |
A. | driver |
B. | clipboard |
C. | terminal |
D. | prompt |
Answer» B. clipboard | |
648. |
______ shares characteristics with both hardware and software. |
A. | Operating system |
B. | Software |
C. | Data |
D. | None of the above |
Answer» B. Software | |
649. |
....... are specially designed computer chips that reside inside other devices, such as your car or electric thermostat |
A. | Server |
B. | Embedded computer |
C. | Robotic computer |
D. | Mainframes |
Answer» C. Robotic computer | |
650. |
Which one is not operating system? |
A. | P11 |
B. | OS/2 |
C. | Windows |
D. | Unix |
Answer» B. OS/2 | |