SQL preguntas y respuestas de entrevista
Test your skills through the online practice test: SQL Quiz Online Practice Test
Pregunta 76. Why does the following command give a compilation error?
DROP TABLE &TABLE_NAME; Variable names should start with an alphabet. Here the table name starts with an '&' symbol.
Es util?
Agregar comentario
Ver comentarios
Pregunta 77. Which system tables contain information on privileges granted and privileges obtained?
USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD
Es util?
Agregar comentario
Ver comentarios
Pregunta 78. Which system table contains information on constraints on all the tables created?
USER_CONSTRAINTS.
Es util?
Agregar comentario
Ver comentarios
Pregunta 79. What is the difference between TRUNCATE and DELETE commands?
TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server.
DELETE is a DML command and can be rolled back.
Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster.
Es util?
Agregar comentario
Ver comentarios
Pregunta 80. State true or false. !=, <>, ^= all denote the same operation?
True.
Es util?
Agregar comentario
Ver comentarios
Lo mas util segun los usuarios: