answersLogoWhite

0

📱

Database Programming

Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.

8,803 Questions

What is dynamic queue?

Dynamic queue is one that can grow to allow for more entries.

àA static queue has a fixed number of slots and once they are full no more entries can be supported until one entry leaves the queue.

What is query expunge?

It means that the mailbox can not be extended and that the calculated size of

the mailbox *after* expunging is larger than its current size. The

addition of mailbox and message meta data is greater than the message data

removed in deleted messages.

What is Difference between productive maintenance and unproductive maintenance in database?

productive maintenance: maintenance that leads to a benefit by meeting a new requirement, not just a continuation of the previous.

Unproductive maintenance is a consequence of the way in which file-based processing is closely tied to the physical structure of the data stored in the files. This is referred to as data dependence.

How do you rename a datafile in Oracle?

â–º Rename a Datafile in Oracle(10g):-SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/product/10.2.0/oradata/abab/system.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/undo.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/sysaux.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/usr01.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/usr02.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/asm01.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/usr04.dbf

/u01/app/oracle/product/10.2.0/oradata/abab/m123.dbf

8 rows selected.

SQL> alter tablespace msb read only;

Tablespace altered.

SQL> select TABLESPACE_NAME, status from dba_tablespaces;

TABLESPACE_NAME STATUS

------------------------------ ---------

SYSTEM ONLINE

UNDOTBS1 ONLINE

SYSAUX ONLINE

TEMP ONLINE

USR01 ONLINE

USR02 ONLINE

TEMP01 ONLINE

INNER ONLINE

ASM ONLINE

MSB READ ONLY

TEMPORARY ONLINE

TABLESPACE_NAME STATUS

------------------------------ ---------

TSPUNDO ONLINE

12 rows selected.

SQL> alter tablespace msb offline;

Tablespace altered.

============================================================

Work on OS level:-

[oracle@abab-YYY-XXX abab]$ CD /u01/app/oracle/product/10.2.0/oradata/nisi/

[oracle@abab-YYY-XXX abab]$ ls

asm01.dbf redo1.log sysaux.dbf undo.dbf usr04.dbf

m123.dbf redo2.log system.dbf usr01.dbf

redo3.log temporary.dbf usr02.dbf

[oracle@abab-YYY-XXX abab]$ cp m123.dbf mmm.dbf

[oracle@abab-YYY-XXX abab]$ ls

asm01.dbf redo1.log sysaux.dbf undo.dbf usr04.dbf

m123.dbf redo2.log system.dbf usr01.dbf

mmm.dbf redo3.log temporary.dbf usr02.dbf

[oracle@abab-YYY-XXX abab]$

============================================================

SQL> alter database rename file

2 '/u01/app/oracle/product/10.2.0/oradata/abab/m123.dbf'

3 to

4 '/u01/app/oracle/product/10.2.0/oradata/abab/mmm.dbf';

Database altered.

SQL> alter tablespace msb online;

Tablespace altered.

SQL> alter tablespace msb read write;

Tablespace altered.

SQL> select name, status from v$datafile;

NAME STATUS

------------------------------------------------------------ -------

/u01/app/oracle/product/10.2.0/oradata/abab/system.dbf SYSTEM

/u01/app/oracle/product/10.2.0/oradata/abab/undo.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/sysaux.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/usr01.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/usr02.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/asm01.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/usr04.dbf ONLINE

/u01/app/oracle/product/10.2.0/oradata/abab/mmm.dbf ONLINE

8 rows selected.

Describe four uses of primary key?

To uniquely identify a record, as every primary key value must be unique.

To ensure every record has a key, as a primary key cannot be left blank.

To be used in creating relationships.

For sorting and searching records.

What was the name of the awful sequel to MASH set in a Missouri VA hospital?

AfterMASH is an American situation comedy that aired on CBS from September 26, 1983 to May 31, 1985. A spin-off of the long-running hit series M*A*S*H which wasent that awful

What is the difference between discretionary and mandatory access control?

In the most common implementations of Discretionary Access Control, users "own" their directories and the files and programs they contain. They can grant and deny access and execution privileges for these to other users. Users can also be parts of groups. They may be able grant or restrict access to all members of a group.

In Mandatory Access Control the operating system controls the ability of a subject or initiator to access or generally perform some sort of operation on an object or target. The object or target can be something like a process, a file, a directory, a program, or a memory segment. Subjects and objects each have a set of security attributes. Whenever a subject attempts to access an object, an authorization rule enforced by the operating system kernal compares these security attributes to the policy and decides whether the access or operation will be allowed. With mandatory access control, this security policy is centrally controlled by a security policy administrator; users do not have the ability to override the policy and, for example, grant access to files that would otherwise be restricted.

How retrieve xml data using php?

Ypu can use file handling function to read XML

file_get_contents()

file()

fopen()

Use SimpleXML Library

simplexml_load_string - Interprets a string of XML into an object

simplexml_load_file - Interprets an XML file into an object

Briefly explain any four components of internet?

Browser: a Web Browser is a program or piece of software which enables a person to easily access the internet and surf to various ip addresses and websites (WWW). There are many different browsers, some popular ones are called Internet Explorer, Mozilla Firefox, Safari and Google Chrome.

FTP: "File Transfer Protocol" is the most common method of transferring files between computers via the Internet. They can be shared through hosts such as rapidshare.com or through programs such as Utorrent or Filezilla.

World Wide Web: This is largest, fastest growing, part of the Internet, the part for which Internet browsers like Netscape's Navigator and Microsoft's Explorer were designed. Business is the leading factor fueling the rapid growth of the Web making information, advertising, and product ordering readily available to everyone with Web access.

Chat: IRC (Internet Relay Chat) is used for live discussions on the Internet. Some programs include MSN and Skype.

Search Engines: These tools are really a part of the World Wide Web and are often used when looking for information because the Web has grown so large and is without any inherent organizational structure. e.g. Google

  1. Devices: the hardware that generates physical signals, interprets them, and sends them along the right transmission medium to get to their destination.
  2. Transmission media: the means by which signals are sent from one place to another.
  3. Software: the internal instructions used by computers to do their job correctly.
  4. Protocols: the standard "language" for messages from one device to another for requesting services and replying to the requests. Protocols are not discussed (directly) in this module, but are touched on in several others, including:

What is a Data Models?

A Data Model is a way to organize the data that you have, it gets the information and using a set of rules it makes sure that the data is good quality for you to use.

Data Models are normally used to get data in, merge already existing data and to get data out. Data Models are also used for people that are working on the same project but in different groups to communicate.

There are multiple different Data Models, each one has its own befits and problems through each one is designed for a certain job.

What is data binding in AngularJS?

Data binding is a very useful feature used in software development technologies. It acts as a bridge between the overview and business logic for the application. AngularJS follow Two-Way Data Binding.

Data can be binded in two ways:

1.One -Way data binding

2.Two-Way data binding

Silicon Valley provides services like:

Angular JS application Development

Node JS Development

React Native Development

How do you create query using wizard?

i dont know

The term 'query' means to search, to question, or to find

What are all types of data processing systems?

a) Batch processing

b) Real - Time processing

c) online processing

d) Distributed processing

e) Time sharing Processing

f) Multi- processing

g) Transaction processing

Your welcome :^)

explain each

:|]

What is the difference between parallel and distrtibuted opering system?

parallel operating system is tha sharing of data between two computers.......

Distributing system is the sharing of data among different computers....

How many types of sign language is there?

There are so many...many different ones for each country.

Africa

There are at least 25 sign languages in Africa, according to researcher Nobutaka Kamei.[1][2][3] Some have distributions that are completely independent of those of African spoken languages. At least 13 foreign sign languages, mainly from Europe and America, have been introduced to at least 27 African nations; some of the 23 sign languages documented by Kamei have originated with or been influenced by them.

* Adamorobe Sign Language (ADS) (Ghana)

* Algerian Sign Language

* Bamako Sign Language (in a school in Mali)

* Bura Sign Language - Nigeria (PDF link)

* Chadian Sign Language

* Congolesian Sign Language

* Egypt Sign Language

* Ethiopian Sign Language

* Franco-American Sign Language - a pidgin observed in Cameroon and elsewhere in West and Central Africa.

* Gambian Sign Language

* Ghana Sign Language (or "Ghanaian Sign Language") (GSE)

* Guinean Sign Language

* Hausa Sign Language "Maganar Hannu" (HSL) - Northern Nigeria (Kano State)

* Kenyan Sign Language (KSL or LAK)

* Libyan Sign Language

* Malagasy Sign Language (or "Madagascan Sign Language")

* Morroccan Sign Language

* Mozambican Sign Language

* Mbour Sign Language - Senegal

* Namibian Sign Language

* Nigerian Sign Language

* Sierra Leone Sign Language

* South African Sign Language (SASL)

* Tanzanian Sign Language (seven independent languages, one for each deaf school in Tanzania)

* Tunisian Sign Language

* Uganda Sign Language (USL)

* Zambian Sign Language (ZASL)

* Zimbabwe Sign Language

The Americas

* American Sign Language (ASL)

* Argentine Sign Language (LSA)

* Bolivian Sign Language

* Brazilian Sign Language "Lingua Brasileira de Sinais" (LIBRAS)

* Chilean Sign Language "Lenguaje de Señas Chileno" (LSCH)

* Colombian Sign Language (CSN)

* Costa Rican Sign Language (LESCO)

* Cuba Sign Language

* Ecuadorian Sign Language

* Guatemalan Sign Language

* Honduras Sign Language "Lengua de señas hondureña" (LESHO)

* Maritime Sign Language

* Mayan sign languages

* Mexican Sign Language "Lengua de señas mexicana" (LSM)

* Nicaraguan Sign Language "Idioma de señas nicaragüense" (ISN)

* Quebec Sign Language "Langue des Signes Québécoise" (LSQ)

* Peruvian Sign Language

* Providence Island Sign Language

* Salvadorian Sign Language

* Uruguayan Sign Language

* Urubú Sign Language

* Venezuelan Sign Language "Lengua de señas venezolana" (LSV)

* Yucatec Maya Sign Language

Asia/Pacific

* Auslan (Australian Sign Language)

* Ban Khor Sign Language - used in the Isan region of Thailand.

* Bengali Sign language

* Chinese Sign Language "中国手语" (ZGS)

* Filipino Sign Language "Philippine Sign Language" (PSL)

* Hawaii Pidgin Sign Language

* Hong Kong Sign Language "香港手語" (HKSL)

* Huay Hai Sign Language (Thailand)

* Indo-Pakistani Sign Language or Indian Sign Language

* Indonesian Sign Language Bahasa Isyarat Indonesia (BII)

* Japanese Sign Language "日本手話" (Nihon shuwa), (NS)

* Kata Kolok - used in Bali

* Laos Sign Language

* Korean Sign Language

* Malaysian Sign Language "Bahasa Isyarat Malaysia" (BIM)

* Mongolian Sign Language

* Na Sai Sign Language (Thailand)

* Nepal Sign Language

* New Zealand Sign Language (NZSL)

* Old Bangkok Sign Language

* Old Chiangmai Sign Language

* Plaa Pag Sign Language

* Penang Sign Language (used in Malaysia)

* Selangor Sign Language (used in Malaysia)

* Singapore Sign Language

* Sri Lankan Sign Language

* Taiwanese Sign Language

* Tibetan Sign Language

* Thai Sign Language

* Vietnamese sign languages (Hanoi Sign Language, Ho Chi Minh Sign Language, Haiphong Sign Language)

Europe

* Albanian Sign Language "Gjuha e Shenjave Shqipe"

* Armenian Sign Language

* Austrian Sign Language "Österreichische Gebärdensprache" (ÖGS)

* Belgian-French Sign Language "Langue des Signes de Belgique Francophone" (LSFB)

* British Sign Language (BSL)

* Bulgarian Sign Language

* Catalan Sign Language (or "Catalonian Sign Language") "Llengua de Signes Catalana" (LSC)

* Croatian Sign Language (Croslan) "Hrvatskog Znakovnog Jezika" (HZJ)

* Czech Sign Language "Český znakový jazyk" (CZJ)

* Danish Sign Language "Tegnsprog"

* Dutch Sign Language "Nederlandse Gebarentaal" (NGT), also commonly known as "Sign Language of the Netherlands" (SLN)

* Estonian Sign Language "Eesti viipekeel"

* Finnish Sign Language "Suomalainen viittomakieli" (SVK)

* Finland-Swedish Sign Language "finlandssvenskt teckenspråk" (Swedish) or "suomenruotsalainen viittomakieli" (Finnish)

* Flemish Sign Language "Vlaamse Gebarentaal" (VGT)

* French Sign Language "Langues des Signes Française" (LSF)

* German Sign Language "Deutsche Gebärdensprache" (DGS)

* Greek Sign Language "Ελλ ηνική Νοηματ ική Γλώσσ α" (GSL)

* Hungarian Sign Language "Magyar jelnyelv"

* Icelandic Sign Language "Táknmál"

* Irish Sign Language (ISL)

* Italian Sign Language "Lingua dei Segni Italiana" (LIS)

* Lithuanian Sign Language "Lietuvių gestų kalba"

* Maltese Sign Language "Lingwi tas-Sinjali Maltin" (LSM)

* Northern Ireland Sign Language (NISL)

* Norwegian Sign Language "Tegnspråk" (NSL)

* Polish Sign Language "Polski Język Migowy" (PJM)

* Portuguese Sign Language "Língua Gestual Portuguesa" (LGP)

* Russian Sign Language "Russkii Zhestovyi Iazyk"

* Spanish Sign Language "Lengua de signos española" (LSE)

* Swedish Sign Language "Svenskt teckenspråk" (TSP)

* Swiss-French Sign Language "Langage Gestuelle"

* Swiss-German Sign Language "Deutschschweizer Gebärdensprache" (DSGS)

* Turkish Sign Language "Türk İşaret Dili" (TİD)

* Valencian Sign Language "Llengua de Signes en la Comunitat Valenciana" (LSCV)

Middle East

* Al-Sayyid Bedouin Sign Language (ABSL), Southern Israel

* Israeli Sign Language

* Persian Sign Language

* Jordanian Sign Language Lughat il-Ishaarah il-Urduniah (LIU)

* Kuwaiti Sign Language

* Saudi Arabian Sign Language

Historical sign languages

* BANZSL - Language family to which BSL, Auslan, and NZSL belong

* Martha's Vineyard Sign Language

* Old French Sign Language - Parent language of many sign languages

* Old Kent Sign Language

Auxiliary sign systems

* Australian Aboriginal sign languages

* Baby Sign - using signs to assist early language development in young children.

* Baseball Sign - a method used in baseball and softball to communicate strategic plays without the opponent knowing

* Contact Sign - a pidgin or contact language between a spoken language and a sign language, eg. Pidgin Sign English (PSE).

* International Sign (previously known as Gestuno) - an auxiliary language used by deaf people in international settings.

* Makaton - a system of signed communication used by and with people who have speech, language or learning difficulties.

* Monastic sign language

* Plains Indian Sign Language

* Tic tac - a traditional British system of communicating betting odds at racecourses.

http://en.wikipedia.org/wiki/List_of_sign_languages2

Pts

Rate Answer