SQL for Database Construction The SQL command to create a table is: MAKE TABLE DEFINE TABLE CREATE TABLE ALTER TABLE MAKE TABLE DEFINE TABLE CREATE TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: SELECT VIEW INSERT VIEW MAKE VIEW CREATE VIEW SELECT VIEW INSERT VIEW MAKE VIEW CREATE VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Common types of SQL CHECK constraints include range checks and limiting columns values. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? The VALUE constraint None of these The LIMIT constraint The CHECK constraint The VALUE constraint None of these The LIMIT constraint The CHECK constraint ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? To save users from having to write an expression. None of these To accomplish both of the above. To ensure that the results are consistent. To save users from having to write an expression. None of these To accomplish both of the above. To ensure that the results are consistent. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a program that performs some common action on database data and that is stored in the database. trigger pseudofile stored procedure None of these trigger pseudofile stored procedure None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS