VVCE_SQL_RDBMS_1

VVCE_SQL_RDBMS_1

12th Grade

7 Qs

quiz-placeholder

Similar activities

Chapter 10: Encryption Techniques

Chapter 10: Encryption Techniques

University

10 Qs

KUIZ TING3 KRIPTOGRAFI

KUIZ TING3 KRIPTOGRAFI

1st - 12th Grade

10 Qs

Storage Quiz Challenge

Storage Quiz Challenge

University

10 Qs

Day #03  | Quiz

Day #03 | Quiz

University

11 Qs

Data Dictionary Quiz

Data Dictionary Quiz

12th Grade

10 Qs

CS1010 Lab 02

CS1010 Lab 02

University

10 Qs

Working around Adobe Photoshop

Working around Adobe Photoshop

12th Grade

10 Qs

Keyboarding Terms

Keyboarding Terms

9th - 12th Grade

10 Qs

VVCE_SQL_RDBMS_1

VVCE_SQL_RDBMS_1

Assessment

Quiz

Computers

12th Grade

Practice Problem

Hard

Created by

Praveen Kumar

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

RDMBs has been designed to handle what kind of data?

Semi-Structured

Unstructured

Structured only

Both Structured and Unstructured data

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

"create" command falls under which category?

DDL

DML

DCL

TCL

3.

MULTIPLE CHOICE QUESTION

20 sec • 2 pts

A column that is a foreign key referencing Primary Key of another table cannot have Null values

True

False

4.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

Which of the following is NOT correct wrt RDBMS?

Consistency may not be maintained at times

There is a solid structure attached to each table

Data is in the form of Rows and Columns

While storing Sequence of records is insignificant

5.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

You had a bank balance of Rs. 1000 and you just sent Rs. 500 to a friend. After sending the money, the app still shows that you have a bank balance of Rs. 1000. What aspect of ACID property is compromised here?

Atomicity

Consistency

Durability

Isolation

6.

MULTIPLE CHOICE QUESTION

30 sec • 3 pts

A foreign key (FK) can only have reference to Primary key (PK) of another table?

True, FK can only refer to PK of another table

It can have reference to a column that has Unique Constraint as well

It can refer to any column

It can refer to any column that doesn't have NULL values

7.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

What is the difference between Primary Key and Unique Constraint?

Both are same

Primary key doesn't allow Null values where as Unique constraint allows Nulls

Primary key allows Null values where as Unique constraint doesn't allow Nulls

There can be multiple primary keys in a table but only one unique constraint column

Access all questions and much more by creating a free account

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?