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

Authored by JO-RB007 JO-RB007

Other

University

Used 12+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

35 questions

Show all answers

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

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

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

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

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

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

A. Domain

B. Relation

C. Tuple

D. Attribute

Access all questions and much more by creating a free account

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

30 questions

Teste Inicial Mecanização

Quiz

•

University

30 questions

MINITO AMSA 2

Quiz

•

University

30 questions

DASAR-DASAR IPS

Quiz

•

University

30 questions

27.06.2020_EC8652 WC_MCQ TEST-5

Quiz

•

University

37 questions

QUALITY PRELIM

Quiz

•

University

40 questions

FINANCIAL ACCOUNTING II

Quiz

•

University

30 questions

language

Quiz

•

University

30 questions

IMMUNITY

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Other

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

5 questions

Poetry Interpretation

Interactive video

•

4th Grade - University

19 questions

Black History Month Trivia

Quiz

•

6th Grade - Professio...

15 questions

Review1

Quiz

•

University

15 questions

Pre1

Quiz

•

University

MODULE-3-DATABASE MANAGEMENT SYSTEMS

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other