- Home
- Database
- Oracle 12 C
- OCA Oracle 12 C SQl Fundamentals(1Z0-061)
6.
Which database tools are parts of Oracle Database 12c? Choose two.
- A.Oracle Enterprise Manager Cloud Control 12c
- B.Oracle Enterprise Manager Database Express 12c
- C.SQL Developer
- D.TOAD (Tool for Oracle Application Developers)
- Answer & Explanation
- Report
Answer : [B, C]
Explanation :
Explanation :
| Oracle Enterprise Manager Cloud Control is a separate product to manage and administer various Oracle products including the database. TOAD is not an Oracle product. |
7.
In the physical implementation of RDBMS, which database object is used to represent
unique identifiers?
- A.Any constraint
- B.Index
- C.Primary key
- D.Foreign key
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The relationship between the entities is part of one or more constraints between the tables. The unique identifiers of an entity become the primary key of the table. The relationship between tables becomes the foreign key. |
8.
SQL Developer is a tool primarily for whom?
- A.Database administrators
- B.End users
- C.Application developers
- D.All of the above
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| SQL Developer is Oracle’s GUI interface to the database. It has menus and reports for DBAs, developers, and end users. |
9.
Which architecture in the Oracle Database 12c implementation guards against
unplanned machine downtime?
- A.Multitenancy Container Database
- B.Real Application Clusters
- C.Consolidate multiple databases and instances to one server
- D.None of the above
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| In RAC architecture, more than one instance communicates to the database. If an instance on one server fails, the remaining instances in the RAC pool remain active and service users. |
10.
Which connection method to the Oracle database is known as the easy connect?
- A.<username>@<connect_string>
- B.<username>@<host>:<port>/<service_name>
- C.Both A and B
- D.Neither A or B
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Easy connect uses the information provided in the connect string to connect to the database directly, without looking for information in another source. Easy connect uses hostname, port, and the service name to connect to the database. |
|
|
||||||||||||||||||||||||||||
