Which two statements are true regarding tables? (Choose two.)
A.
A column that has a DEFAULT value cannot store null values.
B.
The same table name can be used in different schemas in the same database.
C.
A table and a view can have the same name in the same schema.
D.
A table can have any number of columns.
E.
A table name can be of any length.
F.
A table and a synonym can have the same name in the same schema.
In my opinion; A, B are correct answers.
Only correct answer here is B.
A is wrong as a column with a default value can still have a null value. To prevent a null value it must have a not null constraint.
F is wrong because a table and a synonym share the same namespace.
I think B is the only correct option
Cleared Oracle Database 11g 1Z0-051 exam last weekend!
Scored 90%! (The passing score is 60%)
There were 64 questions in my actual 1Z0-051 test.
Many questions on SQL statements (Examine, Evaluate…etc.), Manipulating Data (Insert, Update, Delete), Using DDL Statements to Create and Manage Tables.
Also, please pay close attention to questions on Reporting Aggregated Data Using the Group Functions, Using Subqueries to Solve Queries, Creating Schema Objects, a little difficult!
I mainly learned the PassLeader 1Z0-051 dumps (http://www.passleader.com/1z0-051.html) (303q VCE and PDF), all questions were from it, and many wrong answers have been corrected in it, the most valid 1Z0-051 dumps! DO RECOMMEND!!
By the way, part of that 303q 1Z0-051 dumps are available here:
http://www.oraclebraindump.com/?s=1z0-051
(
p.s. More 1Z0-051 exam questions on Google Drive: drive.google.com/open?id=0B-ob6L_QjGLpWXpBUEhyRnVXVlE
)
Good Luck!!!