subject: Pgces-02 Exam Questions [print this page] Our pgces-02 exam questions are given with detailed description which not only help you to pass your pgces-02 exam but also give you an overall industry view, which increases your market presence in terms of deep knowledge and updateability. Testinside is the only sites which provides true and authenticated materials for pgces-02 exam. The pgces-02 exam available on Testinside website is really IT exams, and by downloading its braindumps one can easily pass actual exam as well.
Testinsides pgces-02 Study Materials and pgces-02 Training Tools are prepared by Industry Experts and Professionals who keep an eye on the latest pgces-02 study guide Objectives and change the pgces-02 questions and answers accordingly. You will not only get the top quality pgces-02 Study Materials and Training Tools from Testinside but can be assured of it being up to date as well.
Our Testinside pgces-02 practice test questions are designed by highly experienced and certified trainers that have put together the best pgces-02 exam questions that will keep success on your pgces-02 exam. Please feel free to download our pgces-02 free practice exam. You will notice that our pgces-02 test questions are very well written and is the key in Passing Your pgces-02 exam on your first try, or your money back.and help you to pass the pgces-02 exam!
1. Select two transaction isolation levels supported in PostgreSQL.
A. DIRTY READ
B. READ COMMITTED
C. REPEATABLE READ
D. PHANTOM READ
E. SERIALIZABLE
Answer: BE
2. Select two incorrect statements regarding 'DOMAIN'.
A. When defining a domain, you can add a default value and constraints to the original data.
B. Domain is a namespace existing between databases and objects such as tables.
C. A domain is created by 'CREATE DOMAIN'.
D. A domain can be used as a column type when defining a table.
E. To define a domain, both input and output functions are required.
Answer: BE
3. Select two suitable statements regarding the following SQL statement:
CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW
EXECUTE PROCEDURE write_log();
A. It is defining a trigger "trigger_1".
B. Every time 'UPDATE' is executed on the "sales" table, the "write_log" function is called once.
C. The "write_log" function is called before 'UPDATE' takes place.
D. 'UPDATE' is not executed if "write_log" returns NULL.
E. 'DROP TRIGGER trigger_1 ON sales;' deletes the defined trigger.
Answer: AE
4. Select two suitable statements regarding the data types of PostgreSQL.
A. One field can handle up to 1GB of data.
B. 'n' in CHARACTER(n) represents the number of bytes.
C. Only the INTEGER type can be declared as an array.
D. There is a non-standard PostgreSQL data type, called Geometric data type, which handles 2-dimensional data.
E. A large object data type can be used to store data of unlimited size.
Answer: AD
5. PostgreSQL can use an index to access a table. Select two incorrect statements about indexes.
A. An index is created by 'CREATE INDEX', and deleted by 'DROP INDEX'.
B. By using an index effectively, searching and sorting performs faster.
C. There are B-tree, Hash, R-tree and GiST index types.
D. By creating an index, performance always improves.
E. Creating an unused index does not affect the performance of a database at all.
Answer: DE
The Testinside pgces-02 Practice tests that we can provide are based on the extensive research and real-world experiences from our online trainers, with over 10 years of IT and certification experience. Custom written content for on-the-go professionals such as yourself. pgces-02 exam training, pgces-02 tests,including pgces-02 questions and answers feed into our larger product base. You can also enjoy pgces-02 study Guides, pgces-02 preparation Labs, and the new and improved pgces-02 Audio Exams to pass pgces-02 certification.
