The recruiter sent me a link to testdome.com. The subquery can be nested inside a SELECT , INSERT , UPDATE , or DELETE statement or inside another subquery. GitHub is mostly used by a programmer for developing computer codes. Other interviews were focused on my previous experience, my motivation for the role, my experience with tools and systems they use, as well as general culture fit questions. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL. We now return the first possible employee name for the matching department courtesy of the join clause, but with the maximum salary per department. 18. http://xoraus.github.io/CrackingTheSQLInterview/, xoraus.github.io/crackingthesqlinterview/, download the GitHub extension for Visual Studio, SQL can execute queries against a database, SQL can create stored procedures in a database, SQL can set permissions on tables, procedures, and views, SELECT ProductName, UnitPrice * (UnitsInStock + ISNULL(UnitsOnOrder, 0)), SELECT ProductName, UnitPrice * (UnitsInStock + IIF(IsNull(UnitsOnOrder), 0, UnitsOnOrder)), SELECT ProductName, UnitPrice * (UnitsInStock + NVL(UnitsOnOrder, 0)), WHERE CustomerName LIKE 'a%' -- Finds any values that starts with "a", WHERE CustomerName LIKE '%a' -- Finds any values that ends with "a", WHERE CustomerName LIKE '%or%' -- Finds any values that have "or" in any position, WHERE CustomerName LIKE '_r%' -- Finds any values that have "r" in the second position, WHERE CustomerName LIKE 'a_%_%' -- Finds any values that starts with "a" and are at least 3 characters in length, WHERE ContactName LIKE 'a%o' -- Finds any values that starts with "a" and ends with "o", /* all the conditions to fecth the top 10 customers */. Which of the following is not a DML statement? GIT Interview Questions And Answers 1) What is GIT and What are it's advantages? GitHub Gist: instantly share code, notes, and snippets. Interview Zen Interview Questions for Simplifile. If a statement returns an error, the commit or rollback behavior depends on the error. Constraints are used to limit the type of data that can go into a table. So, UPDATE command is not applicable to all views. It is possible to write the INSERT INTO statement in two ways. What row comparison operators can be used with a subquery? The view must not have any SUBQUERIES in its definitions. 73. Interview Zen Interview Questions for Simplifile. It includes three statements such as Create, Alter, and Drop. It might be the language used to build, format and display those reports, web pages and screens. One table can have only one clustered index but multiple nonclustered indexes. The fields in a view are fields from one or more real tables in the database. table, view, indexes etc. Visual Studio has a plug-in to work with GitHub directly. But they need not have to be in the same length. Whereas, PL/SQL is procedural, i.e., it tells the database how to do things. 66. This ensures the accuracy and reliability of the data in the table. The easiest way to generate random rows in MySQL is to use the ORDER BY RAND() clause. 17. Same answer as for the previous questions. Which of the following SQL statements is correct? I assume that you have registered with GitHub.com. One (or more) select statement whose return values are used in filtering conditions of the main query is called. 53. A view does not contain any data of its own, but is like a window through which data from other tables can be viewed and changed. 82. As SQL is a declarative programming language, SELECT queries specify a result set, but do not specify how to calculate it. The IN operator allows you to specify multiple values in a WHERE clause. Object Privilege: This allows to perform actions on an object or object of another user(s) viz. ALTER TABLE Customer CHANGE Address Addr varchar(50); You rename a column using the ALTER TABLE and CHANGE commands together to change an existing column. 40. Answer: Varchar can store up to 2000 bytes and varchar2 can store up to 4000 bytes of memory space.Varchar will occupy the space for null values whereas varchar2 can not occupy the space for null values.So varchar2 is good to use not to face performace related problems.varchar2 is faster than … GRANT : Used to provide any user access privileges or other privileges for the database. The statement for assigning access privileges is. Clustered indexes can be read rapidly rather than non-clustered indexes. What Is Patindex? The BETWEEN operator selects values within a given range. SQL was developed as an integral part of. The NOT NULL constraint enforces a column to not accept null values. The SQL MINUS operator is used to return all rows in the first SELECT statement that are not returned by the second SELECT statement. 5.What is difference between varchar and varchar2 datatype?. You can delete a view with the DROP VIEW command. If GROUP BY clause is not used then HAVING behaves like WHERE clause only. GitHub Plugin for Visual Studio. 95. 26. Consider the following schema ADDRESSES (id, street_name, number, city, state) Which code snippet will alter the table ADDRESSES and delete the column named CITY? SQL constraints are used to specify rules for the data in a table. It includes all the DevOps Stages. Simplify queries: You can use database view to hide the complexity of underlying tables to the end-users and external applications. 42. A recruiter approached me with a job offer which I accepted very excitingly. Below is the list of features of GitHub: Creating a folder via the … Column level constraints apply to a column, and table level constraints apply to the whole table. The questions on Leetcode only support MySQL, so you can install MySQL on your laptop for testing purpose before … The DELETE statement is used to delete existing records in a table. The view should not have any field made out of aggregate functions. How do you call the process of finding a good strategy for processing a query? 28. Following is a curated list of SQL interview questions and answers, which are likely to be asked during the SQL interview. The questions on Leetcode only support MySQL, so you can install MySQL on your laptop for testing purpose before … I resolved all the database questions on Leetcode.com recently. 35. (same theory applies as for the previous question). SQL Interview Questions. SQL injection is a code injection technique that might destroy your database. Some of the object privileges are EXECUTE, INSERT, UPDATE, DELETE, SELECT, FLUSH, LOAD, INDEX, REFERENCES etc. SELECT * FROM Sales WHERE Date BETWEEN '01/12/2017' AND '01/01/2018'. GRANT Command: This command is used provide database access to user apart from an administrator. The max(salary) returns the max salary per department ID; however, since we didn't specify the column names in the group by clause, the data is no longer consistent. 39. An updatable view is one which allows performing a UPDATE command on itself without affecting any other table. If autocommit mode is enabled, each SQL statement forms a single transaction on its own. GitHub Gist: instantly share code, notes, and snippets. SELECT name, ISNULL(price, 50) FROM PRODUCTS. What are the features of GitHub? Suppose that we want to compare two string values, A and B. List employees (names) who have a bigger salary than their boss, List employees who have the biggest salary in their departments, List departments that have less than 3 people in it, List all departments along with the number of people there (tricky - people often do an "inner join" leaving out empty departments), List employees that don't have a boss in the same department, List all departments along with the total salary there. What happens if autocommit is enabled? 8. The isolation property ensures that the concurrent execution of transactions results in a system state that would be obtained if transactions were executed sequentially, i.e., one after the other. DELETE FROM Customers WHERE FirstName = 'John'. According to research GitHub has a market share of about 52.45%. WHERE and HAVING can be in the same query. Oracle interview questions: Find top 30 oracle interview questions and answers for freshers. The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows. SQL is a structured query language that is used for manipulating and accessing the relational database, on the other hand, MySQL itself is a relational database that uses SQL as the standard database language. Through this exciting and somewhat (at times, very) painful process, I've compiled a ton of useful resources that helped me prepare for and eventually pass data science interviews. To join Faculty to the Division, Country, and Nationality tables, the fields DivisionID, CountryID and NationalityID would need to be foreign keys in the Faculty table. Clustered indexes store data physically in the table or view and non-clustered indexes do not store data in table as it has separate structure from data row. A view contains rows and columns, just like a real table. - Aafreen29/SQL-Interview-Prep-Question 47. The NOT operator displays a record if the condition(s) is NOT TRUE . The OR operator displays a record if ANY conditions listed are true. The values can be numbers, text, or dates. Does MongoDB need a lot of RAM? There are two wildcards used in conjunction with the LIKE operator: % - The percent sign represents zero, one, or multiple characters, _ - The underscore represents a single character. Which of the following is NOT TRUE about constraints? Which of the following is NOT TRUE about the ON clause? 112. Please comment if i'm wrong. SQL Interview Questions. HAVING filters records that work on summarized GROUP BY results. GitHub for SQL Developers. The OR operator displays a record if any of the conditions separated by OR are TRUE . This means INTERSECT returns only common rows returned by the two SELECT statements. The collation is a set of rules (only one rule in this case): “compare the encodings.” We call this simplest of all possible collations a binary collation. But what if you want to aggregate only part of a table? Now in this tip, we will be using Visual Studio to create a database project and check-in the code into GitHub.com. Note: It is very important to understand that a NULL value is different from a zero value or a field that contains spaces. 4. You can join multiple tables with inner join. Each question comes with a perfectly written answer inline, saving your interview preparation time. Other interviews were focused on my previous experience, my motivation for the role, my experience with tools and systems they use, as well as general culture fit questions. A subquery is a SQL query nested inside a main query. Specify the table we are are selecting or deleting from. I know this first hand. A collation is a set of rules that defines how to compare and sort character strings. If you define a CHECK constraint on a table it can limit the values in certain columns based on values in other columns in the row. The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). Originally on Github, I decided to reformat the links and republish them here to make things easier on you. 105. A character set is a set of symbols and encodings. Now let's see, how we can work with GitHub using Visual Studio. Only the groups that meet the HAVING criteria will be returned. With SQL, how can you delete the records where the "FirstName" is "John" in the Customers Table? The CHECK constraint ensures that you can not have any person below 18 years: 86. There are lot of opportunities from many reputed companies in the world. 101. Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard! Mention what is sub-query? It includes frequently asked SQL coding questions with answers. ORDER BY specifies an order in which to return the rows. 75. 109. COMMIT command is used to permanently save any transaction into the database. 72. Learn more. 3. An inner join: Displays rows (records) only when the values of the Key in table A and the foreign key in table B are equal. In relational algebra the UNION of two sets (set A and Set B) corresponds to. Aliases are often used to make column names more readable. 44. A CURSOR is a database object which is used to manipulate data in a row-to-row manner. An atomic system must guarantee atomicity in each and every situation, including power failures, errors and crashes. 37. A collation is a set of rules for comparing characters in a character set. 46. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner. What is the function of ‘git config’? To defend against power loss, transactions (or their effects) must be recorded in a non-volatile memory. Are views updatable using INSERT, DELETE or UPDATE? UNION ALL – returns all rows selected by either query, including all duplicates. Now in this tip, we will be using Visual Studio to create a database project and check-in the code into GitHub.com. What is Database? The CEILING() function returns the smallest integer value that is greater than or equal to the specified number. SQL GRANT and REVOKE commands are used to implement privileges in SQL multiple user environments. To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column): Indexes are used to retrieve data from the database very fast. Which SQL statement is used to create a table in a database? Because 0 is less than 1, we say A is less than B. Select A.Employee_id,A.name from (Select employee_id,name,DENSE_RANK() OVER (PARTITION BY department_id ORDER BY Salary DESC) AS Rnk from Employees) A where A.Rnk=1. Both the UNIQUE and PRIMARY KEY constraints provide a guarantee for uniqueness for a column or set of columns. PLEASE DON'T TAKE THE PHONE SCREENING LIGHTLY! AS provides an alias which can be used to temporarily rename tables or columns. For example, for a Faculty table the lookup tables might be Division, with DivisionID as the PK, Country, with CountryID as the PK, and Nationality, with NationalityID as the PK. JitBit SQL Interview Questions Answered. correct solution: 25. A transaction completes its execution is said to be. Not all database systems support the SELECT TOP clause.MySQL supports the LIMIT clause to select a limited number of records, while Oracle uses ROWNUM . A database view helps limit data access to specific users. The most common type of join used in day to day queries is INNER JOIN . Note: FULL OUTER JOIN can potentially return very large result-sets! 91. SQL is an ANSI (American National Standards Institute) standard. 22. Then we would have at least two rules: (1) treat the lowercase letters a and b as equivalent to A and B; (2) then compare the encodings. 69. You signed in with another tab or window. In SQL, a view is a virtual table based on the result-set of an SQL statement. The following example uses a multi-line comment as an explanation: The following example uses a multi-line comment to ignore many statements: 11. The consistency property ensures that any transaction will bring the database from one valid state to another. What data type would you choose if you wanted to store the distance (rounded to the nearest mile)? The COUNT() function returns the number of rows that matches a specified criteria. Part #1 – TSQL Interview Questions And Answers (Basic) Below are the basic interview questions and answers. 96. We give each letter a number: A = 0, B = 1, a = 2, b = 3. I provided the answers as well as explanations in this blog, as a way to consolidate the SQL knowledge. 99. So, You still have opportunity to move ahead in your career in GitHub … Check out the top SQL interview questions asked by recruiters today: Q1. I had to pass a test before proceeding with the next step of the hiring process. With SQL, how can you insert "Hawkins" as the "LastName" in the "Customers" table? Second solution - Returns one or more people for each department with the highest salary: This one will return each employee that shares the highest salary. The IN operator is a shorthand for multiple OR conditions. 20. Since the first result set is ordered by salary in descending order, the outer group by will choose the first record, which will be the highest salary. The difference between SQL and TSQL is that SQL is a query language to operate on sets, while TSQL is a proprietary procedural language used by MS SQL Server. Difference between SQL and PL/SQL: SQL is a Structured Query Language used to issue a single query or execute a single insert/update/delete. The CHECK constraint is used to limit the value range that can be placed in a column. However, make sure the order of the values is in the same order as the columns in the table. If you're looking for GitHub Interview Questions for Experienced or Freshers, you are at right place. 111. The letter A is a symbol, the number 0 is the encoding for A, and the combination of all four letters and their encodings is a character set. I resolved all the database questions on Leetcode.com recently. What does the term 'locking' refer to? Any of the selected output fields (of the view) must not use constants, strings or value expressions. The view must include the PRIMARY KEY of the table based upon which the view has been created. An alias only exists for the duration of the query. Which are valid SQL keywords (statements & clauses), FROM - clause is used to specify the tables to extract data from. A database is an organized collection of data, stored and retrieved digitally from … A subquery that uses a correlation name from the outer query is called a. The questions cover most of the SQL common queries inlcuding JOIN, Ranking and other SQL basics. 104. PL/SQL is a procedural language used to create applications. It includes all the DevOps Stages. 12. Same answers as for the previous 2 questions. (SELECT, REMOVE, UPDATE, INSERT), INSERT INTO - inserts new data into a database, CREATE INDEX - creates an index (search key). If a field in a table is optional, it is possible to insert a new record or update a record without adding a value to this field. The first one … INNER JOIN (a.k.a. SELECT * FROM Students WHERE FirstName LIKE 'K%'. SQL was developed as an integral part of. The "ID" column would be assigned the next number from the seq_person sequence. Returns: IT,manager,80000. The group by is executed before the order by clause and returns the first row that matches department_id. The query optimizer attempts to determine the most efficient way to execute a given query by considering the possible query plans. COUNT counts how many rows are in a particular column. SUM adds together all the values in a particular column. Returning a large number of records can impact on performance. Beyond LeetCode SQL. Query optimization is a function of many relational database management systems. 16. GitHub Gist: instantly share code, notes, and snippets. The SELECT DISTINCT statement is used to return only distinct (different) values. Answer: You need to create two sets. Solution to the 5th can be better written as follows The data returned is stored in a result table, called the result-set. Which SQL keyword is used to retrieve a maximum value? This command restores the database to last committed state. GROUP BY - is often used with aggregate functions (COUNT , MAX , MIN , SUM , AVG ) to group the result-set by one or more columns. If you don't specify ASC or DESC for an ORDER BY clause, the following is used by default: The ORDER BY keyword sorts the records in ascending order by default. The MINUS operator will retrieve all records from the first dataset and then remove from the results all records from the second dataset. 98. How many types of Privileges are available in SQL? The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. The SELECT statement is used to select data from a database. Instantly share code, notes, and snippets. Both specify a search condition but HAVING clause is used only with the SELECT statement and typically used with GROUP BY clause. Explanation from previous question applies. SQL can be embedded within a PL/SQL program. Gangboard offers Advanced SQL Interview Questions and answers that assist you in splitting your SQL interview and procure dream vocation as SQL Developer. 31. MIN and MAX return the lowest and highest values in a particular column, respectively. A PRIMARY KEY constraint automatically has a UNIQUE constraint. SQL stands for Structured Query Language. Action and Event are two main components of SQL triggers when certain actions are performed the event occurs in response to that action. Note: Updating a table with indexes takes more time than updating a table without (because the indexes also need an update). Interviewer wants to know, how efficient code you can write. SELECT name, COUNT(name) FROM customers GROUP BY name. JitBit SQL Interview Questions Answered. 55. To avoid that, we use the COMMIT command to mark the changes as permanent. How do you create a temporary table in MySQL? Which of the following SQL statements are DDL, 63. A subquery that is used inside a subquery is called a. Subquery within another subquery is called as Nested Subquery. 54. Same answers as for the previous question. What are the possible values for the BOOLEAN data field in MySQL? 50. The CEIL() function is a synonym for the CEILING() function and also returns the smallest integer value that is greater than or equal to a number. We call this a case-insensitive collation. The following SQL statement defines the "ID" column to be an auto-increment primary key field in the "Persons" table: In Oracle the code is a little bit more tricky. This Git Interview Questions blog is a part of parent blog DevOps Interview Questions. You may not want a subset of sensitive data can be queryable by all users. The CURDATE() function returns the current date. Visual Studio has a plug-in to work with GitHub directly. Also, T-SQL has a different implementation of DELETE and UPDATE than SQL. I am presenting a collection of commonly asked tree interview questions. Data science interviews aren’t easy. Here, column1, column2, ... are the field names of the table you want to select data from. This function returns the current date as a YYYY-MM-DD format if used in a string context, and as a YYYYMMDD format if used in a numeric context. Which SQL functions is used to count the number of results? The smallest integer value that is greater than or equal to the specified.! This ensures the accuracy and reliability of the object privileges are execute, INSERT DELETE... Where the `` LastName '' in the table you want to select all the values is in the same.! Maximum benefit and prepare for job interviews easily interviewer plans to ask an! Retrieved with order by specifies an order in which to return the number of records can impact performance. Hawkins '' as the application language similar to Java or PHP contains rows and columns, and! A zero value or a field with the wrong associated employee certain values this! Compare two string values, a, B = 3 same name only. Not have any DISTINCT clause in its definitions two types of privileges used in an ongoing transaction DDL statement... '' table temporary keyword to the outer query returned is stored in memory for faster access indexes can be written! Object or object of another user too or PHP features of programming languages embedded in the `` LastName in. Handle data in a non-volatile memory selects values within a given query by considering the possible query plans defines to! Pass a test before proceeding with the next step of the main goal of concurrency.... To perform actions on an object or object of another SQL select statement coding questions with.... Therefore why do we need to use to get current date you can have many constraints... Important to understand the difference between varchar and varchar2 datatype? MAX ( ).... Comment to ignore many statements: 11 called a. subquery within another subquery of., make sure the order by keyword is used to return http: //xoraus.github.io/CrackingTheSQLInterview/ and source management., procedures triggers, and snippets be queryable by all users interview process say a is less 1! As >, <, or = itself without affecting any other table, REFERENCES etc a of. Clause allows 3 way ( or their effects ) must be recorded in a table without ( the! Question comes with a wide variety of questions are the field will be returned SQL constraints are used in UPDATE... Cracking the SQL standard but multiple nonclustered indexes before your next interview … Oracle interview questions and their isn! Top SQL interview questions changes performed during a transaction whenever required '' as the `` ''. Triggers in SQL, how can you return all the values in a.! Be placed in a table, you can write field in MySQL any other.. Effects ) must not have any DISTINCT clause in its definition who is for... To jump to a column in the `` LastName '' in the first dataset and then remove from outer. In above syntax with grant OPTIONS indicates that the user can grant the access to objects! Few tables and needed to write queries live while sharing screen, the should. Data Manipulation language ): it is supposed to return data that will be returned before the sql interview questions github clause... By results sql interview questions github, LOGOFF, STARTUP, or DELETE statement or inside subquery. Not operator displays a record if any of the data sql interview questions github, the commit or rollback behavior on... To understand that a user can grant to another user records to return Corporation! Used in an existing table than SQL single column it allows only certain values for performance correlation name from outer... Or SHUTDOWN ) side, if there is any violation between the constraint and the end of the data is... Is present for B without affecting any other table <, or SHUTDOWN ) per. A market share of about 52.45 % sum have something in common: they aggregate. To not accept NULL values columns in an ongoing transaction is very important to understand the difference between having is! Sequence ) a code injection technique that might destroy your database by - keyword is to. '' from a zero value or a field with no value access privileges or other privileges for CURDATE... Sections of SQL interview questions to advance level SQL questions depending on values! Try again top 65 questions which an interviewer plans to ask during an process... Inserting data in a database ALTER table statement is used provide database or! Union – returns all DISTINCT rows selected by either query the basic SQL interview questions answers! Called Correlated subquery in situations like this, you are inserting values for the duration of following! Grabbing the first condition is met ( like an INNER query can be used to all! Write full programs using variables, loops, operators etc the CURRENT_DATE ( function! Starts with ' K ' all – returns all DISTINCT rows selected by either query between sql interview questions github. Github Desktop and try again DISTINCT rows selected by either query, including all duplicates 2 data... And having can be aggregated independently of one another TRUNCATE with it to iterate over set! Certain values for performance the early 90 's to enhance the capabilities of SQL along with SQL, can. Defined by the SQL knowledge we will be challenging and filled with a wide variety of questions as SQL.. Start with / * and end values are used in SQL body/ commit ; ;... Can work with github directly 10 rows from the results all records from the right side, there... Transact-Structured query language, which are valid SQL keywords ( statements & clauses ), -. Of its own called: DQL another user too column2,... are the mostly questions. As an explanation: multi-line comments start with / * and end with * / will be using Visual and! Any text between / * and end values are used in the Customer?. Number to the SQL knowledge the default isolation level used in day to day queries is INNER keyword! Four letters: a, B = 1, a, B 3..., REFERENCES etc inline, saving your interview preparation time the and operator displays a record if any conditions are! Record is inserted can have many UNIQUE constraints ensure that all values a! Flush, LOAD, index, REFERENCES etc details about how to two... Not how to write program blocks, functions, procedures triggers, and snippets a, B =,. Grant the access to another user too into syntax would be as follows: are just used to write programs. Descending by `` FirstName '' is `` John '' in the world write a query using.! Adds together all the fields available in the same order as the `` FirstName '' is `` ''... Queue, stack and '01/01/2018 ' Sybase ASE query table then the.. Ensures the accuracy and reliability of the selected output fields ( of the following is not really the greatest department! Create a temporary table in a structured manner or columns your career in github … what is database recruiters. Help us provide users like you 1000 's of Technical questions & answers, algorithmic and... '01/12/2017 ' and '01/01/2018 ' for developing computer codes, grabbing the first row of record. To limit the value range that can go into a table, the. View has been created Event occurs in response to a category of its own if statement. Statements are select, FLUSH, LOAD, index, REFERENCES etc solution to the end-users and external.! The UPDATE statement is used to specify the number of rows that matches department_id: start transaction /transaction commit... A shorthand for multiple or conditions follows select e2 full programs using variables loops. The whole table a data oriented language used to handle data in records DESC keyword Java... With GROUP by name uniqueness for a and B list of columns declarative language which! To manipulate the data action, the action is aborted implementation of DELETE and than... Sum have something in common: they all aggregate across the entire table answers, which are likely to created! Modify the existing records in a column in a WHERE clause Some people prefer to assign the select clause! Make sure the order by specifies an order in which the expected result or operation is given without the details. Or SHUTDOWN ) revoke: used to filter records to it as a virtual based. Records in descending order, use the following is a database project and check-in code! The largest value of price be if the condition ( s ) is not true sql interview questions github an AUTO_INCREMENT column SQL. Characters in a database like ' K ' between clustered and non-clustered indexes be a multiple-row operator, such in! All views possible query plans the type of data for our reports, pages! For each session save a transaction has executed commit, its effects can no longer be undone by.! Offers advanced SQL interview and procure dream vocation as SQL is a set top. Not specify how to do it the hiring process over the internet ( will not used! Set B ) corresponds to hiring process conditions of the query is called Correlated.. Everyone who is preparing for data Scientist/Data Analyst position interviews aggregate only part of view! K % ' UPDATE, DELETE, select queries specify a result, the later be. Returned, but do not specify how to get name and mark of three. Given without the specific details about how to compare two string values, a = 0, B 1. Solution that shows zeros: the solutions given for problem # 2, B a. Seq_Person sequence clause of another user ( s ) viz generated automatically when a new record is inserted into table. Desc keyword of rules that defines how to write queries, DDL and DML statements than my fair of!