Study Basics of Database Management System Online MCQ Practice Set for your academic course and prepare for your exam and online assignments. You can give online FREE Quiz and test your knowledge on OMCQ portal.
After Practice of MCQ, you can give Online Quiz Test for Basics of Database Management System
Question: A command that lets you cange one or more fields in a record is
A. InsertB. Modify
C. Look up
D. All of the above
View Answer
Question: A computer language for informing the DBMS regarding the data structure used is
A. PASCALB. DDL
C. PROLOG
D. FORTRAN
View Answer
Question: A data item, which is not broken down into smaller units, is
A. Data elementB. Elementary data item
C. Data entry
D. Database management
View Answer
Question: A data structure consisting of several fields, some or all of which are instances of the same data structure, is called
A. FieldB. Bead
C. Database
D. Data collection
View Answer
Question: A database that contains tables linked by common fields is called a
A. Centralized databaseB. Flat file database
C. Relational database
D. None of above
View Answer
Question: A field that uniquely identifies a record is called a
A. Main fieldB. Header
C. Key field
D. None of above
View Answer
Question: A file containing relatively permanent data is
A. Random fileB. Transaction file
C. Master file
D. Sequential file
View Answer
Question: A form that is used to collect data in a structured manner for entry to a database is called a
A. Database deign formB. Systems flowchart
C. Data capture form
D. None of above
View Answer
Question: A good query system
A. Can accept English language commandsB. Allows non-programmers to access information stored in a database
C. Can be accessed only by data prssing professionals
D. Both (A) and (B)
View Answer
Question: A group of characters used to identiry a given low level instruction is
A. FileB. Record
C. Key field
D. Label
View Answer
Question: A large collections of files are called
A. FieldsB. Records
C. Databases
D. File system
View Answer
Question: A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be
A. The pin codeB. The last name
C. A compound key consisting of the first name and the last name
D. All of the above
View Answer
Question: A logical schema
A. Is the entire databaseB. Is a standard way of organizing information into accessible parts
C. Describes how data is actually stored on disk
D. All of the above
View Answer
Question: A notation for defining the form and structure of data is known as
A. Data description languageB. Binary language
C. Data channels
D. Data definition language
View Answer
Question: A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As
A. TablesB. Relations
C. Tuple
D. Both (A) and (B)
View Answer
Question: A report form
A. Appears on the computer monitor during data entryB. Is used during report generation to format data
C. Both (A) and (B)
D. All of above
View Answer
Question: A repository for data, usually covering some specific topic is called
A. Data acquisitionB. Data bank
C. Real time
D. Database
View Answer
Question: A repository for data, usually covering specific topic is
A. DatabaseB. Data requisition
C. Data bank
D. Data collection
View Answer
Question: A set of programs that handle firm’s database responsibilities is called a
A. Database Management System (DBMS)B. Database Processing System (DBPS)
C. Data Management System (DMS)
D. All of above
View Answer
Question: A specialist in charge of the database of an organization select the best fit for answer
A. Database management approachB. DBMS uses
C. Database administrator
D. Query language
View Answer
Important note for exam preparation: Must try Online MCQ Quiz Test after practice these MCQ, so you can check your knowledge and improve efficiency. You can get link from above mention for these subjects.