MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 1294 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science Engineering (CSE) knowledge and support exam preparation. Choose a topic below to get started.
| 951. |
                 is the smallest unit of allocation in an Oracle database. |
| A. | database |
| B. | instance |
| C. | tablespace |
| D. | database block |
| Answer» E. | |
| 952. |
The                is that part of main memory available for storage of copies of disk blocks. |
| A. | buffer |
| B. | catalog |
| C. | storage |
| D. | secondary storage |
| Answer» B. catalog | |
| 953. |
A Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes. |
| A. | tablespace |
| B. | segments |
| C. | extents |
| D. | blocks |
| Answer» B. segments | |
| 954. |
Relational schemas and other metadata about relations are stored in a structure called the |
| A. | metadata |
| B. | catalog |
| C. | log |
| D. | data dictionary |
| Answer» E. | |
| 955. |
                       is the collection of memory structures and Oracle background processes that operates against an Oracle database. |
| A. | database |
| B. | instance |
| C. | tablespace |
| D. | segment |
| Answer» C. tablespace | |
| 956. |
A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called |
| A. | metadata |
| B. | catalog |
| C. | log |
| D. | dictionary |
| Answer» B. catalog | |
| 957. |
The DBMS acts as an interface between what two components of an enterprise-class database system? |
| A. | database application and the database |
| B. | data and the database |
| C. | the user and the database application |
| D. | database application and sql |
| Answer» B. data and the database | |
| 958. |
A data dictionary is a special ï¬le that contains? |
| A. | the names of all ï¬elds in all ï¬les |
| B. | the data types of all ï¬elds in all ï¬les |
| C. | the widths of all ï¬elds in all ï¬les |
| D. | all of the mentioned |
| Answer» E. | |
| 959. |
The information about data in a database is called |
| A. | metadata |
| B. | hyper data |
| C. | tera data |
| D. | none of the mentioned |
| Answer» B. hyper data | |
| 960. |
Which of the following is not true of the traditional approach to information processing |
| A. | there is common sharing of data among the various applications |
| B. | it is ï¬le oriented |
| C. | programs are dependent on the ï¬le |
| D. | it is inflexible |
| Answer» B. it is ï¬le oriented | |
| 961. |
Which of these data models is an extension of the relational data model? |
| A. | object-oriented data model |
| B. | object-relational data model |
| C. | semi structured data model |
| D. | none of the mentioned |
| Answer» C. semi structured data model | |
| 962. |
Which of these is not a feature of Hierarchical model? |
| A. | organizes the data in tree-like structure |
| B. | parent node can have any number of child nodes |
| C. | root node does not have any parent |
| D. | child node can have any number of parent nodes |
| Answer» E. | |
| 963. |
Large collection of ï¬les are called |
| A. | fields |
| B. | records |
| C. | database |
| D. | sectors |
| Answer» D. sectors | |
| 964. |
An audit trail |
| A. | is used to make backup copies |
| B. | is the recorded history of operations performed on a ï¬le |
| C. | can be used to restore lost information |
| D. | none of the mentioned |
| Answer» C. can be used to restore lost information | |
| 965. |
Choose the RDBMS which supports full fledged client server application development |
| A. | dbase v |
| B. | oracle 7.1 |
| C. | foxpro 2.1 |
| D. | ingress |
| Answer» C. foxpro 2.1 | |
| 966. |
The highest level in the hierarchy of data organization is called |
| A. | data bank |
| B. | data base |
| C. | data ï¬le |
| D. | data record |
| Answer» C. data ï¬le | |
| 967. |
One approach to standardization storing of data? |
| A. | mis |
| B. | structured programming |
| C. | codasyl speciï¬cation |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 968. |
The management information system (MIS) structure with one main computer system is called a |
| A. | hierarchical mis structure |
| B. | distributed mis structure |
| C. | centralized mis structure |
| D. | decentralized mis structure |
| Answer» D. decentralized mis structure | |
| 969. |
Each tablespace in an Oracle database consists of one or more ï¬les called |
| A. | files |
| B. | name space |
| C. | dataï¬les |
| D. | pfile |
| Answer» D. pfile | |
| 970. |
What are the correct features of a distributed database? |
| A. | is always connected to the internet |
| B. | always requires more than three machines |
| C. | users see the data in one global schema. |
| D. | have to specify the physical location of the data when an update is done |
| Answer» D. have to specify the physical location of the data when an update is done | |
| 971. |
The ï¬le organization which allows us to read records that would satisfy the join condition by using one block read is |
| A. | heap ï¬le organization |
| B. | sequential ï¬le organization |
| C. | clustering ï¬le organization |
| D. | hash ï¬le organization |
| Answer» D. hash ï¬le organization | |
| 972. |
A unit of storage that can store one or more records in a hash ï¬le organization is denoted as |
| A. | buckets |
| B. | disk pages |
| C. | blocks |
| D. | nodes |
| Answer» B. disk pages | |
| 973. |
Which level of RAID refers to disk mirroring with block striping? |
| A. | raid level 1 |
| B. | raid level 2 |
| C. | raid level 0 |
| D. | raid level 3 |
| Answer» B. raid level 2 | |
| 974. |
Which one of the following is not a secondary storage? |
| A. | magnetic disks |
| B. | magnetic tapes |
| C. | ram |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 975. |
The surface area of a tape is                  the surface area of a disk. |
| A. | much lesser than |
| B. | much larger than |
| C. | equal to |
| D. | none of the mentioned |
| Answer» C. equal to | |
| 976. |
Which of the following is the oldest database model? |
| A. | relational |
| B. | hierarchical |
| C. | physical |
| D. | network |
| Answer» E. | |
| 977. |
The replacement of a bad block generally is not totally automatic because |
| A. | data in bad block cannot be replaced |
| B. | data in bad block is usually lost |
| C. | bad block does not contain any data |
| D. | none of the mentioned |
| Answer» C. bad block does not contain any data | |
| 978. |
Which of the following are the process of selecting the data storage and data access characteristics of the database? |
| A. | logical database design |
| B. | physical database design |
| C. | testing and performance tuning |
| D. | evaluation and selecting |
| Answer» C. testing and performance tuning | |
| 979. |
During recovery from a failure |
| A. | each pair of physical block is examined |
| B. | speciï¬ed pair of physical block is examined |
| C. | ï¬rst pair of physical block is examined |
| D. | none of the mentioned |
| Answer» B. speciï¬ed pair of physical block is examined | |
| 980. |
A magneto-optic disk is : |
| A. | primary storage |
| B. | secondary storage |
| C. | tertiary storage |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 981. |
A typical tape drive is                  a typical disk drive. |
| A. | more expensive than |
| B. | cheaper than |
| C. | of the same cost as |
| D. | none of the mentioned |
| Answer» B. cheaper than | |
| 982. |
Operating system is responsible for |
| A. | disk initialization |
| B. | booting from disk |
| C. | bad-bock recovery |
| D. | all of the mentioned |
| Answer» E. | |
| 983. |
                             which increases the number of I/O operations needed to write a single logical block, pays a signiï¬cant time penalty in terms of write performance. |
| A. | raid level 1 |
| B. | raid level 2 |
| C. | raid level 5 |
| D. | raid level 3 |
| Answer» B. raid level 2 | |
| 984. |
Tertiary storage is built with : |
| A. | a lot of money |
| B. | unremovable media |
| C. | removable media |
| D. | secondary storage |
| Answer» D. secondary storage | |
| 985. |
                       is popular for applications such as storage of log ï¬les in a database system since it offers the best write performance. |
| A. | raid level 1 |
| B. | raid level 2 |
| C. | raid level 0 |
| D. | raid level 3 |
| Answer» B. raid level 2 | |
| 986. |
Where performance and reliability are both important, RAID level          is used. |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 0+1 |
| Answer» E. | |
| 987. |
The RAID level which mirroring is done along with stripping is |
| A. | raid 1+0 |
| B. | raid 0 |
| C. | raid 2 |
| D. | both raid 1+0 and raid 0 |
| Answer» E. | |
| 988. |
                             partitions data and parity among all N+1 disks, instead of storing data in N-disks and parity in one disk. |
| A. | block interleaved parity |
| B. | block interleaved distributed parity |
| C. | bit parity |
| D. | bit interleaved parity |
| Answer» C. bit parity | |
| 989. |
With multiple disks, we can improve the transfer rate as well by                        data across multiple disks. |
| A. | striping |
| B. | dividing |
| C. | mirroring |
| D. | dividing |
| Answer» B. dividing | |
| 990. |
Optical disk technology uses |
| A. | helical scanning |
| B. | dat |
| C. | a laser beam |
| D. | raid |
| Answer» E. | |
| 991. |
Hybrid disk drives are hard-disk systems that combine magnetic storage with a smaller amount of flash memory, which is used as a cache for frequently accessed data. |
| A. | hybrid drivers |
| B. | disk drivers |
| C. | hybrid disk drivers |
| D. | all of the mentioned |
| Answer» C. hybrid disk drivers | |
| 992. |
The time for repositioning the arm is called the                  and it increases with the distance that the arm must move. |
| A. | access time |
| B. | average seek time |
| C. | seek time |
| D. | rotational latency time |
| Answer» D. rotational latency time | |
| 993. |
                   is around one-half of the maximum seek time. |
| A. | access time |
| B. | average seek time |
| C. | seek time |
| D. | rotational latency time |
| Answer» C. seek time | |
| 994. |
                   is the time from when a read or write request is issued to when data transfer begins. |
| A. | access time |
| B. | average seek time |
| C. | seek time |
| D. | rotational latency time |
| Answer» B. average seek time | |
| 995. |
In magnetic disk                  stores information on a sector magnetically as reversals of the direction of magnetization of the magnetic material. |
| A. | read–write head |
| B. | read-assemble head |
| C. | head–disk assemblies |
| D. | disk arm |
| Answer» E. | |
| 996. |
The disk controller uses                  at each sector to ensure that the data is not corrupted on data retrieval. |
| A. | checksum |
| B. | unit drive |
| C. | read disk |
| D. | readsum |
| Answer» B. unit drive | |
| 997. |
A Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â is the smallest unit of information that can be read from or written to the disk. |
| A. | track |
| B. | spindle |
| C. | sector |
| D. | platter |
| Answer» D. platter | |
| 998. |
There are “record-once†versions of the compact disk and digital video disk, which can be written only once; such disks are also called                      disks. |
| A. | write-once, read-many (worm) |
| B. | cd-r |
| C. | dvd-w |
| D. | cd-rom |
| Answer» B. cd-r | |
| 999. |
Optical disk                systems contain a few drives and numerous disks that can be loaded into one of the drives automatically (by a robot arm) on demand. |
| A. | tape storage |
| B. | jukebox |
| C. | flash memory |
| D. | all of the mentioned |
| Answer» C. flash memory | |
| 1000. |
The primary medium for the long-term online storage of data is the                      where the entire database is stored on magnetic disk. |
| A. | semiconductor memory |
| B. | magnetic disks |
| C. | compact disks |
| D. | magnetic tapes |
| Answer» C. compact disks | |