The number of tuples in a relation is called its …………, while the number of attributes in a relation is called its ………

C. Participation constraint, cardinality

D. Degree, Participation constraint

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a ………..

B. Referential integrity constraint

Which of the following query is correct for using comparison operators in SQL?

SELECT sname, coursename FROM studentinfo WHERE age>50 and age <80;

SELECT sname, coursename FROM studentinfo WHERE age>50 and <80;

SELECT sname, coursename FROM studentinfo WHERE age>50 and WHERE age<80;

How to select all data from studentinfo table starting the name from letter ‘r’?

SELECT * FROM studentinfo WHERE sname LIKE ‘r%’

SELECT * FROM studentinfo WHERE sname LIKE ‘%r%’

SELECT * FROM studentinfo WHERE sname LIKE ‘%r’

SELECT * FROM studentinfo WHERE sname LIKE ‘_r%’

Which of the following SQL query is correct for selecting the name of staffs from ‘tblstaff’ table where salary is 15,000 or 25,000?

SELECT sname from tblstaff WHERE salary IN (15000, 25000);

SELECT sname from tblstaff WHERE salary BETWEEN 15000 AND 25000;

Select a query that retrieves all of the unique courses from the student table?

SELECT DISTINCT coursename FROM studentinfo;

SELECT UNIQUE coursename FROM studentinfo;

SELECT DISTINCT coursename FROM TABLE studentinfo;

SELECT INDIVIDUAL coursename FROM studentinfo;

Which query is used for sorting data that retrieves all the fields from empinfo table and listed them in the ascending order?

SELECT * FROM empinfo ORDER BY age;

SELECT * FROM empinfo ORDER age;

SELECT * FROM empinfo ORDER BY COLUMN age;

SELECT * FROM empinfo SORT BY age;

What is the function of the following command? Delete from r where P

Deletes particular tuple from relation

Empdt1(empcode, name, street, city, state, pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

3NF and hence also in 2NF and 1NF

BCNF and hence also in 3NF, 2NF and 1NF

SELECT dept_name, ID, avg (salary) FROM instructor GROUP BY dept_name; This statement IS erroneous because

Dept_id should not be used in group by clause

Avg(salary) should not be selected

Group by clause is not valid in this query

Observe the given SQL query and choose the correct option. SELECT branch_name, COUNT (DISTINCT customer_name) FROM depositor, account WHERE depositor.account_number = account.account_number GROUP BY branch_id

The query is syntactically wrong

The query is syntactically correct but gives the wrong answer

The query is syntactically correct and gives the correct answer

The query contains one or more wrongly named clauses.

Consider the following transactions with data items P and Q initialized to zero: T1: read (P) ; read (Q) ; if P = 0 then Q : = Q + 1 ; write (Q) ; T2: read (Q) ; read (P) ; if Q = 0 then P : = P + 1 ; write (P) ; Any non-serial interleaving of T1 and T2 for concurrent execution leads to

A schedule that is not conflict serializable

A conflict serializable schedule

A schedule for which a precedence graph cannot be drawn

MODULE-3-DATABASE MANAGEMENT SYSTEMS

Quiz

•

Other

•

University

•

Practice Problem

•

Medium

JO-RB007 JO-RB007

Used 12+ times

FREE Resource

35 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following command is a type of Data Definition language command?

A. Create

B. Update

C. Delete

D. Merge

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is used in the application programs to request data from the database management system?

A. Data Manipulation Language

B. Data Definition Language

C. Data Control Language

D. All of the above

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

A. Delete

B. Drop

C. Remove

D. All of the above

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following keys is generally used to represents the relationships between the tables?

A. Primary key

B. Foreign key

C. Secondary key

D. None of the above

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which one of the following commands is used to modify a column inside a table?

A. Update

B. Drop

C. Alter

D. Set

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following defines the structure of a relation that consists of a fixed set of attribute-domain pairs.

A. Instance

B. Schema

C. Program

D. Super key

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A relational database developer refers to a record as -----------.

A. Domain

B. Relation

C. Tuple

D. Attribute

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

35 questions

PAS NOV. 2024 BAH. INDONESIA KLS 10

Quiz

•

10th Grade - University

36 questions

LearnTube Digital Marketing Quiz 17/3/23

Quiz

•

University

32 questions

Los componentes del currículo dominicano.

Quiz

•

University

35 questions

Le cinéma

Quiz

•

3rd Grade - University

40 questions

PTS Bahasa Indoensia

Quiz

•

5th Grade - University

35 questions

CFAS - Conceptual Framework

Quiz

•

University

31 questions

Sistema Operativo

Quiz

•

University

40 questions

MultiModa and Freight Forwarding

Quiz

•

University

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

15 questions

4:3 Model Multiplication of Decimals by Whole Numbers

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

The Best Christmas Pageant Ever Chapters 1 & 2

Quiz

•

4th Grade

12 questions

Unit 4 Review Day

Quiz

•

3rd Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

Discover more resources for Other

26 questions

Christmas Movie Trivia

Lesson

•

8th Grade - Professio...

7 questions

Different Types of Energy

Interactive video

•

4th Grade - University

20 questions

Slopes and Slope-Intercept Form

Quiz

•

8th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

7 questions

Biomolecules (Updated)

Interactive video

•

11th Grade - University

20 questions

Winter/Holiday Trivia

Quiz

•

KG - University

10 questions

WINTER WIN Time - ELA - 12/9/2025

Quiz

•

KG - University

7 questions

Human Impact on Resources

Interactive video

•

4th Grade - University

MODULE-3-DATABASE MANAGEMENT SYSTEMS

35 questions

Which of the following command is a type of Data Definition language command?

Which of the following is used in the application programs to request data from the database management system?

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

Which of the following keys is generally used to represents the relationships between the tables?

Which one of the following commands is used to modify a column inside a table?

Which of the following defines the structure of a relation that consists of a fixed set of attribute-domain pairs.

A relational database developer refers to a record as -----------.

Grant and revoke are ……. statements.

The candidate key that you choose to identify each row uniquely is called ……….

……… is used to eliminate duplicate rows

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other