InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 251. |
The operation of changing a dimensions used in a cross-tab is called as ________(a) Alteration(b) Pivoting(c) Piloting(d) Renewing |
|
Answer» Correct choice is (b) Pivoting Easiest explanation: We can change the dimensions used in a cross tab. The operation of changing a dimensions used in a cross-tab is called as pivoting. |
|
| 252. |
The operation of moving from finer granular data to coarser granular data is called _______(a) Reduction(b) Increment(c) Roll up(d) Drill down |
|
Answer» The correct choice is (c) Roll up The explanation is: OLAP systems permit users to view the data at any level of granularity. The process of moving from finer granular data to coarser granular data is called as roll-up. |
|
| 253. |
X→ Y is trivial if?(a) X ⊂ Y(b) Y ⊂ X(c) X ⊇ Y(d) None of the mentioned |
|
Answer» The correct choice is (a) X ⊂ Y For explanation: X→ Y is said to be trivial if X is a subset of Y. Thus X ⊂ Y implies X→Y is trivial. |
|
| 254. |
The devices that store a lot of optical disks are called as(a) Optical reservoirs(b) Jukeboxes(c) Karaoke machines(d) Sequential access machines |
|
Answer» Correct option is (b) Jukeboxes The explanation: Jukeboxes are the devices that store a lot of optical disks and load them automatically on demand. |
|
| 255. |
Files that support log disks are called as ________(a) Logging file systems(b) Jorte File Systems(c) Journaling File Systems(d) Channelizing File Systems |
|
Answer» Right answer is (c) Journaling File Systems The explanation: Files that support log disks are called as Journaling File Systems. Journaling file systems can be implemented without a separate log disk, keeping the data and the log on the same disk. |
|
| 256. |
Data striping by splitting bits across multiple disks is called as _______(a) RAID striping(b) Array striping(c) Bit level striping(d) Block level striping |
|
Answer» The correct answer is (c) Bit level striping Explanation: Data striping by splitting bits across multiple disks is called as bit level striping. For example if we have an array of 8 disks, we write bit I of each byte to disk i. |
|
| 257. |
The splitting of input until each partition of the build input fits the memory is called as ______(a) Temporary partitioning(b) Block partitioning(c) Recursive partitioning(d) Byte partitioning |
|
Answer» The correct answer is (c) Recursive partitioning The best explanation: The splitting of input until each partition of the build input fits the memory is called as recursive partitioning. |
|
| 258. |
The _________ statement is used in SQL to confer authorization.(a) grant(b) confer(c) implement(d) permit |
|
Answer» Correct choice is (a) grant Easy explanation: The grant statement is used in SQL to confer authorization. It has the syntax grant |
|
| 259. |
What is the full form of JSP?(a) Java servlet program(b) Java server pages(c) Java server pages(d) Java server program |
|
Answer» The correct option is (b) Java server pages Best explanation: The full form of JSP is Java Server Pages. It is a scripting language that allows HTML programmers to mix static HTML with dynamically generated HTML. |
|
| 260. |
The primary key of the representation of a weak entity set consists of the primary key of the strong entity set and the _______(a) Discriminator of the weak entity set(b) Foreign key(c) Primary key of all the other entity sets(d) All the attributes of the weak entity set |
|
Answer» Right choice is (a) Discriminator of the weak entity set The best I can explain: The primary key of the representation of a weak entity set consists of the primary key of the strong entity set and the discriminator of the weak entity set. |
|
| 261. |
What is the standard for exchanging authentication and authorization information between two different security domains?(a) SABM(b) STML(c) SPTA(d) SAML |
|
Answer» Correct choice is (d) SAML The explanation is: SAML (Security assertion Markup Language) is the standard for exchanging authentication and authorization information between two different security domains. This provides a cross-organization sign-on. |
|
| 262. |
What is the full form of LRU (in buffer replacement strategy)?(a) Least Reactive User(b) Least Recently Used(c) Least Read URL(d) Lowest Reading User |
|
Answer» Correct option is (b) Least Recently Used Easy explanation: The full form of LRU is Least Recently Used. In this, the least recently used program is substituted by the new request. |
|
| 263. |
What is the full form of RAID?(a) Redundant Array of Independent Disks(b) Reliable Array of Independent Disks(c) Redundant Asset Increment Data(d) Reliable Aggravation of Immaculate Data |
|
Answer» Right answer is (a) Redundant Array of Independent Disks Explanation: The full form of RAID is Redundant array of Independent Disks. This disk organization technique improves performance and reliability. |
|
| 264. |
What is the full form of USB?(a) Universal Serial Binary(b) Universal Storage Base(c) Universal Serial Bus(d) Uninterrupted Service Bus |
|
Answer» Correct choice is (c) Universal Serial Bus To explain I would say: USB – Universal Serial Bus. This is currently the most popular and convenient way of data transmittal. |
|
| 265. |
The relationship associating the weak entity sets with the identifying entity set is called as ________(a) Identifying relationship(b) Connecting relationship(c) Completing relationship(d) Unique relationship |
|
Answer» Correct choice is (a) Identifying relationship The best explanation: The relationship associating the weak entity sets with the identifying entity set is called as an Identifying relationship. An identifying set is a many to one from the weak entity set to the identifying entity set. |
|
| 266. |
Browsers use a standardized syntax called?(a) TCP/IP(b) HTML(c) XML(d) Java |
|
Answer» Right answer is (b) HTML The explanation is: The Hypertext Markup Language [HTML] is the standardized syntax used by the browsers which supports formatted information as well as forms based interfaces. |
|
| 267. |
Which of the following set operations is not commutative?(a) Union(b) Intersection(c) Set difference(d) None of the mentioned |
|
Answer» Right choice is (c) Set difference For explanation I would say: The set difference operation is not commutative. As the position of the set difference operator affects the result of the operation. |
|
| 268. |
What is the full form of HTTP?(a) Hyper Text Trial Program(b) Hyper Text Transfer Protocol(c) Hyper Text Technology Protocol(d) Hyper Text Trial Protocol |
|
Answer» Right option is (b) Hyper Text Transfer Protocol To elaborate: HTTP – Hyper Text Transfer Protocol. This is aprotocol for transferring HTML documents. |
|
| 269. |
What is unique role assumption?(a) The attribute name has a unique meaning in the database(b) The attributes are all unique(c) No two tuples have even a single same value in a relation(d) None of the mentioned |
|
Answer» Right option is (a) The attribute name has a unique meaning in the database The explanation: Unique role assumption means that the attribute names must have unique meaning in the database. This prevents us from using the same attribute to mean different things in different schemas. |
|
| 270. |
What is the function of inner join?(a) It preserves tuples only in the relation named before the operation(b) It preserves tuples only in the relation named after the operation(c) It preserved tuples in the relations named on both the sides of the operation(d) It does not preserve any tuples on either side of the relation |
|
Answer» The correct choice is (d) It does not preserve any tuples on either side of the relation The best I can explain: The join operations that do not retain mismatched tuples are called as inner join operations. The inner join operation does not preserve any tuples on either side of the relation. |
|
| 271. |
Which of the following operations are associative(a) Natural joins(b) Theta joins(c) Both the mentioned(d) None of the mentioned |
|
Answer» Right choice is (c) Both the mentioned Explanation: Both natural join operation and theta join operation are associative. The commutativity and associativity of the join operations are important for join reordering in query optimization. |
|
| 272. |
A ______ is a globally unique name for every document that can be accessed on the Web(a) ID(b) UCL(c) URL(d) UML |
|
Answer» The correct option is (c) URL Best explanation: A URL (Uniform resource locator) is a globally unique name for every document that can be accessed on the Web. |
|
| 273. |
What is the function of a right outer join?(a) It preserves tuples only in the relation named before the operation(b) It preserves tuples only in the relation named after the operation(c) It preserved tuples in the relations named on both the sides of the operation(d) It does not preserve any tuples on either side of the relation |
|
Answer» Right choice is (b) It preserves tuples only in the relation named after the operation For explanation: The right outer join operation preserves the tuples named after the operation. |
|
| 274. |
What is a subquery?(a) A subquery is a select-from-where expression that is nested within another query(b) A subquery is any query that is nested within another query(c) A subquery is a relation that is externally specified which can be used to handle data in queries(d) A subquery is a condition that excludes all the invalid tuples from the database |
|
Answer» Correct answer is (a) A subquery is a select-from-where expression that is nested within another query Explanation: A subquery is a select-from-where expression that is nested within another query. Common uses for sub-queries are to perform tests for set membership, make set comparisons etc. |
|
| 275. |
If no rule can be derived from any combination of others then the set of rules is said to be ________(a) Primitive(b) Axiomatic(c) Minimal(d) Atomic |
|
Answer» Correct option is (c) Minimal Explanation: A set of equivalence rules is said to be minimal if no rule can be derived from any combination of others. Query optimizers use minimal sets of equivalence rules. |
|
| 276. |
Which of the following operations is associative(a) Set union(b) Set intersection(c) Set difference(d) Theta join |
|
Answer» Correct option is (d) Theta join Explanation: The theta join operation is associative within a certain set of conditions whereas the rest of the operations are non-associative in each and every condition. |
|
| 277. |
The extra information of a site maintained at the client end is called as _______(a) Cookie(b) Password(c) History(d) Sessions |
|
Answer» Correct choice is (a) Cookie To explain: The extra information of a site maintained at the client end is called as cookie. It is a small piece of text containing identifying information with an associated name. |
|
| 278. |
Statement 1: A tuple is a row in a relationStatement 2: Existence of multiple foreign keys in a same relation is possible(a) Both the statements are true(b) Statement 1 is correct but Statement 2 is false(c) Statement 1 is false but Statement 2 is correct |
|
Answer» The correct answer is (a) Both the statements are true To elaborate: A tuple is a row is a relation. There can exist multiple foreign keys in the same relation because there can exist multiple attributes in the relation that are primary keys in two or more other relations. |
|
| 279. |
Which of the following functions are done by a web server?(a) Accept requests from a web browser(b) Sends back results in HTML(c) Executes programs with arguments supplied by the user(d) All of the mentioned |
|
Answer» Correct answer is (d) All of the mentioned Best explanation: A web server accepts requests from a web browser and sends back results in HTML. The most important feature of a web server is to execute programs with arguments supplied by the user. |
|
| 280. |
Theta join operations are(a) Commutative(b) Associative(c) Distributive under projection(d) All of the mentioned |
|
Answer» Right option is (d) All of the mentioned For explanation: The theta join operations are commutative, associative and are distributive under projection. |
|
| 281. |
The ______ construct returns true if a given tuple is present in the subquery.(a) not exists(b) present(c) not present(d) exists |
|
Answer» The correct answer is (d) exists Explanation: The exists construct returns true if a given tuple is present in the subquery. The not exists construct gives true if a given tuple is not present in the subquery. |
|
| 282. |
The _________ layer provides the interface between the business logic layer and the underlying database(a) Business-logic layer(b) Data access layer(c) Data transfer layer(d) Business manager layer |
|
Answer» Right answer is (b) Data access layer The best explanation: The data-access layer provides the interface between the business logic layer and the underlying database. The data access layer provides the mapping from the object oriented data model to the relational model. |
|
| 283. |
The merge join can be used to compute(a) Natural joins(b) Equi joins(c) Both the mentioned(d) None of the mentioned |
|
Answer» The correct answer is (c) Both the mentioned To explain: The merge join can be used to compute both equijoins and natural joins. This is also called as the sort-merge-join algorithm. |
|
| 284. |
A join of the form r ⨝r.A=s.B s is called as(a) Equi join(b) Left outer join(c) Right outer join(d) Full outer join |
|
Answer» Right choice is (a) Equi join Explanation: A join of the form r ⨝r.A=s.B s is called as equi-join where A and B are sets of attributes of r and s respectively. |
|
| 285. |
If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, what happens to the values that are preserved on the left hand side?(a) They are given null values(b) They are given a random value(c) The user is asked to enter data(d) The query is declared invalid by the compiler |
|
Answer» The correct option is (a) They are given null values For explanation I would say: If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, the remaining values are given a null value. |
|
| 286. |
What are differentials in view management?(a) The differences between relations(b) The changes made to a relation(c) The changes made to an expression(d) More than one of the mentioned |
|
Answer» Right answer is (d) More than one of the mentioned The best I can explain: The changes made to a relation or and expression are known as differentials in materialized view management. |
|
| 287. |
Which of the following is true regarding the model-view- controller architecture?(a) The model corresponds to the business logic layer(b) The view defines the presentation of data(c) The controller receives events, executes actions on the model and returns a view(d) All of the mentioned |
|
Answer» The correct option is (d) All of the mentioned The explanation: In the model-view-controller architecture, the model corresponds to the business logic layer, the view defines the way data is presented and the controller receives events, executes actions on the model and returns a view. |
|
| 288. |
Which of the following is a type of materialized view management?(a) Incremental view management(b) Immediate view management(c) Deferred view management(d) All of the mentioned |
|
Answer» Right option is (d) All of the mentioned The best I can explain: Incremental, immediate and deferred are all different types of materialized view management techniques. Most database systems perform immediate view management. |
|
| 289. |
Reducing the complexity of complex queries by similarly handling sub-queries is known as ______(a) Complex query handling(b) Multi query optimization(c) Complex query optimization(d) Parametric query optimization |
|
Answer» The correct choice is (b) Multi query optimization For explanation: Reducing the complexity of complex queries by similarly handling sub-queries is known as multi query optimization. |
|
| 290. |
If nested loop join is done on a per block basis rather than on a per tuple basis, it is called as(a) Equi join(b) Hash join(c) Nested loop join(d) Block nested loop join |
|
Answer» Right option is (d) Block nested loop join The explanation is: If nested loop join is done on a per block basis rather than on a per tuple basis, it is called as Block nested loop join. Within each pair of blocks, every tuple in one block is paired with every tuple in the other block to generate all possible combinations. |
|
| 291. |
What technique is used for the evaluation of a query with a nested sub query?(a) Caching(b) Decorrelated evaluation(c) Correlated evaluation(d) Time based evaluation |
|
Answer» The correct choice is (c) Correlated evaluation For explanation I would say: The technique used to evaluate a query with a nested sub query is called as correlated evaluation. It is not very efficient as a large number of I/O operations may occur. |
|
| 292. |
A view whose contents are computed and stored is called as _______(a) Storage view(b) Backup view(c) Materialized view(d) Advanced view |
|
Answer» Correct choice is (c) Materialized view Explanation: A view whose contents are computed and stored is called as a materialized view. I does not only store the query defining the view. |
|
| 293. |
The problem of an update affecting the execution of a query associated with the update is known as the _________(a) Updation problem(b) Incremental problem(c) Halloween problem(d) Optimization problem |
|
Answer» Correct answer is (c) Halloween problem For explanation I would say: The problem of an update affecting the execution of a query associated with the update is known as the Halloween problem. This was because it was first recognized on the Halloween day at IBM. |
|
| 294. |
What does the “x” operator do in relational algebra?(a) Output specified attributes from all rows of the input relation. Remove duplicate tuples from the output(b) Output pairs of rows from the two input relations that have the same value on all attributes that have the same name(c) Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)(d) Returns the rows of the input relation that satisfy the predicate |
|
Answer» Correct choice is (c) Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes) Easy explanation: The “x” operator outputs all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes). This operation is called as the Cartesian product operation and is similar to the Cartesian product of sets. |
|
| 295. |
What action does ⋈ operator perform in relational algebra(a) Output specified attributes from all rows of the input relation and remove duplicate tuples from the output(b) Outputs pairs of rows from the two input relations that have the same value on all attributes that have the same name(c) Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)(d) Return rows of the input relation that satisfy the predicate |
|
Answer» Correct answer is (a) Output specified attributes from all rows of the input relation and remove duplicate tuples from the output The best explanation: ⋈ Outputs specified attributes from all rows of the input relation. Remove duplicate tuples from the output. The operation is called the join operation. |
|
| 296. |
The process of replacing a nested query with a query with a join is known as _________(a) Correlation(b) Decorrelation(c) Cache handling(d) Join replacement |
|
Answer» Right answer is (b) Decorrelation Easiest explanation: The process of replacing a nested query with a query with a join is known as decorrelation. It is more complicated when the nested sub query uses aggregate functions inside it. |
|
| 297. |
How is the left outer join symbol represented in relational algebra?(a) ⟕(b) ⟖(c) ⟗(d) ⋈ |
|
Answer» The correct option is (a) ⟕ To elaborate: The symbol of the left outer join is similar to the symbol of the natural join but it has two dashes on the top and bottom left side. |
|
| 298. |
How is the right outer join symbol represented in relational algebra?(a) ⟕(b) ⟖(c) ⟗(d) ⋈ |
|
Answer» The correct option is (b) ⟖ Best explanation: The symbol of the right outer join is similar to the symbol of the natural join but it has two dashes on the top and bottom right side. |
|
| 299. |
Updating, Deleting and Inserting in relational algebra is done using the ________ operator(a) Assignment(b) Modification(c) Alteration(d) Inclusion |
|
Answer» Right answer is (a) Assignment Explanation: Updating, Deleting and Inserting in relational algebra is done using the assignment operator. |
|
| 300. |
The project operation’s function in relational algebra is identical to the _______ clause in SQL(a) where(b) from(c) select(d) none of the mentioned |
|
Answer» Correct choice is (c) select To elaborate: The project operation’s function in relational algebra is identical to the select clause in SQL standard. It is used to list the attributes that are to be displayed. |
|