DBMS Quiz

DBMS Quiz

University

20 Qs

quiz-placeholder

Similar activities

Data Mining - Classification Mining

Data Mining - Classification Mining

University

15 Qs

Unit 28 - Quiz #1

Unit 28 - Quiz #1

University

15 Qs

Quiz on List and Tuples

Quiz on List and Tuples

University

16 Qs

Sistem Informasi Manajemen

Sistem Informasi Manajemen

University

20 Qs

Data Structure & Algo - Prelim Long Quiz

Data Structure & Algo - Prelim Long Quiz

University

21 Qs

Introduction to Networking

Introduction to Networking

University

15 Qs

The AI Shield

The AI Shield

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?