DBMS Quiz

DBMS Quiz

University

20 Qs

quiz-placeholder

Similar activities

IT (data, viruses and more)

IT (data, viruses and more)

8th Grade - Professional Development

20 Qs

PHP First Internal Practical Viva

PHP First Internal Practical Viva

University

20 Qs

Quiz on neural network unit II

Quiz on neural network unit II

University

16 Qs

Gerência do Processador

Gerência do Processador

University

16 Qs

GIS Unit-1

GIS Unit-1

University

15 Qs

Computer Architecture Unit 3

Computer Architecture Unit 3

University

15 Qs

IT 209

IT 209

University

15 Qs

DBMS Quiz

DBMS Quiz

Assessment

Quiz

Computers

University

Practice Problem

Hard

Created by

Ashish Mathur

Used 26+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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;

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A RDBMS consists a collection of ?

Tables

Fields

Records

Keys

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The term attribute refers to a ___________ of a table.

Record

Tuple

Column

Key

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In relational model, the row of table is known to be ?

Relation

Entity field

Tuple

Attribute

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?