Home

Advance DBMS MCQ Solved Paper for SSC MTS

Thursday 9th of March 2023

Sharing is caring

Downlaod Advance DBMS MCQ PDF
1. Volatile storage
A. loses its contents when power is switched off.
B. doesnt loses its contents when power is switched off.
C. creates backup when power is switched off.
D. none
Answer : A
2. What is the max data capacity of STP?
A. 1 Gbps
B. 56 Mbps
C. 100 Mbps
D. 256 Mbps
Answer : C
3. A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
A. i and ii only
B. ii and iii only
C. i and iii only
D. iii and iv only
Answer : D
4. The raw facts and figures are:
A. Data
B. Data field
C. DBMS
D. DBASE
Answer : A
5. Which of the following is not an Aggregate function?
A. Min
B. Max
C. Select
D. Avg
Answer : C
6. The degree of the table with 500 rows and 7 columns is
A. 500
B. 7
C. 3500
D. none of these
Answer : B
7. The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
A. View
B. Cursor defination
C. Referential intergrity
D. Trigger
Answer : C
8. In defining the notion of the tuple variable, which one of the clause is useful?
A. as
B. by
C. from
D. none of the above
Answer : A
9. Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
A. i only
B. ii only
C. Both
D. None of these
Answer : B
10. Which of the following statements is not true about two tier client server database architecture?
A. SQL statements are processed on tier server
B. SQL statements may be processed on some of the clients
C. Business logic is mostly processed on clients
D. Business logic may be processed on the server
Answer : C
11. A relation is said to be in ………. If it doesnt contain partial dependency
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Answer : B
12. The ability to modify the conceptual schema without causing any change to the application program is known as
A. Physical data independence
B. Logical data independence
C. External data independence
D. Static data
Answer : B
13. Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:
A. mn
B. m+n
C. m+n)/2
D. 2 m+n)
Answer : A
14. In which of the following SET concept is used ?
A. Network Model
B. Hierarchical Model
C. Relational Model
D. None of these
Answer : A
15. In two-phase locking protocol the two phases are
A. growing phase and shrinking phase
B. execution phase and blocking phase.
C. running phase and sleeping phase.
D. none of the above
Answer : A
16. Data integrity refers to
A. the uniqueness of the data in a database
B. the correctness and completeness of the data in a database
C. the un redundancies of the data in a database
D. Data independence of the database
Answer : B
17. Secondary storage
A. magnetic disk
B. magnetic tape
C. juke box
D. cache
Answer : A
18. 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
19. 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 : @
20. DECLARE is a(an)
A. executable statement.
B. declarative statement.
C. Ordered file
D. none of the above
Answer : B
21. In E-R Diagram weak entity set are represented by
A. Ellipse
B. Dashed ellipse
C. Dashed Rectangle
D. Doubled Rectangle
Answer : D
22. Which of the following is logical topology?
A. Bus
B. Ring
C. Star
D. None of these
Answer : B
23. 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
24. Cross Product is a:
A. Unary Operator
B. Binary Operator
C. Ternary Operator
D. none of the above
Answer : B
25. 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
26. Size of source and destination address in IP header
A. 4 bits
B. 8 bits
C. 12 bits
D. 32 bits
Answer : D
27. A ………… clause permits a view definition to be used in multiple places within a query.
A. where
B. exist
C. with
D. select
Answer : C
28. Radio frequencies below ............. are more suitable for omnidirectional applications.
A. 300MHz
B. 1GHz
C. 5GHz
D. 10 GHz
Answer : B
29. Count function in SQL returns the number of
A. values.
B. distinct values.
C. groups.
D. columns.
Answer : A
30. Data stored in cursor is called ……………
A. record
B. active data set
C. object
D. none of the above
Answer : B
31. Symbol to represent weak entity set in ER Model
A. Dotted rectangle
B. Square
C. Doubly outlined rectangle
D. Diamond
Answer : C
32. Query processing is
A. converting data to insert in a database
B. translation of query to lower form
C. range of activities involved in extracting data from a database
D. none of the above
Answer : C
33. The database environment has all of the following components except:
A. users.
B. separate files.
C. database.
D. database administrator.
Answer : A
34. A logical schema
A. is the entire database.
B. is a standard way of organizing information into accessible parts.
C. describes how data is actually stored on disk.
D. both A) and C)
Answer : A
35. Only one communication channel is needed rather than n channels to transmit data between two communicating devices
A. parallel
B. serial
C. analog
D. digital
Answer : B
36. A composite attribute is converted to individual attributes in which of the following normal form ?
A. first
B. Second
C. third
D. fourth
Answer : A
37. 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
38. A type of query that is placed within a WHERE or HAVING clause of another query is called
A. Super query
B. Sub query
C. Master query
D. Multi-query
Answer : B
39. As a side-effect of database update ,the system automatically executes a statement called
A. a view
B. a grant permission
C. a trigger
D. all of the above
Answer : C
40. Disk storage is referred to as
A. sequential access storage
B. direct access storage
C. random access storage
D. none of the above
Answer : B
41. In an object oriented model, one object can access data of another object by passing?
A. Instance variable
B. Variable
C. Message
D. Function
Answer : C
42. The union of primary keys of a related entity becomes …………. Of a relation.
A. primarykey
B. superkey
C. candidatekey
D. foreignkey
Answer : B
43. A transaction is said to have terminated if it has
A. either committed or aborted
B. either partially committed or aborted
C. either committed or failed
D. none of these
Answer : D
44. The host part in a class A type of an IP address has
A. 12 bits
B. 16 bits
C. 24 bits
D. 28 bits
Answer : C
45. Three SQL, DDL, CREATE commands are
A. Schema, Base and Table
B. Schema, Table and View
C. Base, Table and Schema
D. Key, Base and Table
Answer : B
46. A transaction which may not complete its execution successfully is termed as
A. Failed
B. Aborted
C. Blocked
D. Finished
Answer : B
47. 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
48. Which of the following submit and execute query at un time?
A. Static SQL
B. Dynamic SQL
C. both
D. none of these
Answer : B
49. The class based addressing is known as
A. Classless addressing
B. Classful addressing
C. Classified addressing
D. Classical addressing
Answer : B
50. Tape storage is referred to as
A. sequential access storage
B. direct access storage
C. random access storage
D. none of the above
Answer : A
Downlaod Advance DBMS MCQ PDF

Sharing is caring

Related Post