SSC JE - Advance DBMS 1000+ MCQ [Solved] PDF Download

1. The transaction consists of all statements executed between
A. the begin transaction and end transaction
B. the start transaction and end transaction
C. the begin transaction and finish transaction
D. none of the above.
Answer : A

2. Datalog is
A. procedural query language
B. nonprocedural query language
C. scan(), write()
D. none of the above
Answer : B

3. Which of the following produces the relation that has attributes of R1 and R2
A. Cartesian product
B. Difference
C. Intersection
D. Product
Answer : A

4. EEPROM
A. Electrically Extractable Programmable Read Only Memory
B. Electrically Erasable Programmable Read Only Memory
C. Electronically Erasable Programmable Read Only Memory
D. Electrically Erasable Programmable Read Only Memory
Answer : D

5. The exists construct returns the value true, if the argument subquery is
A. empty
B. nonempty
C. contains null values
D. none of the above
Answer : B

6. Data independence means
A. data is defined separately and not included in programs.
B. programs are not dependent on the physical attributes of data.
C. programs are not dependent on the logical attributes of data.
D. both B) and C).
Answer : @

7. Expand the acronym OLAP
A. Object Linked Access Program
B. Organizational Architecture Processing
C. Online Analytical Processing
D. none of these
Answer : C

8. In E-R Diagram weak entity set are represented by
A. Ellipse
B. Dashed ellipse
C. Dashed Rectangle
D. Doubled Rectangle
Answer : D

9. The overall design of a database is called
A. Subschema of the database
B. Schema of the database
C. Structure of the database
D. View of the database
Answer : B

10. Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
A. i and ii only
B. ii and iii only
C. i and iii only
D. i only
Answer : C

11. Symbol to represent weak entity set in ER Model
A. Dotted rectangle
B. Square
C. Doubly outlined rectangle
D. Diamond
Answer : C

12. Aggregate functions are also called
A. serial functions
B. non-serial functions
C. row functions
D. column functions
Answer : D

13. Radio frequencies below ............. are more suitable for omnidirectional applications.
A. 300MHz
B. 1GHz
C. 5GHz
D. 10 GHz
Answer : B

14. In a Hierarchical model records are organized as
A. Graph.
B. List.
C. Links.
D. Tree.
Answer : D

15. Which of the following is true statement ?
A. SQL permits attribute names to be repeated in the same relation.
B. a SQL query automatically eliminates duplicates.
C. a SQL query will not work if there are no indexes on the relations
D. None of these
Answer : D

16. A relation that has no partial dependencies is in which normal form
A. First
B. Second
C. Third
D. BCNF
Answer : B

17. Which of the following concurrency control schemes is not based on serializability property?
A. Two-phase locking
B. Timestamped based locking
C. Graph-based locking
D. none of the above
Answer : C

18. DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
A. Backup
B. Recovery
C. Grant
D. Troubleshooting
Answer : B

19. Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
A. i only
B. ii, only
C. ii, iii only
D. none of the above
Answer : D

20. which of the following is a binary operation?
A. project
B. select
C. rename
D. none of the above
Answer : D

21. Which of the following is also known as Offline storage ?
A. primary storage
B. secondary storage
C. tertiary storage
D. none of the above
Answer : C

22. Tertiary storage
A. magnetic tape
B. juke box
C. optical disk
D. All of the above
Answer : D

23. Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considring its compatibility
iii) View definition cant be used at multiple places through with clause .
A. i and ii only
B. ii and iii only
C. i and iii only
D. i only
Answer : A

24. The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
A. B-Tree File
B. Hashed File
C. Indexed File
D. Sequential file.
Answer : B

25. A transaction which completes successfully is called
A. Granted
B. Committed
C. Compensated
D. Accomplished
Answer : B

26. In which of the following SET concept is used ?
A. Network Model
B. Hierarchical Model
C. Relational Model
D. None of these
Answer : A

27. Which of the following layer uses trailer of the frame for error detection?
A. Transport layer
B. Network layer
C. Datalink layer
D. None of these
Answer : C

28. The class based addressing is known as
A. Classless addressing
B. Classful addressing
C. Classified addressing
D. Classical addressing
Answer : B

29. A fragmentation is categorized in
A. 1 part
B. 2 part
C. 3 part
D. 4 part
Answer : C

30. For large networks, _______ topology is used
A. Ring
B. Bus
C. Mesh
D. none of these
Answer : A

31. The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
A. Normalization
B. Indexing
C. Enforcing referential integrity
D. Enforcing data integrity
Answer : A

32. The syntax to select all column from the table is
A. select all from tablename
B. select * from tablename
C. select from tablename
D. none of these
Answer : B

33. A lock that allows concurrent transactions to access different rows of the same table is known as a
A. Field-level lock
B. Row-level lock
C. Table-level lock
D. Database-level lock
Answer : A

34. If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
A. Noise
B. Delay
C. Dispersion
D. Attenuation
Answer : D

35. Cross Product is a:
A. Unary Operator
B. Binary Operator
C. Ternary Operator
D. none of the above
Answer : B

36. Full form of CIDR
A. Classful Inter Domain Routing
B. Classless International Domain Routing
C. Classless Inter Domain Routing
D. none of these
Answer : C

37. File organization that provides fast access to any arbitrary record
A. Hashed file
B. B-tree
C. Ordered file
D. Unordered file
Answer : A

38. Which of the following is also known as Offline storage ?
A. primary storage
B. secondary storage
C. tertiary storage
D. none of the above
Answer : B

39. The race condition occurs when
A. Two concurrent processes attempt to interact with each other.
B. Two concurrent processes interact with different data files.
C. Two concurrent processes attempt to hold a data item .
D. none of the above.
Answer : C

40. It is possible to define a schema completely using
A. VDL and DDL.
B. DDL and DML.
C. SDL and DDL.
D. VDL and DML.
Answer : B

41. …………… is responsible for using that the database remains in a consistent state despite system failure.
A. Storage manager
B. Admin
C. Transaction manager
D. none of the above
Answer : C

42. Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
A. Data rate
B. Bit rate
C. Signal to Noise Ratio
D. Baud rate
Answer : D

43. Functional dependencies are generalization of
A. Relation dependencies
B. Data dependencies
C. key dependencies
D. none of the above
Answer : A

44. The raw facts and figures are:
A. Data
B. Data field
C. DBMS
D. DBASE
Answer : A

45. The degree of the table with 500 rows and 7 columns is
A. 500
B. 7
C. 3500
D. none of these
Answer : B

46. Transaction processing is associated with everything below except
A. producing detail, summary, or exception reports.
B. recording a business activity.
C. confirming an action or triggering a response.
D. maintaining data.
Answer : C

47. Th statement in SQL which allows to change the definition of a table is
A. Select
B. Update
C. Create
D. Alter
Answer : D

48. In case of entity integrity, the primary key may be
A. not Null
B. Null
C. both Null & not Null.
D. any value.
Answer : A

49. The database environment has all of the following components except:
A. users.
B. separate files.
C. database.
D. database administrator.
Answer : A

50. Which of the following operator preserves unmatched rows of the relations being joined?
A. Inner join
B. Outer join
C. union
D. Intersect
Answer : B