All Topics
Topic16 questions
Accenture Data Manipulation LanguageQuestions & Answers
Practice 16 verified Accenture Data Manipulation Language questions with detailed answers and explanations. Tap any question below to study the full solution — perfect for last-minute Accenture primer and dumps prep.
Data Manipulation Language question list
Which are auto-commit statements?Which of the update statement produces the following error in the employee table? ORA-02291: integrity constraint (SYS_C23) violat…Which of the following is not a DML statement?Which SQL statement needs both insert and update privilege on the target table and select privilege on the source table?On delete restrict is used to restrict the deletion of child records. State True or False.Delete statement supports up to two conditions only. State True or FalseWhich statement inserts a new row into the STUDENT table?insert into employee(empid,empname)values(123,'John'); When we issue the above insert command and if the statement fails, what w…DELETE FROM dept WHERE dept_id = 901; The above delete statement throws an integrity constraint error because a child record was f…Which query is used to delete employee records whose age is greater than 55?By using _____ datatype we can store numeric and character values as an input .To permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command pe…Which statement would you use to add a primary key constraint to the patient table using the id_number column, immediately enablin…Composite key is used in one to one relationship. State true or false.Which CREATE TABLE statement is valid?Cascade constraints are used only in drop statements. State True or False.Practice more Accenture topics
PrimerDumps has 1400+ primer questions, 2026 mocks and coding hands-on — all free.