On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 38

Q1 | Which is a duplicate copy of a file program that is stored on a different storagemedia than the original location:
  • Concurrency
  • Deadlock
  • Backup
  • Recovery
Q2 | ............... joins are SQL server default
  • Outer
  • Inner
  • Equi
  • None of the above
Q3 | The ..................... is essentially used to search for patterns in target string.
  • Like Predicate
  • Null Predicate
  • In Predicate
  • Out Predicate
Q4 | ................. requires that data should be made available to only authorized users.
  • Data integrity
  • Privacy
  • Security
  • None of the above
Q5 | .............. is a combination of two of more attributes used as a primary key
  • Composite Key
  • Alternate Key
  • Candidate Key
  • Foreign Key
Q6 | To delete a database ................... command is used
  • delete database database_name
  • Delete database_name
  • drop database database_name
  • drop database_name
Q7 | Some of the utilities of DBMS are .............i) Transaction ii) Backup iii) File organization iv) Process Organization
  • i, ii, and iv only
  • i, ii and iii only
  • ii, iii and iv only
  • All i, ii, iii, and iv
Q8 | There are _________ number of Normal forms that has been defined
  • 5
  • 6
  • 4
  • 3
Q9 | The primary key must be
  • Unique
  • Not Null
  • Both A & B
  • None of these
Q10 | Which of the following is not unary operation?
  • Select
  • Union
  • Project
  • Rename
Q11 | Which is relation calculus:
  • Tuple relational calculus
  • Domain relational calculus
  • Both
  • None
Q12 | Which calculus is based on specifying a number of tuple variables:
  • Tuple relation calculus
  • Domain relational calculus
  • Both
  • None
Q13 | SQL outputs a single table known as the ______:
  • View
  • Column
  • Tablespace
  • Result set
Q14 | If a piece of data is stored in two places in the database, then
  • Storage space is wasted
  • Changing the data in one spot will cause data inconsistency
  • In can be more easily accessed
  • Storage space is wasted & Changing the data in one spot will cause data inconsistency
Q15 | An audit trail ___________
  • Is used to make backup copies
  • Is the recorded history of operations performed on a file
  • Can be used to restore lost information
  • None of the mentioned
Q16 | Large collection of files are called ____________
  • Fields
  • Records
  • Database
  • Sectors
Q17 | Which of the following hardware component is the most important to the operation of adatabase management system?
  • High resolution video display
  • Printer
  • High speed, large capacity disk
  • Mouse
Q18 | Which of the following is not true of the traditional approach to information processing
  • There is common sharing of data among the various applications
  • It is file oriented
  • Programs are dependent on the file
  • It is inflexible
Q19 | The information about data in a database is called _______
  • Metadata
  • Hyper data
  • Tera data
  • None of the mentioned
Q20 | A data dictionary is a special file that contains?
  • The names of all fields in all files
  • The data types of all fields in all files
  • The widths of all fields in all files
  • All of the mentioned
Q21 | A relational database system needs to maintain data about the relations, such as theschema of the relations. This is called
  • Metadata
  • Catalog
  • Log
  • Dictionary
Q22 | Relational schemas and other metadata about relations are stored in a structure calledthe ____________
  • Metadata
  • Catalog
  • Log
  • Data Dictionary
Q23 | ___________ is the collection of memory structures and Oracle background processesthat operates against an Oracle database.
  • Database
  • Instance
  • Tablespace
  • Segment
Q24 | A ________ is a logical grouping of database objects, usually to facilitate security,performance, or the availability of database objects such as tables and indexes.
  • Tablespace
  • Segments
  • Extents
  • Blocks
Q25 | A tablespace is further broken down into ________
  • Tablespace
  • Segments
  • Extents
  • Blocks