NEW
Font size
WorksheetsDBMS CS3
Total questions: 25
Worksheet time: 13mins
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;
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?
&
_
%
$
To which of the following the term "DBA" referred?
Data Bank Administrator
Database Administrator
Data Administrator
None of the above
Which of the following refers to the number of tuples in a relation?
Entity
Column
Cardinality
None of the above
In the relational table, which of the following can also be represented by the term "attribute"?
Entity
Row
Column
Both B &C
Which of the following is used in the application programs to request data from the database management system?
Data Manipulation language
Data Definition Language
Data Control Language
All of the above
Which of the following commands is used to save any transaction permanently into the database?
Commit
Rollback
Savepoint
None of the above
Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?
Delete
Drop
Remove
All of the above
Which one of the following commands is used to restore the database to the last committed state?
Savepoint
Rollback
Commit
Both A & B
The term "DFD" stands for?
Data file diagram
Data flow document
Data flow diagram
None of the above
The term "SQL" stands for
Standard query language
Sequential query language
Structured query language
Server-side query language
The term "Data independence" refers to____
Data is defined separately and not included in the programs
Programs are not dependent on the logical attributes of the data
Programs are not dependent on the physical attributes of the data
Both B & C
The term "ODBC" stands for_____
Oral database connectivity
Oracle database connectivity
Open database connectivity
Object database connectivity
Which of the following keys is generally used to represents the relationships between the tables?
Primary Key
Foreign Key
Secondary key
None of the above
Which one of the following keyword is used to find out the number of values in a column?
TOTAL
COUNT
SUM
AVG
Which one of the following commands is used to modify a column inside a table?
Drop
Alter
Update
Set
Which of the following is the property of transaction that protects data from system failure?
Atomicity
Isolation
Durability
Consistency
Which normalization form is based on the transitive dependency?
1NF
2NF
3NF
BCNF
Rectangles in ER diagram represents?
Tables
Attributes
Entity sets
Tuples
Select the correct definition of relation.
Subset of a cartesian product of list of domains
Subset of a cartesian product of list of tuple
Subset of a cartesian product of list of attributes
Subset of a cartesian product of list of relations
Which of the following is known as minimal super key?
Primary key
Candidate key
Foreign key
None
Identify the concurrency based protocol?
Lock based protocol
Two phase locking protocol
Timestamp ordering protocol
All of the above
Total view of a database is known as?
Physical view
Internal view
Conceptual view
External view
Primary key can be?
NULL
NOT NULL
BOTH NULL and NOT NULL
NOT NULL and UNIQUE
NATURAL JOIN can also be termed as -
Combination of Union & Cartesian product
Combination of Selection & Cartesian product
Combination of Projection & Cartesian product
None
