Aguien me puede ayudar con estas preguntas? Gracias
Publicado por Omar (1 intervención) el 15/11/2016 01:06:55
1. SQL is an acronym that stands for which of the following terms? (A) Simple Query Language
(B) Standard Question Language
(C) SearchQuestionLanguage
(D) Structured Query Language
2. Which of the following statements BEST describes the purpose of a “primary key” field within a relational database table? (A) A primary key is used to identify the types of data stored within the fields of the table. (B) A primary key is used to ensure that every field within a table has a unique field name. (C) A primary key is used to uniquely identify every record within a table. (D) A primary key is used to duplicate records within a table to prevent data loss.
3. The values contained within a “foreign key” field in a relational database table must ALWAYS be unique values for every record. (A) True (B) False
4. Which of the following terms is the term used to describe a row of data within a table in a relational database? (A) Field (B) Record (C) Query (D) Report
5. The first normal form requires atomic, or unique, values at each column and row intersection in the entity table. There should be no repeating groups. Thus, no “Item1,” “Item2” column design like you may see in a ‘flat-file’ table layout. (A) True (B) False
CHAPTER 2
1. Which of the following terms is the SQL statement used to create tables within a relational database? (A) MAKE TABLE (B) CREATE TABLE (C) CONSTRUCTTABLE (D) GENERATE TABLE
2. Which of the following choices is the name of a commonly used SQL constraint? (A) NULL ALLOWED (B) ORDER DESC (C) NOT NULL (D) TEXT ONLY
3. If available for your RDBMS, the TRUNCATE TABLE command in SQL will delete and then re-create an existing table within a relational database. (A) True (B) False
4. Which of the following terms is the SQL statement used to modify the structure of an existing table within a relational database? (A) ALTER TABLE (B) EDITTABLE (C) MODIFY TABLE (D) CHANGE TABLE
5. Which of the following terms is used to describe an unknown value within a field in a database table that occurs when a user who is performing data entry skips entering a value into the field? (A) Spacebar Value (B) Empty String Value (C) Zero Value (D) NULL Value
CHAPTER 3
1. Which of the following terms is the SQL statement used to add new records to a table within a relational database? (A) NEW (B) UPDATE (C) ADD (D) INSERT
2. Which of the following terms is the SQL statement used to edit existing values in a table within a relational database? (A) UPDATE (B) EDIT (C) INSERT (D) ALTER
3. Within the SELECT statement in SQL, which of the following terms is a clause used to determine which records are selected from the table or tables? (A) ORDER BY (B) GROUP BY (C) WHERE (D) UNION
4. The INSERT INTO SELECT statement in SQL is used to copy the result set of a SELECT statement into a new table that is created by the INSERT INTO SELECT statement. (A) True (B) False
5. Which of the following punctuation characters is used as a wildcard character within SQL to denote multiple, unknown values within a character or text string? (A) ! (B) = (C) > (D) %
6. Which of the following types of joins is used to create a result set that displays records that contain a matching value in the PRIMARY KEY and FOREIGN KEY columns between two tables and NOT display records that do NOT have a matching value within both of these same two columns? (A) RIGHT JOIN (B) LEFT JOIN (C) INNER JOIN (D) FULL JOIN
CHAPTER 4
1. The CREATE USER statement in SQL is technically classified as belonging to which of the following types of SQL statements? (A) Data Definition Language (DDL) (B) Data Manipulation Language (DML) (C) Data Control Language (DCL) (D) Transaction Control Language (TCL)
2. Which of the following terms is the SQL statement used to assign privileges to users within a relational database? (A) INSERT (B) ALTER (C) DROP (D) GRANT
3. The REVOKE statement in SQL is technically classified as belonging to which of the following types of SQL statements? (A) Data Definition Language (DDL) (B) Data Manipulation Language (DML) (C) Data Control Language (DCL) (D) Transaction Control Language (TCL)
4. Which of the following terms is the SQL statement used to delete users from a relational database? (A) ALTER USER (B) DROP USER (C) DELETEUSER (D) REMOVE USER
CHAPTER 5
1. The TRANSACTION statement in SQL is used to encapsulate a set of Data Manipulation Language (DML) statements so that either all of the changes made by the DML statements within the transaction are committed to the database or none of them are? (A) True
(B) False
CHAPTER 6
1. In SQL, an aggregate function is performed upon a single value and returns a single value. (A) True (B) False
2. Which of the following terms is the SQL keyword used to apply an alias to a field or a table? (A) ALIAS (B) AKA (C) ALT (D) AS
CHAPTER 7
1. In SQL, a view is a virtual table that is based on the results of a SELECT statement. (A) True (B) False
2. The CREATE VIEW, ALTER VIEW, and DROP VIEW statements in SQL are technically classified as belonging to which of the following types of SQL statements? (A) Transaction Control Language (TCL) (B) Data Control Language (DCL) (C) DataDefinitionLanguage(DDL) (D) Data Manipulation Language (DML)
2. Which of the following statements BEST describes the purpose of a “primary key” field within a relational database table? (A) A primary key is used to identify the types of data stored within the fields of the table. (B) A primary key is used to ensure that every field within a table has a unique field name. (C) A primary key is used to uniquely identify every record within a table. (D) A primary key is used to duplicate records within a table to prevent data loss.
3. The values contained within a “foreign key” field in a relational database table must ALWAYS be unique values for every record. (A) True (B) False
4. Which of the following terms is the term used to describe a row of data within a table in a relational database? (A) Field (B) Record (C) Query (D) Report
5. The first normal form requires atomic, or unique, values at each column and row intersection in the entity table. There should be no repeating groups. Thus, no “Item1,” “Item2” column design like you may see in a ‘flat-file’ table layout. (A) True (B) False
CHAPTER 2
1. Which of the following terms is the SQL statement used to create tables within a relational database? (A) MAKE TABLE (B) CREATE TABLE (C) CONSTRUCTTABLE (D) GENERATE TABLE
2. Which of the following choices is the name of a commonly used SQL constraint? (A) NULL ALLOWED (B) ORDER DESC (C) NOT NULL (D) TEXT ONLY
3. If available for your RDBMS, the TRUNCATE TABLE command in SQL will delete and then re-create an existing table within a relational database. (A) True (B) False
4. Which of the following terms is the SQL statement used to modify the structure of an existing table within a relational database? (A) ALTER TABLE (B) EDITTABLE (C) MODIFY TABLE (D) CHANGE TABLE
5. Which of the following terms is used to describe an unknown value within a field in a database table that occurs when a user who is performing data entry skips entering a value into the field? (A) Spacebar Value (B) Empty String Value (C) Zero Value (D) NULL Value
CHAPTER 3
1. Which of the following terms is the SQL statement used to add new records to a table within a relational database? (A) NEW (B) UPDATE (C) ADD (D) INSERT
2. Which of the following terms is the SQL statement used to edit existing values in a table within a relational database? (A) UPDATE (B) EDIT (C) INSERT (D) ALTER
3. Within the SELECT statement in SQL, which of the following terms is a clause used to determine which records are selected from the table or tables? (A) ORDER BY (B) GROUP BY (C) WHERE (D) UNION
4. The INSERT INTO SELECT statement in SQL is used to copy the result set of a SELECT statement into a new table that is created by the INSERT INTO SELECT statement. (A) True (B) False
5. Which of the following punctuation characters is used as a wildcard character within SQL to denote multiple, unknown values within a character or text string? (A) ! (B) = (C) > (D) %
6. Which of the following types of joins is used to create a result set that displays records that contain a matching value in the PRIMARY KEY and FOREIGN KEY columns between two tables and NOT display records that do NOT have a matching value within both of these same two columns? (A) RIGHT JOIN (B) LEFT JOIN (C) INNER JOIN (D) FULL JOIN
CHAPTER 4
1. The CREATE USER statement in SQL is technically classified as belonging to which of the following types of SQL statements? (A) Data Definition Language (DDL) (B) Data Manipulation Language (DML) (C) Data Control Language (DCL) (D) Transaction Control Language (TCL)
2. Which of the following terms is the SQL statement used to assign privileges to users within a relational database? (A) INSERT (B) ALTER (C) DROP (D) GRANT
3. The REVOKE statement in SQL is technically classified as belonging to which of the following types of SQL statements? (A) Data Definition Language (DDL) (B) Data Manipulation Language (DML) (C) Data Control Language (DCL) (D) Transaction Control Language (TCL)
4. Which of the following terms is the SQL statement used to delete users from a relational database? (A) ALTER USER (B) DROP USER (C) DELETEUSER (D) REMOVE USER
CHAPTER 5
1. The TRANSACTION statement in SQL is used to encapsulate a set of Data Manipulation Language (DML) statements so that either all of the changes made by the DML statements within the transaction are committed to the database or none of them are? (A) True
(B) False
CHAPTER 6
1. In SQL, an aggregate function is performed upon a single value and returns a single value. (A) True (B) False
2. Which of the following terms is the SQL keyword used to apply an alias to a field or a table? (A) ALIAS (B) AKA (C) ALT (D) AS
CHAPTER 7
1. In SQL, a view is a virtual table that is based on the results of a SELECT statement. (A) True (B) False
2. The CREATE VIEW, ALTER VIEW, and DROP VIEW statements in SQL are technically classified as belonging to which of the following types of SQL statements? (A) Transaction Control Language (TCL) (B) Data Control Language (DCL) (C) DataDefinitionLanguage(DDL) (D) Data Manipulation Language (DML)
Valora esta pregunta
0
