Font size
WorksheetsDBMS
Total questions: 45
Worksheet time: 22mins
Which of the following is a property of database
Represents some aspect of the real world
Logically related collection of data
Built, and populated with data for a specific purpose
All the above
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
The database and DBMS software together is called a ________________
Database system
Data Model
Application Program
System software
Who is responsible for authorizing access to the database, coordinating and monitoring its use
Database programmer
System Analyst
DBA
Specialised user
What is the full form of DBMS?
Data of Binary Management System
Database Management System
Database Management Service
Data Backup Management System
Procedural language among the following is __________
Domain relational calculus
Tuple relational calculus
Relational algebra
Query language
The database schema written in
HLL
DML
DDL
DCL
Data about data is normally termed as:
Directory
Data Bank
Meta data
none of these
Collection of information stored in a Database at a particular moment is:
View
Schema
instance
None of these
An Association between Student and a course is:
1:1 relationship
1:M relationship
M:N relationship
None of these
This is a level of the DBMS architecture that is the "top level" and it is also called the "view level" because several users can view their desired data from this level, which is internally fetched from the database with the help of conceptual and internal level mapping.
EXTERNAL LEVEL
CONCEPTUAL LEVEL
INTERNAL LEVEL
This is a level of the DBMS architecture that is also called the logical level. The whole design of the database, such as relationships among data, schema of data, etc., is described at this level.
EXTERNAL LEVEL
CONCEPTUAL LEVEL
INTERNAL LEVEL
This is a level of the DBMS architecture that is also known as the physical level because it describes how the data is actually stored in the storage devices. This level is also responsible for allocating space to the data, and this is the lowest level of the architecture.
EXTERNAL LEVEL
CONCEPTUAL LEVEL
INTERNAL LEVEL
The result of combining, comparing, and performing calculations from raw material
Data
Information
Database Management
______________ is a raw material from which you can draw conclusions
Data
Information
A relational database stores information in tables with rows and columns
True
False
____________ is a software that controls the storage, organization, and retrieval of data
DBMS
Databse
Data
Which of the following statements contains an error?
Select * from emp where empid = 10003;
Select empid from emp where empid = 10006;
Select empid from emp;
Select empid where empid = 1009 and lastname = ‘GELLER’;
To remove a relation from an SQL database, we use the ______ command.
delete
drop
remove
none of these
can a primary key be null
yes
no
A ____________ refers to the data files that contains records, which have a small, fixed number of fields, without any structured relationship.
Flat file database
Relational database
All the _______________ in a table are called fields.
rows
columns
cells
The rows in a table are called _______________.
data
records
queries
A database stores a vast amount of data, but _____________ helps us to retrieve the filtered data based upon some conditions.
forms
reports
queries
_____________ are the user friendly interfaces that facilitates the process of entering data in tables and queries.
Fields
Form
Report
CREATE TABLE employee (name VARCHAR, id INTEGER)
What type of statement is this?
DML
DDL
View
Integrity constraint
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
How do we select all rows for the "Design" table?
SELECT * FROM Design
SELECT [All] FROM Design
SELECT star from Design
SELECT FROM Design
In the given query which of the keyword has to be inserted?
INSERT INTO employee _____ (1002,'Joey',2000);
table
values
from
relation
Identify the following the correct way/s to delete all rows at a time from salary table.
DELETE * FROM salary;
TRUNCATE TABLE salary;
DELETE FROM SALARY;
TRUNCATE TABLE FROM salary;
Which one of the following is commonly used to define the overall design of the database?
Application program
Data definition language
Schema
Source code
A Relational database consists of a collection of
Tables
Fields
Records
Keys
In relational model, the row of table is known to be ?
Relation
Entity field
Tuple
Attribute
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
The union of primary keys of the related entity sets becomes a -------------------------- of the relation ?
Super Key
Candidate key
Foreign key
Primary key
By default the UPDATE SQL clause can _____________
update only one row at a time
update more than one row at a time
delete more than one row at a time
delete only one row at a time
Which one of the following cannot be taken as a primary key?
Student_Id
Register_number
Dept_id
Street_name
The command used to delete a particular column in a relation is ____________
A.UPDATE TABLE
B.TRUNCATE COLUMN
C.ALTER , DROP
D.DELETE COLUMN
SELECT * FROM cars WHERE Doors > 3
would return how many records?
1
2
3
4
SELECT * FROM Students WHERE Gender="Female" AND Class=2.2
would return how many records?
1
2
3
4
With SQL, how can you insert a new record into the "Persons" table?
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
A data analyst wants to retrieve only records from a database that have matching values in two different tables. Which JOIN function should they use?
LEFT JOIN
RIGHT JOIN
OUTER JOIN
INNER JOIN
A list of the attributes we wish to appear in the result is displayed in ___ operation.
Select
Project
Union
Rename
![COMPUTER NETWORKS [LEC] - UAC PREPARATION](https://cf.quizizz.com/image/image-loader.svg)
