Page 385 - TP_IT_V1.0_C10_flipbpookl
P. 385
c. To display the details of all students whose MARKS are less than 80.
d. Display the list of all students in descending order of MARKS.
20. Create table EMPLOYEE [2020]
EMPID Char(4)
EMPNAME Varchar(15)
DESIGN Varchar(20)
SALARY Decimal
21. statement is used to add one or more records to a database. [2020]
22. statement retrieves zero or more rows from one or more database tables. [2020]
23. Explain two types of languages used for creating and manipulating the data in databases. [2020]
24. Explain any three data types in OpenOffice Base. [2020]
25. Explain the following with respect to Databases: [2020]
a. Forms b. Reports
c. Table d. Primary key?
e. Categorise the following commands as DDL and DML :
SELECT, ALTER, INSERT, DROP
26. What is RDBMS? [2019]
27. What is database server ? Explain Primary key and Foreign key. [2019]
28. command is used to create a new table in a database. [2018]
a. New b. Create
c. Alter d. Select
29. Write SQL query to create the Table Flight with the following structure: [2018]
Field Type
Flight_ID Char(4)
Flight_Name Varchar(25)
Source Varchar(30)
Destination Varchar(30)
30. Consider the following table and answer the following: [2018]
ID Department OPD_DAYS Doctor_Name
H201 ENT MWF Akaash Arora
H308 Oncology TTS Dharma Sharma
H907 Paediatrics MWF Sanjay Singh
a. Identify suitable Primary Key from the above table.
b. Add a new record with the following data:
(‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)
c. Write a select query to display records of those Doctors whose OPD_DAYS are ‘MWF’.
31. What is DDL ? Mention any two DDL statements. [2018]
32. What do DBMS and RDBMS stand for? Explain in short. [2017]
33. What do you mean by primary key and foreign key? [2017]
34. What do you mean by DDL and DML commands? [2017]
Database Management System using LibreOffice Base 383

