數據庫管理員

14. Using the CUSTOMERS table,  you need to generate a report that shows 50% of each credit       amount in each income level. The report should NOT show any repeated credit amounts in each income  level.  

16. Evaluate the following query:SQL> SELECT promo_name q'{'s start date was }' promo_begin_date AS "Promotion Launches"FROM promotions;What would be the outcome of the above query?A. It produces

catalog資料庫：catalog indirect： db2 catalog database on /db2sys[dir_name]catalog remote:    db2 catalog database as at node    案例：        db2 catalog tcpip node NODESUN remote 192.168

遠端連線Oracle比較麻煩，通常需要安裝oracle的用戶端才能實現。通過instantclient可以比較簡單的串連遠端Oracle。 1.建立目錄D:\Oracle_Cleint用於存放相關檔案，建立目錄D:\Oracle_Cleint\NETWORK\ADMIN用於存放tnsnames檔案2.下載對應版本和系統的instantclient壓縮包，解壓得到instantclient檔案夾，將該檔案夾內的內容放在D:\Oracle_Cleint下。   

SqlPlus中退格鍵和方向鍵的設定在剛裝好的Oracle中，我們使用SqlPlus會發現非常的蹩腳，不僅退格鍵不好用，方向鍵也不行調出history，下面有幾種解決方案。1.可以使用ctrl+Backspace鍵強制輸出輸入的錯誤，也可以export stty erase ^h，當然這隻是臨時的方法，想一勞永逸請看下面。2.在oracle使用者目錄下編輯bash_profile檔案[oracle@linux245 ~]$ vi

29. Which two statements are true regarding constraints? (Choose two.) A. A foreign key cannot contain NULL values. B. The column with a  UNIQUE  constraint can store NULLS . C. A constraint is enforced only for an INSERT

27. Which two statements are true regarding tables? (Choose two.) A. A table name can be of any length. B. A table can have any number of columns. C. A column that has a DEFAULT value cannot store null values. D. A table and a

25. You need to create a table with the following column specifications: 1. Employee ID (numeric data type) for each employee 2. Employee Name (character data type) that stores the employee name 3. Hire date, which stores the date of

6. Examine the structure of the SHIPMENTS table:name                    Null       　　TypePO_ID          　　  

8. View the Exhibit and examine the structure of the CUSTOMERS table.Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)（題意：題目給出了一個Customers表，問哪兩個任務在一條語句中執行需要用到子查詢或者串連語句。）A. listing of

22. You need to create a table for a banking application. One of the columns in the table has the following requirements: 1) You want a column in the table to store the duration of the credit period. 2) The data in the column should be

24. Examine the structure proposed for the TRANSACTIONS table: name                    Null      Type TRANS_ID               NOT NULL

本文使用的環境是：win7_64+Eclipse+maven一、準備工作下載java驅動包

by qx.zhongHangzhou 29 Jun 2014開發環境OS:  Win8.1 x64JDK: 1.8 SEDB:  MySQL 5.5 Lib:  mysql-connector-java.jar1.

前言本文PL/SQL(Procedure Language,過程化語言)SQL 1999各大資料庫廠商通用的一種結構化語言  PL/SQL只支援Oracle資料庫基本文法多行注釋   /*    */      單行注釋   --PLSQL程式塊結構[declare]定義變數begin過程語句[exception]處理 異常end;例子 輸出helloworldbegin  dbms_output.put_

4. Which two statements are true regarding single row functions? (Choose two.)A. They a ccept only a single argument.B. They can be nested only to two levels.C. Arguments can only be column values or constants.D. They a lways return a single result

5. Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three .)A. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;B. SELECT TO_CHAR(1890.55,'$9,999V99')  FROM DUAL; C. SELECT TO_CHAR(1890.55,'$99,999D99')FROM DUAL;

drop procedure if exists P_SEQUENCE;/** 暫省略包 @AUTO LIANGRUI 2014/6/27 T_PRO_PRODUCT 表排序 對整個表進行按序號排序 根據序號從新自然排序 重複序號的安建立日期分配序號測試階段 測試調用set @merid='TEST66';call P_SEQUENCE(@merid);**/create procedure P_PRODUCT_SEQUENCE( in v_merchar_id

GFS解決了某些業務情境對Distributed File System需求，很自然的，也有某些業務僅僅靠檔案系統用起來還是不那麼方便，它們需要分散式資料庫系統。BigTable就是Google為瞭解決內部對大規模結構化資料處理的需求而產生的。論文摘要涉及的“關鍵”字為：1. 結構化資料2. 資料量大3. 典型應用：Web索引，Google Earth，Google Finance4. 批處理和即時需求5.

本文主要介紹免安裝配置mysql5.6.19的過程，整個過程中自己出現很多次失誤，經過整理，現將一次可成功的過程記錄下來，供大家參考。準備在mysq官網 http://dev.mysql.com/downloads/mysql/，下載最新穩定版本。本文使用的mysql版本為5.6.19，因下載免安裝版本，在頁面選擇“Windows (x86, 64-bit), ZIP