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
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.