Question 47 1. You issue this statement: SQL> CREATE PUBLIC SYNONYM part FOR lin
ID: 3731067 • Letter: Q
Question
Question 47
1. You issue this statement:
SQL> CREATE PUBLIC SYNONYM part FOR linda.product;
Which task was accomplished by this statement?
A new segment object was created.
A new object privilege was assigned.
A new system privilege was assigned.
The need to qualify an object name with its schema was eliminated.
0.5 points
Question 48
1. Which of the following is not a valid way to avoid search problems when you want to search for rows that have a specific date in a column that’s defined with the DATE data type?
a.
use the TRUNC function to truncate the time values from the date value in the column that you’re searching
b.
search for date values that fall between the day and the day after the date you want
c.
use the TO_DATE function to remove the time values from the dates in each column
Question 50
1. With shadow paging, the commit operation involves all the following EXCEPT
A.
write the log records out to disk
B.
copy the current page table to disk
C.
write modified database buffer pages to disk
D.
make the current page table the new shadow page table
Question 52
1. Which of the following statements about mapping a union in an EE-R diagram to a relational schema is true?
A.
The union can be represented using a single table can be includes all the supersets
Ans. C
B.
A surrogate key is always required
C.
It is not possible to represent a union in a relational schema
D.
The union can be represented as a table, with additional tables for the supersets
Question 56
1.
Which statement about error propagation is true?
a.
An exception can propagate across remote procedure calls.
b.
The RAISE; statement in an exception handler ends the current exception.
c.
An exception raised inside an exception handler will not propagate to the enclosing block.
d.
When an exception is raised in a called procedure, control goes to the exception section of that block.
0.5 points
Question 57
1. Which statements represent benefits of using the EXECUTE IMMEDIATE statement over the DBMS_SQL package?
(Choose all that apply.)
a.
EXECUTE IMMEDIATE is simpler to use.
b.
EXECUTE IMMEDIATE is faster than DBMS_SQL.
c.
Client-side programs support EXECUTE IMMEDIATE .
d.
Unlike DBMS_SQL , EXECUTE IMMEDIATE supports user-defined types.
e.
SQL statements that are larger than 32 KB are supported by EXECUTE IMMEDIATE .
A new segment object was created.
A new object privilege was assigned.
A new system privilege was assigned.
The need to qualify an object name with its schema was eliminated.
Explanation / Answer
47A: The need to qualify an object name with its schema was eliminated. (we can use the table with the part synonym insted full qualified name)
48A: b.search for date values that fall between the day and the day after the date you want.
50A: D.make the current page table the new shadow page table.
52A: A surrogate key is always required (Surrogate is nothing but primary key).
56A: When an exception is raised in a called procedure, control goes to the exception section of that block.
57: (a,b,d)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.