{"id":265,"date":"2022-03-24T00:05:25","date_gmt":"2022-03-23T15:05:25","guid":{"rendered":"https:\/\/kashiiblog.com\/?p=265"},"modified":"2022-03-24T00:27:23","modified_gmt":"2022-03-23T15:27:23","slug":"%e3%80%90oss-db-exam-silver%e3%80%919-%e7%b5%84%e3%81%bf%e8%be%bc%e3%81%bf%e9%96%a2%e6%95%b0%e3%81%a8%e6%bc%94%e7%ae%97%e5%ad%90","status":"publish","type":"post","link":"https:\/\/kashiiblog.com\/?p=265","title":{"rendered":"9.\u7d44\u307f\u8fbc\u307f\u95a2\u6570\u3068\u6f14\u7b97\u5b50\u3010OSS DB exam Silver\u3011"},"content":{"rendered":"

\u73fe\u5728OSS-DB Silver Ver.2\u3092\u52c9\u5f37\u4e2d\u306e\u30b5\u30a4\u30c8\u4e3b\u3067\u3059\u3002<\/p>\n

OSS DB Silver\u3092\u672c\u3067\u52c9\u5f37\u3057\u3066\u3044\u3066\u3082\u56f3\u306b\u3057\u306a\u3044\u3068\u308f\u304b\u3089\u306a\u304b\u3063\u305f\u308a\u3001\u8868\u306b\u3057\u305f\u307b\u3046\u304c\u5206\u304b\u308a\u3084\u3059\u3044\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001\u81ea\u5206\u304c\u899a\u3048\u306b\u304f\u3044\u3068\u601d\u3063\u305f\u3053\u3068\u3001\u6df7\u540c\u3057\u3084\u3059\u3044\u3053\u3068\u3092\u307e\u3068\u3081\u3066\u3044\u307e\u3059\u3002\u66f8\u3044\u3066\u3042\u308b\u3053\u3068\u306f\u5e38\u8b58\u306a\u3053\u3068\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u79c1\u304c\u308f\u304b\u3089\u306a\u304b\u3063\u305f\u3053\u3068\u3092\u307e\u3068\u3081\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u52c9\u5f37\u6cd5\u306a\u3069\u306f\u4e0b\u8a18\u306b\u8a18\u8f09\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

OSS DB Silver\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306b\u3084\u3063\u305f\u3053\u3068<\/a><\/p>\n

OSS DB exam Silver\u306e\u52c9\u5f37\u5185\u5bb9<\/h2>\n
    \n
  1. \u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4e00\u822c\u7684\u7279\u5fb4<\/a><\/span><\/li>\n
  2. \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u57fa\u790e\u77e5\u8b58<\/span><\/a><\/li>\n
  3. \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/span><\/a><\/li>\n
  4. \u6a19\u6e96\u4ed8\u5c5e\u30c4\u30fc\u30eb<\/span><\/a><\/li>\n
  5. \u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb<\/span><\/a><\/li>\n
  6. \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3068\u30ea\u30b9\u30c8\u30a2<\/span><\/a><\/li>\n
  7. \u57fa\u672c\u7684\u306a\u904b\u7528\u7ba1\u7406<\/span><\/a><\/li>\n
  8. SQL\u3068\u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/span><\/a><\/li>\n
  9. \u7d44\u307f\u8fbc\u307f\u95a2\u6570\u3068\u6f14\u7b97\u5b50\u21e6\u4eca\u65e5\u306f\u3053\u308c\uff01<\/strong><\/span><\/li>\n
  10. \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3<\/span><\/a><\/li>\n<\/ol>\n

    \u7d44\u307f\u8fbc\u307f\u95a2\u6570\u3068\u6f14\u7b97\u5b50<\/span><\/h2>\n

    PostgreSQL\u306e\u6570\u591a\u304f\u306e\u578b\u306b\u5bfe\u3059\u308b\u7b97\u8853\u6f14\u7b97\u5b50\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u4eca\u56de\u306f\u4ee5\u524dSQL\u3092\u52c9\u5f37\u3057\u3066\u3044\u305f\u306e\u3067\u305d\u3053\u307e\u3067\u6238\u60d1\u3046\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002\u4ee5\u4e0b\u306e\u5185\u5bb9\u3092\u899a\u3048\u3066\u304a\u3051\u3070\u96c6\u8a08\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n

    \u7b97\u8853\u95a2\u6570<\/strong><\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    \u95a2\u6570\u540d<\/span><\/td>\n\u8aac\u660e<\/span><\/td>\n<\/tr>\n
    abs<\/span><\/td>\n\u7d76\u5bfe\u5024<\/td>\n<\/tr>\n
    div<\/span><\/td>\ny<\/tt>\/x<\/tt>\u306e\u6574\u6570\u5546<\/td>\n<\/tr>\n
    mod<\/span><\/td>\ny<\/tt>\/x<\/tt>\u306e\u5270\u4f59<\/td>\n<\/tr>\n
    sqrt<\/span><\/td>\n\u5e73\u65b9\u6839<\/td>\n<\/tr>\n
    power<\/span><\/td>\na<\/tt>\u306eb<\/tt>\u4e57<\/td>\n<\/tr>\n
    ceil<\/span><\/td>\n\u5f15\u6570\u3088\u308a\u5c0f\u3055\u304f\u306a\u3044\u6700\u5c0f\u306e\u6574\u6570<\/td>\n<\/tr>\n
    floor<\/span><\/td>\n\u5f15\u6570\u3088\u308a\u5927\u304d\u304f\u306a\u3044\u6700\u5927\u306e\u6574\u6570<\/td>\n<\/tr>\n
    round<\/span><\/td>\n\u56db\u6368\u4e94\u5165<\/td>\n<\/tr>\n
    trunc<\/span><\/td>\n\u5207\u308a\u6368\u3066<\/td>\n<\/tr>\n
    log<\/span><\/td>\n10\u3092\u5e95\u3068\u3057\u305f\u5bfe\u6570\uff08\u5e38\u7528\u5bfe\u6570\uff09<\/td>\n<\/tr>\n
    pi<\/span><\/td>\n“\u5186\u5468\u7387\uff08\u03c0\uff09”<\/span>\u5b9a\u6570<\/td>\n<\/tr>\n
    random<\/span><\/td>\n0.0 <= x < 1.0\u306e\u7bc4\u56f2\u306e\u4e71\u6570\u5024<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u554f\u984c\u3068\u3057\u3066\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u96c6\u8a08\u304c\u51fa\u307e\u3059\u3002<\/p>\n

    Q1.PostgreSQL\u306e\u7b97\u8853\u6f14\u7b97\u5b50\u306e\u5229\u7528\u306b\u3064\u3044\u3066\u3001\u8aa4\u3063\u305f\u8a18\u8ff0\u30921\u3064\u9078\u3073\u306a\u3055\u3044\u3002<\/strong><\/p>\n

    SELECT 5\/2; \u306e\u7d50\u679c\u306f 2 \u3060\u304c\u3001SELECT 5\/2.0; \u306e\u7d50\u679c\u306f 2.5 \u3068\u306a\u308b\u3002
    \nSELECT 5%2; \u306e\u7d50\u679c\u306f 1 \u3067\u3042\u308b\u3002
    \nSELECT 5\/NULL; \u3092\u5b9f\u884c\u3059\u308b\u3068\u30010\u3067\u9664\u7b97\u306e\u30a8\u30e9\u30fc\u3068\u306a\u308b\u3002
    \nSELECT 5\/0; \u3092\u5b9f\u884c\u3059\u308b\u3068\u30010\u3067\u9664\u7b97\u306e\u30a8\u30e9\u30fc\u3068\u306a\u308b\u304c\u3001SELECT NULL\/0; \u306a\u3089\u7d50\u679c\u306f NULL \u3068\u306a\u308b\u3002
    \nSELECT 5^2; \u306e\u7d50\u679c\u306f 25 \u3067\u3042\u308b\u3002<\/p>\n

    Silver\u306e\u4f8b\u984c\u89e3\u8aac\u300c\u958b\u767a\/SQL – \u7d44\u307f\u8fbc\u307f\u95a2\u6570(\u7b97\u8853\u6f14\u7b97\u5b50)\u300d<\/a><\/p><\/blockquote>\n

    \u6587\u5b57\u5217\u95a2\u6570<\/span><\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    \u95a2\u6570\u540d<\/span><\/td>\n\u8aac\u660e<\/span><\/td>\n<\/tr>\n
    length()<\/span>
    \nchar_length()<\/span><\/td>\n    		\u6587\u5b57\u578b\u306e\u6587\u5b57\u6570<\/td>\n<\/tr>\n
    octet_length()<\/span><\/td>\n\u6587\u5b57\u5217\u4e2d\u306e\u30d0\u30a4\u30c8\u6570<\/td>\n<\/tr>\n
    substring()<\/span><\/td>\nPOSIX\u6b63\u898f\u8868\u73fe\u306b\u4e00\u81f4\u3059\u308b\u526f\u6587\u5b57\u5217\u3092\u53d6\u308a\u51fa\u3059<\/td>\n<\/tr>\n
    upper()<\/span><\/td>\n\u6587\u5b57\u5217\u3092\u5927\u6587\u5b57\u306b\u5909\u63db<\/td>\n<\/tr>\n
    lower()<\/span><\/td>\n\u6587\u5b57\u5217\u3092\u5c0f\u6587\u5b57\u306b\u5909\u63db<\/td>\n<\/tr>\n
    repeat()<\/span><\/td>\n\u6307\u5b9a\u3055\u308c\u305fnumber<\/tt>\u306e\u6570\u3060\u3051string<\/tt>\u3092\u7e70\u308a\u8fd4\u3059<\/td>\n<\/tr>\n
    replace()<\/span><\/td>\nstring<\/tt>\u306b\u51fa\u73fe\u3059\u308b\u5168\u3066\u306efrom<\/tt>\u90e8\u5206\u6587\u5b57\u5217\u3092to<\/tt>\u90e8\u5206\u6587\u5b57\u5217\u306b\u7f6e\u63db<\/td>\n<\/tr>\n
    lpad()<\/span><\/td>\n\u6587\u5b57fill<\/tt>\uff08\u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u7a7a\u767d\u6587\u5b57\uff09\u3092\u6587\u5b57\u5217\u306e\u524d\u306b\u8ffd\u52a0\u3057\u3066\u3001string<\/tt>\u3092length<\/tt>\u306e\u9577\u3055\u306b\u3059\u308b\u3002string<\/tt>\u304c\u65e2\u306blength<\/tt>\u306e\u9577\u3055\u3092\u8d85\u3048\u3066\u3044\u308b\u5834\u5408\u306f\uff08\u53f3\u5074\u304c\uff09\u5207\u308a\u6368\u3066\u3089\u308c\u308b\u3002<\/td>\n<\/tr>\n
    rpad()<\/span><\/td>\n\u6587\u5b57fill<\/tt>\uff08\u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u30b9\u30da\u30fc\u30b9\uff09\u3092\u6587\u5b57\u5217\u306b\u8ffd\u52a0\u3057\u3066\u3001string<\/tt>\u3092length<\/tt>\u306e\u9577\u3055\u306b\u3059\u308b\u3002string<\/tt>\u304c\u65e2\u306blength<\/tt>\u306e\u9577\u3055\u3092\u8d85\u3048\u3066\u3044\u308b\u5834\u5408\u306f\u5207\u308a\u6368\u3066\u3089\u308c\u308b<\/td>\n<\/tr>\n
    trim()<\/span><\/td>\ncharacters<\/tt>\uff08\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u7a7a\u767d\uff09\u3067\u6307\u5b9a\u3055\u308c\u305f\u6587\u5b57\u306e\u307f\u3092\u542b\u3080\u6700\u3082\u9577\u3044\u6587\u5b57\u5217\u3092\u3001string<\/tt>\u306e\u5148\u982d\u3001\u672b\u5c3e\u3001\u305d\u3057\u3066\u305d\u306e\u4e21\u65b9\u304b\u3089\u524a\u9664\u3059\u308b<\/td>\n<\/tr>\n
    ltrim()<\/span><\/td>\nstring<\/tt>\u306e\u6700\u521d\u304b\u3089\u3001characters<\/tt>\uff08\u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u30b9\u30da\u30fc\u30b9\uff09\u3067\u6307\u5b9a\u3055\u308c\u305f\u6587\u5b57\u3060\u3051\u3092\u6709\u3059\u308b\u6700\u9577\u306e\u6587\u5b57\u5217\u3092\u524a\u9664<\/td>\n<\/tr>\n
    rtrim()<\/span><\/td>\nstring<\/tt>\u306e\u672b\u5c3e\u304b\u3089\u3001characters<\/tt>\uff08\u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u30b9\u30da\u30fc\u30b9\uff09\u3067\u6307\u5b9a\u3055\u308c\u305f\u6587\u5b57\u306e\u307f\u3092\u6709\u3059\u308b\u6700\u9577\u306e\u6587\u5b57\u5217\u3092\u524a\u9664<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u6240\u611f<\/h2>\n

    BigQuery\u3067\u3082\u3068\u3082\u3068\u30c7\u30fc\u30bf\u62bd\u51fa\u3092\u3057\u3066\u3044\u305f\u306e\u3067\u4eca\u56de\u306f\u305d\u3053\u307e\u3067\u96e3\u3057\u304f\u306a\u304b\u3063\u305f\u3067\u3059\u3002\u3059\u3067\u306b\u307b\u304b\u306e\u3068\u3053\u308d\u3067\u52c9\u5f37\u3057\u3066\u3044\u308b\u306e\u3067\u3042\u308c\u3070\u3001BigQuery\u3084\u307b\u304b\u306eSQL\u3068\u5bfe\u5fdc\u3055\u305b\u306a\u304c\u3089\u899a\u3048\u3066\u3044\u304f\u3068\u3088\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

    \u73fe\u5728OSS-DB Silver Ver.2\u3092\u52c9\u5f37\u4e2d\u306e\u30b5\u30a4\u30c8\u4e3b\u3067\u3059\u3002 OSS DB Silver\u3092\u672c\u3067\u52c9\u5f37\u3057\u3066\u3044\u3066\u3082\u56f3\u306b\u3057\u306a\u3044\u3068\u308f\u304b\u3089\u306a\u304b\u3063\u305f\u308a\u3001\u8868\u306b\u3057\u305f\u307b\u3046\u304c\u5206\u304b\u308a\u3084\u3059\u3044\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001\u81ea\u5206\u304c\u899a\u3048\u306b\u304f\u3044\u3068\u601d\u3063\u305f…<\/p>\n","protected":false},"author":1,"featured_media":244,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[20],"tags":[],"class_list":["post-265","post","type-post","status-publish","format-standard","has-post-thumbnail","category-oss-db-silver-ver-2","article cf"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kashiiblog.com\/index.php?rest_route=\/wp\/v2\/posts\/265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kashiiblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kashiiblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kashiiblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kashiiblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=265"}],"version-history":[{"count":3,"href":"https:\/\/kashiiblog.com\/index.php?rest_route=\/wp\/v2\/posts\/265\/revisions"}],"predecessor-version":[{"id":310,"href":"https:\/\/kashiiblog.com\/index.php?rest_route=\/wp\/v2\/posts\/265\/revisions\/310"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kashiiblog.com\/index.php?rest_route=\/wp\/v2\/media\/244"}],"wp:attachment":[{"href":"https:\/\/kashiiblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kashiiblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kashiiblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}