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.
| 1. |
The module in the SQL which is used to identify elements in the schema is classified as |
| A. | interaction |
| B. | declaration |
| C. | interpreters |
| D. | descriptors |
| Answer» E. | |
| 2. |
While operating with strings, what does “_ _ _%” match with? |
| A. | A string of three letters |
| B. | A string of at least three letters |
| C. | A string of three words |
| D. | A string of at least three words |
| Answer» B. A string of at least three letters | |
| 3. |
In the SQL environment, the collection of schemas is classified as |
| A. | value set |
| B. | catalog |
| C. | initiator |
| D. | integration |
| Answer» C. initiator | |
| 4. |
What is the function of the except operation? |
| A. | It excludes all the results present in both the queries |
| B. | It includes the results of the second query but excludes the results of the first query |
| C. | It includes the results of the first query but excludes the results of the second query |
| D. | It includes all the results of both queries but removes duplicates |
| Answer» D. It includes all the results of both queries but removes duplicates | |
| 5. |
The other name of application programming interface in database management system is |
| A. | library of clauses |
| B. | library of variables |
| C. | library of functions |
| D. | library of iterators |
| Answer» D. library of iterators | |
| 6. |
How many relations can a delete command operate on? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | Infinitely many |
| Answer» C. 2 | |
| 7. |
The command used in SQL which deletes the table definition as well as all the records available in the table is called |
| A. | DELETE command |
| B. | DROP TABLE command |
| C. | PRIMARY KEY command |
| D. | SECONDARY KEY command |
| Answer» C. PRIMARY KEY command | |
| 8. |
When the schema is to be dropped in SQL which has no elements then the type of DROP Command used is called |
| A. | SCALE DROP command |
| B. | PRECISION DROP command |
| C. | RESTRICT DROP schema |
| D. | CASCADE DROP command |
| Answer» D. CASCADE DROP command | |
| 9. |
The clause used in CREATE TABLE statement in SQL to specify secondary keys is called |
| A. | STAMPED clause |
| B. | UNIQUE clause |
| C. | SECOND clause |
| D. | FIRST clause |
| Answer» C. SECOND clause | |
| 10. |
Which command is used to create a new relation in SQL |
| A. | create table( , …) |
| B. | create relation( , …) |
| C. | new table( , …) |
| D. | new relation( , …) |
| Answer» B. create relation( , …) | |
| 11. |
In the statement DECIMAL (I, j) to specify numeric data type, the digits after the decimal point are called |
| A. | the precision |
| B. | the scale |
| C. | the string |
| D. | the numeric strip |
| Answer» C. the string | |
| 12. |
The ________ comparison checker is used to check “each and every” condition |
| A. | all |
| B. | and |
| C. | every |
| D. | each |
| Answer» B. and | |
| 13. |
What does the following query do?select name, ID, branchfrom student, departmentwhere student.branch = department.branch; |
| A. | It gives all values of name, ID, branch from both the relations only if all those attributes are present in both |
| B. | It gives all values of name, ID, branch from their respective relations |
| C. | It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same |
| D. | It gives the values of name, ID, branch from their respective relations where all the values are matching with each other |
| Answer» D. It gives the values of name, ID, branch from their respective relations where all the values are matching with each other | |
| 14. |
If the length of bit string is multiple of 4 then it can be specified with the notation called |
| A. | fixed string notation |
| B. | triple decimal notation |
| C. | double decimal notation |
| D. | hexadecimal notation |
| Answer» E. | |
| 15. |
The type of data in SQL which includes TIME and DATE fields plus six positions for other decimal fractions is classified as |
| A. | timestamp |
| B. | interval stamp |
| C. | Boolean stamp |
| D. | literal string stamp |
| Answer» B. interval stamp | |
| 16. |
Observe the following query and choose the correct option.select name, IDfrom student natural join department natural join section |
| A. | The query is syntactically wrong because there is no where clause |
| B. | The query is syntactically wrong because there are more than one attributes in the select clause |
| C. | The query is syntactically wrong because more than one relations are included in the natural join operation |
| D. | The query is correct |
| Answer» E. | |
| 17. |
The data type in SQL which includes various size integers and floating point numbers are classified as |
| A. | query data type |
| B. | numeric data types |
| C. | binary data types |
| D. | formatted data types |
| Answer» C. binary data types | |
| 18. |
If the referential integrity constraint is violated then the specific action clause attached by the database designers other than by default action is classified as |
| A. | referential triggered action |
| B. | foreign key triggered action |
| C. | primary key triggered action |
| D. | decimal triggered action |
| Answer» B. foreign key triggered action | |
| 19. |
If we specify multiple relations in the from clause and do not specify any conditions in the where clause, what will the result be? |
| A. | The natural join of both the relations |
| B. | The left outer join of both the relations |
| C. | A syntactical error |
| D. | The Cartesian product of both the relations |
| Answer» E. | |
| 20. |
The _____ aggregation operation adds up all the values of the attribute |
| A. | add |
| B. | avg |
| C. | max |
| D. | sum |
| Answer» E. | |
| 21. |
The concatenation operator in SQL which can concatenate two strings is denoted as |
| A. | double quotation marks |
| B. | double vertical bar |
| C. | single vertical bar |
| D. | triple vertical bar |
| Answer» C. single vertical bar | |
| 22. |
In SQL, the type of character string value which is padded with blank characters to the right side of string is called |
| A. | fixed length bit-string |
| B. | literal time stamp |
| C. | literal string value |
| D. | fixed length string |
| Answer» E. | |
| 23. |
The referential triggered action clause in Standard Query Language is attached to constraint called |
| A. | primary key constraint |
| B. | stamped key constraint |
| C. | interval notation constraint |
| D. | foreign key constraint |
| Answer» E. | |
| 24. |
The command in SQL which is used when any of the schema is no longer needed in relation is classified as |
| A. | DROP SCHEMA command |
| B. | PICK SCHEMA command |
| C. | DELETE SCHEMA command |
| D. | RESTRICT SCHEMA command |
| Answer» B. PICK SCHEMA command | |
| 25. |
In fixed length character string CHAR(n), the 'n' represents |
| A. | number of characters |
| B. | maximum number of characters |
| C. | number of rows |
| D. | number of columns |
| Answer» B. maximum number of characters | |
| 26. |
What values does the count(*) function ignore? |
| A. | Repetitive values |
| B. | Null values |
| C. | Characters |
| D. | Integers |
| Answer» C. Characters | |
| 27. |
Which keyword is used to rename the resulting attribute after the application of the aggregation function? |
| A. | rename |
| B. | as |
| C. | replace |
| D. | to |
| Answer» C. replace | |
| 28. |
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy |
| A. | SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); |
| B. | SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy'); |
| C. | SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy'); |
| D. | SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy'); |
| Answer» B. SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy'); | |
| 29. |
The database interface in which the data is directly entered into the monitor is classified as |
| A. | interactive interface |
| B. | direct interface |
| C. | monitored interface |
| D. | command interface |
| Answer» B. direct interface | |
| 30. |
The kind of iterator which lists the types and names of attributes in the result of query is classified as |
| A. | unnamed iterator |
| B. | non-positioned iterator |
| C. | positional iterator |
| D. | named iterator |
| Answer» E. | |
| 31. |
The general purpose programming languages such as COBOL and ADA is classified as |
| A. | server language |
| B. | client language |
| C. | host language |
| D. | referential language |
| Answer» D. referential language | |
| 32. |
In SQL, the type of character string value which is specified as being case sensitive and placed between apostrophes is called |
| A. | literal string value |
| B. | fixed length string |
| C. | fixed length bit-string |
| D. | literal time stamp |
| Answer» B. fixed length string | |
| 33. |
What is a correlated sub-query? |
| A. | An independent query that uses the correlation name of another independent query. |
| B. | A sub-query that uses the correlation name of an outer query |
| C. | A sub-query that substitutes the names of the outer query |
| D. | A sub-query that does not depend on its outer query’s correlation names |
| Answer» C. A sub-query that substitutes the names of the outer query | |
| 34. |
The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; |
| A. | is illegal |
| B. | prints garbage |
| C. | prints 045.926 |
| D. | prints 50 |
| Answer» E. | |
| 35. |
In Standard Query Language, the data types included are |
| A. | character string |
| B. | bit-string |
| C. | time stamp |
| D. | all of above |
| Answer» E. | |
| 36. |
The clause used in SQL for ensuring referential integrity is classified as |
| A. | PRIMARY KEY clause |
| B. | SECONDARY KEY clause |
| C. | FOREIGN KEY clause |
| D. | INTERVAL KEY clause |
| Answer» D. INTERVAL KEY clause | |
| 37. |
The data type which can be fixed length or varying length as CHAR(n) and VARCHAR(n) respectively is classified as |
| A. | ternary string |
| B. | binary string |
| C. | schema string |
| D. | character-string |
| Answer» E. | |
| 38. |
Which of the following commands do we use to delete all the tuples from a relation (R)? |
| A. | delete table R |
| B. | drop table R |
| C. | delete from R |
| D. | drop from R |
| Answer» D. drop from R | |
| 39. |
The database program which handles software applications and include database servers calls to update the data is classified as |
| A. | client program |
| B. | host program |
| C. | iterator program |
| D. | loop program |
| Answer» B. host program | |
| 40. |
The type of iterator which is used to list the types of attributes that are included in the query result is called |
| A. | positional iterator |
| B. | named iterator |
| C. | unnamed iterator |
| D. | non-positioned iterator |
| Answer» B. named iterator | |
| 41. |
State true or false: We can use Subqueries inside the from clause |
| A. | True |
| B. | False |
| C. | May be |
| D. | Can't say |
| Answer» B. False | |
| 42. |
In database management system, if the cursor is to be moved to next rows in queries result then the command is classified as |
| A. | OPEN CURSOR command |
| B. | FETCH command |
| C. | UPDATE command |
| D. | CLOSE CURSOR command |
| Answer» C. UPDATE command | |
| 43. |
Considering the change in schema statement in SQL, the command which is used to delete records of table and leave the definition of table for later use is classified as |
| A. | DELETE command |
| B. | DROP TABLE command |
| C. | PRIMARY KEY command |
| D. | SECONDARY KEY command |
| Answer» B. DROP TABLE command | |
| 44. |
If the explicit value of attributes is not provided in SQL then the value included in new tuple in such situation is called |
| A. | sampled statement |
| B. | decimal value |
| C. | notation statement |
| D. | default value |
| Answer» E. | |
| 45. |
The command used in SQL to specify new relation, its initial constraints and attributes is classified as |
| A. | CREATE TABLE |
| B. | CREATE IDENTIFIER |
| C. | CREATE CATALOG |
| D. | CREATE SCHEMAS |
| Answer» B. CREATE IDENTIFIER | |
| 46. |
In the declaration statement DECIMAL (I, j), the 'I' is classified as |
| A. | the precision |
| B. | the scale |
| C. | the string |
| D. | the numeric strip |
| Answer» B. the scale | |
| 47. |
In CREATE TABLE SQL command, each table must have atleast column/s |
| A. | 0 |
| B. | 2 |
| C. | 3 |
| D. | 1 |
| Answer» E. | |
| 48. |
In Standard Query Language, the types of DROP commands include |
| A. | RESTRICT command |
| B. | FOREIGN key command |
| C. | CASCADE command |
| D. | both a and c |
| Answer» E. | |
| 49. |
What does the natural join operation do? |
| A. | It considers only those pairs of tuples that have the same value on those attributes that appear in the schemas of both relations |
| B. | It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations |
| C. | It considers only those pairs of tuples that do not have the same value on those attributes that appear in the schemas of both relations |
| D. | None of the mentioned |
| Answer» B. It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations | |
| 50. |
SQL subqueries that can occur wherever a value is permitted provided the subquery gives only one tuple with a single attribute are called _________ |
| A. | Exact Subqueries |
| B. | Vector Subqueries |
| C. | Positive Subqueries |
| D. | Scalar Subqueries |
| Answer» E. | |