MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 139 Mcqs, each offering curated multiple-choice questions to sharpen your Technical Programming knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
To obtain the structure of an Oracle table, the command to use is: |
| A. | STRUCTURE [TableName]. |
| B. | DESCRIBE [TableName]. |
| C. | DESCRIBE STRUCTURE [TableName]. |
| D. | DESC TABLE [TableName]. |
| Answer» C. DESCRIBE STRUCTURE [TableName]. | |
| 2. |
A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________ |
| A. | DCL |
| B. | DML |
| C. | DDL |
| D. | All of the Mentioned |
| Answer» D. All of the Mentioned | |
| 3. |
The Database Language That Allows You To Access Or Maintain Data In A Database |
| A. | DCL |
| B. | DML |
| C. | DDL |
| D. | All of the Mentioned |
| Answer» B. DML | |
| 4. |
DCL Provides Commands To Perform Actions Like _____________ |
| A. | Change The Structure Of Tables |
| B. | Insert, Update Or Delete Records And Data Values |
| C. | Authorizing Access And Other Control Over Database |
| D. | None of the Mentioned |
| Answer» D. None of the Mentioned | |
| 5. |
Which of the following keyword is used with Data Control Language (DCL) statements? |
| A. | SELECT |
| B. | INSERT |
| C. | DELETE |
| D. | GRANT |
| Answer» E. | |
| 6. |
A transaction completes its execution is said to be |
| A. | Committed |
| B. | Aborted |
| C. | Rolled back |
| D. | Failed |
| Answer» B. Aborted | |
| 7. |
In an SQL statement, which of the following parts states the conditions for row selection? |
| A. | Where |
| B. | From |
| C. | Order By |
| D. | Group By |
| Answer» B. From | |
| 8. |
_________commands in SQL allow controlling access to data within database. |
| A. | Database |
| B. | Data |
| C. | Data Control |
| D. | All of the Mentioned |
| Answer» D. All of the Mentioned | |
| 9. |
TCL stands for: |
| A. | Transaction control languages |
| B. | Transaction command languages |
| C. | Transaction connect languages |
| D. | None of the Mentioned |
| Answer» B. Transaction command languages | |
| 10. |
DCL stands for : |
| A. | Data Control Language |
| B. | Data Console Language |
| C. | Data Console Level |
| D. | Data Control Level |
| Answer» B. Data Console Language | |
| 11. |
The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with? |
| A. | DDL |
| B. | DML |
| C. | DDL and DCL |
| D. | DCL and DML |
| Answer» C. DDL and DCL | |
| 12. |
A type of query that is placed within a WHERE or HAVING clause of another query is called |
| A. | Master query |
| B. | Sub query |
| C. | Super query |
| D. | Multi-query |
| Answer» C. Super query | |
| 13. |
A table that displays data redundancies yields ____________ anomalies. |
| A. | Update |
| B. | Insertion |
| C. | Deletion |
| D. | All of the Mentioned |
| Answer» E. | |
| 14. |
Stack is also called __________ |
| A. | First In First Out (LIFO) |
| B. | Last In First Out (FIFO) |
| C. | First In Last Out (FILO) |
| D. | First Come First Served (FCFS) |
| Answer» D. First Come First Served (FCFS) | |
| 15. |
In SQL, which command is used to add new rows to a table? |
| A. | Alter Table |
| B. | Add row |
| C. | Insert |
| D. | Append |
| Answer» D. Append | |
| 16. |
TRUNCATE statement in SQL is a – |
| A. | DML statement |
| B. | DDL statement |
| C. | DCL statement |
| D. | TCL statement |
| Answer» C. DCL statement | |
| 17. |
Which of the following is not included in DML (Data Manipulation Language) |
| A. | INSERT |
| B. | UPDATE |
| C. | DELETE |
| D. | CREATE |
| Answer» E. | |
| 18. |
Which of the following is not a type of SQL statement? |
| A. | Data Manipulation Language (DML) |
| B. | Data Definition Language (DDL) |
| C. | Data Control Language (DCL) |
| D. | Data Communication Language (DCL) |
| Answer» E. | |
| 19. |
In SQL, which of the following is not a data Manipulation Language Commands? |
| A. | Delete |
| B. | Truncate |
| C. | Update |
| D. | Create |
| Answer» C. Update | |
| 20. |
The language used application programs to request data from the DBMS is referred to as __________ |
| A. | DML |
| B. | DDL |
| C. | Query language |
| D. | All of the Mentioned |
| Answer» B. DDL | |
| 21. |
Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained: |
| A. | TRUNCATE command |
| B. | Create command |
| C. | Drop table command |
| D. | Alter table command |
| Answer» B. Create command | |
| 22. |
Which command is used for removing a table and all its data from the database: |
| A. | Create command |
| B. | Drop table command |
| C. | Alter table command |
| D. | All of the Mentioned |
| Answer» C. Alter table command | |
| 23. |
Which command defines its columns, integrity constraint in create table: |
| A. | Create command |
| B. | Drop table command |
| C. | Alter table command |
| D. | All of the Mentioned |
| Answer» B. Drop table command | |
| 24. |
SQL has how many main commands for DDL: |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» D. 4 | |
| 25. |
___________ 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» C. Index | |
| 26. |
________clause is an additional filter that is applied to the result. |
| A. | Select |
| B. | Group-by |
| C. | Having |
| D. | Order by |
| Answer» D. Order by | |
| 27. |
In SQL, which command(s) is(are) used to change a table’s storage characteristics? |
| A. | ALTER TABLE |
| B. | MODIFY TABLE |
| C. | CHANGE TABLE |
| D. | All of the Mentioned |
| Answer» B. MODIFY TABLE | |
| 28. |
Which of the following is/are the DDL statements? |
| A. | Create |
| B. | Drop |
| C. | Alter |
| D. | All of the Mentioned |
| Answer» E. | |
| 29. |
Let the statement : SELECT column1 FROM myTable; return 10 rows. The statement : SELECT ALL column1 FROM myTable; will return |
| A. | less than 10 rows |
| B. | more than 10 rows |
| C. | exactly 10 rows |
| D. | none of the Mentioned |
| Answer» D. none of the Mentioned | |
| 30. |
Which of the following is illegal? |
| A. | SELECT SYSDATE – SYSDATE FROM DUAL; |
| B. | SELECT SYSDATE – (SYSDATE – 2) FROM DUAL; |
| C. | SELECT SYSDATE – (SYSDATE + 2) FROM DUAL; |
| D. | None of the Mentioned |
| Answer» E. | |
| 31. |
Find the temperature in increasing order of all cities |
| A. | SELECT city FROM weather ORDER BY temperature; |
| B. | SELECT city, temperature FROM weather; |
| C. | SELECT city, temperature FROM weather ORDER BY temperature; |
| D. | SELECT city, temperature FROM weather ORDER BY city; |
| Answer» D. SELECT city, temperature FROM weather ORDER BY city; | |
| 32. |
The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’, ‘b’), 4) FROM DUAL; |
| A. | 6789 |
| B. | 2345 |
| C. | 1234 |
| D. | 456789 |
| Answer» C. 1234 | |
| 33. |
Which of the SQL statements is correct? |
| A. | SELECT Username AND Password FROM Users |
| B. | SELECT Username, Password FROM Users |
| C. | SELECT Username, Password WHERE Username = ‘user1’ |
| D. | None of the Mentioned |
| Answer» C. SELECT Username, Password WHERE Username = ‘user1’ | |
| 34. |
A command that lets you change one or more fields in a record is |
| A. | Insert |
| B. | Modify |
| C. | Look-up |
| D. | All of the Mentioned |
| Answer» C. Look-up | |
| 35. |
In SQL, which command is used to SELECT only one copy of each set of duplicable rows |
| A. | SELECT DISTINCT |
| B. | SELECT UNIQUE |
| C. | SELECT DIFFERENT |
| D. | All of the Mentioned |
| Answer» B. SELECT UNIQUE | |
| 36. |
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? |
| A. | Data Definition Language(DDL) |
| B. | Data Manipulation Language(DML) |
| C. | DDL and DML |
| D. | None of the Mentioned |
| Answer» B. Data Manipulation Language(DML) | |
| 37. |
What is the full form of SQL? |
| A. | Structured Query Language |
| B. | Structured Query List |
| C. | Simple Query Language |
| D. | None of the Mentioned |
| Answer» B. Structured Query List | |
| 38. |
An n-array relationship is drawn using which symbol: |
| A. | A diamond |
| B. | A line with arrows showing direction |
| C. | A line without arrows showing direction |
| D. | A rectangle |
| Answer» B. A line with arrows showing direction | |
| 39. |
An aggregation association is drawn using which symbol: |
| A. | a line which loops back onto the same table |
| B. | small closed diamond at the end of a line connecting two tables |
| C. | small open diamond at the end of a line connecting two tables |
| D. | small triangle at the end of a line connecting the aggregated item and multiple component items |
| Answer» D. small triangle at the end of a line connecting the aggregated item and multiple component items | |
| 40. |
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 | |
| 41. |
Identify the criteria for designing database from the point of view of user |
| A. | No redundancy |
| B. | No inapplicable attributes |
| C. | Uniformity in naming & definitions of the data items |
| D. | All of the Mentioned |
| Answer» E. | |
| 42. |
A ___________ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute. |
| A. | First |
| B. | Second |
| C. | Third |
| D. | Fourth |
| Answer» D. Fourth | |
| 43. |
Which of the following is record based logical model? |
| A. | Network Model |
| B. | Object oriented model |
| C. | E-R Model |
| D. | None of the Mentioned |
| Answer» B. Object oriented model | |
| 44. |
E-R model uses this symbol to represent weak entity set ? |
| A. | Dotted rectangle |
| B. | Diamond |
| C. | Doubly outlined rectangle |
| D. | None of the Mentioned |
| Answer» D. None of the Mentioned | |
| 45. |
The relational model feature is that there |
| A. | is no need for primary key data |
| B. | is much more data independence than some other database models |
| C. | are explicit relationships among records |
| D. | are tables with many dimensions |
| Answer» C. are explicit relationships among records | |
| 46. |
A relational database developer refers to a record as |
| A. | A criteria |
| B. | A relation |
| C. | A tuple |
| D. | An attribute |
| Answer» D. An attribute | |
| 47. |
In an E-R diagram an entity set is represent by a |
| A. | Rectangle |
| B. | Ellipse |
| C. | Diamond box |
| D. | Circle |
| Answer» B. Ellipse | |
| 48. |
In a database, a foreign key is ? |
| A. | A data element/attribute within a data field of a data record that is not unique, and cannot be used to distinguish one data record in a database from another data record within a database table |
| B. | A data element/attribute within a data field of a data record within a database table that is a secondary key in another database table |
| C. | A data element/attribute within a data field of a data record within a database table that is a primary key in another database table |
| D. | A data element/attribute within a data field of a data record that enables a database to uniquely distinguish one data record in a database from another data record within a database table |
| Answer» D. A data element/attribute within a data field of a data record that enables a database to uniquely distinguish one data record in a database from another data record within a database table | |
| 49. |
Which of the following statements is not correct? |
| A. | The primary key must be unique for a given table |
| B. | Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is required |
| C. | Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required |
| D. | Most databases allow multiple records that are identical |
| Answer» C. Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required | |
| 50. |
A Foreign key is combined with a foreign key creates |
| A. | Parent child relationship between the tables that connect them |
| B. | Many-Many relationship between the tables that connect them |
| C. | Network model between the tables that connect them |
| D. | None of the Mentioned |
| Answer» B. Many-Many relationship between the tables that connect them | |