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
| 1201. |
A set of objects that share a common structure and a common behavior is called: |
| A. | Object |
| B. | Class |
| C. | Entity |
| D. | None of these |
| Answer» B. Class | |
| 1202. |
Every weak entity set can be converted into a strong entity set by: |
| A. | using generalization |
| B. | adding appropriate attributes |
| C. | using aggregation |
| D. | none of the above |
| Answer» B. adding appropriate attributes | |
| 1203. |
The number of entities to which another entity can be associated via a relationship set is expressed as: |
| A. | Entity |
| B. | Cardinality |
| C. | Schema |
| D. | Attributes |
| Answer» B. Cardinality | |
| 1204. |
The view of total database content is |
| A. | Conceptual view. |
| B. | Internal view. |
| C. | External view |
| D. | Physical view |
| Answer» A. Conceptual view. | |
| 1205. |
The file organization that provides very fast access to any arbitrary record of a file is: |
| A. | Ordered file |
| B. | Unordered file |
| C. | Hashed file |
| D. | B-tree |
| Answer» C. Hashed file | |
| 1206. |
What is not true about a view? |
| A. | It is a definition of a restricted portion of the database |
| B. | It is a security mechanism |
| C. | It is always updatable like any other table |
| D. | All are true |
| Answer» C. It is always updatable like any other table | |
| 1207. |
The database schema is written in |
| A. | HLL |
| B. | DML |
| C. | DDL |
| D. | DCL |
| Answer» C. DDL | |
| 1208. |
Who developed SEQUEL? |
| A. | Dr. E.F. Codd |
| B. | Chris Date |
| D. | Chamberlain |
| Answer» D. Chamberlain | |
| 1209. |
Which of the following is used to get all the columns of a table? |
| A. | * |
| B. | @ |
| C. | % |
| D. | # |
| Answer» A. * | |
| 1210. |
The first commercial RDBMS is: |
| A. | INGRESS |
| B. | DB2 |
| C. | ORACLE |
| D. | None of these. |
| Answer» A. INGRESS | |
| 1211. |
Which of the following is not a DCL statement? |
| A. | Rollback |
| B. | Grant |
| C. | Revoke |
| D. | None of these |
| Answer» A. Rollback | |
| 1212. |
Which of the following is the result of a select statement? |
| A. | Trigger |
| B. | Index |
| C. | Table |
| D. | None of these |
| Answer» C. Table | |
| 1213. |
Which of the following clause specifies the table or tables from where the data has to be retrieved? |
| A. | Where |
| B. | Table |
| C. | From |
| D. | None of these |
| Answer» C. From | |
| 1214. |
How many tables can be joined to create a view? |
| A. | 1 |
| B. | 2 |
| C. | Database dependent |
| D. | None of these |
| Answer» A. 1 | |
| 1215. |
Which of the following can be used to get those items that fall within a range? |
| A. | IN |
| B. | BETWEEN |
| C. | DISTINCT |
| D. | LIKE |
| Answer» C. DISTINCT | |
| 1216. |
Which of the following constitutes a basic set of operations for manipulating relational data? |
| A. | Predicate calculus |
| B. | Relational algebra |
| C. | Relational calculus |
| D. | None of the above |
| Answer» B. Relational algebra | |
| 1217. |
Which of the following is not a relational algebraic operation that is not form the set theory? |
| A. | UNION |
| B. | INTERSECTION |
| C. | CARTESIAN PRODUCT |
| D. | SELECT |
| Answer» D. SELECT | |
| 1218. |
Which of the following is not a relational algebraic operation that is developed specifically for the relational databases? |
| A. | SELECT |
| B. | UNION |
| C. | JOIN |
| D. | PROJECT |
| Answer» B. UNION | |
| 1219. |
Which is the symbol used to denote the SELECT operation? |
| A. | Sigma |
| B. | Rho |
| C. | Pi |
| D. | None of the above |
| Answer» A. Sigma | |
| 1220. |
Which of the following operations need the participating relations to be union compatible? |
| A. | UNION |
| B. | INTERSECTION |
| C. | DIFFERENCE |
| D. | All of the above |
| Answer» D. All of the above | |
| 1221. |
What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively? |
| A. | 5 |
| B. | 12 |
| C. | 35 |
| D. | None of the above |
| Answer» B. 12 | |
| 1222. |
What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 20 rows respectively? |
| A. | 5 |
| B. | 20 |
| C. | 25 |
| D. | 100 |
| Answer» D. 100 | |
| 1223. |
Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table? |
| A. | SELECT |
| B. | PROJECT |
| C. | UNION |
| D. | JOIN |
| Answer» B. PROJECT | |
| 1224. |
Which of the following is not a procedural language? |
| A. | Relational Algebra |
| B. | SQL |
| C. | Relational calculus |
| D. | None of the above |
| Answer» C. Relational calculus | |
| 1225. |
Who developed QBE? |
| A. | C.J. Date |
| B. | E.F. Codd |
| C. | M.M. Zloof |
| D. | None of the above |
| Answer» C. M.M. Zloof | |
| 1226. |
What is the expansion of QBE? |
| A. | Query by Example |
| B. | Query by Experiment |
| C. | Question before evaluation |
| D. | None of the above |
| Answer» A. Query by Example | |
| 1227. |
Who developed Structured English Query Language? |
| A. | E.F. Codd |
| B. | D. Chamberlain |
| C. | Chris Date |
| D. | None of the above |
| Answer» B. D. Chamberlain | |
| 1228. |
Which of the following is the first commercial RDBMS? |
| A. | DB2 |
| B. | INGRESS |
| C. | ORACLE |
| D. | None of the above |
| Answer» D. None of the above | |
| 1229. |
Which of the following is IBM’s first RDBMS? |
| A. | DB2 |
| B. | IMS |
| C. | SQL/DS |
| D. | None of the above |
| Answer» C. SQL/DS | |
| 1230. |
Which of the following company now known as the Oracle Corporation? |
| A. | Stepware Inc. |
| B. | Relational Software Inc. |
| C. | Rational Inc. |
| D. | Oracle Software Inc. |
| Answer» B. Relational Software Inc. | |
| 1231. |
What is the process that is done to SQL before execution, to check for proper syntax and to optimize the request called? |
| A. | Syntax checking |
| B. | Performance tuning |
| C. | Parsing |
| D. | Optimizing |
| Answer» C. Parsing | |
| 1232. |
Which of the following is a valid SQL data type? |
| A. | CHARACTER |
| B. | NUMERIC |
| C. | FLOAT |
| D. | All of the above |
| Answer» D. All of the above | |
| 1233. |
Which of the following is not a data definition language statement? |
| A. | CREATE |
| B. | ALTER |
| C. | DROP |
| D. | SELECT |
| Answer» D. SELECT | |
| 1234. |
Which of the following is not a DCL statement? |
| A. | GRANT |
| B. | REVOKE |
| C. | ROLLBACK |
| D. | None of the above |
| Answer» C. ROLLBACK | |
| 1235. |
Which of the following is a comparison operator? |
| A. | = |
| B. | LIKE |
| C. | BETWEEN |
| D. | All of the above |
| Answer» D. All of the above | |
| 1236. |
Which of the following consists of a row of column headings, together with zero or more rows of data values? |
| A. | COMPOSITE INDEX |
| B. | UNIQUE INDEX |
| C. | TABLE |
| D. | None of the above |
| Answer» C. TABLE | |
| 1237. |
In which of the following cases will the RDBMS specify a default value for the column if there are no values for it? |
| A. | NOT NULL WITH DEFAULT |
| B. | COLUMN DEFAULT |
| C. | NOT NULL UNIUE |
| D. | None of the above |
| Answer» C. NOT NULL UNIUE | |
| 1238. |
Which of the following database object does not physically exist? |
| A. | Base table |
| B. | Index |
| C. | View |
| D. | None of the above |
| Answer» C. View | |
| 1239. |
How many tables can be joined to create a view? |
| A. | 1 |
| B. | 2 |
| C. | Database dependent |
| D. | None of the above |
| Answer» C. Database dependent | |
| 1240. |
Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns? |
| A. | Table |
| B. | View |
| C. | Index |
| D. | None of the above |
| Answer» C. Index | |
| 1241. |
Which of the following index is made up of more than one column? |
| A. | Composite index |
| B. | Clustered index |
| C. | Simple index |
| D. | None of the above |
| Answer» A. Composite index | |
| 1242. |
Which of the following index can occur only one per table? |
| A. | Distinct index |
| B. | Unique index |
| C. | Simple index |
| D. | Clustered index |
| Answer» B. Unique index | |
| 1243. |
Which question corresponds best to the following query? SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2 |
| A. | Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Leave an empty line after every second line. |
| B. | Select two columns from the COURSES table, the second one gets as title “ =PRICE”.Sort the data according to the second column, in ascending order. |
| C. | Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order. |
| D. | Select two columns from the COURSES table, of which the second one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order |
| Answer» C. Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order. | |
| 1244. |
What is the default order of Order by clause? |
| A. | Descending |
| B. | Ascending |
| C. | Random |
| D. | None of the above |
| Answer» B. Ascending | |
| 1245. |
View the Exhibit and examine the structure of the EMPLOYEES and DEPARTMENTS tables.
|
| A. | UNION |
| B. | MINUS |
| C. | INTERSECT |
| D. | UNION ALL |
| Answer» B. MINUS | |
| 1246. |
View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement? |
| A. | The statement would execute successfully and display all the rows in the ascending order ofDEPARTMENT_ID. |
| B. | The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order. |
| C. | The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause. |
| D. | The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement. |
| Answer» D. The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement. | |
| 1247. |
Which CREATE TABLE statement is valid? |
| A. | CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date date NOT NULL); 50 |
| B. | CREATE TABLE ord_details (ord_no NUMBER(2) UNIQUE, NOT NULL, item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL); |
| C. | CREATE TABLE ord_details (ord_no NUMBER(2) , item_no NUMBER(3), ord_date date DEFAULT NOT NULL, CONSTRAINT ord_uq UNIQUE (ord_no), CONSTRAINT ord_pk PRIMARY KEY (ord_no)); |
| D. | CREATE TABLE ord_details (ord_no NUMBER(2), item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL, CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no)); |
| Answer» D. CREATE TABLE ord_details (ord_no NUMBER(2), item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL, CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no)); | |
| 1248. |
Pick entities from the following: I. vendor II. student III. attends IV. km/hour |
| A. | i, ii, iii |
| B. | i, ii, iv |
| C. | i and ii |
| D. | iii and iv |
| Answer» C. i and ii | |
| 1249. |
By relation cardinality we mean |
| A. | number of items in a relationship |
| B. | number of relationships in which an entity can appear |
| C. | number of items in an entity |
| D. | number of entity sets which may be related to a given entity |
| Answer» B. number of relationships in which an entity can appear | |
| 1250. |
If an entity appears in only one relationship then it is |
| A. | a 1:1 relationship |
| B. | a 1:N relationship |
| C. | a N:1 relationship |
| D. | a N:M relationship |
| Answer» A. a 1:1 relationship | |
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.