Exam (elaborations)

Computer Science – Database Management

0 purchase

Course
Computer Science

Institution

Computer Science – Database Management –Multiple Choice Questions with Answers – Assertion & Reason Type Questions with Answers - 78 Pages – Helpful for Students and Teachers

[Show more]

Preview 4 out of 78 pages

View example

Uploaded on September 6, 2024
Number of pages 78
Written in 2024/2025
Type Exam (elaborations)
Contains Questions & answers

comp
computer
computersc
computerscience
computerclass12
computerscienceclass12
computerboard
computerscienceboard
computerboardpaper
computerboardexampaper
database
management
databasemanagement
mcqs

Institution Secondary school
Computer Science
School year 5

$2.99

Add to cart

Add to wishlist

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

Name of the Chapter-DATABASE MANAGEMENT

Sl. Question: Learning Objective
No
1. A data ________ is a restriction or limitation to ensure accuracy and Understanding
reliability of data in database
(A) Constraint
(B) Dictionary
(C) Query
(D) None of these
2. A _________is a type of command that retrieves data from a database Understanding
on a server
(A) Constraint
(B) Dictionary
(C) Query
(D) None of these
3. RDBMS stands for Knowledge
(A) Relational Database Management System
(B) Rotational Database Management System
(C) Reliable Database Management System
(D) None of these
4. An attribute or set of attributes that is used to uniquely identify a Understanding
record in a database table is called
(A) A primary key
(B) An identifier
(C) A tuple
(D) None of the above
5 A primary key consisting of more than one attribute is called Creation
(A)Composite Primary Key
(B)Foreign Key
(C)Alternate Key
(D)None of these

6. Each row of data in a relation(table) is called Understanding
(A) attribute
(B) tuple
(C) domain
(D) None of these
7. Column headings in a relation are referred as Understanding
(A) attributes
(B) tuples
(C) domains
(D) None of these
8. ______________ is a set of values from which an attribute can take a Understanding
value in each row
(A) Attribute
(B) Tuple

, (C) Domain
(D) None of these
9. The number of attributes in a relation is called the ___________ of Understanding
the relation
(A)Degree
(B) Cardinality
(C) Domain
(D) None of these
10. The number of tuples in a relation is called the ___________ of the Understanding
relation
(A)Degree
(B) Cardinality
(C) Domain
(D) None of these
11. A _________ is used to represent the relationship between two Application
relations. (A)Composite Key
(B)Foreign Key
(C)Alternate Key
(D)None of these
12. An attribute or set of attributes that can be served as a primary key of Understanding
a relation is called
(A)Service Key
(B)Foreign Key
(C)Candidate Key
(D)None of these

13. A candidate key that is not the primary key is called Understanding
(A)Composite Key
(B)Foreign Key
(C)Alternate Key
(D)None of these
14. In relational model, tables are called Understanding
(A) Domains
(B) Relations
(C) Tuples
(D) None of these
15 ___________ can take NULL values in it Knowledge
(A)Primary Key
(B)Foreign Key
(C)Both Primary Key and Foreign Key
(D)None of these

Answers
Multiple Choice question

,Q.No.1 (A) Constraint
Q.No.2 (C) Query
Q.No.3 (A)Relational Database Management System
Q.No.4 (A) A primary key
Q.No.5 (A)Composite Primary Key
Q.No.6 (B) tuple
Q.No.7 (A) attributes
Q.No.8 (C) Domain
Q.No.9 (A)Degree
Q.No.10 (B) Cardinality
Q.No.11 (B)Foreign Key
Q.No.12 (C)Candidate Key
Q.No.13 (C)Alternate Key
Q.No.14 (B) Relations
Q.No.15 (B)Foreign Key

MCQ QUESTIONS
Sl. Question: Learning
No Objective
1 A relational database consists of a collection of Knowledge
(A) Tables
(B) Fields
(C) Records
(D) Keys
2 A/An ____________ in a table represents a logical relationship among a set of Knowledge
values.
(A) Attribute
(B) Key
(C) Tuple
(D) Entry
3 The term _________ is used to refer to a record in a table. Knowledge
(A) Attribute
(B) Tuple
(C) Field
(D) Instance
4 The term _________ is used to refer to a record in a table. Knowledge

, (A) Attribute
(B) Tuple
(C) Field
(D) Instance
5 Which of the following attributes cannot be considered as a choice for primary Understanding
key?
(A) Id
(B) License Number
(C) Dept_Id
(D) Street
6 An attribute in a relation is a foreign key if it is the ___________ key in any other Knowledge
relation.
(A) Candidate
(B) Primary
(C) Super
(D) Sub
7 Consider the table with structure as : Understanding
Student (ID, name, dept_name, tot_cred)
In the above table, which attribute will form the primary key?
(A) Name
(B) Dept
(C) Total_credits
(D) ID
8 Which one of the following is commonly used to define the overall design of the Knowledge
database?
(A) Application program
(B) Data definition language
(C) Schema
(D) Source code
9 Which of the following keys is generally used to represents the relationships Understanding
between the tables?
(A) Primary key
(B) Foreign key

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller kbzone. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $2.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69252 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling