RDBMS

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 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)

Answer explanation

Jupiter is a gas giant made primarily of hydrogen and helium. Unlike terrestrial planets that have solid surfaces, gas giants like Jupiter don't have a well-defined solid surface, allowing them to accumulate more mass in a gaseous form. This composition has allowed Jupiter to grow significantly larger than planets with solid surfaces.

The given Query can also be replaced with_______: SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= te aches_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;

The given Query can also be replaced with_______: 1. SELECT name, course_id 2. FROM instructor, teaches 3. 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';

Rows of a relation are known as the _______.

• Tuples
• Degree
• Entity
• All of the above

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

• Delete
• Remove
• Drop
• 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

The operation of eliminating columns in a table done by ........ Operation

• Restrict
• Project
• Union
• Divide

.......... keyword is used to find the number of values in a column.

• TOTAL
• ADD
• SUM
• COUNT