/31
In which of the following formats data is stored in the database management system?
Table stores data
Image
Text
Table
Graph
/31
Which of the following is not a type of database?
Hierarchical
Network
Distributed
Decentralized
/31
Which of the following is not an example of DBMS?
MySQL
Microsoft Access
IBM DB2
Google
/31
Which of the following is a feature of DBMS?
Minimum Duplication and Redundancy of Data
High Level of Security
Single-user Access only
Support ACID Property
/31
Which of the following is a feature of the database?
No-backup for the data stored
Lack of Authentication
User interface provided
Store data in multiple locations
/31
Which of the following is not a function of the database?
Managing stored data
Manipulating data
Security for stored data
Analysing code
/31
Which of the following is a function of the DBMS?
Storing data
Providing multi-users access control
Data Integrity
All of the above
/31
Which of the following is a component of the DBMS?
Data
Data Languages
Data Manager
All of the above
/31
Which of the following is known as a set of entities of the same type that share same properties, or attributes?
Relation set
Tuples
Entity set
Entity Relation model
/31
What is information about data called?
Hyper data
Tera data
Meta data
Relations
/31
What does an RDBMS consist of?
Collection of Records
Collection of Keys
Collection of Tables
Collection of Fields
/31
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
/31
_____________ is a hardware component that is most important for the operation of a database management system.
Microphone
High speed, large capacity disk to store data
High-resolution video display
Printer
/31
The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.
Data and the DBMS
Application and SQL
Database application and the database
The user and the software
/31
The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________
TCL (Transaction Control Language)
DCL (Data Control Language)
DDL (Data Definition Langauge)
DML (Data Manipulation Langauge)
/31
______________ is a set of one or more attributes taken collectively to uniquely identify a record.
Primary Key
Foreign key
Super key
Candidate key
/31
Which command is used to remove a relation from an SQL?
Drop table
Delete
Purge
Remove
/31
Which of the following set should be associated with weak entity set for weak entity to be meaningful?
Neighbour set
Strong entity set
Owner set
Identifying set
/31
Which of the following command is correct to delete the values in the relation teaches?
Delete from teaches;
Delete from teaches where Id =’Null’;
Remove table teaches;
Drop table teaches;
/31
Procedural language among the following is __________
Domain relational calculus
Tuple relational calculus
Relational algebra
Query language
/31
_________________ operations do not preserve non-matched tuples.
Left outer join
Inner join
Natural join
Right outer join
/31
Which forms have a relation that contains information about a single entity?
4NF
2NF
5NF
3NF
/31
The top level of the hierarchy consists of ______ each of which can contain _____.
Schemas, Catalogs
Schemas, Environment
Environment, Schemas
Catalogs, Schemas
/31
_______ indicates the maximum number of entities that can be involved in a relationship.
Greater Entity Count
Minimum cardinality
Maximum cardinality
ERD
/31
The user IDs can be added or removed using which of the following fixed roles?
db_sysadmin
db_accessadmin
db_securityadmin
db_setupadmin
/31
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
/31
After groups have been established, SQL applies predicates in the ___________ clause, allowing aggregate functions to be used.
Where
Having
Group by
With
/31
Which of the following is not the utility of DBMS? i) Backup ii) Loading iii) Process Organization iv) File organization
i, ii, and iv only
i, ii and iii only
i, iii and iv only
All i, ii, iii, and iv
/31
What does a foreign key combined with a primary key create?
Network model between the tables that connect them
Parent-Child relationship between the tables that connects them
One to many relationship between the tables that connects them
All of the mentioned
/31
Which of the following is correct according to the technology deployed by DBMS?
Pointers are used to maintain transactional integrity and consistency
Cursors are used to maintain transactional integrity and consistency
Locks are used to maintain transactional integrity and consistency
Triggers are used to maintain transactional integrity and consistency
/31
Which of the following is correct regarding the file produced by a spreadsheet?
can be used as it is by the DBMS
stored on disk in an ASCII text format
all of the mentioned
none of the mentioned
You got {number correct} / 7 answers correct, your score is {percent correct}% / 100
Not so good. We hope you'll learn more so that you can live a healthier life!
You got {number correct} / 7 answers correct, your score is {percent correct}% / 100
Well done! We hope you apply your knowledge to your own health!