WorksheetsFinal Quiz
Total questions: 45
Worksheet time: 25mins
Primary Key can be null
True
False
Give the Cardinality ratio of the following
College _____________ Student
1:N
N:1
M:N
1:1
Tuples in a relation refers to
Attributes
Columns
Rows
Entities
A database schema is
A collection of attributes
A collection of rows
 collection of columns
A collection of tables
Which shape represents an Entity in ER Diagram
Square
Rectangle
Oval
Circle
What is the full form of DDL?
Data Demand Language
Data Definition Language
Data Dealing Language
Data Damage Language
DDL Commands include
CREATE TABLE
DELETE TABLE
DROP TABLE
ALTER TABLE
INSERT and SELECT are
(a)
Full form of DML is
Data Manager Language
Data Manufacturer Language
Data Manipulation Language
Data Multiplier Language
A set of attributes in a relation R which is used to uniquely identify a tuple in R
Alternate key
Candidate Key
Primary Key
Super key
A key which can uniquely identify a tuple in the relation R but is not primary key
Super Key
Candidate Key
Foreign Key
The underlined attribute in a relation represents the
(a)
Entity Integrity Constraint states that
Primary Key Value can be NULL
No Primary Key Value can be NULL
All Primary Key Values can be NULL
One Primary Key Value can be NULL
Referential Integrity Constraint is specified between
Two Relations
Two Attributes
Two Tuples
Two Databases
A value of Foreign Key in a tuple t1 of the relation R1 either
occurs as a value of Primary Key for some tuple t2 in the relation R2 or is NULL.
True
False
An Oval represents __________ in ER Diagram
Attribute
Weak entity
Strong Entiry
Derived Attribute
Diamond shape in an ER diagram represents
Attribute
Derived Attribute
Composite Attribute
Reletionship
Which of the following relationship types exist in ER diagrams
1 to 1
1 to N
N to 1
M to N
A multivalued attribute is shown by
(a)
A tree like structure can be made for
multivalued attributes
weak entities
strong entities
Composite attributes
ER diagrams represent the conceptual data model
True
False
Every relation R has at least one default (a) the set of all its attributes.
The minimal set of attribute which can uniquely
identify a tuple is known as .
(a)
What is the full form of SQL?
Strong Query Language
Structured Query Language
Structured Question Language
Strong Question Language
Which of the following is used to extract data from a database?
EXTRACT
GET
OPEN
SELECT
Which SQL statement is used to add a record in the database?
INSERT
ALTER
UPDATE
ADD
Which SQL statement is used to remove a record in the database?
REMOVE
DELETE
DROP
ERASE
Which SQL statement is used to delete a table?
DELETE TABLE
ERASE TABLE
CUT TABLE
DROP TABLE
The (a) Constraint states that no component of a primary key should be NULL.
Refrential Integrity Constraint is defined on
3 relations
1 relation
2 relations
Multiple relations
With SQL, how do you display values from a column named "EmpName" from a table named "Employee"?
Select EmpName from Employee
Display EmpName.from Employee
Select Employee.EmpName
Which operator is used to retrieve the data from the whole table?
@
&
$
*
SQL keywords are not case sensitive.
TRUE
FALSE
Which SQL statement is used to retrieve a unique record in the database table?
UNIQUE
DISTINCT
DIFFERENT
NO DUPLICATE
The SQL clause for displaying the output of the query in sorted order
(a)
Which expression will be used to display all names starting with "Ak"?
"%Ak%"
"A%k%"
"Ak%"
"A%k"
Which language is used to create and edit a database?
SQL
DDL
DML
DFL
The characteristics that describe an entity are called
(a)
It is used to return all the rows from multiple tables where the join condition is satisfied.
Outer Join
Full Join
Left Join
Inner Join
Which clause is used to retrieve values in a range?
(a)
Which keyword is used to generate the sequential values in a table column automatically?
(a)
Which of the following is used to insert the new record in the table?
Insert new
insert Add
Insert new record
insert into
Which SQL clause is used to display the table data into different categories based on a particular attribute type?
Order By
Categorize
Group Into
Group By
The three tiers of DBMS architecture are
Physical Level, Conceptual Level, External Level
Physical Level, Logical Level, External Level
Internal Level, Logical Level, External Level
Internal Level, Conceptual Level, External Level
For a relation to be in INF
All column values should be null
All column values should be not null
All column values should be atomic
All column values should be composite
