| Home | Previous Lesson: Summary Next Lesson: Exercises |
What is a Primary Key?
The column or columns whose value uniquely identify a row in a table.
What is a Foreign Key?
A key column in a table that logically depends on a primary key column of another table. The column (or combination of columns) whose values are required to match a primary key in some other table is called a Foreign Key.
What is the character you use to terminate the SQL statement in the database administration painter?
semicolon.
What is a View?
An alternate way of looking at the data in one or more tables. Usually created as a subset of columns and/or rows from one or more tables.
What are PowerBuilder extended attributes?
PowerBuilder extended attributes are column attributes that are used in a PowerBuilder application. These include comments, display/edit styles, client side validation rules, labels/headings, font information, etc..
What is a validation rule?
A validation rule allows you to specify the values allowed in a column.
What is the difference between the server-side validation and the client-side validation rules?
When a validation rule is specified in the database server, database server always validates the data irrespective of the client that is trying to manipulate the data. On the other hand, defining a validation rule by a client will result in data validation only the client such as PowerBuilder that has defined the rule.
Does PowerBuilder allow writing of stored procedures in the Database Administration Painter?
Yes, you can write Stored Procedures in the database administration painter and execute them. You can also see the source code for the existing stored procedure from this painter and past it in the script painter if needed.
Can you execute multiple SQL statements including variable declarations from the Database Administration Painter?
You can execute multiple SQL statements from the database administration painter. However you can declare variables only while writing stored procedures.
Write the definition for a display format style that displays value in Red color.
You can use [RED] keyword before the format.
To restrict the number of characters that a user can enter, which method do you choose? Edit style or Validation rule and why?
You can restrict the number of characters in the "Edit" edit style. However, you can't do that with other edit styles. With a validation rule, you can validate irrespective of the edit style.
What is ODBC?
Open Database Connectivity. Microsoft provides ODBC API. A vendor can write an ODBC driver for any database, using the ODBC API. There are different sets of ODBC API for application developers who want to make use of the ODBC driver to access the database.
How is ODBC driver different from ODBC Driver Manager?
ODBC driver is the DLL, which really does the dog, work. ODBC Driver Manager decides which ODBC driver to load depending on the details provided in the ODBC.ini file located under the Window directory. ODBC Driver Manager makes the database connectivity transparent to the application.
List the .INI files PowerBuilder creates at the time of PowerBuilder installation.
pb.ini, pbodb070.ini and optionally pblab050.ini
Who creates and manages ODBC.INI and ODBCINST.INI files?
ODBC.ini and ODBCINST.ini files are created by the operating system, i.e. Windows, NT/95. Whenever the drivers are added or removed through the ODBC option in the control panel, operating system changes the ODBCINST.ini file. Applications such as PowerBuilder change the ODBC.ini file whenever a database profile is created.
How does PowerBuilder/ODBC Driver Manager locate SQL Server Network address?
PowerBuilder/ODBC driver manager reads either win.ini or NT/95 registry to find the network address of the specified SQL server address. Sybase SQL Server needs sql.ini file or should be in the registry.
What is a database profile and who uses that profile?
A database profile consists of information required by a PowerBuilder application to access the database. PowerBuilder uses database profile files to connect to the database instead of prompting every time when connecting to the database.
Describe the structure of any .INI file under windows environment.
Any .ini file is divided into sections. Each section occupies a line by itself and the section name is enclosed in a square bracket. Each line below the section name consists of a variable and its value separated by a =.
How ODBC driver manager decides which ODBC driver to load?
ODBC driver manager reads information from the ODBC.ini file and decides which ODBC driver to load.
| Home | Previous Lesson: Summary Next Lesson: Exercises |