Helloloksewa

My Loksewa Preparation

Select Your Favourite
Category And Start Learning.

Database Exam Set

Welcome to your Database Exam Set 1

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 is not related to database ?

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 controls concurrency.

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. 
OLE means

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 ?