What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length? ?->(Show Answer!)

1. What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?

Write Comment

Comments

Tags

Show Similar Question And Answers

QA->Data Definition language used for:....

QA->4G LTE is a standard for wireless communication of high speed data for mobile phone and data terminals. What does LTE stand for?....

QA->Data rate of a ring network is 20Mbps and signal propagates at 200m/µsec. The number of bits that can be placed on the channel of length 200km is :....

QA->Red data book provides data on :....

QA->A subset of data in a warehouse in the form of summary data, related to a particular department of business function:....

MCQ->What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?....

MCQ->What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?....

MCQ-> India is rushing headlong toward economic success and modernisation, counting on high- tech industries such as information technology and biotechnology to propel the nation toprosperity. India’s recent announcement that it would no longer produce unlicensed inexpensive generic pharmaceuticals bowed to the realities of the World TradeOrganisation while at the same time challenging the domestic drug industry to compete with the multinational firms. Unfortunately, its weak higher education sector constitutes the Achilles’ Heel of this strategy. Its systematic disinvestment in higher education inrecent years has yielded neither world-class research nor very many highly trained scholars, scientists, or managers to sustain high-tech development. India’s main competitors especially China but also Singapore, Taiwan, and South Korea — are investing in large and differentiated higher education systems. They are providingaccess to large number of students at the bottom of the academic system while at the same time building some research-based universities that are able to compete with theworld’s best institutions. The recent London Times Higher Education Supplement ranking of the world’s top 200 universities included three in China, three in Hong Kong,three in South Korea, one in Taiwan, and one in India (an Indian Institute of Technology at number 41.— the specific campus was not specified). These countries are positioningthemselves for leadership in the knowledge-based economies of the coming era. There was a time when countries could achieve economic success with cheap labour andlow-tech manufacturing. Low wages still help, but contemporary large-scale development requires a sophisticated and at least partly knowledge-based economy.India has chosen that path, but will find a major stumbling block in its university system. India has significant advantages in the 21st century knowledge race. It has a large high ereducation sector — the third largest in the world in student numbers, after China andthe United States. It uses English as a primary language of higher education and research. It has a long academic tradition. Academic freedom is respected. There are asmall number of high quality institutions, departments, and centres that can form the basis of quality sector in higher education. The fact that the States, rather than the Central Government, exercise major responsibility for higher education creates a rather cumbersome structure, but the system allows for a variety of policies and approaches. Yet the weaknesses far outweigh the strengths. India educates approximately 10 per cent of its young people in higher education compared with more than half in the major industrialised countries and 15 per cent in China. Almost all of the world’s academic systems resemble a pyramid, with a small high quality tier at the top and a massive sector at the bottom. India has a tiny top tier. None of its universities occupies a solid position at the top. A few of the best universities have some excellent departments and centres, and there is a small number of outstanding undergraduate colleges. The University Grants Commission’s recent major support of five universities to build on their recognised strength is a step toward recognising a differentiated academic system and fostering excellence. At present, the world-class institutions are mainly limited to the Indian Institutes of Technology (IITs), the Indian Institutes of Management (IIMs) and perhaps a few others such as the All India Institute of Medical Sciences and the Tata Institute of Fundamental Research. These institutions, combined, enroll well under 1 percent of the student population. India’s colleges and universities, with just a few exceptions, have become large, under-funded, ungovernable institutions. At many of them, politics has intruded into campus life, influencing academic appointments and decisions across levels. Under-investment in libraries, information technology, laboratories, and classrooms makes it very difficult to provide top-quality instruction or engage in cutting-edge research.The rise in the number of part-time teachers and the freeze on new full-time appointments in many places have affected morale in the academic profession. The lackof accountability means that teaching and research performance is seldom measured. The system provides few incentives to perform. Bureaucratic inertia hampers change.Student unrest and occasional faculty agitation disrupt operations. Nevertheless, with a semblance of normality, faculty administrators are. able to provide teaching, coordinate examinations, and award degrees. Even the small top tier of higher education faces serious problems. Many IIT graduates,well trained in technology, have chosen not to contribute their skills to the burgeoning technology sector in India. Perhaps half leave the country immediately upon graduation to pursue advanced study abroad — and most do not return. A stunning 86 per cent of students in science and technology fields from India who obtain degrees in the United States do not return home immediately following their study. Another significant group, of about 30 per cent, decides to earn MBAs in India because local salaries are higher.—and are lost to science and technology.A corps of dedicated and able teachers work at the IlTs and IIMs, but the lure of jobs abroad and in the private sector make it increasingly difficult to lure the best and brightest to the academic profession.Few in India are thinking creatively about higher education. There is no field of higher education research. Those in government as well as academic leaders seem content to do the “same old thing.” Academic institutions and systems have become large and complex. They need good data, careful analysis, and creative ideas. In China, more than two-dozen higher education research centers, and several government agencies are involved in higher education policy.India has survived with an increasingly mediocre higher education system for decades.Now as India strives to compete in a globalized economy in areas that require highly trained professionals, the quality of higher education becomes increasingly important.India cannot build internationally recognized research-oriented universities overnight,but the country has the key elements in place to begin and sustain the process. India will need to create a dozen or more universities that can compete internationally to fully participate in the new world economy. Without these universities, India is destined to remain a scientific backwater.Which of the following ‘statement(s) is/are correct in the context of the given passage ? I. India has the third largest higher education sector in the world in student numbers. II. India is moving rapidly toward economic success and modernisation through high tech industries such as information technology and bitechonology to make the nation to prosperity. III. India’s systematic disinvestment in higher education in recent years has yielded world class research and many world class trained scholars, scientists to sustain high-tech development.....

MCQ-> In a modern computer, electronic and magnetic storage technologies play complementary roles. Electronic memory chips are fast but volatile (their contents are lost when the computer is unplugged). Magnetic tapes and hard disks are slower, but have the advantage that they are non-volatile, so that they can be used to store software and documents even when the power is off.In laboratories around the world, however, researchers are hoping to achieve the best of both worlds. They are trying to build magnetic memory chips that could be used in place of today’s electronics. These magnetic memories would be nonvolatile; but they would also he faster, would consume less power, and would be able to stand up to hazardous environments more easily. Such chips would have obvious applications in storage cards for digital cameras and music- players; they would enable handheld and laptop computers to boot up more quickly and to operate for longer; they would allow desktop computers to run faster; they would doubtless have military and space-faring advantages too. But although the theory behind them looks solid, there are tricky practical problems and need to be overcome.Two different approaches, based on different magnetic phenomena, are being pursued. The first, being investigated by Gary Prinz and his colleagues at the Naval Research Laboratory (NRL) in Washington, D.c), exploits the fact that the electrical resistance of some materials changes in the presence of magnetic field— a phenomenon known as magneto- resistance. For some multi-layered materials this effect is particularly powerful and is, accordingly, called “giant” magneto-resistance (GMR). Since 1997, the exploitation of GMR has made cheap multi-gigabyte hard disks commonplace. The magnetic orientations of the magnetised spots on the surface of a spinning disk are detected by measuring the changes they induce in the resistance of a tiny sensor. This technique is so sensitive that it means the spots can be made smaller and packed closer together than was previously possible, thus increasing the capacity and reducing the size and cost of a disk drive. Dr. Prinz and his colleagues are now exploiting the same phenomenon on the surface of memory chips, rather spinning disks. In a conventional memory chip, each binary digit (bit) of data is represented using a capacitor-reservoir of electrical charge that is either empty or fill -to represent a zero or a one. In the NRL’s magnetic design, by contrast, each bit is stored in a magnetic element in the form of a vertical pillar of magnetisable material. A matrix of wires passing above and below the elements allows each to be magnetised, either clockwise or anti-clockwise, to represent zero or one. Another set of wires allows current to pass through any particular element. By measuring an element’s resistance you can determine its magnetic orientation, and hence whether it is storing a zero or a one. Since the elements retain their magnetic orientation even when the power is off, the result is non-volatile memory. Unlike the elements of an electronic memory, a magnetic memory’s elements are not easily disrupted by radiation. And compared with electronic memories, whose capacitors need constant topping up, magnetic memories are simpler and consume less power. The NRL researchers plan to commercialise their device through a company called Non-V olatile Electronics, which recently began work on the necessary processing and fabrication techniques. But it will be some years before the first chips roll off the production line.Most attention in the field in focused on an alternative approach based on magnetic tunnel-junctions (MTJs), which are being investigated by researchers at chipmakers such as IBM, Motorola, Siemens and Hewlett-Packard. IBM’s research team, led by Stuart Parkin, has already created a 500-element working prototype that operates at 20 times the speed of conventional memory chips and consumes 1% of the power. Each element consists of a sandwich of two layers of magnetisable material separated by a barrier of aluminium oxide just four or five atoms thick. The polarisation of lower magnetisable layer is fixed in one direction, but that of the upper layer can be set (again, by passing a current through a matrix of control wires) either to the left or to the right, to store a zero or a one. The polarisations of the two layers are then either the same or opposite directions.Although the aluminum-oxide barrier is an electrical insulator, it is so thin that electrons are able to jump across it via a quantum-mechanical effect called tunnelling. It turns out that such tunnelling is easier when the two magnetic layers are polarised in the same direction than when they are polarised in opposite directions. So, by measuring the current that flows through the sandwich, it is possible to determine the alignment of the topmost layer, and hence whether it is storing a zero or a one.To build a full-scale memory chip based on MTJs is, however, no easy matter. According to Paulo Freitas, an expert on chip manufacturing at the Technical University of Lisbon, magnetic memory elements will have to become far smaller and more reliable than current prototypes if they are to compete with electronic memory. At the same time, they will have to be sensitive enough to respond when the appropriate wires in the control matrix are switched on, but not so sensitive that they respond when a neighbouring elements is changed. Despite these difficulties, the general consensus is that MTJs are the more promising ideas. Dr. Parkin says his group evaluated the GMR approach and decided not to pursue it, despite the fact that IBM pioneered GMR in hard disks. Dr. Prinz, however, contends that his plan will eventually offer higher storage densities and lower production costs.Not content with shaking up the multi-billion-dollar market for computer memory, some researchers have even more ambitious plans for magnetic computing. In a paper published last month in Science, Russell Cowburn and Mark Well and of Cambridge University outlined research that could form the basis of a magnetic microprocessor — a chip capable of manipulating (rather than merely storing) information magnetically. In place of conducting wires, a magnetic processor would have rows of magnetic dots, each of which could be polarised in one of two directions. Individual bits of information would travel down the rows as magnetic pulses, changing the orientation of the dots as they went. Dr. Cowbum and Dr. Welland have demonstrated how a logic gate (the basic element of a microprocessor) could work in such a scheme. In their experiment, they fed a signal in at one end of the chain of dots and used a second signal to control whether it propagated along the chain.It is, admittedly, a long way from a single logic gate to a full microprocessor, but this was true also when the transistor was first invented. Dr. Cowburn, who is now searching for backers to help commercialise the technology, says he believes it will be at least ten years before the first magnetic microprocessor is constructed. But other researchers in the field agree that such a chip, is the next logical step. Dr. Prinz says that once magnetic memory is sorted out “the target is to go after the logic circuits.” Whether all-magnetic computers will ever be able to compete with other contenders that are jostling to knock electronics off its perch — such as optical, biological and quantum computing — remains to be seen. Dr. Cowburn suggests that the future lies with hybrid machines that use different technologies. But computing with magnetism evidently has an attraction all its own.In developing magnetic memory chips to replace the electronic ones, two alternative research paths are being pursued. These are approaches based on:
....

MCQ-> Read passage carefully. Answer the questions by selecting the most appropriate option (with reference to the passage). PASSAGE 4While majoring in computer science isn't a requirement to participate in the Second Machine Age, what skills do liberal arts graduates specifically possess to contribute to this brave new world? Another major oversight in the debate has been the failure to appreciate that a good liberal arts education teaches many skills that are not only valuable to the general world of business, but are in fact vital to innovating the next wave of breakthrough tech-driven products and services. Many defenses of the value of a liberal arts education have been launched, of course, with the emphasis being on the acquisition of fundamental thinking and communication skills, such as critical thinking, logical argumentation, and good communication skills. One aspect of liberal arts education that has been strangely neglected in the discussion is the fact that the humanities and social sciences are devoted to the study of human nature and the nature of our communities and larger societies. Students who pursue degrees in the liberal arts disciplines tend to be particularly motivated to investigate what makes us human: how we behave and why we behave as we do. They're driven to explore how our families and our public institutions-such as our schools and legal systems-operate, and could operate better, and how governments and economies work, or as is so often the case, are plagued by dysfunction. These students learn a great deal from their particular courses of study and apply that knowledge to today's issues, the leading problems to be tackled, and various approaches for analyzing and addressing those problems. The greatest opportunities for innovation in the emerging era are in applying evolving technological capabilities to finding better ways to solve human problems like social dysfunction and political corruption; finding ways to better educate children; helping people live healthier and happier lives by altering harmful behaviors; improving our working conditions; discovering better ways to tackle poverty; Improving healthcare and making it more affordable; making our governments more accountable, from the local level up to that of global affairs; and finding optimal ways to incorporate intelligent, nimble machines into our work lives so that we are empowered to do more of the work that we do best, and to let the machines do the rest. Workers with a solid liberal arts education have a strong foundation to build on in pursuing these goals. One of the most immediate needs in technology innovation is to invest products and services with more human qualities. with more sensitivity to human needs and desires. Companies and entrepreneurs that want to succeed today and in the future must learn to consider in all aspects of their product and service creation how they can make use of the new technologies to make them more humane. Still, many other liberal arts disciplines also have much to provide the world of technological innovation. The study of psychology, for example, can help people build products that are more attuned to our emotions and ways of thinking. Experience in Anthropology can additionally help companies understand cultural and individual behavioural factors that should be considered in developing products and in marketing them. As technology allows for more machine intelligence and our lives become increasingly populated by the Internet of things and as the gathering of data about our lives and analysis of it allows for more discoveries about our behaviour, consideration of how new products and services can be crafted for the optimal enhancement of our lives and the nature of our communities, workplaces and governments will be of vital importance. Those products and services developed with the keeneSt sense of how they' can serve our human needs and complement our human talents will have a distinct competitive advantage. Much of the criticism of the liberal arts is based on the false assumption that liberal arts students lack rigor in comparison to those participating in the STEM disciplines and that they are 'soft' and unscientific whereas those who study STEM fields learn the scientific method. In fact the liberal arts teach many methods of rigorous inquiry and analysis, such as close observation and interviewing in ways that hard science adherents don't always appreciate. Many fields have long incorporated the scientific method and other types of data driven scientific inquiry and problem solving. Sociologists have developed sophisticated mathematical models of societal networks. Historians gather voluminous data on centuries-old household expenses, marriage and divorce rates, and the world trade, and use data to conduct statistical analyses, identifying trends and contributing factors to the phenomena they are studying. Linguists have developed high-tech models of the evolution of language, and they've made crucial contributions to the development of one of the technologies behind the rapid advance of automation- natural language processing, whereby computers are able to communicate with the, accuracy and personality of Siri and Alexa. It's also important to debunk the fallacy that liberal arts students who don't study these quantitative analytical methods have no 'hard' or relevant skills. This gets us back to the arguments about the fundamental ways of thinking, inquiring, problem solving and communicating that a liberal arts education teaches.What is the central theme of the passage?
....