MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 155 Mcqs, each offering curated multiple-choice questions to sharpen your Technical Programming knowledge and support exam preparation. Choose a topic below to get started.
| 101. |
Triggers ________ enabled or disabled. |
| A. | Can be |
| B. | Cannot be |
| C. | Ought to be |
| D. | Always |
| Answer» B. Cannot be | |
| 102. |
The type of function which allows performing additional operations and sending messages to other tables in database program is considered as |
| A. | trigger |
| B. | semantics |
| C. | index |
| D. | structure |
| Answer» B. semantics | |
| 103. |
In query result, the type of variable which is used to loop tuples is called |
| A. | cursor |
| B. | iterator variable |
| C. | loop variable |
| D. | both a and b |
| Answer» E. | |
| 104. |
State true or false: Multiple conditions in the where clause are separated by a “,” |
| A. | True |
| B. | False |
| C. | May be |
| D. | Can't say |
| Answer» C. May be | |
| 105. |
The ________ clause is used to list the attributes desired in the result of a query |
| A. | select |
| B. | from |
| C. | where |
| D. | create |
| Answer» B. from | |
| 106. |
The data type often used in SQL-99 to specify columns with large values is classified as |
| A. | CHARACTER LARGE OBJECT |
| B. | CHARACTER STRING SCHEMA |
| C. | CHARACTER MAX COLUMN |
| D. | CHARCATER MIN ROW |
| Answer» B. CHARACTER STRING SCHEMA | |
| 107. |
In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____. |
| A. | Catalogs, schemas |
| B. | Schemas, catalogs |
| C. | Environment, schemas |
| D. | Schemas, Environment |
| Answer» B. Schemas, catalogs | |
| 108. |
In varying length character string CHAR(n), the 'n' represents |
| A. | number of rows |
| B. | number of columns |
| C. | number of characters |
| D. | maximum number of characters |
| Answer» E. | |
| 109. |
The following SQL is which type of join:SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID |
| A. | Equi-join |
| B. | Natural join |
| C. | Outer join |
| D. | Cartesian join |
| Answer» B. Natural join | |
| 110. |
The _________ construct returns true if the argument in the sub-query is void of duplicates |
| A. | not null |
| B. | not unique |
| C. | unique |
| D. | |
| Answer» D. | |
| 111. |
What does the notnull integrity constraint do? |
| A. | It ensures that at least one tuple is present in the relation |
| B. | It ensures that at least one foreign key is present in the relation |
| C. | It ensures that all tuples have a finite value on a specified attribute |
| D. | It ensures that all tuples have finite attributes on all the relations |
| Answer» D. It ensures that all tuples have finite attributes on all the relations | |
| 112. |
The formatted numbers are declared in SQL by using statement such as |
| A. | DECIMAL (I, j) |
| B. | DEC () |
| C. | NUMERIC () |
| D. | all of above |
| Answer» E. | |
| 113. |
Which of the following is an advantage of view? |
| A. | Data security |
| B. | Derived columns |
| C. | Hiding of complex queries |
| D. | All of the above |
| Answer» E. | |
| 114. |
State true or false: Any attribute which is present in the having clause without being aggregated must not be present in the group by clause. |
| A. | True |
| B. | False |
| C. | May be |
| D. | Can't say |
| Answer» C. May be | |
| 115. |
In database management systems, the record which contains all the data regarding tuples of database is called |
| A. | statement record |
| B. | environment record |
| C. | description record |
| D. | connection record |
| Answer» D. connection record | |
| 116. |
In SQL, the identifier which are used to indicate the user of schema is classified as |
| A. | high level identifiers |
| B. | low level identifiers |
| C. | authorization identifier |
| D. | query identifier |
| Answer» D. query identifier | |
| 117. |
The type of bit strings which is preceded by 'B' and is placed between single quotes is classified as |
| A. | double bit string |
| B. | nested bit string |
| C. | fixed bit string |
| D. | literal bit strings |
| Answer» E. | |
| 118. |
What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green') |
| A. | Find the sailor IDs of all sailors who have reserved red boats but not green boats |
| B. | Find the sailor IDs of at least one sailor who have reserved red boats but not green boats |
| C. | Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats |
| D. | None of These |
| Answer» B. Find the sailor IDs of at least one sailor who have reserved red boats but not green boats | |
| 119. |
The data type DATE has three components where as its insertion considers |
| A. | eight positions |
| B. | ten positions |
| C. | four positions |
| D. | five positions |
| Answer» C. four positions | |
| 120. |
State true or false: We can rename the resulting attribute after the aggregation function has been applied |
| A. | True |
| B. | False |
| C. | May be |
| D. | Can't say |
| Answer» B. False | |
| 121. |
What is the syntax to load data into the database? (Consider D as the database and a, b, c as data) |
| A. | enter into D (a, b, c); |
| B. | insert into D values (a, b, c); |
| C. | insert into D (a, b, c); |
| D. | insert (a, b, c) values into D; |
| Answer» C. insert into D (a, b, c); | |
| 122. |
In standard query language, the rows and columns are called respectively |
| A. | tuple and attributes |
| B. | quantifiers and identifiers |
| C. | predicator and indicator |
| D. | non-identifiers and quantifiers |
| Answer» B. quantifiers and identifiers | |
| 123. |
‘AS’ clause is used in SQL for |
| A. | Selection operation |
| B. | Rename operation |
| C. | Join operation |
| D. | Projection operation |
| Answer» C. Join operation | |
| 124. |
In SQL standard, the variable which is considered as communication variable and is string of five characters is named as |
| A. | SQLSECTION |
| B. | SQLSTATE |
| C. | SQLCODE |
| D. | SQLMOD |
| Answer» C. SQLCODE | |
| 125. |
The possible actions of altering the tables in Standard Query Language includes |
| A. | adding or dropping constraints |
| B. | adding or dropping attributes |
| C. | change definition o columns |
| D. | all of above |
| Answer» E. | |
| 126. |
The problem which arises because of the differences between model of programming language and model of database is classified as |
| A. | modeling mismatch |
| B. | referential mismatch |
| C. | dependence mismatch |
| D. | impedance mismatch |
| Answer» E. | |
| 127. |
The variable in DBMS used to communicate error conditions between database management system and program are |
| A. | SQLCODE |
| B. | SQLSECTION |
| C. | SQLSTATE |
| D. | both b and c |
| Answer» E. | |
| 128. |
The technique in which source program are replaced by database management generated code is classified as |
| A. | referential SQL |
| B. | embedded SQL |
| C. | interpreted SQL |
| D. | embossed SQL |
| Answer» C. interpreted SQL | |
| 129. |
Values of one type can be converted to another domain using which of the following ? |
| A. | Cast |
| B. | Drop type |
| C. | Alter type |
| D. | Convert |
| Answer» B. Drop type | |
| 130. |
State true or false: We cannot write a where clause under an update command |
| A. | True |
| B. | False |
| C. | May be |
| D. | Can't say |
| Answer» C. May be | |
| 131. |
Which of the following is not a integrity constraint ? |
| A. | Not null |
| B. | Positive |
| C. | Unique |
| D. | Check ‘predicate’ |
| Answer» C. Unique | |
| 132. |
In multiple tuples retrieval, the command which is used to fetch queries from database is classified as |
| A. | UPDATE command |
| B. | CLOSE CURSOR command |
| C. | OPEN CURSOR command |
| D. | FETCH command |
| Answer» D. FETCH command | |
| 133. |
SQL stands for _________. |
| A. | Structured Query Language |
| B. | Standard Query Language |
| C. | Simple Query Language |
| D. | None of these |
| Answer» B. Standard Query Language | |
| 134. |
In SQL the statement select * from R, S is equivalent to |
| A. | Select * from R natural join S |
| B. | Select * from R cross join S |
| C. | Select * from R union join S |
| D. | Select * from R inner join S |
| Answer» C. Select * from R union join S | |
| 135. |
If the concatenation operator is applied to two strings such as [ 'ABCD' || 'wxyz' ] then the resultant string will be |
| A. | AwBxCyDz |
| B. | wxyzABCD |
| C. | ABCDwxyz |
| D. | ABCD+wxyz |
| Answer» D. ABCD+wxyz | |
| 136. |
SQL is a standard language for ________. |
| A. | Accessing databases |
| B. | Creating Web Pages |
| C. | Creating Front Ends |
| D. | None of these |
| Answer» B. Creating Web Pages | |
| 137. |
The following SQL is which type of join:SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ; |
| A. | Equi-join |
| B. | Natural join |
| C. | Outer join |
| D. | Cartesian join |
| Answer» E. | |
| 138. |
Which of the following correctly describes the between predicate in the where clause? |
| A. | It is used to check whether a value is in between two specified values |
| B. | It is used to check whether a value is exactly in the center of the relation alphabetically |
| C. | It is used to check whether a value is in between any two other values in the database |
| D. | None of the mentioned |
| Answer» B. It is used to check whether a value is exactly in the center of the relation alphabetically | |
| 139. |
Scalar Subqueries can be used in the SQL update statement when they are used under the ____ clause |
| A. | where |
| B. | with |
| C. | set |
| D. | end |
| Answer» D. end | |
| 140. |
The kind of record which is used to keep the information of specific database connection is classified as |
| A. | description record |
| B. | connection record |
| C. | statement record |
| D. | environment record |
| Answer» C. statement record | |
| 141. |
To change a value in a tuple without changing all the values in the tuple, we use the _____ statement |
| A. | insert |
| B. | insert some |
| C. | update |
| D. | alter |
| Answer» D. alter | |
| 142. |
_________ data type can store unstructured data. |
| A. | RAW |
| B. | CHAR |
| C. | NUMERIC |
| D. | VARCHAR |
| Answer» B. CHAR | |
| 143. |
create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID));Choose the correct option regarding the above statement |
| A. | The statement is syntactically wrong |
| B. | It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null. |
| C. | It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null. |
| D. | It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters. |
| Answer» D. It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters. | |
| 144. |
Which of the following commands do we use to delete a relation (R) from a database? |
| A. | drop table R |
| B. | drop relation R |
| C. | delete table R |
| D. | delete from R |
| Answer» B. drop relation R | |
| 145. |
The relations that are declared in SQL through CREATE VIEW statements are classified as |
| A. | binary relations |
| B. | ternary relations |
| C. | logic relations |
| D. | virtual relations |
| Answer» E. | |
| 146. |
In the statement DECIMAL () to specify numeric data type, the number of decimal digits is called |
| A. | the string |
| B. | the numeric strip |
| C. | the precision |
| D. | the scale |
| Answer» D. the scale | |
| 147. |
In the CREATE TABLE command in standard query language, the referential integrity constraints is specified only after the |
| A. | attributes are declared |
| B. | schema is declared |
| C. | identifier is declared |
| D. | notifies are declared |
| Answer» B. schema is declared | |
| 148. |
Which of the following is the right syntax for assertion? |
| A. | Create assertion 'assertion-name' check 'predicate'; |
| B. | Create assertion check 'predicate' 'assertion-name'; |
| C. | Create assertions 'predicates'; |
| D. | All of the mentioned |
| Answer» B. Create assertion check 'predicate' 'assertion-name'; | |
| 149. |
Select __________ from instructor where dept name= ’Comp. Sci.’;Which of the following should be used to find the mean of the salary ? |
| A. | Mean(salary) |
| B. | Avg(salary) |
| C. | Sum(salary) |
| D. | Count(salary) |
| Answer» C. Sum(salary) | |
| 150. |
The SQL database language includes statements for: |
| A. | Database definition. |
| B. | Database manipulation. |
| C. | Database control. |
| D. | All of the above. |
| Answer» E. | |