Helloloksewa

My Loksewa Preparation

Select Your Favourite
Category And Start Learning.

Database management System Exam

Welcome to your Database Exam Set 1

Name
1. Which is the function of relationship?
2. What is the purpose of query?
3. In which object SQL is used
4. What operation is not permitted by query?
5. Which data type doesn`t exist in access?
6. Which field appears when report is created with report wizard?
7. Which one is not a numeric data type ?
8. Which one is used for database management?
9. In access table , which component are exist ?
10. The technique which defines a set values acceptable for a field is known as .
11. Technique of displaying only those records that meets the defined criteria is known as :
12. Data definition language DDL includes .
13. A data manipulation command that combines the records from one or more table is called …
14. To speed up the search and sorting for a specific name in a field is called
15. Which is not matched with DDL ?
16. Which object interact users with application?
17. SQL to select ( name , roll no , section , address ) of std table from section B.
18. The insertion point in a table can be moved by using
19. Database that contains table linked by common field is called a
20. A DBMS allows you to create and maintain a database , create reports and develop application programs , select the best fit answer.
21. …….. Presents data in a way similar to an excel spreadsheet
22. …… means that the data contained in a database is accurate and reliable
23. Database management systems are intended to :
24. The relational model uses some unfamiliar terminology . a tuple is equivalent to a .
25. The sorting and indexing must be performed a
26. The query SELECT* FROM employee returns
27. Function of macro?
28. Which of the following the best describes a query
29. ….. Is used to speed of data retrieval
30. Extension of ms access file
31. What method can you use to add a new table to your database?
32. What is the first step in creating a form or report with the form wizard or report wizard?
33. Which of the following store command to retrieve data from database?
34. How do you insert a graphic of your company’s logo on the report?
35. Two tables can be linked with relationship so that the data integrity can be enforced . where can you find relationship command?
36. A locked file can be ?
37. Which of the following products is relational DBMS ?
38. Queries in access can be used as
39. …… is a collection of data stored in a standarlized format, designed to be shared by multiple users.
40. The column of a table is referred to as the …
41. A field or group of fields that uniquely identifies every row of a table is …
42. What do you mean by one to many relationship between student and class table ?
43. In a database table , the category of information is called …
44. ……. Enables you to view data from a table based on a specific criterion.
45. A database language concerned with the definition of the whole database structure and schema is …
46. The Sql query : Select * From employee
47. Which of the following is the correct order of keyword for SQL, SELECT statements?
48. DDL stands for
49. …. Is a tool to automate tasks and functionality to your forms , reports and controls
50. Which of the following is drop down list ?

Comment List

Leave a comment

Your email address will not be published. Required fields are marked *