QUESTION 1

You executed the following statement: "CREATE TABLE NEW_EMP AS SELECT * FROM EMPLOYEES." Which dependent objects of the EMPLOYEES table are copied to the new table?

	a.	All indexes.
	b.	All NOT NULL constraints.
	c.	All constraints.
	d.	All indexes, constraints, and triggers.

10 points

QUESTION 2

What is wrong with the following SQL? CREATE TABLE XXTAB (A CHAR, B VARCHAR2, C NUMBER, D DATE)

	a.	Column names must be more than 1 character.
	b.	All data types should specify length.
	c.	No error in the SQL.
	d.	There is error in SQL, but the error is not option A or B.

10 points

QUESTION 3

Which special characters are allowed in column names?

	a.	$, _, #
	b.	_, -, *
	c.	$, -, !
	d.	#, _, -

10 points

QUESTION 4

True or False: The following SQL Statement errors out? CREATE TABLE XX (A1 NUMBER, 2B CHAR)

True

False

10 points

QUESTION 5

Which statement is used to remove a column from a table?

	a.	DROP COLUMN.
	b.	ALTER TABLE.
	c.	DROP TABLE.
	d.	None of the above.

10 points

QUESTION 6

True or False: It is possible to truncate a read-only table.

True

False

10 points

QUESTION 7

Choose the best option.

	a.	A table cannot have more than one LONG datatype column.
	b.	A table cannot have more than one BLOB/CLOB datatype column.
	c.	A table cannot have a LONG column and a BLOB/CLOB column.
	d.	Options A and C are true.

10 points

QUESTION 8

When creating temporary tables, which clause must be specified so that rows are deleted when transaction ends?

	a.	ON COMMIT.
	b.	ON ROLLBACK.
	c.	No clause needs to be specified.
	d.	No option available to preserve rows in a temp table.

10 points

QUESTION 9

True or False: You can specify the position of the column when new columns are added to an existing table.

True

False

10 points

QUESTION 10

Choose the correct statements.

	a.	If you specify a DEFAULT value for a newly added column, all the rows in the table will have the default value automatically assigned.
	b.	When modifying column properties, if you omit any of the parts of the column definition (datatype, default value, or column constraint), the omitted parts remain unchanged.
	c.	When a table is dropped, indexes, constraints, triggers, and privileges on the table are also dropped.
	d.	All the above.

10 points

Click Save and Submit to save and submit. Click Save All Answers to save all answers.