"Sample Questions"
Question : 1
Which three statements are true regarding indexes? (Choose three.)
A.A SELECT statement can access one or more indices without accessing any tables
B.An update to a table can result in no updates to any of the table’s indexes
C.A table belonging to one user can have an index that belongs to a different user
D.A UNIQUE index can be altered to be non-unique
E.An update to a table can result in updates to any or all of the table’s indexes
F.When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
Answer: A,B,F
Question : 2
Which statement is true regarding the default behavior of the ORDER BY clause?
A.In a character sort, the values are case-sensitive.
B.NULLs are not included in the sort operation.
C.Only columns that are specified in the SELECT list can be used in the ORDER BY clause.
D.Numeric values are displayed in descending order if they have decimal positions.
E.Column aliases can be used in the ORDER BY clause.
Answer: A
Question : 3
Which two statements are true about Oracle synonyms?
A.A synonym can have a synonym.
B.All private synonym names must be unique in the database.
C.Any user can create a PUBLIC synonym.
C.A synonym can be created on an object in a package.
D.A synonym has an object number.
Answer: B,D
Question : 4
Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.)
A.WHERE and HAVING clauses cannot be used together in a SQL statement.
B.The HAVING clause conditions can have aggregate functions.
C.The HAVING clause conditions can use aliases for the columns.
D.The WHERE clause is used to exclude rows before the grouping of data.
E.The HAVING clause is used to exclude one or more aggregated results after grouping data.
Answer: B,D,E
Question : 5
Which two statements are true regarding constraints? (Choose two.)
A.All constraints can be defined at the column level and at the table level.
B.A constraint can be disabled even if the constraint column contains data.
C.A column with the UNIQUE constraint can contain NULLs.
D.A foreign key column cannot contain NULLs.
E.A constraint is enforced only for INSERT operations.
Answer: B,C
For More Information:-
Visit Now:-
My happiness for my success in Oracle Database 12c is beyond my expression. 1Z0-071 dumps has made the preparation very easy for candidates of all IT certifications by providing such a reliable material. All the questions have been answered very expertly which deal with all the aspects of the exam topics by field specials who have full knowledge about how exams are arranged. The experts supported and guided me throughout my preparation till final exam. Efforts done by Exam4lead are really appreciate able as it is leading so many candidates towards success.
ReplyDeletehttps://www.exam4lead.com/oracle.html