Database Management System Quiz Flashcards
Who created the first DBMS
Charles Bachman
database is collection of ________
Columns
Most popular commercial DBMS
Oracle
DBMS is what type of software ?
It is a type of system software
What is data about data
Meta data
Relational Calculus is what type of language
Non -procedural language
Which of the following is procedural language
Relational Algebra
cardinality is termed as
number of tuples
In a relation database, every tuples divided into fields are known as ________
Domains
What are different views to represent a Table
Design View, Datasheet View, Pivot Table View
What are types of database
Relational, Object Database, NoSql, Hierarchical, Centralized, Operational, Cloud, Network, Distributed
Which command is used to remove a relation from SQL
Drop Table
Report Generators are used to
Retrieve information from files, Answer queries
Tell types of SQL commands and all commands that come under it
- DDL : Create, Alter, Drop, Truncate, Rename
- DML : Select, Insert, Update, Delete
- DCL : Grand, Revoke
- TCL: Commit, Rollback, Saveprint
External Database is
Database Created using DBMS package
Which command creates and initializes one or more memory variables ?
STORE
What are types of Intigrity constraint
- Domain Constraint (Attributes are of same considered datatype)
- Entity Integrity Constraint (Not null like primary key)
- Referential Integrity Constrain (related to foreign key)
- Key Constraint (Unique like id, addhar no.)
Steps of transaction Processing Cycle
- Data Entry
- Transaction Processing
- Database Management
- Transaction Validation
- Commit or Rollback
- Output Generation
- Transaction End
What does data dictionary Identify
field types, field names, field formats, field constraints, field descriptions, field
Minimum size that is supported by FAT
4 GB
Maximum size that is supported by NTFS ?
4 GB
Which command is used to save any transaction permanently into database
Commit
Which field has width of 8 bytes
Data/Time
Properties of Transaction, meaning of each property
Atomicity : Either all commands are performed or none
Consistency : Data is in consistent state when transaction starts and ends
Isolation : Transactions that run concurrently appear to be serialized
Durability : Once change is done in db it should be permanent
