| |||||
|
We have a table with a CHARACTER data type field More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...) We have a table with a CHARACTER data type field
Q: We have a table with a CHARACTER data type field. We apply a ">" row comparison between this field and another CHARACTER field in another table. What will be the results for records with field value of NULL ? (Check one that applies the best )
Any database needs to go through a nprmalization process to make sure that data is represented only once ...
Q: Any database needs to go through a nprmalization process to make sure that data is represented only once. This will eliminate problems with creating or destroying data in the database. The normalization process is done usually in three steps which results in first, second and third normal forms. Which best describes the process to obtain the third normal form ? (Check one that applies the best)
SQL can be embeded in a host program that uses a relational database as a persistent data repository...
Q: SQL can be embeded in a host program that uses a relational database as a persistent data repository. Some of the most important pre-defined structures for this mechanism are SQLDA ("SQL Descriptor Area") and SQLCA ("SQL Communications Area") SQLCA contains two structures - SQLCODE and SQLSTATE. SQLSTATE is a standard set of error messages and warnings in which the first two characters defines the class and the last three defines the subclass of the error. Which of the following SQLSTATE codes is interpreted as "No data returned"? (Chech one that applies the best) What are common SQL abend codes ?
Q: What are common SQL abend codes ? (e.g. : 0, 100 etc..,)
What is meant by dynamic SQL ?
Dynamic SQL are SQL statements that are prepared and executed within a program while the program is executing. What is meant by embedded SQL ? They are SQL statements that are embedded with in application program and are prepared during the program preparation process before the program is executed. After it is prepared, the statement itself does not change ( although values of host variables specified within the statement might change ). break_What is meant by entity integrity ? Entity integrity is when the primary key is in fact unique and not null. break_What will EXPLAIN do? EXPLAIN obtains information (which indexes are used, whether sorting is necessary, which level of locking is applied ) about how SQL statements in the DBRM will be executed, inserting this information into the "X", PLAN.TABLE where the "X" is the authorization ID of the owner of the plan. break_What is the foreign key? A foreign key is a column (or combination of columns) in a table whose values are required to match those of the primary key in some other table. break_What will GRANT option do? It will grant privileges to a list of one or more users. If the GRANT option is used in conjunction with the "PUBLIC" option. then all users will be granted privileges. Also you can grant privileges by objects and types. (Continued on next question...)
Other Job Interview Questions
|
||||