Related Questions

Four engineers, designated as CE, SE, EE and AE, read a certain number of newspapers early in the morning. One of them reads four newspapers, another reads three newspapers, the third reads two newspapers while the fourth one reads one newspaper. Below are some additional facts regarding the names of these officers. a) N is not the EE b) H is the AE c) N is not the CE and he reads more number of newspapers than L d) The one who is the CE reads more number of newspapers than L e) The person who is the SE reads the maximum number of newspapers f) B does not read two newspapers Which of the following statements is necessarily true?
Aayu, Jayu, Miyu and Keya all have different taste in literature. One reads novels, one reads poetry, one reads science fictions and one reads stories. Using following information select the type of literature enjoyed by Miyu. The novel fan has asked by Jayu to help her to collect data for Miyu. Miyu and Jayu are working on the project along with the person who enjoys science fictions. Both Keya and fan of novels are in the same class as the person who enjoys story reading. Miyu and Anu are not in the same class.
Which of the following statements are true?
Statement I Big data refers to no precise quantity, but generally refers to data in the range of Petabytes and Exabyte, i.e. billions to trillions of records, all from various sources. Big data is generated much faster. than traditional data in much larger quantities.
Statement II Big data interests industries because they are able to learn more patterns and curious variances than smaller data sets, with the capability to provide valuable insights into consumer behaviour, weather systems, financial market activity, or other phenomena.
Statement III Various departments and product lines use various applications within most organisations and store data in separate datasets. These separate databases may contain similar data, but data from one data base to another is not always consistent. This is called data silo.
Consider the following schedule S of transactions T1, T2, T3, T4: T1 T2 T3 T4   Reads(X)         Writes(X) Commit   Writes(X)  Commit         Writes(Y) Reads(Z) Commit           Reads(X) Reads(Y) Commit   Which one of the following statements is CORRECT?
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn = S.isbn;   Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 3: SELECT B.isbn, S.copies FROM Book B RIGHT OUTER JOIN Stock S ON B.isbn = S.isbn;   Query 4: SELECT B.isbn, S.copies FROM Book B FULL OUTER JOIN Stock S ON B.isbn = S.isbn;   Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?
The SQL statement that queries or reads data from a table is --
The SQL statement that queries or reads data from a table is ________ .
You develop an enterprise application, called XYZApplication that includes a Windows Form presentation layer, middle-tier components for business logic and data access, and a Microsoft SQL Server database.
You are in the process of creating a middle-tier component that will execute the data access routines in your application. When data is passed to this component, the component will call several SQL Server stored procedures to perform database updates. All of these procedure calls run under the control of a single transaction.
The code for the middle-tier component will implement the following objects:
SqlConnection cn = new SqlConnection();
SqlTransaction tr;
If two users try to update the same data concurrently, inconsistencies such as phantom reads will occur. You must now add code to your component to specify the highest possible level of protection against such inconsistencies.
Which code segment should you use?
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?