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 does primary key mean in ict?

it key that will enable you link the two tables together for relationship

When did the minimalist concept evolve?

Minimalism rejects the need for social comment, self-expression, narrative, or any other allusion to history, politics, or religion. It is based on creating objects of interest and beauty. Minimalists reduced their work to the smallest number of colors, values, shapes, lines, and textures. David Burlyuk first used the term in an exhibition catalogue for John Graham's paintings at the Dudensing Gallery in New York in 1929. The term was later applied to the movement in the 1960's. Other names for the movement include ABC art, minimal art, reductivism, and rejective art. Minimalism was a reaction against the formal overkill and pretentiousness of Abstract Expressionism. It had roots in Pop art, Cubism, and Conceptual art and was also inspired by Russian Suprematists such as Kasimir Malevich.

What are the database management activities?

Make sure the database does not run out of space. Nowdays no manual intervention is required in products from major database vendors like Oracle.

Make sure the database jobs are running with no issues.

Configure, Schedule backups

Make sure backup and recovery procedures work as configured.

Database security is another task.

What is output variable?

When you call a function, its parameters may transfer data to the function, back from the function, or both directions. The second sort of them is called as output variable.

How to set up an OLE DB connection?

OLE DB connections not only offer greater performance than ODBC (DSN) , but also allow some additional functions and have the benefit that you do not need to wait for your web hosting provider to set up a DSN on your server.

First create a new text file, by default windows will name it New Text Document.txt, rename the file NewConnection.udl, or whatever you wish, the important thing is to change the file extension to .udl (Universal Data Link). Windows will give you a warning message about renaming file extensions, click Yes to proceed.

Double click the newly created .udl file, this will open the Data Link Properties box shown below:

Select Microsoft OLE DB Provider for SQL Server from the list shown and click the Next>> button.

To connect to a SQL Server database on your local PC, select or type in the server name in the text box number 1. Next click the relevant radio button and select whether you wish to use Windows NT integrated security or a specific user name and password. Finally select the database on the SQL Server to which you wish to connect.

Click the Test Connection button to confirm that everything is working correctly and click OK. Now right click the .udl file and select Open with Notepad.

If you selected Windows NT Integrated security you should see something like this:

[oledb]

; Everything after this line is an OLE DB initstring

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=YourDB;_

Data Source=YOUR_LOCAL_SERVER_NAME

If you selected Use a specific user name and password, you will see something like this:

[oledb]

; Everything after this line is an OLE DB initstring

Provider=SQLOLEDB.1;Password=YourPassword;Persist Security Info=True;User ID=YourUserID;_

Initial Catalog=YourDB;Data Source=YOUR_LOCAL_SERVER_NAME

You can now copy and paste the connection string wherever it's required, for example:

<%

Set commInsert = Server.CreateObject("ADODB.Connection")

commInsert.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;_

PersistSecurity Info=False;Initial Catalog=_

YourDB;_Data Source=YOUR_LOCAL_SERVER_NAME

strInsertCommand = "INSERT INTO tableName(TextField, NumericField)_

VALUES('ABCDE', 12345);"

commInsert.Execute(strInsertCommand) ' Execute the insert command

commInsert.Close()

Set commInsert = Nothing

%>

connecting to the remote database

Connecting to a remote SQL Server database is almost identical to connecting to a local database.

Create a .udl (Universal Data Link) file as in the first section, select Microsoft OLE DB Provider for SQL Server from the list and click Next, as before.

The details required to make the connection should be given to you by the host provider or your server administrator. Type in the server name in the text box, number 1, this may be an IP address as shown or a domain address like http//YourServer.com. Next enter the user name and password supplied by the host provider or administrator. Finally select your database on the SQL Server to which you wish to connect.

Open the .udl file with notepad, the connection string will appear similar to this:

[oledb]

; Everything after this line is an OLE DB initstring

Provider=SQLOLEDB.1;Password=YourPassword;Persist Security Info=True;User ID=YourUserID;_

Initial Catalog=YourDB;Data Source=YOUR_REMOTE_SERVER_NAME

What is throw away prototyping?

Throw away prototype is a run-able and deployable prototype for experimental purposes, serves same as a trailer of the movie. Not the Complete Movie.

How many versions are there in oracle?

A prophet is an oracle as is a seer, though a seer is greater than a prophet. Any person blessed with the spirit of God may be given the authority to act in in the calling of an oracle.

Is it easy to store data on a data base?

It depends. What kind and how much data?

You can create a simple database in a program like MS Access or you can create a massively complex database system using databases such as Oracle, DB2 or Teradata.

Since this is such a general question, it sounds like you don't have very complex needs for your data tracking. If you just want to keep track of data as in a list, you can use a spreadsheet program such as MS Excel or the free one offered by Google.

What is the difference between AS levels and A levels?

A levels are generally spread over two years but AS are 3 modules so it is only spread over 1 year... Look here for more info http://www.mumsnet.com/Talk/2405/289261

Difference between super key and composite key?

A Super key and composite key are similar to one another. Both of them are used to uniquely identify a row in a database table.

A super key is a set of columns within a table that can be used to identify a particular row in a table. A super key can be only one column or a combination of multiple columns. If a super key contains multiple columns it becomes a composite key.

What are advantages of part practice?

When all sub-routines are brought together, the whole practice becomes more easier and benificial.

How would you use the four step management approach of diagnosis evaluation design and implementation to improve strategy information management of the bank?

Please refer to book by Steven R. Gordon and Judith R. Gordon titled "Information Systems, a Management Approach" for a comprehensive answer. Please refer to book by Steven R. Gordon and Judith R. Gordon titled "Information Systems, a Management Approach" for a comprehensive answer.

In access how many characters can be in table and field?

A text field can have up to 255 characters Proud to be of service HoloGuides.com

Difference between adodb and adodc?

Very simple difference between adodc and adodb is "C" and "B".. he he he kidding... adodc is a data control and adodb is a class library, adodc good to use but some time it produce error for "multiple operation". With adodb can data bound dynamically, other hand can say if u r making big software so use ADODB and use ADODC is suitable for small projects.