McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Computer Science Engineering (CSE) , Bachelor of Science in Computer Science FY (BSc CS) , Bachelor of Science in Computer Science SY (BSc CS) , Bachelor of Science in Information Technology SY (BSc IT) , Bachelor of Computer Applications (BCA) .
Chapters
| 1001. |
………………….. operator is basically a join followed by a project on the attributes of first relation. |
| A. | Join |
| B. | Semi-Join |
| C. | Full Join |
| D. | Inner Join |
| Answer» B. Semi-Join | |
| 1002. |
Which of the following is not a binary operator in relational algebra? |
| A. | Join |
| B. | Semi-Join |
| C. | Assignment |
| D. | Project |
| Answer» D. Project | |
| 1003. |
Centralizing the integrity checking directly under the DBMS ………….. duplication and ensures the consistency and validity of the database. |
| A. | Increases |
| B. | Skips |
| C. | Does not reduce |
| D. | Reduces |
| Answer» D. Reduces | |
| 1004. |
Which of the following is/are the DDL statements? |
| A. | Create |
| B. | Drop |
| C. | Alter |
| D. | All of the above |
| Answer» D. All of the above | |
| 1005. |
---------------- is used to retrieve tuples from the relation. |
| A. | Create |
| B. | Drop |
| C. | Select |
| D. | All of the above |
| Answer» C. Select | |
| 1006. |
……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity. |
| A. | Column |
| B. | Constraint |
| C. | Index |
| D. | Trigger |
| Answer» B. Constraint | |
| 1007. |
For like predicate which of the following is true. i) % matches zero of more characters. ii) _ matches exactly one character. |
| A. | i-only |
| B. | ii-only |
| C. | Both of them |
| D. | None of them |
| Answer» C. Both of them | |
| 1008. |
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………. |
| A. | Fields |
| B. | Records |
| C. | Relations |
| D. | Keys |
| Answer» C. Relations | |
| 1009. |
……………….. contains information that defines valid values that are stored in a column or data type. |
| A. | View |
| B. | Rule |
| C. | Index |
| D. | Default |
| Answer» C. Index | |
| 1010. |
Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values> |
| A. | i-only |
| B. | ii-only |
| C. | Both of them |
| D. | None of them |
| Answer» C. Both of them | |
| 1011. |
………………. first proposed the process of normalization. |
| A. | Edgar. W |
| B. | Edgar F. Codd |
| C. | Edward Stephen |
| D. | Edward Codd |
| Answer» B. Edgar F. Codd | |
| 1012. |
For using a specific database …………… command is used. |
| A. | Use database |
| B. | <Database name> use |
| C. | Both A &B |
| D. | None of them |
| Answer» A. Use database | |
| 1013. |
Which of the following is not comparison operator? |
| A. | <> |
| B. | < |
| C. | =< |
| D. | >= |
| Answer» C. =< | |
| 1014. |
An outstanding functionality of SQL is its support for automatic ………… to the target data. |
| A. | Programming |
| B. | Functioning |
| C. | Navigation |
| D. | Notification |
| Answer» C. Navigation | |
| 1015. |
………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations. |
| A. | Entity Integrity Constraints |
| B. | Referential Integrity Constraints |
| C. | Domain Integrity Constraints |
| D. | Key Constraints |
| Answer» B. Referential Integrity Constraints | |
| 1016. |
……………..specifies a search condition for a group or an aggregate. |
| A. | GROUP BY Clause |
| B. | HAVING Clause |
| C. | FROM Clause |
| D. | WHERE Clause |
| Answer» B. HAVING Clause | |
| 1017. |
Drop Table cannot be used to drop a table referenced by a …………… constraint. |
| A. | Local Key |
| B. | Primary Key |
| C. | Composite Key |
| D. | Foreign Key |
| Answer» D. Foreign Key | |
| 1018. |
Which are the not features of a DBMS which provide a number of advantages for data management: |
| A. | DML |
| B. | DDL |
| C. | SDL |
| D. | None of these |
| Answer» D. None of these | |
| 1019. |
Minimal data redundancy means improved _________: |
| A. | Data independence |
| B. | Data consistency |
| C. | Data integration |
| D. | Data sharing |
| Answer» B. Data consistency | |
| 1020. |
Who access the database occasionally and have different needs each time: |
| A. | Naïve users |
| B. | Casual users |
| C. | Sophisticated user |
| D. | All of these |
| Answer» B. Casual users | |
| 1021. |
System analyst and application programmers are commonly referred to as ……………………. |
| A. | Naïve users |
| B. | Casual users |
| C. | Software engineers |
| D. | Programmers |
| Answer» C. Software engineers | |
| 1022. |
Who interact with the system without writing a program: |
| A. | Naïve users |
| B. | Casual users |
| C. | Sophisticated user |
| D. | All of these |
| Answer» C. Sophisticated user | |
| 1023. |
Who interact with the system by invoking one of the permanent application program: |
| A. | Naïve users |
| B. | Casual users |
| C. | Sophisticated user |
| D. | All of these |
| Answer» A. Naïve users | |
| 1024. |
The main interface that a naive user uses is a form interface using___: |
| A. | DDL |
| B. | GUI |
| C. | OLAP |
| D. | DML |
| Answer» B. GUI | |
| 1025. |
The provision of _______ is a major objective for database system: |
| A. | Data independence |
| B. | Data consistency |
| C. | Data integration |
| D. | Data sharing |
| Answer» A. Data independence | |
| 1026. |
____ is a translates into low-level instruction that a query processor understands: |
| A. | DBA |
| B. | DBMS |
| C. | DBS |
| D. | DDL compiler |
| Answer» D. DDL compiler | |
| 1027. |
Retrieval of data is done by using a ____: |
| A. | Stack |
| B. | Query |
| C. | Linked list |
| D. | All of these |
| Answer» B. Query | |
| 1028. |
DML is a language by which user accesses or manipulates the ________: |
| A. | Data model |
| B. | Data consistency |
| C. | Data integration |
| D. | Data sharing |
| Answer» A. Data model | |
| 1029. |
Which is the central component of the DBMS software that can also be termed as the database control system? |
| A. | Data consistency |
| B. | Data integration |
| C. | Data sharing |
| D. | Data manager |
| Answer» D. Data manager | |
| 1030. |
Which is stored information about description of data in the database: |
| A. | Data files |
| B. | Data dictionary |
| C. | Database |
| D. | Data administrator |
| Answer» B. Data dictionary | |
| 1031. |
After conversion of high level queries into low level commands for file access and is called compiled_____: |
| A. | DDL |
| B. | DML |
| C. | SDL |
| D. | VDL |
| Answer» B. DML | |
| 1032. |
Which is installs, configures, troubleshoots and maintains a database system: |
| A. | DBA |
| B. | DDL |
| C. | DML |
| D. | SDL |
| Answer» A. DBA | |
| 1033. |
Which is incorporated to create an appropriate physical database that is transformed by a logical data model: |
| A. | SDL |
| B. | VDL |
| C. | Both |
| D. | None |
| Answer» D. None | |
| 1034. |
In which end is really just any application that runs on top of the DBMS and acts as a user interface: |
| A. | Back end |
| B. | Front end |
| C. | Both |
| D. | None |
| Answer» B. Front end | |
| 1035. |
Data are stored in________ as database: |
| A. | Data files |
| B. | Data dictionary |
| C. | Database |
| D. | Data administrator |
| Answer» A. Data files | |
| 1036. |
ACID properties of transactions are |
| A. | Atomicity |
| B. | Consistency |
| C. | Isolation |
| D. | Durability |
| Answer» D. Durability | |
| 1037. |
DA stands for: |
| A. | Data administrator |
| B. | Database active |
| C. | Define application |
| D. | All of these |
| Answer» A. Data administrator | |
| 1038. |
Which is the person responsible for overall control f the database system: |
| A. | DDL |
| B. | DBMS |
| C. | DBA |
| D. | SDL |
| Answer» C. DBA | |
| 1039. |
DBA stands for: |
| A. | Database maintenance |
| B. | Database administrator |
| C. | Database backup |
| D. | Database designer |
| Answer» B. Database administrator | |
| 1040. |
Transaction is an action used to perform some manipulation on data stored in the____: |
| A. | Memory |
| B. | Record |
| C. | Database |
| D. | All of these |
| Answer» C. Database | |
| 1041. |
The data in the database at a particular moment in time is called a ________________ |
| A. | Database state |
| B. | Valid state |
| C. | Initial state |
| D. | Empty state |
| Answer» A. Database state | |
| 1042. |
Which is a DBMS keeps back-up copies of the database: |
| A. | Backup |
| B. | Recovery |
| C. | Both |
| D. | None |
| Answer» A. Backup | |
| 1043. |
In which the database can be restored up to the last consistent state after the system failure: |
| A. | Backup |
| B. | Recovery |
| C. | Both |
| D. | None |
| Answer» B. Recovery | |
| 1044. |
How many levels of abstraction in DBMS: |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» B. 3 | |
| 1045. |
Which are the three levels of abstraction: |
| A. | Physical |
| B. | Logical |
| C. | External |
| D. | All of these |
| Answer» D. All of these | |
| 1046. |
How many types of data independence: |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» B. 2 | |
| 1047. |
Which are the types of data independence: |
| A. | Physical |
| B. | Logical |
| C. | Both |
| D. | All of these |
| Answer» C. Both | |
| 1048. |
Which is the transformation of requests and results between different levels of abstraction: |
| A. | Evaluation |
| B. | Mapping |
| C. | Compiler |
| D. | Precompiler |
| Answer» B. Mapping | |
| 1049. |
Which mapping exists between the conceptual and internal levels: |
| A. | Conceptual |
| B. | Internal |
| C. | Both |
| D. | None |
| Answer» C. Both | |
| 1050. |
Which mapping exists between the external and conceptual levels: |
| A. | Conceptual |
| B. | External |
| C. | Both |
| D. | None |
| Answer» C. Both | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.