1Z0-514 試験問題を無料オンラインアクセス

Which two statements are true regarding indexes? (Choose two.)

• A.Indexes are implicitly created by the PRIMARY KEY and UNIQUE constrains.
• B.column can have multiple indexes created on it.
• C.An index can be created on one or more columns.
• D.Index must be created in the same tablespace as the table.

Listed below are the database resident program units and their descriptions in random order.
1.Package a. stored subprogram that is associated with a database table, view or event
2.Procedure b. stand alone program that must return a value
3.Functionc. structure that contains program definitions and PL/SQL code
4.Trigged. stand-alone program that may or may not return a value
Which option specifies the correct definition for each program unit?

• A.l-a, 2-b, 3-d, 4-c
• B.l-a, 2-d, 3-b, 4-c
• C.l-c, 2 b, 3-d, 4-a
• D.1-c, 2-d, 3-b, 4-a

Which two statements are true regarding consistent backups? (Chooser two)

• A.Database can be opened immediately after the restore operation.
• B.Consistent backups can be taken only when the instance is shut clown and the database is closed.
• C.Consistent backups can be taken only when the instance is running and the database is closed.
• D.Database can be opened only after the restore and recovery operations.
• E.Consistent backup are taken before the changes in the online redo log files haw been applied to the data files.

There are two listeners, LISTENER1 and LISTENER2, and one service name ORCL available for your database.The database is running and currently only LISTENERI has been started. You issue the following command:
$lsnrctl start listener2
What would be the outcome?

• A.It would give an error because multiple listeners can run simultaneously only if there are multiple net service names.
• B.It would start the second listener and terminate all the current sessions.
• C.It would start the second listener without affecting the current sessions.
• D.It would give an error because multiple listeners cannot run simultaneously.

Which two statements correctly differentiate undo and redo data? (Choose two.)

• A.Undo reverses a change, whereas redo re-creates a change.
• B.Undo protects against inconsistent reads, whereas redo protects against data loss.
• C.Redo protects against inconsistent reads, whereas undo protects against data loss.
• D.Redo reverses a change, whereas undo re-creates a change.