Advanced Database Management MCQ

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

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 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';

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?

• &

• _

• %

• $

Which one of the following is a type of Data Manipulation Command?

• Create

• Alter

• Delete

• All of the above

In case of any shut down during transaction before commit which of the following statement is done automatically?

• View

• Commit

• Rollback

• Flashback

The term 'TCL' stands for_____.

• Ternary Control Language

• Transmission Control Language

• Transaction Central Language

• Transaction Control Language

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

A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.

• Idle

• Waiting

• Deadlock

• Ready

In order to undo the work of transaction after last commit which one should be used?

• View

• Commit

• Rollback

• Flashback