Basic Simple DBMS GK Questions

DBMS:

DBMS stands for Database Management System. It is a software system designed to facilitate the management and organization of databases. A DBMS allows users to store, retrieve, modify, and manipulate vast amounts of data efficiently and securely.

Key aspects and functions of a DBMS:

  • Data Organization:

A DBMS provides a structured framework for organizing data. It allows data to be stored in tables, which consist of rows (records) and columns (attributes). This structured approach ensures data integrity and enables efficient data retrieval.

  • Data Retrieval:

With a DBMS, users can retrieve data from databases using query languages such as SQL (Structured Query Language). These queries enable users to search for specific data, perform calculations, and extract meaningful insights.

  • Data Manipulation:

DBMS systems support various operations for manipulating data. Users can insert new data into the database, update existing records, or delete data as needed. The DBMS ensures data consistency and integrity during these operations.

  • Data Security:

DBMS systems incorporate security mechanisms to protect sensitive data. Access controls, user authentication, and encryption techniques are implemented to safeguard data from unauthorized access and ensure data privacy.

  • Data Integrity:

DBMS systems enforce data integrity by implementing constraints and rules. These constraints ensure that data entered into the database adheres to predefined rules, such as unique key values or referential integrity between tables.

  • Data Backup and Recovery:

DBMS systems provide mechanisms for data backup and recovery. Regular backups protect against data loss due to system failures, hardware malfunctions, or disasters. In case of data loss, the DBMS enables the restoration of the database to a previous state.

  • Data Concurrency:

DBMS systems support concurrent access to the database by multiple users or applications. They manage concurrent transactions, ensuring that data remains consistent and preventing conflicts that may arise from simultaneous updates.

Here are some Basic Simple DBMS GK Question list:

Sr. No Question Answer
Q. 1 In the relational modes, cardinality is termed as: Number of tuples.
Q. 2 Relational calculus is a Non- Procedural language.
Q. 3 The view of total database content is Conceptual view.
Q. 4 Cartesian product in relational algebra is a Binary operator.
Q. 5 DML is provided for Manipulation & processing of database.
Q. 6 ‘AS’ clause is used in SQL for Rename operation.
Q. 7 ODBC stands for Open Database Connectivity.
Q. 8 Architecture of the database can be viewed as three levels.
Q. 9 In a relational model, relations are termed as Tables.
Q. 10 The database schema is written in DDL
Q. 11 In the architecture of a database system external level is the view level.
Q. 12 An entity set that does not have sufficient attributes to form a primary key is a weak entity set.
Q. 13 In a Hierarchical model records are organized as Tree.
Q. 14 In an E-R diagram attributes are represented by ellipse.
Q. 15 In case of entity integrity, the primary key may be not Null
Q. 16 In tuple relational calculus P1 ®P2 is equivalent to ¬P1 Ú P2
Q. 17 The language used in application programs to request data from the DBMS is referred DML
Q. 18 A logical schema is the entire database.
Q. 19 Related fields in a database are grouped to form a data record.
Q. 20 The database environment has all of the following components except: users.
Q. 21 The language which has recently become the defacto standard for interfacing application grams with relational database system is
Q. 22 The way a particular application views the data from the database that the application programs with relational database system is sub schema.
Q. 23 In an E-R diagram an entity set is represent by a rectangle.
Q. 24 A report generator is used to print files on paper.
Q. 25 The property / properties of a database is / are : It is an integrated collection of logically related records.
Q. 26 The DBMS language component which can be embedded in a program is The data manipulation language (DML).
Q. 27 A relational database developer refers to a record as a tuple.
Q. 28 The relational model feature is that there is much more data independence than some other database models.
Q. 29 Conceptual design involves modelling independent of the DBMS.
Q. 30 The method in which records are physically stored in a specified order according to a key hash.
Q. 31 A subschema expresses the external view.
Q. 32 Count function in SQL returns the number of values.
Q. 33 Which one of the following statements is false? Data elements in the database can be modified by changing the data dictionary.
Q. 34 An advantage of the database management approach is data is integrated and can be accessed by multiple programs.
Q. 35 A DBMS query language is designed to support in the development of complex applications software.
Q. 36 TrAnsaction processing is associated with everything below except confirming an action or triggering a response.
Q. 37 It is possible to define a schema completely using DDL and DML.
Q. 38 The method of access which uses key trAnsformation is known as hash.
Q. 39 Data independence meAns programs are not dependent on the physical attributes of data and programs are not dependent on the logical attributes of data.
Q. 40 The statement in SQL which allows to change the definition of a table is Alter.
Q. 41 E-R model uses this symbol to represent weak entity set ? Doubly outlined rectangle
Q. 42 SET concept is used in : Network Model
Q. 43 Relational Algebra is Procedural query Language
Q. 44 Key to represent relationship between tables is called Foreign Key
Q. 45 _______ produces the relation that has attributes of R1 and R2 Cartesian product
Q. 46 The file organization that provides very fast access to any arbitrary record of a file is Hashed file
Q. 47 DBMS helps achieve Data independence and Centralized control of data
Q. 48 Which of the following are the properties of entities? Attributes
Q. 49 In a relation Ordering of rows is immaterial and No two rows are identical
Q. 50 Which of the following is correct: None of these
Q. 51 It is better to use files than a DBMS when there are Stringent real-time requirements, Multiple users wish to access the data and Complex relationships among data.
Q. 52 The conceptual model is independent of both hardware and software.
Q. 53 What is a relationship called when it is maintained between two entities? Binary
Q. 54 Which of the following operation is used if we are interested in only certain columns of a PROJECTION
Q. 55 Which of the following is a valid SQL type? CHARACTER, NUMERIC and FLOAT
Q. 56 The RDBMS terminology for a row is tuple.
Q. 57 Which of the following operations need the participating relations to be union compatible? UNION, INTERSECTION and DIFFERENCE
Q. 58 The full form of DDL is Data Definition Language
Q. 59 Which of the following is an advantage of view? Data security, Derived columns, Hiding of complex queries
Q. 60 Which of the following is a legal expression in SQL? SELECT NAME FROM EMPLOYEE;
Q. 61 The users who use easy-to-use menu are called Naïve users.
Q. 62 Which database level is closest to the users? External
Q. 63 Which are the two ways in which entities can participate in a relationship? Total and partial
Q. 64 The result of the UNION operation between R1 and R2 is a relation that includes all the tuples of R1 and R2 which have common columns
Q. 65 Which of the following is a comparison operator in SQL? = , LIKE and BETWEEN
Q. 66 A set of possible data values is called domain.
Q. 67 Which of the operations constitute a basic set of operations for manipulating relational Relational algebra
Q. 68 Which of the following is another name for weak entity? Child
Q. 69 Which of the following database object does not physically exist? view
Q. 70 NULL is not a value
Q. 71 Which of the following is record based logical model? Network Model
Q. 72 A data dictionary is a special file that contains: The name of all fields in all files, The width of all fields in all files, and The data type of all fields in all files.
Q. 73 A file manipulation command that extracts some of the records from a file is called SELECT
Q. 74 The physical location of a record is determined by a mathematical formula that trAnsforms Hashed File
Q. 75 Using Relational Algebra the query that finds customers, who have a balance of over PCustomer_name(s balance >1000(Deposit))
Q. 76 A primary key is combined with a foreign key creates Parent-Child relation ship between the tables that connect them.
Q. 77 In E-R Diagram derived attribute are represented by Dashed ellipse
Q. 78 Cross Product is a: Binary Operator
Q. 79 An instance of relational schema R (A, B, C) has distinct values of A including NULL A is not a candidate key
Q. 80 Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, mn
Q. 81 The natural join is equal to : Combination of projection and Cartesian product
Q. 82 Which one of the following is not true for a view: A view definition is permanently stored as part of the database.
Q. 83 A primary key if combined with a foreign key creates Parent-Child relationship between the tables that connect them.
Q. 84 In E-R Diagram relationship type is represented by Diamond
Q. 85 Hierarchical model is also called Tree structure
Q. 86 To delete a particular column in a relation the command used is: ALTER
Q. 87 The ______ operator is used to compare a value to a list of literals values that have been BETWEEN
Q. 88 A logical schema defines the structure of the data itself and the relationships between the various attributes, tables, and entries.
Q. 89 A B-tree of order m has maximum of _____________ children m
Q. 90 _____________ function divides one numeric expression by another and returns the MOD
Q. 91 A data manipulation command the combines the records from one or more tables is called JOIN
Q. 92 In E-R diagram generalization is represented by Triangle
Q. 93 _________ is a virtual table that draws its data from the result of an SQL View
Q. 94 The method of access which uses key trAnsformation is known as Hash
Q. 95 A table joined with itself is called Self Join
Q. 96 _________ data type can store unstructured data RAW
, , , , , ,

Leave a Reply