Q & A - Computer Science

Q & A

• Which clause is used to produce a list of only values that are different from one another? Which clause is used to produce a list of only values that are different from one another? (a)Aggregate (b)Restricted (c)Select (d)Distinct (e)Group By
• Choose the Suitable example for derived attribute from the following: Choose the Suitable example for derived attribute from the following: (a)Roll no (b)Name (c)Marks (d)Age (e)Phone number.
• Select the incorrect statement describing the keys used in a Relational Data Model. Select the incorrect statement describing the keys used in a Relational Data Model. (a)A primary key is an attribute that uniquely identifies each row in a relation (...
• What does a multi level index lead to? What does a multi level index lead to? (a)Binary Tree (b)B-tree (c)Mapping (d)Transaction Failure (e)Dead Lock.
• How a null value is created or represented? How a null value is created or represented? (a)A zero (b)A space (c)Entering a value (d)Pressing the Enter key without making a prior entry of any kind (e)Pressing...
• Employees, Customers, Account, Vehicle are examples of Employees, Customers, Account, Vehicle are examples of (a)Attributes (b)Entities (c)Fields (d)Columns (e)Domains.
• The term used to identify a row of a table in the relational data model is The term used to identify a row of a table in the relational data model is (a)Cardinality (b)Data (c)Data Set (d)Tuple (e)Record.
• Which of the following statement is not true? Which of the following statement is not true? (a)Stored procedures can receive and return parameters (b)CHECK (bonus
• Which attribute that can be further subdivided to yield additional attributes? Which attribute that can be further subdivided to yield additional attributes? (a)Composite (b)Simple (c)Single-valued (d)Multi-valued (e)Derived.
• Which procedure is used for acquiring the necessary locks for a transaction where all nece Which procedure is used for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released? (a)Record controller (b)Ex...
• Which of the following statement can be considered as a part of data dictionary? Which of the following statement can be considered as a part of data dictionary? (a)Metadata (b)The complete set of data records (c)Data flow diagram of the system ...
• Which of the following collection(s) of attributes correctly represent(s) a Lecturer relat Which of the following collection(s) of attributes correctly represent(s) a Lecturer relation and possible relationship(s) it might have with other relations when the E-R...
• Which normal form states that a relation has no transitive dependencies in it? Which normal form states that a relation has no transitive dependencies in it? (a)First (b)Second (c)Third (d)Fourth (e)BCNF.
• In an SQL statement, which of the following parts states the condition for Group. In an SQL statement, which of the following parts states the condition for Group selection? (a)Select (b)From (c)Where (d)Group By (e)Having.
• Which of the following statement is true for the 3 level architecture? Which of the following statement is true for the 3 level architecture? (a)The physical schema should assist to locate the data stored on disk (b)The logical view of t...
• Which of the following concept(s) cannot be represented in the Enhanced Entity-Relations Which of the following concept(s) cannot be represented in the Enhanced Entity-Relationship Model? (a)Composite attribute (b)Derived attribute (c)Weak entity (d)G...
• Which of the following statement will not affect the performance of a database system? Which of the following statement will not affect the performance of a database system? (a)Adequate free disk storage capacity (b)Disk access time (c)Processor speed ...
• Which type of file is easiest to update? Which type of file is easiest to update? (a)Sequential (b)Hashed (c)Indexed (d)Clustered (e)Heaped.
• Which of the following statement is component of DBMS? Which of the following statement is component of DBMS? (a)Data dictionary/directory subsystem (b)Naïve Users (c)Database administrator (d)Users and programmers (e)...
• When the detection algorithm detects a deadlock, the recovery is normally accomplished by? When the detection algorithm detects a deadlock, the recovery is normally accomplished by? (a)Roll-back of transactions (b)Consistency checking (c)Locking of data (...
• What factors would not determine the capacity of a block of a disk organization? What factors would not determine the capacity of a block of a disk organization? (a)Blocking factor (b)Record size (c)Block pointer (d)Inter-block gap (e)End of track.
• Which property of transaction ensures that either all operations of the transaction. Which property of transaction ensures that either all operations of the transaction are reflected properly in the database or none? (a)Atomicity (b)Durability (c)Iso...
• Which among the following is function of DBA? Which among the following is function of DBA? (a)Communicating with all computer users (b)Classify user groups and provide authorization to access data elements (c)R...
• Which Model describes entities, relationships and attributes? Which Model describes entities, relationships and attributes? (a)E – R Model (b)Functional (c)Relational (d)Network (e)Info logical.
• What will happen to leaf and internal nodes if data is inserted into a B-tree?  What will happen to leaf and internal nodes if data is inserted into a B-tree? (a)Collapse (b)Mix (c)Split (d)Merge (e)Shrink.
• Which of the following is an incorrect statement? Which of the following is an incorrect statement? (a)Pointer – A data model which assumes that all data relationships can be structured as hierarchies (b)Data model –...
• What is the means that data used during the execution of a transaction cannot be used by a What is the means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed is called (a)Serializabi...
• The file organization which allows to read records that would satisfy the join condition . The file organization which allows to read records that would satisfy the join condition by using one block read is (a)Heap file organization (b)Sequential file organ...
• When implementing security in a DBMS, which of the following is not supported by the GRANT When implementing security in a DBMS, which of the following is not supported by the GRANT command? (a)Providing DELETE privileges (b)Supporting the devolution of acc...
• State the unit of storage that can store one or more records in a hash file organization State the unit of storage that can store one or more records in a hash file organization (a)Buckets (b)Disk pages (c)Blocks (d)Nodes (e)Baskets.
• “When a very large record of a file is allocated to disk blocks, some unused spaces will r “When a very large record of a file is allocated to disk blocks, some unused spaces will remain and to utilize this unused space, parts of records can be allocated. Each ...
• Check pointing when used in conjunction with incremental log reduces the actual recovery t Check pointing when used in conjunction with incremental log reduces the actual recovery time. However, for proper recovery the system must ensure that (choose the correc...
• The extent of the database resource that is included with each lock is called . The extent of the database resource that is included with each lock is called (a)Level of impact (b)Granularity (c)Management (d)DBMS control (e)Recovery.
• The methodology for documenting databases illustrating the relationship between various en The methodology for documenting databases illustrating the relationship between various entities in the database is (a)Data flow diagram (b)State transition diagram ...
• Select the correct statement from the following on proper naming of schema constructs: Select the correct statement from the following on proper naming of schema constructs: (a)Entity type name applies to all the entities belonging to that entity type an...
• Consider the following ER diagram depicting the relationship of an employee and supervisor Consider the following ER diagram depicting the relationship of an employee and supervisor: What is the possible relation if the above ERD is mapped into a relational mo...
• “In 1978 committee proposed a generalized framework for database systems and it provides a “In 1978 committee proposed a generalized framework for database systems and it provides a three_level architecture. The of the architecture defines user views of the dat...
• Embedded SQL means Embedded SQL means (a)Using the EMBED key word in a SQL statement (b)Writing a SQL statement to retrieve data from more than one relation (c)Writing SQL statements w...
• Which of the following concept is applicable with respect to 2NF? Which of the following concept is applicable with respect to 2NF? (a)Full functional dependency (b)Partial dependency (c)Transitive dependency (d)Non-transitive dep...
• If K is a foreign key in a relation R1, then (a)Every tuple of R1 has a distinct value fo If K is a foreign key in a relation R1, then (a)Every tuple of R1 has a distinct value for K (b)K cannot have a null value for tuples in R1 (c)K is a key for some ot...
• Making a change to the conceptual schema of a database but not affecting the existing exte Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of (a)Physical data independence (b)Concurrency C...
• A database management software (DBMS) includes (a)Automated tools (CASE) used to design A database management software (DBMS) includes (a)Automated tools (CASE) used to design databases and application programs (b)A software application that is used to...
• Which of the following type of index is automatically created when we do not specify? (a) Which of the following type of index is automatically created when we do not specify? (a)Bitmap (b)Balanced Tree Index (c)Binary Tree Index (d)Hashed (e)Sparse Index.
• An index record appears for every search key value in the file is An index record appears for every search key value in the file is (a)Secondary index (b)Dense index (c)Sparse index (d)Multi level index (e)B tree.
• Horizontal Fragmentation is Horizontal Fragmentation is (a)Divide the data up by logical groups of records (b)Divide the data up by logical groups of attributes (c)Divide the data up by logical...
• Out of the following activities, which is the one that normally performed by DBMS, witho Out of the following activities, which is the one that normally performed by DBMS, without the interference of the DBA? (a) Integrity (b) Retention (c) Secu...
• Which of the following is a procedure for acquiring the necessary locks for a transaction Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released? (a) Record c...
• A type of query that is placed within a WHERE or HAVING clause of another query is called. 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 ...
• All of the following are advantages of SQL-invoked routines EXCEPT (a) Flexibility (b) All of the following are advantages of SQL-invoked routines EXCEPT (a) Flexibility (b) Efficiency (c) Sharability (d) Security (e) Easy of use.
• Which of the following questions is answered by the SQL statement? Select Count (Product_D Which of the following questions is answered by the SQL statement? Select Count (Product_Description) from Product_T; (a) How many products are in the Product Table?...