Truncate table - Study guides, Class notes & Summaries

C170 - PRE-ASSESSMENT QUESTIONS AND ANSWERS GRADED A+ A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? One-to-one One-to-many Many-to-many One-to-one binary Many-to-many Which two examples are attributes? Choose 2 answers A person attending a meeting An employee number A sales meeting A meeting code An employee number A meeting code Brainpower Rea...

Create Database Syntax ans: CREATE DATABASE db_name; Simple SFW query syntax ans: SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? ans: Outside Modality: Inside or outside? ans: Inside What commands are used with data definition? ans: create, alter, drop, truncate, comment, rename What commands are used with data manipulation? ans: Select, Insert, Update, Delete, Merge, Call, Explain Plan, Lock Table Create Table Syntax ans: CREATE TABLE table_name

The relationship (within the relation) that describes how the value of one attribute may be used to find the value of another attribute. Functional Dependency An attribute that can be used to find the value of another attribute in the relation. Determinant Value can be used to find the value of every other non-key attribute in the table. Unique and minimal. Candidate Key Define & manage database structures DDL Adding, deleting, and modifying data - Manipulates data stored in a database...

All SQL Sub Languages. correct answers DDL: Data Definition Language DML: Data Manipulation Language DCL: Data Control Language TCL: Transaction Control Language DDL correct answers Data Definition Language - Used to define the schema of the database -- CREATE: creates and defines the table -- ALTER: modifies an existing table -- TRUNCATE: Removes all data from the table, leaves the schema, cannot rollback, ignores constraints -- DROP: Drops the table, cannot rollback DML correct a...

Create Database Syntax - -CREATE DATABASE db_name; Simple SFW query syntax - -SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? - -Outside Modality: Inside or outside? - -Inside What commands are used with data definition? - -create, alter, drop, truncate, comment, rename What commands are used with data manipulation? - -Select, Insert, Update, Delete, Merge, Call, Explain Plan, Lock Table Create Table Syntax - -CREATE TABLE table_name ( column_name...

TRUNCATE TABLE - delete all data from table leaving structure intact DROP TABLE - deletion of a table DELETE FROM table_name WHERE conditional; - delete specific data/rows from a table DROP DATABASE - Dropping a database ALTER TABLE table_name ALTER COLUMN column_name TIMESTAMP DEFAULT current_timestamp; - adding column in table to store a timestamp ALTER TABLE table_name ALTER COLUMN column_name1 TYPE CHARACTER VARYING( ), ALTER COLUMN column_name1 SET NOT NULL; - modify ...

Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table? a. SELECT customer names FROM customers; b. SELECT "Names" FROM customers; c. SELECT firstname, lastname FROM customers; d. SELECT firstname, lastname, FROM customers; e. SELECT firstname, lastname, "Customer Names" FROM customers; - correct answer C Which clause is required in a SELECT statement? a. WHERE b. ORDER BY c. GROUP BY d. F...

Final WGU D426 V2 Exam |Question and Answer| #LATEST!! The relationship (within the relation) that describes how the value of one attribute may be used to find the value of another attribute. Functional Dependency 3 multiple choice options An attribute that can be used to find the value of another attribute in the relation. Determinant 3 multiple choice options Value can be used to find the value of every other non-key attribute in the table. Unique and minimal. Candidate Key 3 mu...

Which statement about a database table key is valid? The primary key cannot contain null values whereas the unique key can contain null values. I have a Decision Table that can result in more than one Output value being satisfied. Which of the following would be the best option in order to guarantee the Decision works? Set the Hit Policy to either First or Rule Order Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:00 / 0:00 ...

Create Database Syntax - ANSWER CREATE DATABASE db_name; Simple SFW query syntax - ANSWER SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? - ANSWER Outside Modality: Inside or outside? - ANSWER Inside What commands are used with data definition? - ANSWER create, alter, drop, truncate, comment, rename What commands are used with data manipulation? - ANSWER Select, Insert, Update, Delete, Merge, Call, Explain Plan, Lock Table Create Table Sy...