WorksheetsRDBMS/SQL
Total questions: 20
Worksheet time: 10mins
In Select Statement do we choose Row Name or Column Name
Row Name
Column Name
A or B
A & B
--------- is a Horizontal entity in a table
Row
Column
Record
A or C
Data in RDBMS is stored in database object called
Query
Tables
Database Backend
Zoho
varchar(), char(), text(), longtext(). what are these words?
keys
constraints
datatypes
clauses
we have three databases, i.e., sakila_db, world_db, customer_db. If you want to work with 'world_db", which query will you write to select that particular database?
select world_db;
choose world_db;
use world_db;
show world_db;
_____ is used to filter out the data by applying condition on grouped data.
where
from
having
order by
____ is the clause which we use to choose the required data in the OUTPUT from the original table.
select
where
group by
drop, truncate, create are the commands of DDL?
True
False
Which option is not the command of DML ?
insert
update
alter
delete
_____ is the logical skeleton of the database
Views
Tables
database
schema
Is images and videos being the example of the Structured data?
Yes
No
What kind of database we and SQL will be mostly deal with ?
Hierarchical Database
Network Database
Relational Database
Object oriented database
In an ER diagram, Entity types are represented by
rectangle
ellipse
diamond box
circle
What database level is closest to the user
External
Internal
Physical
Conceptual
In ER diagram relationship type is represented by
Ellipse
Dashed Ellipse
Rectangle
Diamond
An advantage of DBMS approach is
data is dependent on programs
data redundancy increases
data can be integrated and can be accessed by multiple programs
none of the above
A relational database developer refers to a record as
Criteria
a relation
a tuple
an attribute
A logical Schema
is the entire database.
is a standard way of organizing the information into accessible parts.
describes how data actually stores on the disc
options 1 & 3
In an ER diagram, attributes are represented by?
Rectangle
Square
Ellipse
Triangle
In the architecture of the Database System, external level is the
Physical level
Logical level
Conceptual level
View level
