• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 2 fuera de 11 páginas
Examen

SQL for Database Construction and Application Processing (7)

Document preview thumbnail
Vista previa 2 fuera de 11 páginas

SQL for Database Construction and Application Processing (7)

Vista previa del contenido

SQL for Database Construction and Application Processing (7)


1. The SQL CREATE TABLE statement is used to name a new table and de- scribe the table's columns.:
True
2. The SQL keyword CONSTRAINT is used to define one of several types of constraints.: True
3. The SQL keyword PRIMARY KEY is used to designate the column(s) that are the primary key for the table.:
True
4. The SQL keyword CONSTRAINT is used to limit the column values to specific values.: True
5. The SQL keyword CONSTRAINT can be used in conjunction with the SQL keywords PRIMARY KEY and
FOREIGN KEY.: True
6. One advantage of using the CONSTRAINT command to define a primary key is that the database designer
controls the name of the constraint.: True
7. The SQL keyword UNIQUE is used to define alternate keys.: True
8. If the table PRODUCT has a column PRICE, and PRICE has the data type Numeric (8,2), the value 98765
stored in that field will be displayed by the DBMS as 98765.00: False
9. If the table ITEM has a column WEIGHT, and WEIGHT has the data type Numeric (4,2), the value 4321
will be displayed by the DBMS as 43.21: True
10.The SQL keyword CHECK is used to limit the column values to specific values.: True
11.The SQL keyword MODIFY is used to change the structure, properties, and constraints of a table.: False
12.Data values to be added to a table are specified by using the SQL VALUES clause.: True
13.The SQL keyword DELETE is used to delete a table's structure.: False
14.When the correct SQL command is used to delete a table's structure, the command can only be used
with a table that has already had its data removed.: False
15.One or more rows can be added to a table by using the SQL INSERT statement.: True
16.Unless it is being used to copy data from one table to another, the SQL INSERT statement can be used to
insert only a single row into a table.: True
17.Rows in a table can be changed by using the SQL UPDATE statement.: True
18.The SQL SET keyword is used to specify a new value when changing a column value.: True
19.The SQL keyword MODIFY is used to change a column value.: False
20.Rows can be removed from a table by using the SQL DELETE statement.-
: True
21.An SQL virtual table is called a view.: True






, SQL for Database Construction and Application Processing (7)


22.The SQL command CREATE USER VIEW is used to create a virtual table.-
: False
23.SQL views are constructed from SELECT statements.: True
24.According to the SQL-92 standard, statements used to construct views cannot contain the WHERE
clause.: False
25.The SQL command SELECT is used to retrieve view instances.: True
26.The values in an SQL view are not always changeable through the view itself.: True
27.SQL view can be used to hide columns.: True
28.SQL views can be used to provide a level of insulation between data processed by applications and the
data actually stored in the database ta- bles.: True
29.If the values in an SQL view are changeable through the view itself, the SQL command UPDATE is used to
change the values.: True
30.The values in an SQL view are always changeable through the view itself.-
: False
31.SQL views are updatable when the view is based on a single table with no computed columns, and all non-
null columns are present in the view.: True
32.Because SQL statements are table-oriented, whereas programs are vari- able-oriented, the results of SQL
statements used in programs are treated as pseudofiles.: True
33.A set of SQL statements stored in an application written in a standard programming language is called
embedded SQL: True
34.Because SQL statements are table-oriented, whereas programs are vari- able-oriented, the results of SQL
statements used in programs are accessed using an SQL cursor.: True
35.A stored program that is attached to a table or view is called a stored procedure.: False
36.SQL triggers use the ANSI SQL keywords BEFORE, INSTEAD OF, and AFTER.: True
37.SQL triggers can be used with SQL operations INSERT, UPDATE, and DELETE.: True
38.SQL triggers can be used when the DBMS receives an INSERT request.: -
True
39.SQL triggers are used for providing default values, validity checking, up- dating views, and performing
referential integrity actions.: True
40.The Oracle DBMS supports the SQL BEFORE trigger.: True
41.The SQL Server DBMS supports the SQL BEFORE trigger.: False

Información del documento

Subido en
11 de diciembre de 2024
Número de páginas
11
Escrito en
2024/2025
Tipo
Examen
Contiene
Preguntas y respuestas
$9.49

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
smartchoices
4.8
(9)
Vendido
39
Seguidores
5
Artículos
4500
Última venta
1 mes hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes