ITS Databases Practice Exam #20 - Edubirdie

University:
American Baptist College
Course:
CIT370 | Database Design and Processing
Academic year:

2024
Views:

71

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. Which of the following range conditions would generate a syntax error? A. salary <= 50000 AND salary >= 10000 B. salary between (10000 AND 50000) AND (60000 and 90000) C. salary BETWEEN 10000 AND 50000 D. salary>= 10000 AND salary <= 50000 2. In an RDMS, a group of rows and columns is called a what? A. Variable B. Field C. Table D. Relation 3. Which Transact-SQL command removes all rows from a table without logging the individual row deletions? A. TRUNCATE TABLE B. REMOVE TABLE C. DELETE TABLE D. DROP TABLE 4. What is collation? A. It is a concept in SQL Server by which we can add other SQL Server to a group and query both the SQL Servers dbs using T-SQL statements. B. It refers to a set of rules that determine how data is sorted and compared. C. It means that the data in the db is organized so that all the data elements relating to the same real-world event or object are linked together. D. It is a data design and organization process applied to data structures, based on rules that help build relational databases. 5. Which of the following could not be used as a primary key? A. Social Security Number B. Employee Number C. A table containing only one FOREIGN key D. Serial number for an electronic component

Related Documents

ITS Databases Practice Exam #20

ITS Databases Practice Exam #20 - Page 1

ITS Databases Practice Exam #20 - Page 2

of 2

Recommended Documents

Quiz 1: Fundamental Of Data Visualization - Knowledge And Comprehension

Quiz 1: Fundamental Of Data Visualization - Knowledge And Comprehension

American Baptist College CIT370 | Database Design and Processing

Assignment

Quiz 3: Fundamental Of Data Visualization - Synthesis And Creation

Quiz 3: Fundamental Of Data Visualization - Synthesis And Creation

American Baptist College CIT370 | Database Design and Processing

Assignment

Quiz 4: Fundamental Of Data Visualization - Evaluation And Reflection

Quiz 4: Fundamental Of Data Visualization - Evaluation And Reflection

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam 18

Data Analytics Practice Exam 18

American Baptist College CIT370 | Database Design and Processing

Answer Key

Quiz 5: Fundamental Of Data Visualization - Application To Real-World Scenarios

Quiz 5: Fundamental Of Data Visualization - Application To Real-World Scenarios

American Baptist College CIT370 | Database Design and Processing

Assignment

Quiz 8 : Fundamental Of Data Visualization – Effectiveness Of Chart Usage

Quiz 8 : Fundamental Of Data Visualization – Effectiveness Of Chart Usage

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #12

ITS Databases Practice Exam #12

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #5

Data Analytics Practice Exam #5

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #16

Data Analytics Practice Exam #16

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam

ITS Databases Practice Exam

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #2

ITS Databases Practice Exam #2

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #10

ITS Databases Practice Exam #10

American Baptist College CIT370 | Database Design and Processing

Assignment

New Documents from this Course

ITS Databases Practice Exam #5

ITS Databases Practice Exam #5

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #13

Data Analytics Practice Exam #13

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #17

Data Analytics Practice Exam #17

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #14

Data Analytics Practice Exam #14

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #12

Data Analytics Practice Exam #12

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #9

Data Analytics Practice Exam #9

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #6

Data Analytics Practice Exam #6

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #2

Data Analytics Practice Exam #2

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #10

Data Analytics Practice Exam #10

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #3

Data Analytics Practice Exam #3

American Baptist College CIT370 | Database Design and Processing

Assignment

Storytelling With Data

Storytelling With Data

American Baptist College CIT370 | Database Design and Processing

Lecture Note