Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help me pleaaase and i need anwer just answer not explain / for example i need ( 1-A 2-B ) like this pleeease Q1. Multiple

help me pleaaase and i need anwer just answer not explain / for example i need ( 1-A 2-B ) like this pleeease image text in transcribed
image text in transcribed
Q1. Multiple Choice Questions. 15 points) 1. The routines that are executed automatically in response to a database event, are called A Procedures B. Functions C. Triggers D. Query 2- provides the ability to query information, and insert, delete and update tuples A. Data Manipulation Language B. Data Definition Language C. Data Control Language D. Data management Language 3- With SQL, how do you select all the records from a table named "Students" where the value of the column "FirstName" starts with an "a"? A. SELECT * FROM Students WHERE FirstName=' B. SELECT * FROM Students WHERE FirstName LIKE '% C. SELECT * FROM Students WHERE FirstName LIKE '%a' D. SELECT * FROM Students WHERE FirstName%% 4- To sort the results of a query use: A. SORT BY B. GROUP BY C. ORDER BY D. None of the above is correct. Language for defining the database structure (i.e., database objects) 5- A DML B. DLL C. DSL D. DDL 6- Which SQL statement is used to return values without duplication (repetition)? A. Select column B. Select different C. Select distinct D. None of the above Page 2 >> Automatically called when Manly called a PL SOL Manually called as a part of a PLISOL expression None of the above enable a dependent relationship in the logical relational DB A Primary keys B. Secondary Keys C. Alternate Keys D. Foreign Keys functions 9. Avg. min, max, sum and count are called A algebra B normal C aggregate D. complex 10- Which of the following is NOT a type of SQL constraint? A. Primary Keys B. Alternate Keys C. Foreign Keys D. UNIQUE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning VB.NET Databases

Authors: Thearon Willis

1st Edition

1594864217, 978-1594864216

More Books

Students also viewed these Databases questions