Advance DBMS 1000+ MCQ with answer for SSC JHT
Thursday 9th of March 2023
Sharing is caring
1. …………… 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
2. 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
A. Physical data independence
B. Logical data independence
C. External data independence
D. Static data
Answer : B
3. 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
4. In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
A. parallel
B. serial
C. analog
D. digital
Answer : A
A. parallel
B. serial
C. analog
D. digital
Answer : A
5. 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
6. A relation that has no partial dependencies is in which normal form
A. First
B. Second
C. Third
D. BCNF
Answer : B
A. First
B. Second
C. Third
D. BCNF
Answer : B
7. 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
A. primary storage
B. secondary storage
C. tertiary storage
D. none of the above
Answer : B
8. Aggregate functions are also called
A. serial functions
B. non-serial functions
C. row functions
D. column functions
Answer : D
A. serial functions
B. non-serial functions
C. row functions
D. column functions
Answer : D
9. 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
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
10. 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
A. Field-level lock
B. Row-level lock
C. Table-level lock
D. Database-level lock
Answer : A
11. Select the incorrect statement
A. BCNF is stronger than 3NF
B. Relational algebra is a non-procedural language
C. Every conflict serializable schedule is view serializable.
D. none of the above
Answer : B
A. BCNF is stronger than 3NF
B. Relational algebra is a non-procedural language
C. Every conflict serializable schedule is view serializable.
D. none of the above
Answer : B
12. 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
A. Data rate
B. Bit rate
C. Signal to Noise Ratio
D. Baud rate
Answer : D
13. 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
14. A fragmentation is categorized in
A. 1 part
B. 2 part
C. 3 part
D. 4 part
Answer : C
A. 1 part
B. 2 part
C. 3 part
D. 4 part
Answer : C
15. which of the following is a binary operation?
A. project
B. select
C. rename
D. none of the above
Answer : D
A. project
B. select
C. rename
D. none of the above
Answer : D
16. Select the incorrect statement
A. View is derived from other tables.
B. Once a transaction has executed commit work its effect cant be undone by rollback work .
C. The input to the aggregate function avg can be non numeric data types
D. A primary key can never be null.
Answer : C
A. View is derived from other tables.
B. Once a transaction has executed commit work its effect cant be undone by rollback work .
C. The input to the aggregate function avg can be non numeric data types
D. A primary key can never be null.
Answer : C
17. In an Entity-Relationship Diagram Ellipses represents
A. Attributes
B. Weak entity set
C. Relationship sets
D. Multi-valued attributes
Answer : A
A. Attributes
B. Weak entity set
C. Relationship sets
D. Multi-valued attributes
Answer : A
18. Benefit of database normalization is
A. smaller number of tables
B. higher query processing efficiency
C. reduced I/O for most queries
D. reduced data redundancy
Answer : D
A. smaller number of tables
B. higher query processing efficiency
C. reduced I/O for most queries
D. reduced data redundancy
Answer : D
19. Which of the following submit and execute query at run time?
A. Static SQL
B. Dynamic SQL
C. both
D. none of these
Answer : B
A. Static SQL
B. Dynamic SQL
C. both
D. none of these
Answer : B
20. Which of the following is not an Aggregate function?
A. Min
B. Max
C. Select
D. Avg
Answer : C
A. Min
B. Max
C. Select
D. Avg
Answer : C
21. Multivalued dependency is removed in
A. 4 NF
B. 3 NF
C. 2 NF
D. 1 NF
Answer : A
A. 4 NF
B. 3 NF
C. 2 NF
D. 1 NF
Answer : A
22. The language used in application programs to request data from the DBMS is referred to as the
A. DML
B. DDL
C. VDL
D. SDL
Answer : A
A. DML
B. DDL
C. VDL
D. SDL
Answer : A
23. 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
A. Backup
B. Recovery
C. Grant
D. Troubleshooting
Answer : B
24. Which one of the following is provided by a data dictionary ?
A. User data
B. Database structure data
C. Sorted data
D. Functional data
Answer : B
A. User data
B. Database structure data
C. Sorted data
D. Functional data
Answer : B
25. Cross Product is a:
A. Unary Operator
B. Binary Operator
C. Ternary Operator
D. none of the above
Answer : B
A. Unary Operator
B. Binary Operator
C. Ternary Operator
D. none of the above
Answer : B
26. In two-phase locking
A. the data items are locked in growing phase.
B. the data items are released in shrinking phase.
C. Both A and B are true
D. Both A and B are false
Answer : C
A. the data items are locked in growing phase.
B. the data items are released in shrinking phase.
C. Both A and B are true
D. Both A and B are false
Answer : C
27. File organization that provides fast access to any arbitrary record
A. Hashed file
B. B-tree
C. Ordered file
D. Unordered file
Answer : A
A. Hashed file
B. B-tree
C. Ordered file
D. Unordered file
Answer : A
28. Expand the acronym OLAP
A. Object Linked Access Program
B. Organizational Architecture Processing
C. Online Analytical Processing
D. none of these
Answer : C
A. Object Linked Access Program
B. Organizational Architecture Processing
C. Online Analytical Processing
D. none of these
Answer : C
29. In mesh topology, if the number of devices is n , then the number of ports present in each device is
A. n
B. n+1
C. n-1
D. n/2
Answer : C
A. n
B. n+1
C. n-1
D. n/2
Answer : C
30. 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
A. select all from tablename
B. select * from tablename
C. select from tablename
D. none of these
Answer : B
31. 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
32. RAID
A. Redundant Arrays of Independent Disks
B. Redundant Arrays of Independent Drives
C. Redundant Arrays of Interconnected Drives
D. Redundant Arrays of Interconnected Disks
Answer : A
A. Redundant Arrays of Independent Disks
B. Redundant Arrays of Independent Drives
C. Redundant Arrays of Interconnected Drives
D. Redundant Arrays of Interconnected Disks
Answer : A
33. An association of several structure of a data base can be expressed graphically by?
A. Tuple
B. Record
C. Relationship
D. Field
Answer : C
A. Tuple
B. Record
C. Relationship
D. Field
Answer : C
34. A data manipulation command the combines the records from one or more tables is called
A. SELECT
B. PROJECT
C. JOIN
D. PRODUCT
Answer : C
A. SELECT
B. PROJECT
C. JOIN
D. PRODUCT
Answer : C
35. 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
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
36. The degree of the table with 500 rows and 7 columns is
A. 500
B. 7
C. 3500
D. none of these
Answer : B
A. 500
B. 7
C. 3500
D. none of these
Answer : B
37. 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
38. 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
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
39. 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
40. 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
i) Noisy channel
ii) Noiseless channel
A. i only
B. ii only
C. Both
D. None of these
Answer : B
41. Functional dependencies are generalization of
A. Relation dependencies
B. Data dependencies
C. key dependencies
D. none of the above
Answer : A
A. Relation dependencies
B. Data dependencies
C. key dependencies
D. none of the above
Answer : A
42. 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
43. Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
A. BCNF
B. Second
C. Third
D. Fourth
Answer : A
A. BCNF
B. Second
C. Third
D. Fourth
Answer : A
44. 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
45. In RDBMS, Data is presented as a collection of
A. Relation
B. Table
C. Attribute
D. Entity
Answer : A
A. Relation
B. Table
C. Attribute
D. Entity
Answer : A
46. 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
A. where
B. exist
C. with
D. select
Answer : C
47. An advantage of the database management approach is
A. data is dependent on programs.
B. data redunancy increases.
C. data is integrated and can be accessed by multiple programs.
D. none of the above.
Answer : C
A. data is dependent on programs.
B. data redunancy increases.
C. data is integrated and can be accessed by multiple programs.
D. none of the above.
Answer : C
48. Triggers are also called
A. active rules
B. passive rules
C. inferences
D. none of the above
Answer : A
A. active rules
B. passive rules
C. inferences
D. none of the above
Answer : A
49. 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
A. Subschema of the database
B. Schema of the database
C. Structure of the database
D. View of the database
Answer : B
50. In E-R Diagram weak entity set are represented by
A. Ellipse
B. Dashed ellipse
C. Dashed Rectangle
D. Doubled Rectangle
Answer : D
A. Ellipse
B. Dashed ellipse
C. Dashed Rectangle
D. Doubled Rectangle
Answer : D
Sharing is caring
Related Post
Steam Boilers, Engines, Nozzles & Turbines MCQ Solved Paper for SSC JE
English Grammer 1000+ MCQ with answer for SSC JHT
1000+ Urologic infections and inflammations Multiple Choice Question Answer [Solved]
1000+ Airport Engineering Multiple Choice Question Answer [Solved]
Auto CAD 2D 1000+ MCQ with answer for SSC Scientific Assistant
1000+ General Biology Set 2 Multiple Choice Question Answer [Solved]