MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is a degree of relation? |
| A. | It is the number of attributes of its relation schema. |
| B. | The number of relationships with other tables |
| C. | Number of association among two or more entities |
| D. | Number of foreign key dependencies |
| Answer» B. The number of relationships with other tables | |
| 2. |
Which command helps to display schema of a table? |
| A. | DESCRIBE |
| B. | DISPLAY |
| C. | DESC |
| D. | SHOW |
| Answer» B. DISPLAY | |
| 3. |
Which command allows the user to change multiple fields? |
| A. | Modify |
| B. | Lookup |
| C. | Update |
| D. | Change |
| Answer» D. Change | |
| 4. |
What is degree 0 isolation? |
| A. | Transaction does not read dirty data from other transactions. |
| B. | Transaction does not commit any writes until it completes all its writes. |
| C. | Transactions do not dirty data read by a transaction before the transaction commits. |
| D. | A transaction does not overwrite data updated by another user or process. |
| Answer» E. | |
| 5. |
Which type of lock ensures that multiple updates cannot be made to the same resource at the same time? |
| A. | Schema |
| B. | Shared |
| C. | Exclusive |
| D. | Intent |
| Answer» D. Intent | |
| 6. |
Under which category do the commands CREATE and ALTER belong to? |
| A. | DML |
| B. | DDL |
| C. | UML |
| D. | None of the above. |
| Answer» C. UML | |
| 7. |
Which of the following is / are known as a minimal superkey? |
| A. | Primary key |
| B. | Foreign key |
| C. | Unique key |
| D. | Candidate key |
| Answer» E. | |
| 8. |
What type of database object represents a result set and is used to manipulate data row by row? |
| A. | Trigger |
| B. | Procedure |
| C. | Cursor |
| D. | Monitor |
| Answer» D. Monitor | |
| 9. |
What relationships does Referential integrity control? |
| A. | Attributes in a table |
| B. | Operations of an object |
| C. | Instances of a class |
| D. | Tables in a database |
| Answer» B. Operations of an object | |
| 10. |
What are the following types of?SERIALIZABLEREPEATABLE READREAD COMMITTED |
| A. | Locks |
| B. | Logs |
| C. | Isolation level |
| D. | Latch types |
| Answer» D. Latch types | |
| 11. |
State the main difference between a latch and a lock. |
| A. | Locks are more restrictive than Latches in that they are always exclusive. |
| B. | Latches are more restrictive than locks in that they are always exclusive. |
| C. | Latch is used to protect data while lock is not. |
| D. | Lock is used to protect data while latch is not. |
| Answer» C. Latch is used to protect data while lock is not. | |
| 12. |
Which of the following command executes faster? |
| A. | Copy File < FILE 1>< FILE 2 > |
| B. | Copy Structure to < NEW FILE > |
| C. | Copy to M FILE - DAT DELIMITED. |
| D. | Copy to < New file > |
| Answer» C. Copy to M FILE - DAT DELIMITED. | |
| 13. |
What is a report generator used for? |
| A. | Update Files |
| B. | Print Files |
| C. | Alter files |
| D. | All the above |
| Answer» C. Alter files | |
| 14. |
What is a master list of index file? |
| A. | Has a number assigned to each record |
| B. | Is sorted in ascending order |
| C. | Contains only a list of keys and record number |
| D. | Both A and B. |
| Answer» B. Is sorted in ascending order | |
| 15. |
Which of the following is not true regarding to traditional information processing? |
| A. | Common sharing of data between applications |
| B. | Is file oriented |
| C. | Programs are dependent on the files |
| D. | It is inflexible |
| Answer» B. Is file oriented | |
| 16. |
Which of the following is not a relational data of DBMS? |
| A. | FOX PRO |
| B. | dBASE IV |
| C. | 4th Dimension |
| D. | ReFlex |
| Answer» B. dBASE IV | |
| 17. |
What does a form define? |
| A. | Where data is placed on screen |
| B. | The width of each field |
| C. | Both A and B |
| D. | None of the above |
| Answer» C. Both A and B | |
| 18. |
What information is not provided by a data dictionary? |
| A. | How data is used |
| B. | Where data is located |
| C. | Size of storage disk |
| D. | Who owns or is responsible for data |
| Answer» D. Who owns or is responsible for data | |
| 19. |
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? |
| A. | Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key, EMPID; |
| B. | Update table EMPLOYEE Add Constraint PK - EMPID Primary Key (EMPID); |
| C. | Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key (EMPID); |
| D. | Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key, (EMPID); |
| Answer» D. Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key, (EMPID); | |
| 20. |
What is a transparent DBMS? |
| A. | Keeps its logical structure hidden from users |
| B. | Keeps its physical structure hidden from users |
| C. | Cannot hide sensitive information from users. |
| D. | Both A and B. |
| Answer» D. Both A and B. | |
| 21. |
Between what can information be transferred? |
| A. | DBMS to Spread sheet program |
| B. | DBMS to Word processor program |
| C. | DBMS to Graphics program |
| D. | All of the above |
| Answer» D. All of the above | |
| 22. |
Which of the following provides an access path? |
| A. | Physical record key |
| B. | Private key |
| C. | File key |
| D. | None of the above |
| Answer» D. None of the above | |
| 23. |
Which of the following is true regarding indexing operation? |
| A. | Established an index for a file |
| B. | Sorts a file using a single key |
| C. | Sorts a file using two keys |
| D. | Both B and C |
| Answer» B. Sorts a file using a single key | |
| 24. |
What are the properties of Relational Database model? |
| A. | Data is presented as a collection of relations. |
| B. | Each relation is depicted as a table |
| C. | Each row ( tuple ) represents as a single entity |
| D. | All of the above |
| Answer» E. | |
| 25. |
Abbreviate ACID. |
| A. | Atomicity, Consistency, Isolation, Durability |
| B. | Atomicity, Concurrency, Isolation, Duplicity |
| C. | Aggregation, Consistency, Isolation, Durability |
| D. | Atomicity, Consistency, Identity, Durability |
| Answer» B. Atomicity, Concurrency, Isolation, Duplicity | |
| 26. |
What data structure is used to construct a Prev LSN in a database log? |
| A. | Queue |
| B. | Link List |
| C. | Graph |
| D. | Tree |
| Answer» C. Graph | |
| 27. |
What stores the metadata about the structure of the database, in particular the schema of the database? |
| A. | Indices |
| B. | Database log |
| C. | Data files |
| D. | Data Dictionary |
| Answer» E. | |
| 28. |
Which of the following language is used to define the integrity constraints? |
| A. | DCL |
| B. | DML |
| C. | DDL |
| D. | All of the above |
| Answer» D. All of the above | |
| 29. |
How many primary key can a table in database have? |
| A. | Only one |
| B. | At least one |
| C. | More than one |
| D. | Any number of |
| Answer» B. At least one | |
| 30. |
What does a query processor do in semantic checking? |
| A. | Checks whether all the relations mentioned under the FROM clause in the SQL statement are from the database the user is referenced. |
| B. | 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 WHERE clauses of the SQL statement. |
| C. | Verifies whether the types of attributes are compatible with the values used for the attributes. |
| D. | All of these. |
| Answer» E. | |
| 31. |
What is the maximum length of a field name? |
| A. | 10 characters |
| B. | 30 characters |
| C. | 50 characters |
| D. | 20 characters |
| Answer» B. 30 characters | |
| 32. |
Where can a subschema be used? |
| A. | Present information in different formats |
| B. | Create very different personalized view of the same data |
| C. | Hide sensitive information |
| D. | All of the above |
| Answer» D. All of the above | |
| 33. |
What is used to delete an entire file except for a file structure? |
| A. | Eraser |
| B. | Pack |
| C. | Delete |
| D. | Zap |
| Answer» E. | |
| 34. |
What is the generalization of functional dependencies? |
| A. | Database dependencies |
| B. | Key dependencies |
| C. | Relation dependencies |
| D. | None of these |
| Answer» C. Relation dependencies | |
| 35. |
What is a network structure? |
| A. | Domi t database. |
| B. | Is physical representation of data |
| C. | Many to many relationship |
| D. | Is conceptually simple |
| Answer» D. Is conceptually simple | |
| 36. |
Which command permanently deletes the record from database? |
| A. | PACK |
| B. | ZAP |
| C. | SEEK |
| D. | SKIP |
| Answer» B. ZAP | |
| 37. |
What is a trigger? |
| A. | It is a procedural code which is executed automatically in response to certain events on a particular table or view. |
| B. | Statement that enables to start any DBMS. |
| C. | Condition the system tests for the validity of the database user. |
| D. | Statement that is executed by the user when debugging an application program. |
| Answer» B. Statement that enables to start any DBMS. | |
| 38. |
How can a tuple be divided in a relational schema? |
| A. | Domains |
| B. | Queries |
| C. | Relations |
| D. | Joins |
| Answer» B. Queries | |
| 39. |
How is specialization denoted in an ER Diagram? |
| A. | Triangle labeled IS A |
| B. | Rectangle labeled IS A |
| C. | Rectangle Labeled HAS A |
| D. | Triangle labeled HAS A |
| Answer» B. Rectangle labeled IS A | |
| 40. |
What is a schedule for a set of transactions? |
| A. | It consists of all instructions of those transactions. |
| B. | It preserve the order in which the instructions appear in each individual transaction. |
| C. | Both a and b |
| D. | None of these |
| Answer» D. None of these | |
| 41. |
An unnormalized relation contains values ? |
| A. | Atomic |
| B. | Non - Atomic |
| C. | Classified |
| D. | None of these |
| Answer» D. None of these | |
| 42. |
Database: To avoid the problem of updating you can take the following principle for a good database design. |
| A. | Unrelated data should be kept in different table. |
| B. | Table should not contain any redundancy. |
| C. | Table should represent constraint. |
| D. | All the above |
| Answer» E. | |
| 43. |
Databases: The view of total database content is _____ |
| A. | Conceptual view. |
| B. | Internal view. |
| C. | External view |
| D. | Physical View. |
| Answer» B. Internal view. | |
| 44. |
What are the important criteria for designing tables? (Datebases) |
| A. | Meaningful grouping of attribute |
| B. | No redundancy |
| C. | No inapplicable attribute |
| D. | All the above |
| Answer» E. | |
| 45. |
Which of the following database object does not physically exist? (Database) |
| A. | Base table |
| B. | Index |
| C. | View |
| D. | None of the above |
| Answer» D. None of the above | |
| 46. |
A trigger is ? |
| A. | A statement that enables to start any DBMS |
| B. | A statement that is executed by the user when debugging an application program |
| C. | A condition the system tests for the validity of the database user |
| D. | A statement that is executed automatically by the system as a side effect of modification to the database |
| Answer» E. | |
| 47. |
Primitive operations common to all record management system include ? (Database) |
| A. | |
| B. | Sort |
| C. | Look up |
| D. | All of above |
| Answer» D. All of above | |
| 48. |
Database: In second normal form ______________________ |
| A. | A composite attributes is converted to individual attributes. |
| B. | Non key attributes are functional dependent on key attributes. |
| C. | The non key attributes functionally dependent on not a part of key attributes. |
| D. | All the above. |
| Answer» C. The non key attributes functionally dependent on not a part of key attributes. | |
| 49. |
Database: Which is not a function of aggregate function? |
| A. | Count |
| B. | Avg |
| C. | Create |
| D. | Max |
| Answer» D. Max | |
| 50. |
Consider an SQL querySELECT A.Id FROM A WHERE A.Age>All (SELECT B.Age FROM B WHERE B.name = Anay )The result of this query contains |
| A. | 1 tuple |
| B. | 2 tuples |
| C. | 3 tuples |
| D. | 4 tuples |
| Answer» D. 4 tuples | |