1. CREATE TABLE EMPLOYEE_UC(Ssn VARCHAR(5) NOT NULL PRIMARY KEY,Fname VARCHAR(15) NOT NULL,Minit VARCHAR(15) NOT NULL,Lname VARCHAR(15) NOT NULL,Bdate DATE,Address VARCHAR(30),Gender CHAR,Salary Decimal(10,2),Age INT); 2. CREATE TABLE DEPARTMENT_UC(Dptname VARCHAR(15),Dptnmbr INT NOT NULL PRIMARY KEY,Mgr_ssn CHAR(9),Mgr_start_date DATE,Mgr_last_date DATE,Ssn VARCHAR(5) FOREIGN KEY REFERENCES…
Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG
1. At which of the following levels is the actual data stored in a database? A. Physical 2. Consider the first step involved in acquisition of data for warehouse:“Extract data from multiple and heterogeneous sources.”Which of the following steps will…
LESSON-1 Q1) which of the following functions of the database management system causes some data to be read and some data to be written into a database. Transaction Q2) which of the following applications analyses large amount of data to search for…
LESSON-7 Q1)Which of the following joins is the default type of join in a joined table, where a tuple is included in the result only if a matching tuple exists in the other relation? Inner Q2). Which of the following…
Q1) Which of the following java technologies exists on the web server on the web server machine interactions with the client? Java Servlet Q2) Which of the following constraints can be directly expressed in the schemas of the data model? 1. Entity…
LESSON 10 QUIZ 1. Which statement in the SQL standard can be used to invoke a stored prored-either from an interface or from embedded SQL or SQLJ ? call 2. Which of the following approaches does not suffer from…
LEESON 4 QUIZ 1.Which of the following notations indicates a specialization/generalization with the disjoint…
LESSON 18 1. Which search applies to any file, but all the other methods depend on having the appropriate access path on the attribute used in the selection condition? linear 2. In which of the following joins does the search…
LESSON 22 1 .Deferred update is also known as the ______ NO-UNCO/REDO algorithm 2. For which of the following checkpoint actions does the fuzzy checkpointing technique come into use to overcome from the action? Suspend execution of…
