Sunday, October 17, 2010
Sunday, October 10, 2010
Database Questions Blog Task 1
1. What does a column in a table represent?FIELD
- Field
- Record
2. What does a row in a table represent?RECORD
- Field
- Record
3. What does DBMS stand for? Database Management Systems
4. What is a primary key in a table used for?
It is is a field that uniquely identifies each record. This field can be used to link records across multiple tables.
5. Why is the ID column such a useful field? ID IS KING, “If you know the ID of a record, you can do anything you want with that record”
6. What Access data type would you use to store the string “18 Segway Drive, Moonville” ?TEXT
7. What Access data type would you use to record True/False values?YES/NO
8. What Access data type would you use to store a number?NUMBER
9. What Access data type would you use to store a long string such as an essay or
report?MEMO
report?MEMO
10. A database is a collection of what? RELATED DATA THAT IS STORED IN A STRUCTURED FORMAT
11. A table is made up of what? ROWS AND COLUMNS
12. What is a record? THE ROWS IN A TABLE
A record is a group of related fields containing all of the information about a specific person, place or thing.
13. Are spaces allowed in field names? NO THEY ARE NOT
Monday, October 4, 2010
IO-Input and Output
Stream Reader
Stream Writer
File Object
OutFile = IO.File.AppendText ("x.txt")
Append Text = Open a file for Append so that we can add text to it and this is also a writer
Create Text = This is a writer
Read Line = Will read one line
Peak = Method that peeks inside the files that is associated with the Peek File, if there are no more lines to write the peek function will return a negative one, if there are no more items in the list
Stream Reader
Stream Writer
File Object
OutFile = IO.File.AppendText ("x.txt")
Append Text = Open a file for Append so that we can add text to it and this is also a writer
Create Text = This is a writer
Read Line = Will read one line
Peak = Method that peeks inside the files that is associated with the Peek File, if there are no more lines to write the peek function will return a negative one, if there are no more items in the list
Sunday, October 3, 2010
BLOG TASK 2
Answer the following questions:
1. Which of the following procedures can be used to read information from a sequential access file? ALL OF THEM?
- AppendText
- CreateText
- OpenText
2. Which of the following reads a line of text from the file associated with the inFile variable and assigns the line of text (excluding the newline character) to the msg variable? MY ANSWER: msg = inFile.ReadLine
- msg = inFile.Read
- msg = inFile.ReadLine
- inFile.ReadLine(msg)
3. Write the statement required to close the file associated with the inFile variable.
inFile.Close()
4. If a sequential access file contains another character to read, what does the Peek method return?
The Peek method returns the character
5. If a sequential access file does not contain another character to read, what does the Peek method return?
it will return the number -1 (negative 1)
BLOG TASK 1
Answer the following questions:
1. Which of the following methods can be used to open a sequential access file? ALL OF THE ABOVE
- AppendText
- CreateText
- OpenText
- all of the above
2. Which of the following writes the contents of the favouriteTuneTextBox’s Text property, followed by the newline character, to the sequential access file associated with the outFile variable?
MY ANSWER IS : outFile.Write(favouriteTuneTextBox.Text)
- outFile.Write(favouriteTuneTextBox.Text)
- outFile.WriteLine(favouriteTuneTextBox.Text)
- outFile.WriteNext(favouriteTuneTextBox.Text)
- none of the above
3. What does IO in the syntax stand for?
INPUT OUTPUT!
Subscribe to:
Posts (Atom)