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),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Learning Mode Previous Next
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:
Q2 | ............... joins are SQL server default
Q3 | The ..................... is essentially used to search for patterns in target string.
Q4 | ................. requires that data should be made available to only authorized users.
Q5 | .............. is a combination of two of more attributes used as a primary key
Q6 | To delete a database ................... command is used
Q7 | Some of the utilities of DBMS are .............i) Transaction ii) Backup iii) File organization iv) Process Organization
Q8 | There are _________ number of Normal forms that has been defined
Q9 | The primary key must be
Q10 | Which of the following is not unary operation?
Q11 | Which is relation calculus:
Q12 | Which calculus is based on specifying a number of tuple variables:
Q13 | SQL outputs a single table known as the ______:
Q14 | If a piece of data is stored in two places in the database, then
Q15 | An audit trail ___________
Q16 | Large collection of files are called ____________
Q17 | Which of the following hardware component is the most important to the operation of adatabase management system?
Q18 | Which of the following is not true of the traditional approach to information processing
Q19 | The information about data in a database is called _______
Q20 | A data dictionary is a special file that contains?
Q21 | A relational database system needs to maintain data about the relations, such as theschema of the relations. This is called
Q22 | Relational schemas and other metadata about relations are stored in a structure calledthe ____________
Q23 | ___________ is the collection of memory structures and Oracle background processesthat operates against an Oracle database.
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.
Q25 | A tablespace is further broken down into ________
Previous Next