Similar Collections

    No collections found

questions

Title
In DBMS, table is known as _____ and row is known as _____

In DBMS, table is known as _____ and row is known as _____.

  1. Relation, Tuple
  2. Tuple, Tuple
  3. Tuple, Relation
  4. Relation, Relation
discuss
Select the statement which is TRUE?

Select the statement which is TRUE?

  1. In a table, there could be any number of rows and any number of columns.
  2. In a table, there could be any number of rows and specified number of columns.
  3. In a table, there could be any number of columns and specified number of rows.
  4. In a table, there could be specified number of rows and specified number of columns.
discuss
Select the statement which is TRUE?

Select the statement which is TRUE?

  1. In case a transaction is rolled back, the data allied with table variable also get rolled back.
  2. In case a transaction is rolled back, the data allied with table variable does not roll back.
  3. In case a transaction is not rolled back, the data allied with table variable get rolled back.
  4. None of the above.
discuss
Temporary variables use ____ resources than table variables

Temporary variables use ____ resources than table variables.

  1. More
  2. Less
  3. Equal
  4. None of the above
discuss
Input and output parameters can be derived from table variables

Input and output parameters can be derived from table variables.

  1. True
  2. False
discuss
What is SQL CREATE Table used for?

What is SQL CREATE Table used for?

  1. To Update table
  2. To Create table
  3. To Delete table
  4. None of the above
discuss
For integer value, which data type is supported in Oracle?

For integer value, which data type is supported in Oracle?

  1. INT
  2. Number
  3. Digit
  4. None of the above
discuss
To delete table definition and all data from the table, which statement is used?

To delete table definition and all data from the table, which statement is used?

  1. DELETE
  2. DROP
  3. ALTER
  4. None of the above
discuss
What is the difference between DELETE and TRUNCATE statements?

What is the difference between DELETE and TRUNCATE statements?

  1. DELETE statement free up the space kept in check by the table whereas TRUNCATE statement does not free up the space kept in check by the table.
  2. DELETE statement does not free up the space kept in check by the table whereas TRUNCATE statement free up the space kept in check by the table.
  3. DELETE statement only deletes rows from the table whereas TRUNCATE statement can only delete columns from the table.
  4. DELETE statement only deletes columns from the table whereas TRUNCATE statement can only delete rows from the table.
discuss
When the table is dropped:

When the table is dropped:

  1. Table structure is dropped
  2. Integrity constraints are dropped
  3. Relationship is dropped
  4. All of the above
discuss
When the table is truncated:

When the table is truncated:

  1. Table structure is dropped
  2. Integrity constraints are dropped
  3. Relationship is dropped
  4. None of the above
discuss
In SQL, which statement can help in changing the name of the table?

In SQL, which statement can help in changing the name of the table?

  1. RENAME
  2. ALTER
  3. Both A) and B)
  4. None of the above
discuss
TRUNCATE TABLE requires:

TRUNCATE TABLE requires:

  1. WHERE clause
  2. HAVING clause
  3. Both a and b
  4. None of the above
discuss
Select the correct statement

Select the correct statement.

  1. TRUNCATE TABLE is faster than DELETE TABLE statement.
  2. TRUNCATE TABLE uses fewer resources than DELETE TABLE statement.
  3. Both A) and B)
  4. None of the above
discuss
SELECT INTO statement-

SELECT INTO statement-

  1. Select the content from a table.
  2. Rename the content in a table.
  3. Copy the content from one table into another existing table.
  4. None of the above
discuss
Which of the following statement is TRUE?

Which of the following statement is TRUE?

  1. At run time, temporary tables can be created.
  2. Temporary table can do similar operations to normal table.
  3. Both A) and B)
  4. None of the above
discuss
How many temp tables are there?

How many temp tables are there?

  1. 1
  2. 2
  3. 3
  4. 4
discuss
Which of the following are the types of the temp tables?

Which of the following are the types of the temp tables?

  1. Local Temp
  2. Global Temp
  3. Both A) and B)
  4. None of the above
discuss
Local Temp Variable is used with which sign?

Local Temp Variable is used with which sign?

  1. ?
  2. @
  3. #
  4. &
discuss
Global Temp Variable is used with which sign?

Global Temp Variable is used with which sign?

  1. ###
  2. ####
  3. #
  4. ##
discuss
total MCQs: 20

MCQs

20

Views

81

Best Answers

299

Points

5