Database Fundamentals and SQL
Questions covering basic database concepts, SQL commands, schema design, and transaction management
Questions
Question 1 Multiple Choice (Single Answer)
________ is the authorisation command of SQL.
- Authorise
- Grant
- Allow
- Access
- Permit
Question 2 Multiple Choice (Single Answer)
A view is basically a/an
- database
- table
- entity relationship diagram
- virtual table
- schema
Question 3 Multiple Choice (Single Answer)
Which of the following symbols represents a weak entity set?
- Ellipse
- Double outlined rectangle
- Diamond
- Rectangle
- Line
Question 4 Multiple Choice (Single Answer)
The overall structure of a table is known as
- schema
- table
- view
- database
- record
Question 5 Multiple Choice (Single Answer)
Which of the following commands is/are used to terminate transactions?
- STOP TRANSACTION
- COMMIT and ROLLBACK TRANSACTION
- Only by COMMIT TRANSACTION
- Only by ROLLBACK TRANSACTION
- END TRANSACTION
Question 6 Multiple Choice (Single Answer)
Which of the following operations increases the length of a list?
- INSERT
- DELETE
- ALTER
- LOOKUP
- ADD
Question 7 Multiple Choice (Single Answer)
A top to bottom relationship among the items in a database is established by
- entity relation schema
- relational schema
- top down schema
- hierarchical schema
- stair schema
Question 8 Multiple Choice (Single Answer)
Which of the following defines the external view?
- Sub schema
- Schema
- View
- Table
- Trigger
Question 9 Multiple Choice (Single Answer)
The store procedure that is automatically fired is called
- view
- cursor
- transaction
- trigger
- database
Question 10 Multiple Choice (Single Answer)
Who is responsible for the consistency of a database?
- Database administrator
- Database end user
- Transaction manager
- Database designer
- Software designer