1. Which of the following Application of database________________?
2. ________is a collection of related information
3. _________is a set of values for an attribute in that column
4. Collection of record is called as a____________.
5. A software package used to manage the databases and run operations in the data is known as _________
6. An _________in DBMS is a real-world thing or a real-world object which is distinguishable from other objects in the real world.
7. ______ is a set of data values that are given to an entity.
8. An _______is a characteristic which represents the entity.
9. A row of a table that represents a complete information about a particular entity is called as a ______________
10. Which of the following not belongs to datatypes of DBMS?
11. The RDBMS terminology for a row is
12. Which of the following is a valid SQL type?
13. ________is a repository of an organization’s electronically stored data.
14. ___________are components of data ware house.
15. __________ is concerned with the analysis and picking out relevant information.
16. SQL stands for__________________.
17. SQL statements should be terminated by a______________.
18. DDL stands for ______________
19. ___________command used crate a new table.
20. ___________command modifies an existing table.
21. _______________command is used to delete table content in SQL.
22. _____________command will create a record.
23. ___________command modifies the existing rows (records) in a table.
24. ______ command is used for querying or retrieving data from a table in the database.
25. DCL Stands for__________________.
26. ________________takes back privileges granted from user.
27. TCL stands for________.
28. ____________makes all the changes made by statements issued permanent.
29. _____________Undoes all changes since the beginning of a transaction or since a save point.
30. Which of the following constraints not available in SQL?
31. ___________ constraints define a column or combination of columns which uniquely identifies each row in the table.
32. ____________ constraints identify any column referencing the Primary Key in another table.
33. _________ constraints ensure that a column or a group of columns in each row have a distinct value.
34. _________constraints define a business rule on a column. All the rows must satisfy this rule.
35. The ___________ operator is used to checks the membership condition specified by the list of values.
36. _________operator is used to output data which lies in a range of values.
37. ____________________ are the logical operators of SQL.
38. RDBMS stands for
39. ______is dummy table containing a single row and single column provided by SQL
40. SQL Group Functions are
No comments: