thangtam
10-06-07, 12:53 AM
. The _____ background process is primarily responsible for writing information to the Oracle Database 10g files.
2. How many online redo log groups are required to start an Oracle Database 10g?
A. 3
B. 2
C. 4
D. 1
3. Of the following four items of information, which one is not stored in Oracle Database 10g's control files?
A. The name of the database files
B. The creator of the database
C. The location of the database files
D. The sizes of the database files
4. What is the function of a default temporary tablespace in the support of the Oracle Database 10g?
5. Differentiate between an Oracle Database 10g and instance.
6. Activities such as allocating space in the database and user management are commonly performed by the DBA. What feature in the Oracle Database 10g allows some of these secure operations to be carried out by non-DBA users? How are these rights given out?
7. As a user of the Oracle Database 10g is created, we often specify a default tablespace. In this context, default tablespace means?
A. The system tablespace
B. A tablespace the user can occupy space in without a private or public synonym
C. The tablespace within which objects are created if a location (tablespace) is not explicitly mentioned as a table is created
8. The ________ GUI interface is used to create a new database.
9. What happens when one tries to store the text ''Madagascar" in a field with a specification of varchar2(8)?
10. What is the most common way one uses triggers in the Oracle Database 10g? Give an example of this activity.
11. What programming language, native to the Oracle Database 10g, is used to create stored objects such as triggers and functions?
A. SQL*Plus
B. OEM Grid Control
C. Basic
D. PL/SQL
12. What is the role of the sysaux tablespace in the Oracle Database 10g?
13. The clob and blob data types differ in all but one of the following three ways. Which one does not apply to the differences between the two data types?
A. The clob holds standard alphanumeric data, whereas the blob may store binary information.
B. The blob contains a time (hour/minute) component, but the clob does not.
C. The blob contains unstructured free-form data, whereas the rules governing the type of information that can be stored in the clob are more stringent.
14. There are many ways to replicate data from one node to another. What main feature does Oracle Streams provide that is missing from many other methods?
15. What does the acronym SQL stand for?
A. Structured Query Language
B. Simple Query Language
C. Straightforward Question-based Learning
Đề nghị mọi người hãy cho kết quả của các câu hỏi trên nhé, sau khi đã đọc những tài liệu đã được post lên.
2. How many online redo log groups are required to start an Oracle Database 10g?
A. 3
B. 2
C. 4
D. 1
3. Of the following four items of information, which one is not stored in Oracle Database 10g's control files?
A. The name of the database files
B. The creator of the database
C. The location of the database files
D. The sizes of the database files
4. What is the function of a default temporary tablespace in the support of the Oracle Database 10g?
5. Differentiate between an Oracle Database 10g and instance.
6. Activities such as allocating space in the database and user management are commonly performed by the DBA. What feature in the Oracle Database 10g allows some of these secure operations to be carried out by non-DBA users? How are these rights given out?
7. As a user of the Oracle Database 10g is created, we often specify a default tablespace. In this context, default tablespace means?
A. The system tablespace
B. A tablespace the user can occupy space in without a private or public synonym
C. The tablespace within which objects are created if a location (tablespace) is not explicitly mentioned as a table is created
8. The ________ GUI interface is used to create a new database.
9. What happens when one tries to store the text ''Madagascar" in a field with a specification of varchar2(8)?
10. What is the most common way one uses triggers in the Oracle Database 10g? Give an example of this activity.
11. What programming language, native to the Oracle Database 10g, is used to create stored objects such as triggers and functions?
A. SQL*Plus
B. OEM Grid Control
C. Basic
D. PL/SQL
12. What is the role of the sysaux tablespace in the Oracle Database 10g?
13. The clob and blob data types differ in all but one of the following three ways. Which one does not apply to the differences between the two data types?
A. The clob holds standard alphanumeric data, whereas the blob may store binary information.
B. The blob contains a time (hour/minute) component, but the clob does not.
C. The blob contains unstructured free-form data, whereas the rules governing the type of information that can be stored in the clob are more stringent.
14. There are many ways to replicate data from one node to another. What main feature does Oracle Streams provide that is missing from many other methods?
15. What does the acronym SQL stand for?
A. Structured Query Language
B. Simple Query Language
C. Straightforward Question-based Learning
Đề nghị mọi người hãy cho kết quả của các câu hỏi trên nhé, sau khi đã đọc những tài liệu đã được post lên.