DBMS CS3

The given Query can also be replaced with_______:

1. SELECT name, course_id  

2. FROM instructor, teaches  

3. WHERE instructor_ID= teaches_ID;  

• 1. Select name,course_id from teaches,instructor where instructor_id=course_id;

• 1. Select name, course_id from instructor natural join teaches;

• 1. Select name, course_id from instructor;

• 1. Select course_id from instructor join teaches;

1. SELECT emp_name  

2. FROM department  

3. WHERE dept_name LIKE ' _____ Computer Science';  

4. 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?

• 1. &

• _

• %

• $

To which of the following the term "DBA" referred?

• 1. Data Bank Administrator

• 1. Database Administrator

• 1. Data Administrator

• 1. None of the above

Which of the following refers to the number of tuples in a relation?

• 1. Entity

• 1. Column

• 1. Cardinality

• 1. None of the above

In the relational table, which of the following can also be represented by the term "attribute"?

• 1. Entity

• 1. Row

• 1. Column

• 1. Both B &C

Which of the following is used in the application programs to request data from the database management system?

• 1. Data Manipulation language

• 1. Data Definition Language

• 1. Data Control Language

• 1. All of the above

Which of the following commands is used to save any transaction permanently into the database?

• 1. Commit

• 1. Rollback

• 1. Savepoint

• 1. None of the above

Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?

• 1. Delete

• Drop

• Remove

• All of the above

Which one of the following commands is used to restore the database to the last committed state?

• 1. Savepoint

• 1. Rollback

• 1. Commit

• 1. Both A & B

The term "DFD" stands for?

• 1. Data file diagram

• 1. Data flow document

• 1. Data flow diagram

• 1. None of the above