1000+ Advance DBMS MCQ for SSC GD [Solved]
Thursday 9th of March 2023
Sharing is caring
1. 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
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
2. Which of the following will NOT eliminates the ambiguities of a null value?
A. Define the attribute as required
B. Define subtypes
C. Define each attribute as having an initial value that is recognized as blank
D. Define supertypes
Answer : D
A. Define the attribute as required
B. Define subtypes
C. Define each attribute as having an initial value that is recognized as blank
D. Define supertypes
Answer : D
3. 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
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
4. 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
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
5. Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
A. i and ii only
B. ii and iii only
C. i and iii only
D. All i, ii iii
Answer : D
i) Specialization
ii) Generalization
iii) Categorization
A. i and ii only
B. ii and iii only
C. i and iii only
D. All i, ii iii
Answer : D
6. A logical description of some portion of database that is required by a user to perform task is called as
A. System View
B. User View
C. Logical View
D. Data View
Answer : B
A. System View
B. User View
C. Logical View
D. Data View
Answer : B
7. 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
then the maximum size of join is:
A. mn
B. m+n
C. m+n)/2
D. 2 m+n)
Answer : A
8. For large networks, _______ topology is used
A. Ring
B. Bus
C. Mesh
D. none of these
Answer : A
A. Ring
B. Bus
C. Mesh
D. none of these
Answer : A
9. 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
A. first
B. Second
C. third
D. fourth
Answer : A
10. Which of the following is not a constraint on a single relation?
A. check
B. unique
C. not null
D. is duplicate
Answer : D
A. check
B. unique
C. not null
D. is duplicate
Answer : D
11. Count function in SQL returns the number of
A. values.
B. distinct values.
C. groups.
D. columns.
Answer : A
A. values.
B. distinct values.
C. groups.
D. columns.
Answer : A
12. 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
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
13. Specialization is a
A. top-down approach.
B. bottom-up approach.
C. left-right approach.
D. none of the above
Answer : A
A. top-down approach.
B. bottom-up approach.
C. left-right approach.
D. none of the above
Answer : A
14. Secondary storage
A. magnetic disk
B. magnetic tape
C. juke box
D. cache
Answer : A
A. magnetic disk
B. magnetic tape
C. juke box
D. cache
Answer : A
15. A transaction which completes successfully is called
A. Granted
B. Committed
C. Compensated
D. Accomplished
Answer : B
A. Granted
B. Committed
C. Compensated
D. Accomplished
Answer : B
16. Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
A. i ,iii only
B. ii, iv only
C. iii, iv only
D. ii, iii, iv
Answer : C
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
A. i ,iii only
B. ii, iv only
C. iii, iv only
D. ii, iii, iv
Answer : C
17. Natural mask for a Class A network
A. 255.0.0.0
B. 255.255.0.0
C. 255.255.255.0
D. none of these
Answer : A
A. 255.0.0.0
B. 255.255.0.0
C. 255.255.255.0
D. none of these
Answer : A
18. 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
A. Noise
B. Delay
C. Dispersion
D. Attenuation
Answer : D
19. The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
A. entity integrity rule
B. referential integrity constraint
C. composite attribute
D. action assertion
Answer : A
A. entity integrity rule
B. referential integrity constraint
C. composite attribute
D. action assertion
Answer : A
20. A functional dependency between two or more non-key attributes is called
A. Transitive dependency
B. Partial transitive dependency
C. Functional dependency
D. Partial functional dependency
Answer : A
A. Transitive dependency
B. Partial transitive dependency
C. Functional dependency
D. Partial functional dependency
Answer : A
21. What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A. A list of employees phone number
B. A list of all employees that have spouses, with phone number included in the list
C. A list of all employees names, including the phone number if they have one
D. Two lists : One list of employees, the other of phone numbers
Answer : C
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A. A list of employees phone number
B. A list of all employees that have spouses, with phone number included in the list
C. A list of all employees names, including the phone number if they have one
D. Two lists : One list of employees, the other of phone numbers
Answer : C
22. Object based data models are used in describing the abstraction of thefollowing levels?
A. Conceptual and view
B. Only physical
C. Physical and conceptual
D. Only conceptual
Answer : A
A. Conceptual and view
B. Only physical
C. Physical and conceptual
D. Only conceptual
Answer : A
23. In a Hierarchical model records are organized as
A. Graph.
B. List.
C. Links.
D. Tree.
Answer : D
A. Graph.
B. List.
C. Links.
D. Tree.
Answer : D
24. The access protocol used by traditional Ethernet
A. CSMA/CA
B. CSMA/CD
C. CSMA
D. Token ring
Answer : B
A. CSMA/CA
B. CSMA/CD
C. CSMA
D. Token ring
Answer : B
25. 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
A. sequential access storage
B. direct access storage
C. random access storage
D. none of the above
Answer : B
26. …………… 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
A. Storage manager
B. Admin
C. Transaction manager
D. none of the above
Answer : C
27. Which of the following works as a filter?
A. UPDATE
B. DROP
C. ALTER
D. SELECT
Answer : D
A. UPDATE
B. DROP
C. ALTER
D. SELECT
Answer : D
28. Which one of the following statements is false?
A. The data dictionary is normally maintained by the database administrator.
B. Data elements in the database can be modified by changing the data dictionary.
C. The data dictionary contains the name and description of each data element.
D. The data dictionary is a tool used exclusively by the database administrator.
Answer : B
A. The data dictionary is normally maintained by the database administrator.
B. Data elements in the database can be modified by changing the data dictionary.
C. The data dictionary contains the name and description of each data element.
D. The data dictionary is a tool used exclusively by the database administrator.
Answer : B
29. 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
A. empty
B. nonempty
C. contains null values
D. none of the above
Answer : B
30. Noiseless channel has ……… types of protocols.
A. 2
B. 3
C. 4
D. 5
Answer : A
A. 2
B. 3
C. 4
D. 5
Answer : A
31. In which of the following SET concept is used ?
A. Network Model
B. Hierarchical Model
C. Relational Model
D. None of these
Answer : A
A. Network Model
B. Hierarchical Model
C. Relational Model
D. None of these
Answer : A
32. The minimal set of super key is called
A. Primary key
B. Secondary key
C. Candidate key
D. Foreign key
Answer : C
A. Primary key
B. Secondary key
C. Candidate key
D. Foreign key
Answer : C
33. The number of cursors depend on the
A. number of queries
B. number of attributes
C. size of memory area
D. none of these
Answer : C
A. number of queries
B. number of attributes
C. size of memory area
D. none of these
Answer : C
34. The statement in SQL which allows to change the definition of a table is
A. Select
B. Update
C. Create
D. Alter
Answer : D
A. Select
B. Update
C. Create
D. Alter
Answer : D
35. 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
A. 12 bits
B. 16 bits
C. 24 bits
D. 28 bits
Answer : C
36. 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
A. not Null
B. Null
C. both Null & not Null.
D. any value.
Answer : A
37. Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
A. i and ii only
B. ii and iii only
C. ii only
D. i only
Answer : D
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
A. i and ii only
B. ii and iii only
C. ii only
D. i only
Answer : D
38. ............... noise is caused by the random motion of the electrons in a wire and is avoidable.
A. Thermal
B. Intermodulation
C. Cross talk
D. Impulse
Answer : A
A. Thermal
B. Intermodulation
C. Cross talk
D. Impulse
Answer : A
39. 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 : @
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 : @
40. In this data model each record can hae more than one parent
A. Hierarchical model
B. E-R model
C. Network based model
D. none of these
Answer : C
A. Hierarchical model
B. E-R model
C. Network based model
D. none of these
Answer : C
41. 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
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
42. Data Manipulation Language DML) is not to
A. Create information table in the Database
B. Insertion of new information into the Database
C. Deletion of information in the Database
D. Modification of information in the Database
Answer : A
A. Create information table in the Database
B. Insertion of new information into the Database
C. Deletion of information in the Database
D. Modification of information in the Database
Answer : A
43. Which of the following is not proper state of transaction ?
A. Partially aborted
B. Partially committed
C. Aborted
D. Committed
Answer : A
A. Partially aborted
B. Partially committed
C. Aborted
D. Committed
Answer : A
44. What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
A. i, ii and iii only
B. i, ii and iv only
C. ii, iii and iv only
D. i, iii and iv only
Answer : B
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
A. i, ii and iii only
B. i, ii and iv only
C. ii, iii and iv only
D. i, iii and iv only
Answer : B
45. In the architecture of a database system external level is the
A. physical level.
B. logical level.
C. conceptual level
D. view level.
Answer : D
A. physical level.
B. logical level.
C. conceptual level
D. view level.
Answer : D
46. .................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
A. Noise
B. Delay distortion
C. Attenuation distortion
D. Dispersion
Answer : B
A. Noise
B. Delay distortion
C. Attenuation distortion
D. Dispersion
Answer : B
47. A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
A. only i)
B. only i) and ii)
C. only ii) and iii)
D. i) ii) iii)
Answer : D
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
A. only i)
B. only i) and ii)
C. only ii) and iii)
D. i) ii) iii)
Answer : D
48. A DBMS query language is designed to
A. support end users who use English-like commands.
B. support in the development of complex applications software.
C. specify the structure of a database.
D. all of the above.
Answer : D
A. support end users who use English-like commands.
B. support in the development of complex applications software.
C. specify the structure of a database.
D. all of the above.
Answer : D
49. In which of the random-access method, stations do not sense the medium?
A. ALOHA
B. ETHERNET
C. CSMA/CA
D. CSMA/CD
Answer : A
A. ALOHA
B. ETHERNET
C. CSMA/CA
D. CSMA/CD
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
A. Inner join
B. Outer join
C. union
D. Intersect
Answer : B
Sharing is caring
Related Post
1000+ Php Programming MCQ for IBPS RRB [Solved]
SSC MTS - Chemical Engineering Thermodynamics 1000+ MCQ [Solved] PDF Download
Basics of Neurology 1000+ MCQ with answer for XAT
Engineering Materials 1000+ MCQ with answer for NEET PG
1000+ Problems on Trains MCQ for JEE Main [Solved]
CEED - Linux OS 1000+ MCQ [Solved] PDF Download