Latest topics

1) Which of the following is not a recovery technique? A. Deferred update B. Immediate update C. Two-phase commit D. Recovery management 2)Checkpoints are a part of A. Recovery measures B. Security measures C. Concurrency measures D. Authorization measures 3) ....... deals with soft errors, such as power failures. A. system recovery B. media recovery C. database recovery D. failure recovery 4) ........... is an essential part of any backup system. A. Filter B. Recovery C. Security D. Scalability 5) Media recovery deals with ........... A. disk errors B. hard errors C. system errors D. power failures 6) For a backup/restore system, ............. is a prerequisite for service in a enterprise. A. Filter B. Recovery C. Security D. Scalability 7) Failure recovery and media recovery fall under ........ A. transaction recovery B. database recovery C. system recovery D. value recovery 8) The .......... consists of the various applications and database that play a role in a backup and recovery ...

1) In the ............, one transaction inserts a row in the table while the other transaction is half way through its browsing of table. A. transaction read problem B. one way read problem C. serial read problem D. phantom read problem 2) Transaction processing is associated with everything below except. A. producing detail, summery, or exception reports B. recording a business activity C. confirming an action or triggering a response D. maintaining data 3) .......... helps solve concurrency problem. A. locking B. transaction monitor C. transaction serializability D. two phase commit 4) If a transaction acquires a shared lock, then it can perform .......... operation. A. read B. write C. read and write D. update 5) If a transaction obtains a shared lock on a row, it means that the transaction wants to ..... that row. A. write B. insert C. execute D. read 6) The node where the distributed transaction originates is called the ....... A. local coordinator B. starting coordinator C. globa...

1) If the transaction is rolled back, all the database changes made inside the transaction are ...... A. made permanent B. made temporary C. copied to the log D. undone 2) Which of the following is not a property of transactions? A. Atomicity B. Concurrency C. Isolation D. Durability 3) A ......... ensures that transactions are performed as expected. A. transaction processing monitor B. transaction procedure monitor C. isolation monitor D. transaction log 4) A transaction that completes its execution successfully is said to be ....... A. committed B. rolled back C. partially committed D. Aborted 5) ........ means that a transaction must execute exactly once completely or not at all. A. durability B. consistency C. atomicity D. isolation 6) Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R. A. It will result in a deadlock situation B. It will immediately be rejected C. It will immediately be granted D. It will be granted as soon as it is r...

1) Which of the following is not a characteristic of a relational database model? A. Table B. Tree like structure C. Complex logical relationship D. Records 2) Field is otherwise called as ......... of the record A. data item B. data type C. value D. variable 3) A table can have only one A. Secondary key B. Alternate key C. Unique key D. Primary key 4) A field can be called as ........... in relation context. A. random file B. direct file C. attribute D. tuple 5) In the relational modes, cardinality is termed as A. Number of tuples B. Number of attributes C. Number of tables D. Number of constraints 6) The ........ is used for creating and destroying table, indexes and other forms of structures. A. data manipulation language B. data control language C. transaction control language D. data definition language 7) The view of total database content is A. Conceptual view B. Internal view C. External view D. Physical view 8) The ............ refers to the way data is organized in and access...

1) ......keyword is used to eliminate the duplicates. A. distinct B. unique C. union D. intersect 2) ..........is a query that has another query embedded within it. A. sub query B. structured query C. nested query D. sequence query 3) Which of the following is not an aggregate operator? A. MAX B. MIN C. TOTAL D. AVG 4) Any SQL statement inside an embedded SQL program must be inside the boundaries of .... A. EXE SQL and END B. EXEC SQL and END C. EXEC and END-EXEC D. EXEC SQL and END-EXEC 5) In embedded SQL, the per-compiler translates the SQL statements inside the code blocks into the appropriate .... A. PL/SQL block B. SQL * plus C. 3GL statements D. equivalent C code blocks 6) ........ accepts multiple rows a SQL query, stores them and hands over them one by one to the 3GL program. A. database program B. database cursor C. database object D. database constraints 7) The ........... is useful in the case of online application. A. embedded SQL B. PL/SQL C. static SQL D. dynamic SQL 8) W...

1) What is a data integrity? A. It is the data contained in database that is non redundant. B. It is the data contained in database that is accurate and consistent. C. It is the data contained in database that is secured. D. It is the data contained in database that is shared. 2) As per equivalence rules for query transformation, selection operation distributes over A. Union B. Intersection C. Set difference D. All of the above 3) In SQL the word 'natural' can be used with A. inner join B. full outer join C. right outer join D. all of the above 4) Which of the following relational algebraic operations is not from set theory? A. Union B. Intersection C. Cartesian Product D. Select 5) An entity set that does not have sufficient attributes to form a primary key is a A. strong entity set B. weak entity set C. simple entity set D. primary entity set 6) In case of entity integrity, the primary key may be A. not Null B. Null C. both Null and not Null D. any value 7) A logical schema A...

1. Which of the following relational algebra operations do not require the participating tables to be union-compatible? A. Union B. Intersection C. Difference D. Join 2) Relational Algebra does not have A. Selection operator B. Projection operator C. Aggregation operator D. Division operator 3) Tree structures are used to store data in A. Network model B. Relational model C. Hierarchical model D. File based system 4) The rule that a value of a foreign key must appear as a value of some specific table is called a A. Referential constraint B. Index C. Integrity constraint D. Functional dependency 5) It is an abstraction through which relationships are treated as higher level entities. A. Generalization B. Specialization C. Aggregation D. Inheritance 6) The operation which is not considered a basic operation of relational algebra is A. Join B. Selection C. Union D. Cross product 7) In SQL the statement select*from R,S is equivalent to A. Select * from R natural join S B. Select * from R c...

1) DROP is a ................ statement in SQL. A. Query B. Embedded SQL C. DDL D. DCL 2) The keyword to eliminate duplicate rows from the query result in SQL is. A. DISTINCT B. NO DUPLICATE C. UNIQUE D. None of the above 3) Which of the following aggregate function does not ignore nulls in its results? A. COUNT B. COUNT(*) C. MAX D. MIN 4) In SQL, testing whether a subquery is empty is done using A. DISTINCT B. UNIQUE C. NULL D. EXISTS 5) ................ operator is used to compare a value to a list of literals values that have been specified. A. Like B. Compare C. Between D. In 6) The language used in application programs to request data from the DBMS is referred to as the A. DML B. DDL C. VDL D. SDL 7) The DBMS language component which can be embedded in a program is A. The data definition language(DDL) B. The data manipulation language(DML) C. The database administrator(DBA) D. A query language 8) A DBMS query language is designed to A. Support end users who use English-like comma...

1. DML is provided for A) Description of logical structure of database B) Addition of new structure in the database system. C) Manipulation & processing of database D) Definition of physical structure of database system 2.'AS' clause is used in SQL for A) Selection operation B) Rename Operation C) Join operation D) Projection Operation 3. Count function in SQL returns the number of A) values B) distinct values C) groups D) columns 4. The statement in SQL which allows to change the definition of a table is A) Alter B) Update C) Cteate D) Select 5. Which of the following is correct. A) A SQL query automatically eliminates duplicates B) SQL permits attribute names to be repeated in the same relation C) A SQL query will not work if there are no indexes on the relations D) None of the above 6. Which of the following operation is used if we are interested in only certain columns of a table? A) PROJECTION B) SELECTION C) UNION D) JOIN 7. Which of the following is a legal expressi...

1. A ..................... specifies the actions needed to remove the drawbacks in the current design of database. A) 1 NF B) 2 NF C) 3 NF D) Normal form 2. A relation is in ........................... if an attribute of a composite key is dependent on an attribute of other composite key. A) 2NF B) 3NF C) BCNF D) 1NF 3. Fifth Normal form is concerned with A) Functional dependency B) Multivalued dependency C) Join dependency D) Domain key 4. A table is in the ....................... if only candidate keys are the determinants. A) functional dependency B) transitive dependency C) 4 NF D) BCNF 5. In 2NF A) No functional dependencies exist. B) No multivalued dependencies exist. C) No partial functional dependencies exist D) No partial multivalued dependencies exist. 6. The normal form that is not necessarily dependency preserving is A) 2NF B) 3NF C) BCNF D) 4NF 7. The ................. is related to the concept of multi-valued dependency. A) fourth normal form B) fifth normal form C) boyc...

1. In SQL, which command is used to issue multiple CREATE TABLE , CREATE VIEW and GRANT statements in a single transaction? SQL database icon with shortcut identification (Photo credit: Wikipedia ) A) CREATE PACKAGE B) CREATE SCHEMA C) CREATE CLUSTER A) All of the above 2. In SQL, the CREATE TABLESPACE is used A) to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace. B) to create a database trigger . C) to add/rename data files, to change storage D) All of the above 3. Which character function can be used to return a specified portion of a character string ? A) INSTR B) SUBSTRING C) SUBSTR D) POS 4. Which of the following is TRUE for the System Variable $date$? A) Can be assigned to a global variable. B) Can be assigned to any field only during design time. C) Can be assigned to any variable or field during run time. D) Can be assigned to a local variable. 5. What are the different events in Triggers? A)...