Category «1Z0-047»

Which three statements are true?

Which three statements are true? (Choose three.) A.Only one LONG column can be used per table. B.A TIMESTAMP data type column stores only time values with fractional seconds. C.The BLOB data type column is used to store binary data in an operating system file. D.The minimum column width that can be specified for a varchar2 …

Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement?

Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.) A.The HAVING clause conditions can have aggregate functions. B.The HAVING clause conditions can use aliases for the columns. C.WHERE and HAVING clauses cannot be used together in a SQL statement. D.The WHERE clause is used to exclude rows …

Which two statements are true regarding constraints?

Which two statements are true regarding constraints? (Choose two.) A.A foreign key cannot contain NULL values. B.A column with the UNIQUE constraint can contain NULL. C.A constraint is enforced only for the INSERT operation on a table. D.A constraint can be disabled even if the constraint column contains data. E.All the constraints can be defined …

Which statement correctly differentiates a system privilege from an object privilege?

Which statement correctly differentiates a system privilege from an object privilege? A.System privileges can be granted only by the DBA whereas object privileges can be granted by DBAs or the owner of the object. B.System privileges give the rights to only create user schemas whereas object privileges give rights to manipulate objects in a schema. …