InstaQB

Home
Institutions
- Institutions
  
  Polytechnic Colleges
  
  Medical Colleges
  
  Arts & Science Colleges
  
  Universities
  
  Engineering Colleges
  
  Agricultural Colleges
  
  Research Institute
  
  Law Colleges
  
  Audiology and Speech Colleges
  
  Business & Management colleges
  
  Nursing colleges
  
  Hotel Management institutes
  
  Aeronautical Colleges
  
  Bachelor's Degree
Syllabus
Courses
Stateboard
- 12th Standard English Medium
  
  Maths
  
  Physics
  
  Chemistry
  
  Biology
  
  Computer Science
  
  Business Maths
  
  Economics
  
  Commerce
  
  Accountancy
  
  History
  
  Computer Applications
  
  Computer Technology
  12th Standard Tamil Medium
  
  உயிரியல்
  
  கணினி பயன்பாடுகள்
  
  கணினி அறிவியல்
  
  வணிகக் கணிதம்
  
  வணிகவியல்
  
  பொருளியல்
  
  கணிதவியல்
  
  வேதியியல்
  
  இயற்பியல்
  
  கணினி தொழில்நுட்பம்
  
  வரலாறு
  
  கணக்குப்பதிவியல்
  11th Standard English Medium
  
  Maths
  
  Commerce
  
  Economics
  
  Biology
  
  Business Maths
  
  Accountancy
  
  Computer Science
  
  Physics
  
  Chemistry
  
  Computer Applications
  
  History
  
  Computer Technology
  
  Bio - Zoology
  11th Standard Tamil Medium
  
  கணிதவியல்
  
  உயிரியல்
  
  பொருளியல்
  
  இயற்பியல்
  
  வேதியியல்
  
  வணிகக் கணிதம்
  
  கணினி அறிவியல்
  
  கணக்குப்பதிவியல்
  
  வணிகவியல்
  
  கணினி பயன்பாடுகள்
  10th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  9th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  8th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  7th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
ICSE/ISC
- Class XII
  
  Mathematics
  
  Physics
  
  Accountancy
  
  Biology
  
  History
  
  Geography
  
  Psychology
  
  chemistry
  
  Economics
  
  Computer Science
  
  Political Science
  
  Business Studies
  Class XI
  
  Accountancy
  
  Chemistry
  
  Mathematics
  
  Biology
  
  Geography
  
  Physics
  
  History
CBSE
- 12Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Geography
  
  Socialogy
  
  Business Studies
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  
  Home Science
  11Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Socialogy
  
  Business Studies
  
  Geography
  
  Home Science
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  10Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  Mathematics
  
  Economics
  
  Geography
  
  History & Civics
  
  Computer Application
  9Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  mathematics
  
  Computer Application
  
  Economics
  
  Geography
  
  History & Civics

12th Computer Applications Monthly Test -3 ( Introduction to Database Management System )

St. Britto Hr. Sec. School - Madurai

12th Computer Applications Monthly Test -3 ( Introduction to Database Management System )-Aug 2020

Time : 2.30 Hours

Part - A

Multiple Choice Question - Answer All Question

A _________ is a "copy" of a primary key

Candidate Key
Super Key
Foreign Key
Composite Key

Which is the MySQL instance responsible for data processing?

MySQL Client
MySQL Server
SQL
Server Daemon Program

__________ represents a “tuple” in a relational database?

Table
Row
Column
Object

A key With more than one attribute to identify rows uniquely in a table is called ___________

Candidate Key
Super Key
Foreign Key
Composite Key

Communication is established with MySQL using

SQL
Network calls
Java
API’s

__________ Command is used to delete a database.

Delete database database_name
Delete database_name
drop database database_name
drop database_name

___________ can be subdivided into simple attributes without change in the meaning of that attribute

Key Attribute
Simple Attributes
Composite Attributes
Single Valued Attribute

An entity set that does not have enough attributes to form primary key is known as

Strong entity set
Weak entity set
Identity set
Owner set

_________ are the values for the entity

Data
Entity
Instance
Relationship

_____________ describes a unique characteristic of an entity

Key Attribute
Simple Attributes
Composite Attributes
Single Valued Attribute

Which language is used to request information from a Database?

Relational
Structural
Query
Compiler

A __________ contains only one value for the attribute and they don't have multiple numbers of values.

Key Attribute
Simple Attributes
Composite Attributes
Single Valued Attribute

The ___________ diagram gives a logical structure of the database graphically?

Entity-Relationship
Entity
Architectural Representation
Database

An _________ can be anything a real-world object

Data
Entity
Instance
Relationship

The ________ cannot be separated it will be haVing a single value for their entity.

Key Attribute
Simple Attributes
Composite Attributes
Single Valued Attribute

Part - B

Generic 2 - Answer All Question

What is XAMPP?

State few advantages of Relational databases.

What is Relationship and List its types.

List few disadvantages of file processing system.

What are the various methods to access file system?

What are the ACID properties?

Define Data Model and list the types of data model used.

What is view in SQL?

Define Single and multi valued attributes.

Write the difference between SQL and MySQL

Write the types of SQL commands

Which command is used to make permanent changes done by a transaction?

Part - C

Generic 3 - Answer All Question

List few commonly used databases.

What are the major parts to form a database

Write few commands used by DBA to control the entire database.

Explain on Evolution of DBMS.

What is relationship in databases? List its types

List any 5 privileges available in MySQL for the User.

Discuss on Cardinality in DBMS.

Comment

Add Comment

Tamilnadu Stateboardszs - Class