What is a database?
- aA system that operates the data
- bA system that stores the data
- cA program that controls users
- dA type of hardware device
124 questions · 18 sections
What is a database?
What is the system that operates the database called?
For many ages, by what means did mankind keep track of data before computers?
Which is a prime example of multiple facets of database management system usage?
Which of the following educational activities require data to be computed and stored?
What is the main advantage of computers over pen and paper for handling data?
When a computer program works with data, where does it put them first?
What is the volatile memory of a computer known as?
What happens to RAM data when the computer is shut down?
Through which system is data in the hard disk drive accessed?
Why does data management become tedious when using only a file system?
In the realm of computer science, a database is best described as a software that can —
In a broader sense, a database can be of which two types?
About how many years ago was the concept of relational databases developed?
Which statement about NoSQL databases is correct?
In relational databases, data is stored in —
A database table has which two parts?
What does a table header contain?
Each row of a database table is also known as a —
Each cell in a database table is known as a —
Which of the following data types are common to almost every database?
Which of the following relational database systems are free and open source?
Why can the same type of information usually be put into the same table?
What value is used when a record's value in the database is unknown?
If a student has no phone number, what should be done with that record?
If a record is kept blank, how does the database treat it?
What is a primary key?
When multiple columns are combined to create a primary key, it is called a —
Why can a student's name not serve as a primary key?
In regular practice, what column is added to serve as the primary key when no suitable column exists?
What does the auto increment attribute do?
In a relational database, what is true about every table and primary key?
Which can be used as the primary key for a database of all adult persons in Bangladesh?
Consider the student table:
What is a database relation?
Database relations can be of how many types?
Which of the following is a type of database relation?
In a one to one relation, a row from one table can have a relation to —
When the primary key of one table is used in another table, it is known as a —
What creates the relation between two tables?
In the result table where one student (roll 1) has results in two subjects across two rows, what relation exists with the student_info table?
When one row of a table relates to multiple rows of a second table AND one row of the second relates to multiple rows of the first, the relation is —
To establish a many to many relationship between student_info and club tables, what is needed?
In the club table, why is 'Name' chosen as the primary key?
What does SQL stand for?
SQL is used in relational databases to —
Why is SQL known as a declarative language?
C and C-like programming languages are known as —
SQL is mainly divided into which two important parts?
What is DDL (Data Definition Language) primarily used for?
What is DML (Data Manipulation Language) used for?
Consider the following about SQL:
Which database is free, open source and easier to learn, used in web, desktop and mobile applications?
Which of the following are GUI software for using SQLite easily?
To create a new database named school in SQLite from the terminal, which command is used?
create school.dbsqlite3 school.dbnew school.dbopen school.dbTo close the SQLite software from the terminal, what command is typed?
.exit.close.quit.stopWhich query is used to create a table?
MAKE TABLECREATE TABLENEW TABLEBUILD TABLEWhat is the correct syntax to create a table?
CREATE TABLE table_name (column_name column_type, ...);CREATE TABLE (column_name) table_name;TABLE CREATE table_name column_type;CREATE (table_name) column_type;Which query is used to delete a table?
DELETE TABLEREMOVE TABLEDROP TABLECLEAR TABLEWhich query is used to store (insert) data into a table?
ADDINSERTPUTSTOREWhich query is used to retrieve data from a table?
GETFETCHSELECTRETRIEVEWhat does the query SELECT * FROM student; do?
Which clause is used to add conditions while retrieving data with SELECT?
IFWHEREWHENHAVINGWhat does the <> operator mean in an SQL condition?
While working with text type data in a condition, what must be used?
Which operators are used to combine multiple conditions in a query?
What does SELECT * FROM student WHERE class = 9 AND section = 'morning'; retrieve?
Which query retrieves students that are in Class 8, 9 or 10?
SELECT * FROM student WHERE class IN (8, 9, 10);SELECT * FROM student WHERE class = 8, 9, 10;SELECT * FROM student WHERE class BETWEEN 8 10;SELECT * FROM student WHERE class = (8 9 10);Which query is used to remove a record from a table?
DROPDELETEREMOVECLEARWhich query is used to change or edit an existing record?
EDITMODIFYUPDATECHANGEThe operation of retrieving data from multiple related tables at once is called a —
In a join query, why is result.roll written instead of just roll?
In the query SELECT name, result.roll, subject, marks FROM result, student_info WHERE result.roll = student_info.roll;, which part joins the two tables?
SELECT nameresult.roll = student_info.rollFROM result, student_infosubject, marksBy tradition, in what case are SQL keywords usually written?
Why is database security a vital issue?
To ensure there is no data loss, what should be done?
Erroneous data caused by hardware, software or network issues is known as —
Why are backups usually stored in separate physical drives?
Why are data centers usually located in different geological locations?
How is a database protected from malicious cyber attacks at the basic level?
Consider the following about database security:
The branch of computer science that deals with data encryption is known as —
Which Roman emperor used to encode his letters so only the receiver could decode them?
What is the original (unencrypted) data called?
What is the encrypted data called?
Encoding the original data is the responsibility of the —
Encryption systems are mainly of which two types?
In symmetric key cryptography, how many keys are used and who holds them?
Which of the following are downfalls of symmetric key cryptography?
In asymmetric key cryptography, each user generates —
If A sends data to B in asymmetric key cryptography, with whose key is the data encrypted?
In asymmetric cryptography, data encrypted with B's public key can be decrypted only with —
Who first proposed the concepts of a relational database?
How many characteristics did Codd mention that must be present in any relational database?
In an RDBMS, every data of the database is stored as a —
Consider these characteristics of an RDBMS:
Regarding where the database stores its data —
Where is national ID information stored?
Which of the following use relational databases to manage their data?
What does ERP stand for?
Which of the following are common ERP modules?
What is one of the main challenges of an ERP system in large corporations?
What problem can improper use or non-use of databases cause among government organizations?
Why do citizens have to refill the same information for passport or driving licence registration?
What is a great use of databases in government institutions for the future?
Consider the main challenges of database management in government organizations:
What is the process used to convert root data into another format?
Which data field can be sorted?
The principal of a college stored all college data into a database and a list of weak students was derived. What was the method of the listing?
Because of the principal's decision to create a database —
To find out who got GPA = 5.00 from the Student table, complete the query: SELECT NAME FROM Student ...
WHERE "GPA" = "5.00"WHERE "GPA", "5.00"WHERE GPA = 5.00WHERE GPA is 5.00What is the relation between primary key and foreign key?
What is the main responsibility of a Database Management System?
What is the purpose of a query command?
How can a relation be created between a Teacher's table and a Routine table that share TID?
Three students searched a results database; the third was fastest. What strategy makes searching fastest?
What type of database is used to store NID information?
For a voter list storing name, father's name, religion, birth date and location, which data types are appropriate?
What is the difference between a primary key and a foreign key?
Saitama and Boros must find people with salary 30000 or more from two tables. Boros used a conditional statement but took more time; Saitama suggested creating another file. What is the trade-off of Saitama's solution?
To insert a new column titled 'address' between Roll and DOB in an existing table, which is true?
Two tables share a Roll column where one table holds Name/Roll/DOB/Tuition Fee and the other holds Roll/Subject/Number/GPA. What relation can be created?
After indexing a database, why do INSERT, UPDATE, DELETE commands take more time?
Why is SQL such an important database tool?