NEW
Font size
WorksheetsDBMania Finale
Total questions: 30
Worksheet time: 10mins
Who created the first DBMS?
Edgar Frank Codd
Charles Bachman
Charles Babbage
Sharon B. Codd
Identify this Database
My SQL
Oracle
Maria
Cassandra
What is information about data called?
Terraform
Metadata
Blackbox data
Test data
What does an RDBMS consist of?
Collection of Tables
Collection of Records
Collection of Fields
Collection of Keys
The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.
Data and the Database
Application and SQL
The user and the software
Database application and the database
Is the NULL pointer same as an uninitialized pointer?
True
False
Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?
DML (Data Manipulation Language)
DDL (Data Definition Language)
Query
Relational Schema
Which one of the following given statements possibly contains the error?
select * from emp where empid = 10003;
select empid where empid = 1009 and Lastname = 'GELLER';
select empid from emp where empid = 10006;
select empid from emp;
A Database Management System is a type of _________ software.
System Software
Application Software
General Software
Generic Software
A huge collection of the information or data accumulated form several different sources is known as
Data Management
Data Mining
Data Center
Data Warehouse
Functions in C Language are always
Internal
External
External and Internal are not valid terms for functions
Both Internal and External
Which one of the following attribute can be taken as a primary key?
Name
ID
Street
Department
The field 'Title' will contain the following options: 'Mr', 'Mrs', 'Miss', 'Ms', 'Other'. Which of the following options would be the most suitable field length to set up?
2
5
4
3
Which one of the following is a type of Data Manipulation Command?
Create
Alter
Delete
All the above
Which of the following commands is used to save any transaction permanently into the database?
Commit
Rollback
Save
Freeze
Which keyword is used to prevent any changes in the variable within a C program?
immutable
mutable
const
volatile
What will be the value of the following Python expression 4 + 3 % 5
2
7
4
1
Which of the following keys is generally used to represents the relationships between the tables?
Primary Key
Candidate Key
Surrogate Key
Foreign Key
The term "ODBC" stands for_____
Oral database connectivity
Oracle database connectivity
Open database connectivity
Object database connectivity
Which one of the following keyword is used to find out the number of values in a column?
TOTAL
SUM
ADD
COUNT
What are the elements present in the array of the following C code?
int array[5] = {5};
5, 5, 5, 5, 5
(garbage), (garbage), (garbage), (garbage), 5
5, (garbage), (garbage), (garbage), (garbage)
5, 0, 0, 0, 0
Which of the following is not a NoSQL database?
SQL Server
MongoDB
Cassandra
RedisDB
Which of the following is a wide-column store?
MariaDB
Cassandra
CouchDB
Oracle
________ stores are used to store information about networks, such as social connections.
Key-value
Wide-column
Document
Graph
Initial release of MongoDB was in the year?
2008
2009
2010
2011
Pick the odd one out
MySQL
MariaDB
PostgreSQL
Aurora
What is the meaning of the following C statement?
10 spaces before the string state is printed
Print empty spaces if the string state is less than 10 characters
Print the last 10 characters of the string
None of the mentioned
Which of the following is a type of cloud computing service?
Service-as-a-Software (SaaS)
Software-and-a-Server (SaaS)
Software-as-a-Service (SaaS)
Software-as-a-Server (SaaS)
Most NoSQL databases support automatic __________ meaning that you get high availability and disaster recovery.
processing
scalability
replication
fault tolerance
Which of the following is the most refined and restrictive cloud service model?
PaaS
IaaS
SaaS
CaaS
