NEW
Font size
WorksheetsDBMS Quiz
Total questions: 20
Worksheet time: 10mins
The given Query can also be replaced with_______.
SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID;
Select name,course_id from teaches,instructor where instructor_id=course_id;
Select name, course_id from instructor natural join teaches;
Select name, course_id from instructor;
Select course_id from instructor join teaches;
Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?
DML(Data Manipulation Language)
Query
Relational Schema
DDL(Data Definition Language)
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 from emp where empid = 10006;
select empid from emp;
select empid where empid = 1009 and Lastname = 'GELLER';
A RDBMS consists a collection of ?
Tables
Fields
Records
Keys
The term attribute refers to a ___________ of a table.
Record
Tuple
Column
Key
In relational model, the row of table is known to be ?
Relation
Entity field
Tuple
Attribute
Address field of a person should not be part of primary key, since it is likely to ?
Dependent
Too long
Changed
Not changed
The relational model is concerned with ?
Data structure and Data integrity
Data Manipulation
Both A and B
None of these
Which is the false statement from the following ?
A veiw is a named derived table
A name relation is variable
A veiw is a named reation and is virtual
None of these
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
What is the full form of RDBMS ?
Database Management system
Right Database Management System
Relational Rapid Database Management System
Route Database Management System
Ready the Query carefully:
SELECT emp_name FROM department WHERE dept_name LIKE ' _____ Computer Science';
In the above-given Query, which of the following can be placed in the Query's blank portion to select the "dept_name" that also contains Computer Science as its ending string?
&
_
%
$
A Database Management System is a type of _________software.
It is a type of system software
It is a kind of application software
It is a kind of general software
Both A and C
A huge collection of the information or data accumulated form several different sources is known as ________:
Data Management
Data Mining
Data Warehouse
Both B and C
Which of the following can be used to extract or filter the data & information from the data warehouse?
Data redundancy
Data recovery tool
Data mining
Both B and C
Which one of the following refers to the "data about data"?
Directory
Sub Data
Warehouse
Meta Data
Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?
Conceptual Level
Physical Level
File Level
Logical Level
To which of the following the term "DBA" referred?
Data Bank Administrator
Database Administrator
Data Administrator
None of the above
