Q.1
Which of the following is the full form of RDBMS?
  • a) Relational Data Management System
  • b) Relational Database Management System
  • c) Relative Database Management System
  • d) Regional Data Management System
Q.2
What is an RDBMS?
  • a) Database that stores data elements that are not linked
  • b) Database that accesses data elements that are not linked
  • c) Database that stores and allows access to data elements that are linked
  • d) None of the mentioned
Q.3
Does RDBMS have ACID properties?
  • a) Follows ACID properties
  • b) Doesn’t follow ACID properties
  • c) Depends on the data stored in the database
  • d) Can’t say
Q.4
What is a relation in RDBMS?
  • a) Key
  • b) Table
  • c) Row
  • d) Data Types
Q.5
Which of the following systems use RDMS?
  • a) Oracle
  • b) Microsoft SQLServer
  • c) IBM
  • d) All of the mentioned
Q.6
Dynamic hashing allows us to?
  • a) Accommodate the growth of the database
  • b) Accommodate the shrinkage of the database
  • c) Allows modification of hash function
  • d) All of the mentioned
Q.7
Which of the following constraints RDBS doesn’t check before creating the tables?
  • a) Not null
  • b) Primary keys
  • c) Data Structure
  • d) Data integrity
Q.8
Which of the following is the correct option for the given query? SELECT DISTINCT name FROM RDBMS WHERE ID IS NOT NULL;
  • a) The query gives all the possible RDBMS names where a finite value exists for ID
  • b) The query gives the RDBMS names where a finite value exists for ID and it excludes identical names
  • c) The query gives the names of the RDBMS that have a null ID and it also excludes identical names
  • d) The query is syntactically wrong
Q.9
Which of the following is the correct output for the given query? (SELECT databaseid FROM RDBMS WHERE SECTION = 'c') EXCEPT (SELECT databaseid FROM RDBMS WHERE id < 10);
  • a) All the values of the databaseid for which section is c and id > 10
  • b) All the values of the databaseid for which section not c and id > 10
  • c) All the values of the databaseid for which section is c and id < 10
  • d) All the values of the databaseid for which section not c and id < 10
Q.10
Which of the following commands do we use to delete a relation (RDBMS) from a database?
  • a) delete table RDBMS
  • b) drop table RDBMS
  • c) delete from RDBMS
  • d) drop relation RDBMS
Q.11
If RDBMSRDBMSRDBMS3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?
  • a) foreign key(RDBMS1, RDBMS2)
  • b) foreign key(RDBMS1, RDBMS2) references S
  • c) primary key(RDBMS1, RDBMS2, RDBMS3)
  • d) primary key(RDBMS1)
Q.12
Which of the following is the time of temporal data that record when a fact was recorded in a database?
  • b) Exit time
  • c) Valid time
  • d) Transaction time
  • a) Enter time
Q.13
________ deletes a data item from a database.
  • a) Insert(RDBMS)
  • b) Drop(RDBMS)
  • c) Delete(RDBMS)
  • d) None of the mentioned
Q.14
What is the result of the following query? SELECT studentdatabasename FROM RDBMS WHERE marks > SOME (SELECT marks FROM student WHERE SECTION = 'c');
  • a) The query gives all the studentdatabasename for which marks are greater than all the students in section c
  • b) The query gives all the studentdatabasename for which the marks are greater than at least on student in section c
  • c) The query gives all the studentdatabasename for which the marks are less than all the students in section c
  • d) The query is syntactically incorrect
Q.15
________ is a predicate that we expect the database to always satisfy
  • a) Reason
  • b) Mandate
  • c) Assertion
  • d) Verify
Q.16
Which of the following is a good database management practice?
  • a) Adding redundant attributes
  • b) Not specifying primary keys
  • c) Removing redundant attributes
  • d) None of the mentioned
Q.17
What is an Instance of a Database?
  • a) The state of the database system at any given point of time
  • b) The entire set of attributes of the Database put together in a single relation
  • c) The initial values inserted into the Database immediately after its creation
  • d) The logical design of the database system
Q.18
The schema for the relationship set linking a weak entity set to its corresponding strong entity set is redundant.
  • a) False
  • b) True
Q.19
Which of the following information does the database system catalog store?
  • a) Number of blocks
  • b) Size of a tuple of a relation
  • c) Number of tuples
  • d) All of the mentioned
Q.20
If the database modifications occur while the transaction is still active, the transaction is said to use the __________ modification technique
  • a) Immediate
  • b) Deferred
  • c) More than one of the mentioned
  • d) None of the mentioned
0 h : 0 m : 1 s