NEW
Font size
WorksheetsDATABASE MANAGEMENT CT-1
Total questions: 20
Worksheet time: 20mins
Which of the following best defines a database?
A collection of programs
A type of software
A collection of data
A type of computer
What is the primary function of a Database Management System (DBMS)?
Managing software installation
Data processing
Data storage and retrieval
Computer networking
In the context of database security, what does the term 'authentication' refer to?
Verifying user identity
Encrypting data
Ensuring data is not corrupted
Backing up data
Which of the following best describes an attribute in an ER model?
A characteristic or property of an entity
A link between entities
A primary key
A type of relationship
Which type of data can be stored in the database?
Image oriented data
Text, files containing data
Data in the form of audio or video
All of the above
In which of the following formats data is stored in the database management system?
Image
Text
Table
Graph
Which of the following is not a feature of DBMS?
Minimum Duplication and Redundancy of Data
High Level of Security
Single-user Access only
Support ACID Property
The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.
Referential
Primary
Referencing
Specific
The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.
Data and the DBMS
Application and SQL
The user and the software
Database application and the database
The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________
TCL (Transaction Control Language)
DML (Data Manipulation Langauge)
DDL (Data Definition Langauge)
DCL (Data Control Language)
______________ is a set of one or more attributes taken collectively to uniquely identify a record.
Primary Key
Foreign key
Super key
Candidate key
Which command is used to remove a relation from an SQL?
Delete
Drop table
Purge
Remove
The traditional storage of data organized by the customer, stored in separate folders in filing cabinets is an example of ______________ type of ‘database’ management system.
Object-oriented database management system
Relational database management system
Network database management system
Hierarchical database management system
The logical design, and the snapshot of the data at a given instant in time is known as?
Instance & Relation
Relation & Schema
Domain & Schema
Schema & Instance
What do you mean by one to many relationships?
One class may have many teachers
One teacher can have many classes
Many classes may have many teachers
Many teachers may have many classes
What is the purpose of the SQL command EXPLAIN?
To document the structure of the database
To describe the syntax of SQL commands
To provide a detailed execution plan of a query
To correct errors in SQL queries
In SQL, how can you modify an existing table to add a foreign key constraint referencing another table?
ALTER TABLE table_name ADD FOREIGN KEY (column_name) REFERENCES other_table
ALTER TABLE table_name MODIFY COLUMN column_name FOREIGN KEY REFERENCES other_table(column_name)
ALTER TABLE table_name ADD CONSTRAINT fk_name FOREIGN KEY (column1) REFERENCES other_table(column2)
USE table_name ADD FOREIGN KEY REFERENCES other_table
Procedural language among the following is __________
Query language
Tuple relational calculus
Domain relational calculus
Relational algebra
After groups have been established, SQL applies predicates in the ___________ clause, allowing aggregate functions to be used.
Group by
Where
With
Having
What is the function of the following command?
Delete from r where P;
Clears entries from relation
Deletes relation
Deletes particular tuple from relation
All of the mentioned
