- Home
- Database
- Oracle 12 C
- OCA Oracle 12 C SQl Fundamentals(1Z0-061)
1.
Look at the diagram. What kind of relationship exists between MOVIES and CHARACTERS?
- A.Each movie may have one or more characters.
- B.Each movie must have one or more characters.
- C.Many movies may have many characters.
- D.One movie can have only one character.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Because the relationship between MOVIES and CHARACTERS is represented through a solid line with a crowfoot at one end, the relationship is mandatory one-tomany, which means each movie must have one or more characters. |
2.
When the physical model is being designed from the logical model, which element may
be attributed as a table from the ER diagram?
- A.Relationship
- B.Attribute
- C.Unique identifier
- D.Entity
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| When the physical structure is being designed, an entity in the ER diagram may be mapped as a table in the database. An attribute may be mapped as a column, a relationship is the referential integrity, and a unique identifier is the primary key. |
3.
Which statement about the object type is true?
- A.They are structures that consist of built-in or user-defined data types.
- B.They are structures that consist of only built-in data types.
- C.They are structures that consist of only user-defined data types.
- D.Only one column in a table can be object type.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| Object type lets you define structures that satisfy the business requirement. It can include built-in and user-defined types. |
4.
Which of the following is not a benefit of Oracle Database 12c?
- A.Manage multiple databases as one
- B.Fast provisioning of cloned databases
- C.Plug and unplug databases
- D.Patch each pluggable database separately
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| Oracle Database 12c has the multitenancy database feature, where multiple databases are plugged in. These pluggable databases share resources such as Oracle home, the memory area, processes, and the disk. Therefore, patching one pluggable database is not possible. Patches are applied to the container database. |
5.
Which one of the following Oracle SQL*Plus command lines is not valid?
- A.sqlplus <username>
- B.sqlplus @<connect_string>
- C.sqlplus <username>@<connect_string>
- D.sqlplus
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| SQL*Plus can be invoked with no parameters or with connection attributes. When connection attributes are provided, the <username> is mandatory. The <password> and <connect_string> commands are optional. When connection attributes are not provided, sqlplus prompts for username and password. If username is included in the command line, sqlplus prompts for password. |
|
|
||||||||||||||||||||||||||||
