Database Management System Set 38
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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