DBMS LAB QUIZ

The following are functions of a DBMS except

• Creating database
• Processing data
• Creating and processing forms
• Administrating database

A database management system (DBMS) is a:

• Software system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide uncontrolled access to a database
• Software system used to create, maintain, and provide uncontrolled access to a database

The term attribute refers to a ________ of a table

• Record
• Foreign key
• Primary key
• Field

The term _______ is used to refer a row

• Record
• Foreign key
• Primary key
• Field

Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?

• NAME
• ID
• CITY
• ID, NAME

which one of the following cannot be taken as a primary key?

• ID
• RegistrationNo
• DepartmentID
• Street

Which of the following is NOT Advantages of DBMS

• Increased data consistency 
• Reduced data redundancy
• Improved data security 
• Increase data isolation

What does the 'where' keyword do in SQL?

• 
  Orders the results in ascending order

• Adds up all the values in a field

• Counts the number of records in a table

• Specifies the condition to apply in a query

Which keyword is used to add up all the values in a field in SQL?

• Like

• Sum

• Select

• Count

Which keyword is used to filter results based on a range of values in SQL?

• In

• And

• Between

• Like