🧪 Source (programming language) MCQ Quiz Hub

1. Which of the following is an Open Source DBMS?
MySQL
Microsoft SQL Server
Microsoft Access
Oracle

2. When a primary key is define in the table, DBMS automatically creates a ____ on a primary key column.
Unique index
Sequence
Trigger
Synonym

3. Match the following A) Composite attribute ------ i) Attribute whose value is calculated from other attributes B) Multivalued Attribute ---- ii) Attribute that can be further subdivided to yield additional attributes C) Derived Attribute -------- iii) Attribute that can have more values
A-i, B-ii, C-iii
A-ii, B-i, C-iii
A-ii, B-iii, C-i
A-iii, B-ii, C-i

4. Which normal form is the partial dependency removed?
First
Second
Third
BCNF

5. What is the responsibility of the buffer manager?
Fetching data from disk storage into main memory, and deciding what data to cache in main memory.
Allocation of space on disk storage and the data structures used to represent information stored on disk.
Storing details such as how many users, which user has which permissions etc.
None of the above

6. The problem caused by independent multivalued dependencies is eliminated in which of the normal form?
3NF
BCNF
4NF
5NF

7. Which is not the relational algebra operator?
Set difference
Cartesian product
Rename
Join

8. An attribute or combination of attributes in one table whose values must either match the primary key in another table or be null is called __________.
Secondary Key
Super key
Candidate Key
Foreign Key

9. A transaction state changes from active to______, after the transaction has been rolled back and the database restored to its state prior to the start of the transaction.
Partially committed
Committed
Aborted
Failed

10. How is specialization denoted in an ER Diagram?
Triangle labeled IS A
Rectangle labeled IS A
Rectangle Labeled HAS A
Triangle labeled HAS A

11. What is Degree of relationships?
number of participating entity types
number of participating relations
number of participating attribute types
number of participating constraints

12. What does a query processor do in semantic checking?
Checks whether all the relations mentioned under the FROM clause in the SQL statement are from the database the user is referenced.
Checks all the attribute values and also checks whether they exist in a particular relation that is specified in the query. It checks all the attribute values that are mentioned in the SELECT and WHER
Verifies whether the types of attributes are compatible with the values used for the attributes
All of the above

13. Generalization is a bottom up design process that combines a number of entity sets, which share the same features into a higher level entity set.
True b.
False
Error
Can't say

14. How many primary key can a table in database have?
Only one
At least one
More than one
Any number of

15. Which of the following language is used to define the integrity constraints?
DCL
DML
DDL
All of the above

16. What stores the metadata about the structure of the database, in particular the schema of the database?
Indices
Database log
Data files
Data Dictionary

17. What data structure is used to construct a Prev LSN in a database log?
Queue
Link List
Graph
Tree

18. Abbreviate ACID.
Atomicity, Consistency, Isolation, Durability
Atomicity, Concurrency, Isolation, Duplicity
Aggregation, Consistency, Isolation, Durability
Atomicity, Consistency, Identity, Durability

19. What is a schedule for a set of transactions?
It consists of all instructions of those transactions.
It preserve the order in which the instructions appear in each individual transaction.
both (a) and (b)
None of these

20. Which is the correct SQL syntax from the following to create a PRIMARY KEY constraint on existing table “ EMPLOYEE ” on " EMPID " column and currently column does not contain any value?
Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key, EMPID;
Update table EMPLOYEE Add Constraint PK - EMPID Primary Key (EMPID);
Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key (EMPID);
Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key (EMPID);

21. What information is not provided by a data dictionary?
How data is used
Where data is located
Size of storage disk
Who owns or is responsible for data

22. What is a master list of index file?
Has a number assigned to each record
Is sorted in ascending order
Contains only a list of keys and record number
None of These

23. What does a form define?
Where data is placed on screen
The width of each field
Both A and B
None of the above

24. Which of the following is not a relational data of DBMS?
FOX PRO
dBASE IV
4th Dimension
ReFlex

25. Which of the following is not true regarding to traditional information processing?
Common sharing of data between applications
Is file oriented
Programs are dependent on the files
It is inflexible

26. Which command permanently deletes the record from database?
PACK
ZAP
SEEK
SKIP

27. What is a network structure?
Dominant database.
Is physical representation of data
Many to many relationship
Is conceptually simple

28. What is the generalization of functional dependencies?
Database dependencies
Key dependencies
Relation dependencies
None of these

29. What is the maximum length of a field name?
10 characters
30 characters
50 characters
20 characters

30. Data items are composed of data elements.
True
False
Error
Can not say

31. What is used to delete an entire file except for a file structure?
Eraser
Pack
Delete
Zap

32. Where can a subschema be used?
Present information in different formats
Create very different personalized view of the same data
Hide sensitive information
All of the above

33. How can a tuple be divided in a relational schema?
Domains
Queries
Relations
Joins

34. What is a trigger?
It is a procedural code which is executed automatically in response to certain events on a particular table or view.
Statement that enables to start any DBMS.
Condition the system tests for the validity of the database user.
Statement that is executed by the user when debugging an application program.

35. What are the properties of Relational Database model?
Data is presented as a collection of relations.
Each relation is depicted as a table
Each row ( “ tuple ” ) represents as a single entity
All of the above

36. Which of the following is true regarding indexing operation?
Established an index for a file
Sorts a file using a single key
Sorts a file using two keys
Both B and C

37. Which of the following provides an access path?
Physical record key
Private key
b.c. File key
None of These

38. Between what can information be transferred?
DBMS to Spread sheet program
DBMS to Word processor program
DBMS to Graphics program
All of the above

39. What is a transparent DBMS?
Keeps its logical structure hidden from users
Keeps its physical structure hidden from users
Cannot hide sensitive information from users.
Both A and B.

40. What is a report generator used for?
Update Files
Print Files
Alter files
All of the above

41. Which command allows the user to change multiple fields?
Modify
Lookup
Update
Change

42. Which of the following command executes faster?
Copy File < FILE 1>< FILE 2 >
Copy Structure to < NEW FILE > c. . d.
Copy to M FILE - DAT DELIMITED
Copy to < New file >

43. State the main difference between a latch and a lock.
Locks are more restrictive than Latches in that they are always exclusive.
Latches are more restrictive than locks in that they are always exclusive.
Latch is used to protect data while lock is not.
Lock is used to protect data while latch is not.

44. What are the following types of? SERIALIZABLE REPEATABLE READ
Locks
Logs
Isolation level
Latch types

45. What relationships does Referential integrity control?
Attributes in a table
Operations of an object
Instances of a class
Tables in a database

46. What type of database object represents a result set and is used to manipulate data row by row?
Trigger
Procedure
Cursor
Monitor

47. Which of the following is / are known as a minimal superkey?
Primary key
Foreign key
Unique key
Candidate key

48. What is a degree of relation?
It is the number of attributes of its relation schema.
The number of relationships with other tables
Number of association among two or more entities
Number of foreign key dependencies

49. Under which category do the commands CREATE and ALTER belong to?
DML
DDL
UML
None of these

50. Which type of lock ensures that multiple updates cannot be made to the same resource at the same time?
Schema
Shared
Exclusive
Intent