GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

DDL

Jerry Reeves Jr 31 questions

Take the quiz

Questions in this quiz (31)

  1. 1Which of the database object is used to improve the performance of queries?
    1. AA. Table
    2. BB. Synonym
    3. CC. View
    4. DD. Index
  2. 2Which of the following special characters cannot be used in table name?
    1. AA. #
    2. BB. @
    3. CC. $
    4. DD. _
  3. 3While creating a table which of the following can be used with the DEFAULT column option?
    1. AA. Strings
    2. BB. SQL functions
    3. CC. Expressions
    4. DD. All of the above
  4. 4 What command is used to view table's structure?
    1. AA. UPDATE
    2. BB. SHOW
    3. CC. SPOOL
    4. DD. DESCRIBE
  5. 5Which of the following statement refers to both table and index?
    1. AA. A table and an index cannot be the same name in a schemA.
    2. BB. A table and an index can have the same name in a schemA.
    3. CC. Neither A nor B
    4. DD. None of the above
  6. 6Which of the following query used to create a table with no rows?
    1. AA. CREATE TABLE stu AS SELECT 0 from students;
    2. BB. CREATE TABLE stu AS SELECT * from students where 1=1;
    3. CC. CREATE TABLE stu AS SELECT * from students where 1=0;
    4. DD. CREATE TABLE stu AS SELECT 0 from students;
  7. 7Which of the following query is used to add a column to an existing table?
    1. AA. ALTER TABLE table_name add column (place varchar2(20));
    2. BB. ALTER TABLE table_name add place varchar2(20);
    3. CC. ALTER TABLE table_name add column (place);
    4. DD. ALTER TABLE table_name add (place varchar2(20));
  8. 8Which of the following is valid query to delete the column from the table ?
    1. AA. ALTER TABLE table_name DROP (place varchar2(20));
    2. BB. ALTER TABLE table table_name DROP COLUMN (place);
    3. CC. ALTER TABLE table table_name DROP COLUMN (place varchar2(20));
    4. DD. ALTER TABLE table_name MODIFY (place varchar2(20));
  9. 9Let us consider the following schema below:

    STUDENTS(sub_code, dep_name, location_id, city);

    Which of the following code snippet will modify the STUDENTS table and add an address column with the data type VARCHAR2(100)?
    1. AA. ALTER TABLE students ADD COLUMN (address varchar2(100));
    2. BB. ALTER TABLE students ADD (address varchar2(100));
    3. CC. MODIFY TABLE students ADD COLUMN (address varchar2(100));
    4. DD. None of the above.
  10. 10Which of the following code snippet will delete a view named marks_maths?
    1. AA. DELETE VIEW marks_maths;
    2. BB. DELETE marks_maths;
    3. CC. DROP VIEW ew marks_maths;
    4. DD. DROP marks_maths;

Information

Description
DDL Interview Questions
Language
English
Views
2
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?