¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Test

DDL

Jerry Reeves Jr 31 preguntas

Hacer el test

Preguntas del test (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;

Información

Descripción
DDL Interview Questions
Idioma
English
Visitas
2
Valoración
Aún sin valoraciones
Valora este test
Valora este test

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?